DA0-001 Practice Test practice questions, page 17 of 17, with answer review and explanations.
Question 81
An analyst has conducted a review of business questions. Which of the following should the analyst do next to conduct an analysis?
Determine the data needs and review the observations.
Determine the data needs and sources for analysis.
Determine the data needs and schedule interviews.
Determine the data needs and begin the analysis.
Question 82
A data analyst is compiling a report that a Chief Executive Officer needs for an impromptu meeting. The report should include information on the previous day’s performance. Which of the following reports should the analyst provide?
Tactical
Ad hoc
Dynamic
Recurring
Question 83
Which of the following tools would be best to use to calculate the interquartile range, median, mean, and standard deviation of a column in a table that has 5,000,000 rows?
Microsoft Excel
R
Snowflake
SQL
Question 84
Which of the following data acquisition concepts is the most appropriate for determining the quality of a company’s product?
Web scraping
Observation
Survey
Sampling
Question 85
Given the following: Which of the following is the most important thing for an analyst to do when transforming the table for a trend analysis?
Fill in the missing cost where it is null.
Separate the table into two tables and create a primary key.
Replace the extended cost field with a calculated field.