DA0-001 Practice Test

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

Question 46

Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?

  1. Simple random
  2. Cluster
  3. Systematic
  4. Stratified

Question 47

Given the following customer and order tables: Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

  1. Five rows, eight columns
  2. Seven rows, eight columns
  3. Eight rows, seven columns
  4. Nine rows, five columns

Question 48

A development company is constructing a new unit in its apartment complex. The complex has the following floor plans: Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?

  1. $640,900
  2. $690,000
  3. $705,200
  4. $702,500

Question 49

Which of the following is a control measure for preventing a data breach?

  1. Data transmission
  2. Data attribution
  3. Data retention
  4. Data encryption

Question 50

A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

  1. Create multiple reports, one for each needed date range.
  2. Build calculations into the report so they are done automatically.
  3. Add macros to the report to speed up the filtering and calculations process.
  4. Create a dashboard with a date range picker and calculations built in.