CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 51:

  A data analyst needs to create and deliver a dashboard that displays the company's financial transactions as they are updated. Which of the following delivery methods should the analyst consider? (Select two).

  A. Real-time
  B. Snapshot
  C. Dynamic
  D. Static
  E. Ad hoc
  F. Time series
  A. Real-time
  C. Dynamic

• Question 52:

  A data analyst is creating a new dataset that involves bringing together the following datasets: Name

  ID Date of birth Frank 23525 3/19

  Martha 11290

  6/13

  Ellen

  12141

  11/4

  ID Address City

  State

  23525

  1234 Harding

  Chicago

  IL

  12141

  935 Terrace Hills

  Chino

  CA

  11290

  2 Speedway

  Miami

  FL

  Which of the following would be the output if the data analyst does a FULL JOIN?

  A. Name ID Date of birth Address City State Frank 23525 3/19 1234 Harding Chicago IL Martha 11290 6/13 935 Terrace Hills Chino CA Ellen 12141 11/4 2 Speedway Miami FL
  B. Name ID Date of birth Address City State Frank 23525 3/19 1234 Harding Chicago IL Martha 11290 6/13 935 Terrace Hills Chino CA Ellen 12141 11/4 2 Speedway Miami FL
  C. Name ID Date of birth Address City State Frank 23525 3/19 1234 Harding Chicago IL Martha 11290 6/13 2 Speedway Miami FL Ellen 12141 11/4 935 Terrace Hills Chino CA
  D. Name ID Date of birth Address City State Frank 23525 3/19 1234 Harding Chicago IL Martha 11290 6/13 2 Speedway Miami FL Ellen 12141 11/4 11040 935 Terrace Hills Chino CA
  D. Name ID Date of birth Address City State Frank 23525 3/19 1234 Harding Chicago IL Martha 11290 6/13 2 Speedway Miami FL Ellen 12141 11/4 11040 935 Terrace Hills Chino CA

• Question 53:

  A data analyst is creating a dashboard and trying to identify the type of information that should be included. Which of the following should the analyst consider first?

  A. Data refresh rate
  B. Consumer types
  C. Access permissions
  D. Data sources and attributes
  D. Data sources and attributes

• Question 54:

  Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders. Which one of the following tools is least likely to meet her needs?

  A. QuickSight.
  B. Tableau.
  C. Power BI.
  D. SPSS Modeler.
  D. SPSS Modeler.

• Question 55:

  A sales manager wants to understand how sales are trending year over year. Which of the following chart types is the most appropriate to display the information?

  A. Line
  B. Donut
  C. Bubble
  D. Hierarchy
  A. Line

• Question 56:

  Which of the following types of analysis is used when comparing last week's sales to the previous week's sales?

  A. Trend analysis
  B. Exploratory analysis
  C. Prescriptive analysis
  D. Link analysis
  A. Trend analysis

• Question 57:

  Exhibit.

  

  Which of the following logical statements results in Table B?

  A. IF Name = "James" and Gender_flag = "College" then delete
  B. IF Name = "Sam" and Gender_flag = "Male" then delete
  C. IF Name = "Pat" and Gender_flag = "Female" then delete
  D. IF Name = "Sean" and Gender_flag = "College" then delete
  D. IF Name = "Sean" and Gender_flag = "College" then delete

• Question 58:

  A data analyst is working with a team to create a dashboard for a client who requires on- demand access. Which of the following is the best delivery method to support the clients' requirement?

  A. Email
  B. Scheduled
  C. Subscription
  D. Static
  C. Subscription

• Question 59:

  A data analyst wants to understand several datasets at the variable level. Which of the following should the analyst consult to find this information?

  A. Data lineage
  B. Data dictionary
  C. Data flow diagram
  D. Data versioning
  B. Data dictionary

• Question 60:

  What would be an example of an acceptable form of primary identification for the Data+ exam?

  A. Passport.
  B. School ID card.
  C. Employee ID card.
  D. Credit card with photo and signature.
  A. Passport.