CompTIA DA0-001 Practice Test - Questions Answers, Page 26
Question list
List of questions
Related questions
Which of the following concepts should be applied if a data set with 40 fields needs to be pared down to 20 fields and contains similar data across multiple fields?
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?
Question