Question 1

The following SQL code returns an error in the program console: SELECT firstName, lastName, SUM(income) FROM companyRoster SORT BY lastName, income Which of the following changes allows this SQL code to run?

Options :

A : SELECT firstName, lastName, SUM(income) FROM companyRoster HAVING SUM(income) 10000000

B : SELECT firstName, lastName, SUM(income) FROM companyRoster GROUP BY firstName, lastName

C : SELECT firstName, lastName, SUM(income) FROM companyRoster ORDER BY firstName, income

D : SELECT firstName, lastName, SUM(income) FROM companyRoster

Answer: B

Question 2

A data analyst is designing a report for the business review team. The team lists the following requirements for the report: Specific data points Color branding Labels and terminology Suggested charts and tables Which of the following components is missing from the requirements?

Options :

A : Source validation

B : Design elements

C : Delivery method

D : Report type

Answer: C

Question 3

A data analyst team needs to segment customers based on customer spending behavior. Given one million rows of data like the information in the following sales order table: Customer_ID Region Amount_spent Product_category Quantity_of_items 00123 East 20000 Baby 4 00124 West 30000 Home 6 00125 South 40000 Garden 7 00126 North 50000 Furniture 8 00127 East 60000 Baby 10 Which of the following techniques should the team use for this task?

Options :

A : Standardization

B : Concatenate

C : Binning

D : Appending

Answer: C

Question 4

A data analyst is joining two tables with different content and one common field. Which of the following should the analyst do to most efficiently meet this requirement?

Options :

A : Match the records of the related columns and merge the tables.

B : Create a cluster to facilitate data integration between the tables.

C : Explode both tables to identify unique values and reorder the fields in one table.

D : Append the values of the matching columns and concatenate the other data fields.

Answer: A

Question 5

A data analyst encounters an issue with new software and a code that they are using. The analyst includes print statements in the code to try to identify the issue, without success. An informal peer review of the code also produces the same result. The analyst confirms that the software is updated to the latest version and compatible with the code. Which of the following troubleshooting steps should the analyst take next?

Options :

A : Use the old software and preexisting code, since both were functional.

B : Contact the IT department and inform them that the software has a bug.

C : Escalate to the department manager and ask for assistance.

D : Research the issue online and see if a solution is available.

Answer: D