CompTIA DA0-001 Practice Test - Questions Answers, Page 26

Given the information in the following tables:

Which of the following describes merging these tables to create a master file that includes all transactions for both online and in-store sales?

Given the table below:

Which of the following variables can be considered inconsistent, and how many distinct values should the variable have?

Given the following tables:

Which of the following will be the dimensions from a FULL JOIN of the tables above?

Which of the following is a best practice when updating a legacy data source?

An analyst is reviewing the following data:

Car ID Speed

1231 55

5664 36

5644 18

6505 67

5464 36

6456 38

Which of the following should the analyst include in the measures of central tendency for speed?

Given the customer table below:

Which of the following chart types is the most appropriate to represent the average spending of active customers vs. inactive customers?

A data analyst has removed the outliers from a data set due to large variances. Which of the following central tendencies would be the best measure to use?

Given the following grocery store orders:

If a query is made to the table with the following logic:

Order_Total > 132 OR (Order Total >= 25 AND Order_Total < 74)

Which of the following is the number of orders that will be returned by the query?

A data analyst needs to create a dashboard to help identify trends in the data sets. Which of the following is an appropriate consideration for dashboard development?