CompTIA DA0-001 Practice Exams
Last updated on Nov 16,2026- Exam Code: DA0-001
- Exam Name: CompTIA Data+ Certification
- Certification Provider: CompTIA
- Latest update: Nov 16,2026
A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table.
This structure is an example of a:
- A . non-relational schema.
- B . galaxy schema.
- C . snowflake schema.
- D . star schema.
Randy scored 76 on a math test, Katie scored 86 on a science test, Ralph scored 80 on a history test, and Jean scored 80 on an English test.
The table below contains the mean and standard deviation of the scores for each of the courses:

Using this information, which of the following students had the BEST score?
- A . Randy
- B . Katie
- C . Ralph
- D . Jean
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 data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer. The analyst must choose an appropriate chart to include in the dashboard.
The following data is available:

Which of the following types of charts should be considered?
- A . Include a line chart using the site and average sales per customer.
- B . Include a pie chart using the site and sales to average sales per customer.
- C . Include a scatter chart using sales volume and average sales per customer.
- D . Include a column chart using the site and sales to average sales per customer.
Which of the following query statements would be used when filtering data in a relational database management system? (Select two).
- A . ORDER BY
- B . HAVING
- C . WHERE
- D . SELECT
- E . INSERT
- F . GROUP BY
Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?
- A . Missing data
- B . Duplicate data
- C . Redundant data
- D . Invalid data
Jhon is working on an ELT process that sources data from six different source systems.
Looking at the source data, he finds that data about the sample people exists in two of six systems.
What does he have to make sure he checks for in his ELT process? Choose the best answer.
- A . Duplicate Data.
- B . Redundant Data.
- C . Invalid Data.
- D . Missing Data.
Which of the following is the best reason for removing data outliers?
- A . Data varies significantly from others.
- B . Data is redundant in the table.
- C . Data is duplicated in the whole range.
- D . Data is missing from the table.
Which of the following is the best description of the term "data governance"?
- A . Data governance governs the development of a data visualization dashboard in an organization.
- B . Data governance is the policy that protects against data breaches by cybercriminals.
- C . Data governance is the process of analyzing, manipulating, and reporting data in an organization.
- D . Data governance is the availability, usability, integrity, and security of data in an enterprise.
Which of the following best describes an exploratory analysis?
- A . Involves the use of descriptive statistics to understand observations
- B . Involves analysis of exploring data sets for performance tracking
- C . Involves the testing of specific hypotheses
- D . Involves the use of arithmetic algebra to determine the distribution