CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 31:

  A data analyst is gathering data from multiple tables in a database. The analyst needs certain columns from each table. Which of the following is the best method to accomplish this task?

  A. Aggregate
  B. Union
  C. Nest
  D. Join
  D. Join

• Question 32:

  A data analyst receives a new data source that contains employee IDs, job titles, dates of birth, addresses, years of service, and employees' birth months. Which of the following inconsistencies should the analyst identify?

  A. Redundancy
  B. Equivalence
  C. Parallel
  D. Duplication
  A. Redundancy

• Question 33:

  A manager wants to use the information in a recurring report on incomplete timesheets for the prior month to guide employee outreach. Which of the following report types is the best for this task?

  A. Summary
  B. Infographic
  C. Snapshot
  D. Ad hoc
  A. Summary

• Question 34:

  A data analyst is designing a report for the business review team. The team lists the following requirements for the report:

  1.Specific data points

  2.Color branding

  3.Labels and terminology

  4.Suggested charts and tables

  Which of the following components is missing from the requirements?

  A. Source validation
  B. Design elements
  C. Delivery method
  D. Report type
  C. Delivery method

• Question 35:

  Q3 2020 has just ended, and now a data analyst needs to create an ad-hoc sales report that demonstrates how well the Q3 2020 promotion went versus last year's Q3 promotion. Which of the following date parameters should the analyst use?

  A. 2019 vs. YTD 2020
  B. Q3 2019 vs. Q3 2020
  C. YTD 2019 vs. YTD 2020
  D. Q4 2019 vs. Q3 2020
  B. Q3 2019 vs. Q3 2020

• Question 36:

  A data analyst pulls a table similar to the following one:

  

  Which of the following best explains the data issue with TypeID?

  A. Redundancy
  B. Outlier
  C. Missing data
  D. Duplication
  A. Redundancy

• Question 37:

  A Chief Executive Officer requests a report that must:

  1.Summarize the company metrics in a simple way.

  2.Be clear and concise.

  3.Be easily understood by all company levels.

  4.Be accessible and updated without manual intervention.

  Which of the following communication approaches best meets these requirements?

  A. Executive summary
  B. Slide presentation
  C. Key performance indicator dashboard
  D. Open data portal
  C. Key performance indicator dashboard

• Question 38:

  Which of the following is the best tool for creating a dynamic dashboard?

  A. Power BI
  B. RStudio
  C. Excel
  D. SAS
  A. Power BI

• Question 39:

  Which of the following is a NoSQL database?

  A. PostgreSQL
  B. MySQL
  C. Oracle
  D. MongoDB
  D. MongoDB

• Question 40:

  What role in a data governance is typically responsible for day-to-day oversight of data use?

  A. Data processors.
  B. Data custodians
  C. Data owners.
  D. Data stewards.
  D. Data stewards.