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
The total values in this month’s revenue report are twice as much as last month’s.
Which of the following most likely occurred during the ETL process?
- A . The data cleansing processes failed to execute.
- B . The database connectivity failed.
- C . The report included the previous month’s data.
- D . The data normalization processes failed.
Given the information in the following tables:

Which of the following describes merging these tables to create a master file that includes all transactions for both online and in-store sales?
- A . Data audit
- B . Data completeness
- C . Data validation
- D . Data consolidation
A database administrator is required to mask certain table columns containing Pll in order to comply with the company privacy policy.
Which of the following are the most likely types of information the administrator should mask? (Select two).
- A . Government-issued ID
- B . Address
- C . Order ID
- D . Order date
- E . Customer ID
- F . Referral number
A data analyst has been asked to organize the table below in the following ways:
By sales from high to low –
By state in alphabetic order –

Which of the following functions will allow the data analyst to organize the table in this manner?
- A . Conditional formatting
- B . Grouping
- C . Filtering
- D . Sorting
An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximately 20% of the total number from the day before. On a given day, the number of datapoints was 8,798.
Which of the following should be the total number of datapoints on the next day?
- A . 7,038
- B . 9,600
- C . 10,600
- D . 10,800
A data analyst has been asked to merge the tables below, first performing an INNER JOIN and then a
LEFT JOIN:

Customer Table –
In-store Transactions C

Which of the following describes the number of rows of data that can be expected after performing both joins in the order stated, considering the customer table as the main table?
- A . INNER: 6 rows; LEFT: 9 rows
- B . INNER: 9 rows; LEFT: 6 rows
- C . INNER: 9 rows; LEFT: 15 rows
- D . INNER: 15 rows; LEFT: 9 rows
Which one of the following is a common data warehouse schema?
- A . Snowflake.
- B . Square.
- C . Spiral.
- D . Sphere.
Which of the following is the best approach to use to gain a general understanding of a data set?
- A . Descriptive statistics
- B . Basic projections
- C . Gap analysis
- D . Trend analysis
A data analyst is compiling a report that a Chief Executive Officer needs for an impromptu meeting. The report should include information on the previous day’s performance.
Which of the following reports should the analyst provide?
- A . Tactical
- B . Ad hoc
- C . Dynamic
- D . Recurring
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
