CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 141:

  Given the following data tables:

  

  Which of the following MDM processes needs to take place FIRST?

  A. Creation of a data dictionary
  B. Compliance with regulations
  C. Standardization of data field names
  D. Consolidation of multiple data fields
  A. Creation of a data dictionary

• Question 142:

  A development company is constructing a new unit in its apartment complex. The complex has the following floor plans:

  

  Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?

  A. $640,900
  B. $690,000
  C. $705,200
  D. $702,500
  C. $705,200

• Question 143:

  A data analyst needs to modify a dashboard that was created by another employee. Upon opening the dashboard, the analyst notices that the information is not loading properly. Which of the following should the analyst do to troubleshoot this error?

  A. Review the data layer and data source.
  B. Validate that the database is up-to-date.
  C. Check that the program is updated to the latest version.
  D. Ensure the correct filters are displaying on the dashboard.
  A. Review the data layer and data source.

• Question 144:

  A table contains several rows of cellular numbers with call timestamps, call durations, called numbers, and carriers of the called number. Which of the following allows a data analyst to sort the cellular numbers based on the carriers of the called numbers and include the total call durations?

  A. SELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY cellular_number ORDER BY called_number_carrier;
  B. SELECT cellular_number, SUM(call_duration) FROM calls GROUP BY call_duration ORDERBY called_number_carrier;
  C. SELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY cellular_number, called_number_carrier ORDER BY called_number_carrier;
  D. SELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY call_duration ORDER BY called_number_carrier;
  C. SELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY cellular_number, called_number_carrier ORDER BY called_number_carrier;

• Question 145:

  Which of the following best describes the function of a data type?

  A. To provide a generic identifier for files used in analysis
  B. To identify the program needed to open a file
  C. To differentiate the real value of the field in its context
  D. To make the addition of individual records simpler
  C. To differentiate the real value of the field in its context

• Question 146:

  A data analyst receives the following sales data for a convenience store: The analyst needs to provide information on the products that contain chocolate. Which of the following RegEx should the analyst use to filter the chocolate products?

  

  A. Chocolate!
  B. Chocolate$
  C. %Chocolateand
  D. #Chocolate#$
  B. Chocolate$

• Question 147:

  A company has a document that includes the names of key metrics and the standard for how those metrics are calculated company-wide. Which of the following describes this documentation?

  A. Data dictionary
  B. Data explainability report
  C. Data lineage
  D. Data flow diagram
  A. Data dictionary

• Question 148:

  The human resources department wants to know the number of employees who earn $125,000 or more. However, the department is concerned about duplicates in the dataset. Given the following table:

  

  Which of the following SQL statements resolves this issue?

  A. SELECT DISTINCT Employee_ID FROM Employee WHERE Salary >= 125000
  B. SELECT COUNT(DISTINCT Employee_ID) FROM Employee WHERE Salary >= 125000
  C. SELECT DISTINCT Employee_ID FROM Employee WHERE Salary > 125000
  D. SELECT COUNT(Employee_ID) FROM Employee WHERE Salary >= 125000
  B. SELECT COUNT(DISTINCT Employee_ID) FROM Employee WHERE Salary >= 125000

• Question 149:

  A data analyst receives a flat file that includes dates. The analyst needs to calculate the number of days from the dates on the file to the current date. Which of the following is the best way to complete this task?

  A. Convert data to date format and use date functions.
  B. Validate the date format with logical functions and use date functions to analyze.
  C. Use date functions to analyze the data with no conversion.
  D. Transform data to a numerical value and use mathematical functions.
  A. Convert data to date format and use date functions.

• Question 150:

  Which of the following is an object associated with a table that sorts and stores table row data in a key-value pair?

  A. Foreign key
  B. Function
  C. Stored procedure
  D. Clustered index
  D. Clustered index