CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 61:

  A data analyst is joining two tables with different content and one common field. Which of the following should the analyst do to most efficiently meet this requirement?

  A. Match the records of the related columns and merge the tables.
  B. Create a cluster to facilitate data integration between the tables.
  C. Explode both tables to identify unique values and reorder the fields in one table.
  D. Append the values of the matching columns and concatenate the other data fields.
  A. Match the records of the related columns and merge the tables.

• Question 62:

  Which of the following is the correct data type for text?

  A. Boolean
  B. String
  C. Integer
  D. Float
  B. String

• Question 63:

  A data analyst troubleshoots a dashboard every day for a week. Which of the following techniques best addresses how to validate the data moving forward?

  A. Inquiring about structure changes
  B. Setting up monitoring alerts
  C. Reaching out to users daily
  D. Rebuilding the dashboard
  B. Setting up monitoring alerts

• Question 64:

  A data analyst receives a notification that a customized report is taking too long to load. After reviewing the system, the analyst does not find technical or operational issues. Which of the following should the analyst try next?

  A. Check that the appropriate filters are applied.
  B. Check data source connections.
  C. Check for data structure changes in the report.
  D. Check whether other peers have the same issue.
  A. Check that the appropriate filters are applied.

• Question 65:

  A recent server migration applied an update to dataset naming conventions. Multiple users are now reporting stale information in an existing dashboard. The date in the dataset confirms a successful data refresh. Which of the following should a data analyst do first?

  A. Confirm the dashboard is pointed to the newest dataset.
  B. Filter the data in the dashboard.
  C. Escalate user permissions on the server.
  D. Verify that the dashboard subscription is not expired.
  A. Confirm the dashboard is pointed to the newest dataset.

• Question 66:

  Which of the following is an example of a discrete data type?

  A. 8in (20cm)
  B. 5 kids
  C. 2.5mi (4km)
  D. 10.7lbs (4.9kg)
  B. 5 kids

• Question 67:

  The duration of a phone call in milliseconds is an example of:

  A. ordinal data.
  B. nominal data.
  C. boolean data.
  D. continuous data.
  D. continuous data.

• Question 68:

  An analyst is building a reporting deck. The deck must include tracking and visualizing metrics and row-level security. Which of the following actions should the analyst take after meeting all of the requirements?

  A. Show a mock-up to the team.
  B. Explain the desired level of reporting detail.
  C. Present an analysis of the data.
  D. Find out the project due date.
  A. Show a mock-up to the team.

• Question 69:

  A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final.

  Which of the following is the BEST way to meet this stakeholder requirement?

  A. Display the version number next to each submission on the dashboard.
  B. Present a data refresh date at the top of the dashboard.
  C. Confirm the dashboard is adhering to the corporate style guide.
  D. Use permissions to ensure users only see certain versions of the submissions.
  A. Display the version number next to each submission on the dashboard.

• Question 70:

  Which of the following best describes an assessment a data analyst would use to validate that the number of records in a dataset matches the expected results?

  A. Source control
  B. Unit test
  C. Stress test
  D. Health check
  B. Unit test