CompTIA DA0-001 Practice Test - Questions Answers, Page 23
List of questions
Question 221

A data analyst needs to create a master file that includes customer information from the tables below:
Given the three tables above, the analyst wants to filter down the information prior to joining it together. In which of the following orders should this data manipulation bo approached for the most efficient result?
Question 222

Which of the following technologies would be best suited for creating a multiple linear regression model?
Question 223

A customer survey reveals 90% positive feedback. Which of the following statistical methods would be best to utilize to determine the reliability of a data set and predict how a larger sample of customers over the same time period might respond?
Question 224

Each month an analyst needs to execute a data pull for the two prior months. Which of the following is the most efficient function for the analyst to use?
Question 225

Given the following report:
Which of the following components need to be added to ensure the report is point-in-time and static? (Select two).
Question 226

Given the image below:
Which of the following file formats is depicted?
Question 227

Which of the following is the most likely reason for a data analyst to optimize a query using parameterization?
Question 228

An analyst is designing a dashboard that will provide a story of the sales and sales customer ratio. The following data is available:
Which of the following charts should the analyst consider including in the dashboard?
Question 229

Which of the following describes the use of a representative amount of data from a main repository?
Question 230

A marketing analytics team received customer transaction data from two different sources. The data is complete and accurate; however, the field names appear to be inconsistent. Given the following tables:
Which of the following is considered best practice if the team wants to consolidate the files and conduct further analysis?
Question