Free CompTIA Data+ Exam (2025) Exam DA0-002 Exam Practice Test

[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?

• Merging
• Appending
• Parsing
• Clustering

[Data Analysis]The following SQL code returns an error in the program console:SELECT firstName, lastName, SUM(income) FROM companyRosterSORT BY lastName, incomeWhich of the following changes allows this SQL code to run?

• SELECT firstName, lastName, SUM(income) FROM companyRoster HAVING SUM(income) > 10000000
• SELECT firstName, lastName, SUM(income) FROM companyRoster GROUP BY firstName, lastName
• SELECT firstName, lastName, SUM(income) FROM companyRoster ORDER BY firstName, income
• SELECT firstName, lastName, SUM(income) FROM companyRoster

[Data Governance]A company reports on seven years of data in a sales dashboard. The dashboard pulls from a sales database that has 30 years of data. The dashboard performance is slow. Which of the following is the best way to improve the dashboard's performance?

• Performing a code review
• Checking network connectivity
• Filtering to include only relevant data
• Adding more RAM and rerunning

[Visualization and Reporting]A data analyst is preparing a survey for Paralympic Games athletes. Which of the following should the analyst consider when creating this survey?

• Idioms
• Color contrast
• Refresh speed
• Granularity

[Visualization and Reporting]A Chief Executive Officer requests a report that must:Summarize the company metrics in a simple way.Be clear and concise.Be easily understood by all company levels.Be accessible and updated without manual intervention.Which of the following communication approaches best meets these requirements?

• Executive summary
• Slide presentation
• Key performance indicator dashboard
• Open data portal

[Data Governance]Which of the following explains the purpose of UAT?

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

[Visualization and Reporting]An analyst must use the same data to create reports for police patrol supervisors, the city council, and a public website. Which of the following is the best way to differentiate the reports?

• Persona type
• Detail levels
• Accessibility
• Sensitivity

[Data Concepts and Environments]Which of the following is the best reason for a company to use a CSV file to share data instead of an Excel file?

• CSV files can store different types of encoding.
• CSV files are not vendor-specific.
• CSV files are smaller in size.
• CSV files are easier to change in text editors.

[Data Concepts and Environments]Which of the following file types separates data using a delimiter?

• XML
• HTML
• JSON
• CSV

[Data Concepts and Environments]A data analyst pulls a table similar to the following one: IDType TypeID Phone 1Full Time Full Time 1 Mobile2Part Time Part Time 2 Work3Full Time Full Time 3 MobileWhich of the following best explains the data issue with TypeID?

• Redundancy
• Outlier
• Missing data
• Duplication