CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 151:

  Which of the following is an example of a at flat file?

  A. CSV file
  B. PDF file
  C. JSON file
  D. JPEG file
  D. JPEG file

• Question 152:

  A data analyst needs to remove all duplicate values between two tables, "Employees" and "Managers," using SQL SELECT statements. Which of the following should the analyst use for this task?

  A. SELECT * FROM Employees UNION ALL SELECT * FROM Managers
  B. SELECT * FROM Employees UNION SELECT * FROM Managers
  C. SELECT * FROM Employees JOIN SELECT * FROM Managers
  D. SELECT * FROM Employees CROSS JOIN SELECT * FROM Managers
  B. SELECT * FROM Employees UNION SELECT * FROM Managers

• Question 153:

  A data analyst receives a request for the current employee head count and runs the following SQL statement:

  SELECT COUNT(EMPLOYEE_ID) FROM JOBS

  The returned head count is higher than expected because employees can have multiple jobs. Which of the following should return an accurate employee head count?

  A. SELECT JOB_TYPE, COUNT DISTINCT(EMPLOYEE_ID) FROM JOBS
  B. SELECT DISTINCT COUNT(EMPLOYEE_ID) FROM JOBS
  C. SELECT JOB_TYPE, COUNT(DISTINCT EMPLOYEE_ID) FROM JOBS
  D. SELECT COUNT(DISTINCT EMPLOYEE_ID) FROM JOBS
  D. SELECT COUNT(DISTINCT EMPLOYEE_ID) FROM JOBS

• Question 154:

  Which of the following types of analyses should be used to evaluate the connections and anomalies in a data set when either known patterns are being violated or new patterns are emerging?

  A. Correlation
  B. Descriptive
  C. Graph
  D. Regression
  C. Graph

• Question 155:

  Five dogs have the following heights in millimeters:

  300, 430, 170, 470, 600

  Which of the following is the mean height for the five dogs?

  A. 394mm
  B. 405mm
  C. 493mm
  D. 504mm
  A. 394mm

• Question 156:

  Joseph is interpreting a left skewed distribution of test scores. Joe scored at the mean, Alfonso scored at the median, and gaby scored and the end of the tail. Who had the highest score?

  A. Joseph
  B. Joe
  C. Alfonso
  D. Gaby
  C. Alfonso

• Question 157:

  A developer builds an online survey that requires all questions to have an answer. Which of the following inconsistencies does this setting prevent?

  A. Missing values
  B. Duplication
  C. Data corruption
  D. Completeness
  A. Missing values

• Question 158:

  A data analyst wants to use the following tables to find all the customers who have not placed an order:

  

  Which of the following SQL statements is the best way to accomplish this task?

  A. SELECT * FROM CUSTOMERS AS C LEFT JOIN PRODUCTS AS P ON C.ID =
  B. Customer_ID WHERE P.Customer_ID IS NULL
  C. SELECT * FROM CUSTOMERS AS C INNER JOIN PRODUCTS AS P ON C.ID =
  D. IDWHERE COUNT(P.) = 0
  E. SELECT * FROM PRODUCTS AS P INNER JOIN CUSTOMERS AS C ON
  F. Customer_ID = C.ID WHERE (SELECT COUNT(P.) = 0)
  G. SELECT * FROM PRODUCTS AS P LEFT JOIN CUSTOMERS AS C ON
  H. Customer_ID = C.ID WHERE P.Customer_ID IS NOT NULL
  A. SELECT * FROM CUSTOMERS AS C LEFT JOIN PRODUCTS AS P ON C.ID =

• Question 159:

  Which of the following best describes the reason an analyst would reference a data dictionary versus a source's metadata?

  A. To gather information and resources about the data
  B. To find the content and specific attributes for a dataset
  C. To find a summary of basic information about the dataset
  D. To gather information about the availability of the data
  B. To find the content and specific attributes for a dataset

• Question 160:

  An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

  

  Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

  A. Aggregate
  B. Logical
  C. Date
  D. Sort
  B. Logical