DA0-002 Practice Test

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

Question 6

A data analyst needs to use one table's data to refine data selection from a second table. Which of the following is the most efficient way?

  1. Subquery
  2. Aggregate
  3. Union
  4. Join

Question 7

Which of the following is found in metadata?

  1. Transformations
  2. Data lineage
  3. Syntax
  4. Variable types

Question 8

Which of the following allows the transfer of isolated applications to multiple environments?

  1. Virtualization
  2. Version control
  3. Continuous integration
  4. Containerization

Question 9

A data breach occurs at a company. Which of the following actions should be taken?

  1. Make an announcement on social media so customers are aware as soon as possible.
  2. Tell the company management team and then tell regulatory agencies.
  3. Keep the incident a secret until the issue is resolved.
  4. Inform the entire IT sector, but ask for discretion.

Question 10

A data analyst is modeling a new data warehouse to analyze sales. One of the requirements is to analyze sales by region. Which of the following best describes the region table?

  1. Fact
  2. Dimensional
  3. Bridge
  4. Snowflake