CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 161:

  Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

  A. Rephrase the business requirement.
  B. Determine the data necessary for the analysis.
  C. Build a mock dashboard/presentation layout.
  D. Perform exploratory data analysis.
  B. Determine the data necessary for the analysis.

• Question 162:

  A grocery store wants to view the revenue from the previous year, highlighting individual departments. Which of the following is the most appropriate chart to communicate this information?

  A. Gantt
  B. Pie
  C. Area
  D. Line
  B. Pie

• Question 163:

  A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?

  A. A real-time monitor that allows the manager to view performance the day the campaign was launched
  B. A sell-service dashboard that allows the manager to look at the company's annual budget performance
  C. A spreadsheet of the raw data from all marketing campaigns and channels
  D. A summary with statistics, conclusions, and recommendations from the data analyst
  D. A summary with statistics, conclusions, and recommendations from the data analyst

• Question 164:

  An analyst needs to create an analytics dashboard for an employee intranet site to improve the search functionality, display relevant information, and maintain an updated FAQ page. Which of the following visualizations would best represent what employees are searching for?

  A. A word cloud
  B. A histogram
  C. A pie chart
  D. A scatter plot
  A. A word cloud

• Question 165:

  A manager wants a report that contains the days off for each direct report. The manager needs this report to always be up-to-date with the latest data. Which of the following describes the refresh frequency that the manager is requesting?

  A. Real-time
  B. Ad hoc
  C. Snapshot
  D. Dynamic
  A. Real-time

• Question 166:

  A data analyst created a dashboard to illustrate the traffic volume and mean response time for a call center. The traffic data is current, but the mean response time has not updated for more than an hour. Which of the following is the best way to verify the data's freshness?

  A. Refactoring the code base
  B. Testing for network connectivity issues
  C. Checking the last time the calculation script ran
  D. Determining the number of calls with no timestamps
  C. Checking the last time the calculation script ran

• Question 167:

  The total values in this month's revenue report are twice as much as last month's. Which of the following most likely occurred during the ETL process?

  A. The data cleansing processes failed to execute.
  B. The database connectivity failed.
  C. The report included the previous month's data.
  D. The data normalization processes failed.
  C. The report included the previous month's data.

• Question 168:

  A data analyst needs to create a report that anticipates the number of calls received daily. Which of the following is the best statistical method to use?

  A. Predictive
  B. Diagnostic
  C. Inferential
  D. Descriptive
  A. Predictive

• Question 169:

  A data analyst needs to create a combined report that includes information from the following two tables: Which of the following query methods should the analyst use for this task?

  

  A. Group
  B. Join
  C. Union
  D. Nested
  C. Union

• Question 170:

  Given the following dataset: Which of the following is the mode?

  

  A. 346
  B. 446
  C. 455
  D. 559
  A. 346