CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 11:

  A data analyst deployed a report for public access. A user states that the report is not showing the latest information, even though the user updated the source an hour ago. Which of the following should the data analyst check first?

  A. Event log
  B. User privileges
  C. Database connection
  D. Report corruption
  C. Database connection

• Question 12:

  Which of the following data repositories should a company use when structured data about the whole company needs to be stored in a predefined data structure?

  A. Data mart
  B. Data warehouse
  C. Data silo
  D. Data lake
  B. Data warehouse

• Question 13:

  A research analyst wants to determine whether the data being analyzed is connected to other datapoints. Which of the following is the BEST type of analysis to conduct?

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

• Question 14:

  A data analyst needs to identify outliers from a given dataset. Which of the following visualizations is the best way to identify outliers?

  A. Box plot
  B. Scatter plot
  C. Gantt chart
  D. Waterfall chart
  A. Box plot

• Question 15:

  An analyst is preparing a report that contains weather data. The temperatures are shown in Fahrenheit. but they must be reported in Celsius. Which of the following should the analyst do to fix this issue?

  A. Normalize the data.
  B. Standardize the data.
  C. Rescale the data.
  D. Aggregate the data.
  C. Rescale the data.

• Question 16:

  Given the following tables:

  

  Which of the following will be the dimensions from a FULL JOIN of the tables above?

  A. Two rows and three columns
  B. Three rows and four columns
  C. Four rows and two columns
  D. Four rows and four columns
  D. Four rows and four columns

• Question 17:

  Which of the following explains the purpose of UAT?

  A. To begin the software application development process to enhance user experience
  B. To ensure all parts of the software application work together after each sprint
  C. To review software application crashes, create patches, and deploy to users
  D. To validate and verify that a software application meets the needs and requirements of users
  D. To validate and verify that a software application meets the needs and requirements of users

• Question 18:

  Which of the following data repositories stores unformatted data in its original, raw form?

  A. Data warehouse
  B. Data silo
  C. Data mart
  D. Data lake
  D. Data lake

• Question 19:

  Given the following table: Which of the following data types should an analyst use for the numeric values in the Value column?

  

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

• Question 20:

  The following SQL code returns an error in the program console:

  SELECT firstName, lastName, SUM(income)

  FROM companyRoster

  SORT BY lastName, income

  Which of the following changes allows this SQL code to run?

  A. SELECT firstName, lastName, SUM(income) FROM companyRoster HAVING SUM(income) > 10000000
  B. SELECT firstName, lastName, SUM(income) FROM companyRoster GROUP BY firstName, lastName
  C. SELECT firstName, lastName, SUM(income) FROM companyRoster ORDER BY firstName, income
  D. SELECT firstName, lastName, SUM(income) FROM companyRoster
  B. SELECT firstName, lastName, SUM(income) FROM companyRoster GROUP BY firstName, lastName