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

A database administrator needs to increase performance on a large dimension table. Which of the following is the best way to accomplish this task?

Which of the following types of dashboards should a business intelligence engineer develop in order to provide information about failed data pipelines?

Which of the following is concatenate typically used to combine?

A dataset requires an analysis for investigating and discovering abnormalities. Which of the following best describes the nature of the exploratory analysis conducted?

A company needs a report that provides executives an overview and regional managers with both an overview and specifics. Which of the following reporting elements will achieve these results?

An analyst wants to test the association between the number of doors in a car and the number of gears in the car. Which of the following is the best test to use?

An analyst is compiling a series of reports for the new executive board to review. Which of the following elements provides a snapshot of what is contained in the reports for the executives who do not have time to focus on the details?

An analyst wants to determine whether a relationship between an individual's age and voting preferences exists. Which of the following is the best statistical method for the analyst to use?

A data architect is designing a data solution for a retail clothing store chain. Each store has a database that tracks sales transactions. The data architect needs to create a summary table that will be used for a senior executive dashboard. The summary table should not contain duplicate store information. Which of the following should the data architect create?