Question 1

Which of the following tables holds relational keys and numeric values?

Options :

Answer:

Question 2

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 :

Answer:

Question 3

A data analyst needs to create and deliver a dashboard that displays the company's financial transactions as they are updated. Which of the following delivery methods should the analyst consider? (Select two).

Options :

Answer:

Question 4

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 :

Answer:

Question 5

A manager wants a report that contains the days off for each direct report. The manager needs this report to always be up-to-date with the latest dat a. Which of the following describes the refresh frequency that the manager is requesting?

Options :

Answer: