CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 111:

  A report triggers an error that prevents information from being displayed. However, the report was functional before a database upgrade. Which of the following should a data analyst do first to troubleshoot the problem?

  A. Ensure the system has permissions for the report service.
  B. Change the report's refresh rate.
  C. Verify the connection to the database.
  D. Check whether the data structures were modified.
  C. Verify the connection to the database.

• Question 112:

  A sales manager wants a dashboard that shows sales aggregated by region and identifies high-volume sales by salesperson per region. Which of the following communication techniques best displays this information?

  A. Defined parameters
  B. Filter options
  C. Level of detail
  D. User persona
  B. Filter options

• Question 113:

  Due to new reporting requirements, a data analyst must add new classification codes to historical data. Which of the following is the best technique for this task?

  A. Append
  B. Binning
  C. Parsing
  D. Union
  A. Append

• Question 114:

  A data analyst is creating a report that will provide information about various regions, products, and time periods. Which of the following formats would be the most efficient way to deliver this report?

  A. A workbook with multiple tabs for each region
  B. A daily email with snapshots of regional summaries
  C. A static report with a different page for every filtered view
  D. A dashboard with filters at the top that the user can toggle
  D. A dashboard with filters at the top that the user can toggle

• Question 115:

  A data analyst is preparing a survey for Paralympic Games athletes. Which of the following should the analyst consider when creating this survey?

  A. Idioms
  B. Color contrast
  C. Refresh speed
  D. Granularity
  B. Color contrast

• Question 116:

  Emma is working in a data warehouse and finds a finance fact table links to an organization dimension, which in turn links to a currency dimension that not linked to the fact table. What type of design pattern is the data warehouse using?

  A. Star.
  B. Sun.
  C. Snowflake.
  D. Comet.
  C. Snowflake.

• Question 117:

  Which of the following best enables the retrieval and manipulation of data that is stored in a relational database?

  A. XML
  B. SQL
  C. Excel
  D. JavaScript
  B. SQL

• Question 118:

  Which of the following summary statements upholds integrity in data reporting?

  

  A. Sales are approximately equal for Product A and Product B across all strategies.
  B. Strategy 4 provides the best sales in comparison to other strategies.
  C. While Strategy 2 does not result in the highest sales of Product
  D. Product D should be promoted more than the other products in all strategies.
  C. While Strategy 2 does not result in the highest sales of Product

• Question 119:

  An analysts building a monthly report for production and wants to ensure the audience is aware of its once-a-month cadence. Which of the following is the MOST important to convey that information?

  A. The date of the dashboard build
  B. The data refresh date
  C. A report summary
  D. Frequently asked questions
  A. The date of the dashboard build

• Question 120:

  Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

  A. SAS
  B. Microsoft Power B1
  C. IBM SPSS
  D. Python
  D. Python