Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. CompTIA
  5. DA0-002

Free CompTIA DA0-002 Exam Questions (page: 6)

Page 3 of 15
PDF with 111 Questions

[Data Concepts and Environments]
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?

  1. Data dictionary
  2. Data explainability report
  3. Data lineage
  4. Data flow diagram

Answer(s): A



[Visualization and Reporting]
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).

  1. Real-time
  2. Snapshot
  3. Dynamic
  4. Static
  5. Ad hoc
  6. Time series

Answer(s): A,C



[Data Analysis]
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?

  1. SELECT JOB_TYPE, COUNT DISTINCT(EMPLOYEE_ID) FROM JOBS
  2. SELECT DISTINCT COUNT(EMPLOYEE_ID) FROM JOBS
  3. SELECT JOB_TYPE, COUNT(DISTINCT EMPLOYEE_ID) FROM JOBS
  4. SELECT COUNT(DISTINCT EMPLOYEE_ID) FROM JOBS

Answer(s): D



[Data Governance]
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?

  1. Refactoring the code base
  2. Testing for network connectivity issues
  3. Checking the last time the calculation script ran
  4. Determining the number of calls with no timestamps

Answer(s): C



[Data Governance]
Which of the following pieces of information, if made public, results in a data privacy violation?

  1. Gender
  2. Driver's license
  3. Age
  4. Employment status

Answer(s): B



[Data Acquisition and Preparation]
A data analyst receives four files that need to be unified into a single spreadsheet for further analysis. All of the files have the same structure, number of columns, and field names, but each file contains different values.
Which of the following methods will help the analyst convert the files into a single spreadsheet?

  1. Merging
  2. Appending
  3. Parsing
  4. Clustering

Answer(s): B



[Data Analysis]
A data analyst team needs to segment customers based on customer spending behavior. Given one million rows of data like the information in the following sales order table:

Customer_ID
Region
Amount_spent
Product_category
Quantity_of_items
00123
East
20000
Baby
00124
West
30000
Home
00125
South
40000
Garden
00126
North
50000
Furniture
00127
East
60000
Baby
Which of the following techniques should the team use for this task?

  1. Standardization
  2. Concatenate
  3. Binning
  4. Appending

Answer(s): C



[Data Governance]
A data analyst receives a notification that a customized report is taking too long to load. After reviewing the system, the analyst does not find technical or operational issues.
Which of the following should the analyst try next?

  1. Check that the appropriate filters are applied.
  2. Check data source connections.
  3. Check for data structure changes in the report.
  4. Check whether other peers have the same issue.

Answer(s): A



Viewing page 6 of 15



Post your Comments and Discuss CompTIA DA0-002 exam prep with other Community members:

DA0-002 Exam Discussions & Posts