DA0-001 Practice Test

Question 76

A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a LEFT JOIN: Customer Table - In-store Transactions - Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?

1. INNER: 6 rows; LEFT: 9 rows
2. INNER: 9 rows; LEFT: 6 rows
3. INNER: 9 rows; LEFT: 15 rows
4. INNER: 15 rows; LEFT: 9 rows

Question 77

A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers. Which of the following would be the BEST method to automate and ensure successful delivery for this task?

1. Use scheduled report delivery.
2. Implement subscription access delivery.
3. Print out a copy.
4. Upload the report to the server.

Question 78

Which of the following is an example of a discrete variable?

1. The temperature of a hot tub
2. The height of a horse
3. The time to complete a task
4. The number of people in an office

Question 79

Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

1. Numeric
2. Date
3. Float
4. Text

Question 80

SIMULATION - The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following: * County outages * Status * Overall trend of outages INSTRUCTIONS: Please, select each visualization to fit the appropriate space on the dashboard and choose an appropriate color scheme. Once you have selected all visualizations, please, select the appropriate titles and labels, if applicable. Titles and labels may be used more than once. If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.