DA0-001 Practice Test

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

Question 36

Which of the following data manipulation techniques is an example of a logical function?

  1. WHERE
  2. AGGREGATE
  3. BOOLEAN
  4. IF

Question 37

A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals’ earned commissions and projected commissions based on sales, but they want that information to be kept confidential. Which of the following would be the BEST way to provide this visibility?

  1. Create a dashboard displaying a data refresh date so users know the current sales numbers and configure permissions to control access.
  2. Create a dashboard for sales numbers, pipeline, and team and individual performance for the management team.
  3. Create a dashboard with filters for the overall team, individuals, and management. Users can filter to see the data they want.
  4. Create a dashboard with views for team, individuals, and management. Configure permissions to control access.

Question 38

Which of the following is a characteristic of a relational database?

  1. It utilizes key-value pairs.
  2. It has undefined fields.
  3. It is structured in nature.
  4. It uses minimal memory.

Question 39

A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?

  1. January 1, 2020 to April 1, 2020
  2. January 1, 2020 to April 7, 2020
  3. January 1, 2020 to April 8, 2020
  4. January 1, 2020 to April 9, 2020

Question 40

Given the following data tables: Which of the following MDM processes needs to take place FIRST?

  1. Creation of a data dictionary
  2. Compliance with regulations
  3. Standardization of data field names
  4. Consolidation of multiple data fields