CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 21:

  An analyst is working on a project for a director. During this process. the analyst pulled the data. created summarized tables and graphs with descriptions, created a report summary, and inserted all items into a report. After writing the report, which of the following would be the most appropriate next step?

  A. Complete an audit on the data pulled for the report.
  B. Complete a check for quality in the report.
  C. Complete a review of the data and a check for consistency
  D. Complete a trend analysis to be included in the report.
  B. Complete a check for quality in the report.

• Question 22:

  A company wants to limit an employee's access to a production environment. Which of the following access control practices is the best to implement?

  A. Mandatory
  B. Time-based
  C. Attribute-based
  D. Role-based
  D. Role-based

• Question 23:

  A data analyst needs to get an accurate idea of how data components are automated. Which of the following types of documentation should the analyst review first?

  A. Data flow diagram
  B. Data explainability report
  C. Data dictionary
  D. Data lineage
  A. Data flow diagram

• Question 24:

  A data analyst is creating a pivot table for a large dataset for an upcoming board meeting. Which of the following is the purpose of the pivot table?

  A. To visualize the data in a dashboard
  B. To retrieve and clean data from several sources
  C. To summarize and analyze the data
  D. To organize the data for reporting
  C. To summarize and analyze the data

• Question 25:

  Which of the following is an example of structured data?

  A. A credit card number
  B. An email
  C. A photo
  D. Social media correspondence
  A. A credit card number

• Question 26:

  A military commander would like to see the health scorecards of the troops daily and filter them based on gender and rank. Considering this data is PHI, which of the following would be the best way for the commander to view the information?

  A. An emailed report
  B. A password-protected dashboard
  C. A daily printout of a report
  D. A cloud-hosted spreadsheet
  B. A password-protected dashboard

• Question 27:

  Before distributing a report, a marketing analyst notices that the total distinct promotional email messages is less than the combined total of emails sent. Which of the following is the most likely reason for this difference?

  A. The aggregation did not include all emails.
  B. Some emails were not delivered.
  C. The report failed to run properly.
  D. A recipient received duplicate emails.
  D. A recipient received duplicate emails.

• Question 28:

  Which of the following data repositories stores unaltered data?

  A. Data lake
  B. Data warehouse
  C. Data table
  D. Data factory
  A. Data lake

• Question 29:

  A company reports on seven years of data in a sales dashboard. The dashboard pulls from a sales database that has 30 years of data. The dashboard performance is slow. Which of the following is the best way to improve the dashboard's performance?

  A. Performing a code review
  B. Checking network connectivity
  C. Filtering to include only relevant data
  D. Adding more RAM and rerunning
  C. Filtering to include only relevant data

• Question 30:

  Which of the following best describes the semi-structured data that is gathered when web scraping?

  A. JSON
  B. CSV
  C. CSS
  D. HTML
  A. JSON