DA0-001 Practice Test

DA0-001 Practice Test practice questions, page 2 of 17, with answer review and explanations.

Question 6

Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

  1. Duplicate data
  2. Missing data
  3. Data outliers
  4. Invalid data type

Question 7

Which of the following is a process that is used during data integration to collect, blend, and load data?

  1. MDM
  2. ETL
  3. OLTP
  4. BI

Question 8

An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?

  1. Optimize the dashboard.
  2. Create subscriptions.
  3. Get stakeholder approval.
  4. Deploy to production.

Question 9

A data analyst has been asked to derive a new variable labeled “Promotion_flag” based on the total quantity sold by each salesperson. Given the table below: Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

  1. Date
  2. Mathematical
  3. Logical
  4. Aggregate

Question 10

Given the diagram below: Which of the following data schemas shown?

  1. Key-value pairs
  2. Online transactional processing
  3. Data lake
  4. Relational database