DA0-002 Practice Test

DA0-002 Practice Test practice questions, page 4 of 6, with answer review and explanations.

Question 16

After a database upgrade, a report using datetime calculations does not complete due to an arithmetic overflow error. Which of the following is the best way for a data analyst to troubleshoot the issue?

  1. Changing the report filter
  2. Reviewing error logs
  3. Verifying the columns' data types
  4. Checking that the data has refreshed

Question 17

A data analyst is preparing a report for external users. The analyst must ensure that visuals can be identified as belonging to the organization. Which of the following should the analyst add to the report to best meet this requirement?

  1. Legal disclaimer
  2. Infographic
  3. Subtitle
  4. Watermark

Question 18

Given the following data set: Which of the following is the mode?

  1. 35
  2. 37
  3. 41
  4. 43

Question 19

A data analyst is evaluating all conditions in a query. Which of the following is the best logical function to accomplish this task?

  1. OR
  2. NOT
  3. AND
  4. IF

Question 20

A data analyst is helping a company achieve its strategic goals. Which of the following types of analytics should the analyst incorporate into the dashboards and tools delivered to the company?

  1. Prescriptive
  2. Predictive
  3. Diagnostic
  4. Descriptive