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 number of phone calls that the call center receives in a day is an example of:
- A . continuous data.
- B . categorical data.
- C . ordinal data.
- D . discrete data.
Which of the following data manipulation techniques is an example of a logical function?
- A . WHERE
- B . AGGREGATE
- C . BOOLEAN
- D . IF
A data analyst has been asked to create one table that has each employee’s first name, last name, sales, and address.
The sales and addresses are listed in the tables below:

Which of the following steps should the analyst take to create the table?
- A . Transpose the first name and last name in both tables. Use lookup to pull the address field from Table 2 into Table 1.
- B . Use lookup with the first name or first name to pull the address field from Table 2 into Table 1.
- C . Use the append formula in both tables for the first name and last name. Use lookup to pull the address field from Table 2 into Table 1.
- D . Create a column that concatenates the first name and last name in each table. Use concatenate and lookup to bring the address field into Table 1.
Consider the following dataset which contains information about houses that are for sale:

Which of the following string manipulation commands will combine the address and region namecolumns to create a full address?
full_address————————- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern
Metropolitan 5 Charles St, Northern Metropolitan 40 Federation La, Northern Metropolitan 55a Park St, Northern Metropolitan
- A . SELECT CONCAT(address, ‘ , ‘ , regionname) AS full_address FROM melb LIMIT 5;
- B . SELECT CONCAT(address, ‘-‘ , regionname) AS full_address FROM melb LIMIT 5;
- C . SELECT CONCAT(regionname, ‘ , ‘ , address) AS full_address FROM melb LIMIT 5
- D . SELECT CONCAT(regionname, ‘-‘ , address) AS full_address FROM melb LIMIT 5;
A column is being used to store strings of variable lengths. Performance is a concern, so the column needs to use as little space as possible.
Which of the following data types best meets these requirements?
- A . char
- B . nchar
- C . varchar
- D . nvarchar
A client wants a new report that will be automatically emailed to all global sales teams on a weekly basis. Each sales team must be able to view the sales for its region and the combined sales for all regions.
Which of the following would be the most efficient method for meeting the requirements?
- A . Creating a single report with a region filter
- B . Creating report distribution lists for the sales teams in each region
- C . Creating a unique copy of the report for each sales team region
- D . Creating a unique copy of the report for each recipient
An analyst is preparing a report that contains weather data. The temperatures are shown in Fahrenheit. but they must be reported in Celsius.
Which of the following should the analyst do to fix this issue?
- A . Normalize the data.
- B . Standardize the data.
- C . Rescale the data.
- D . Aggregate the data.
A financial institution is reporting on sales performance to a company at the account level. Due to the sensitive nature of the government the does il with, some account information is not shown.
Which of the following fields should be masked?
- A . Sales volume
- B . Start date
- C . Product name
- D . Customer name
You are working with a dataset and need to swap the values in rows with those in columns.
What action do you need to perform?
- A . Recording
- B . Filtering.
- C . Aggregation.
- D . Transposition.
Which of the following best describe qualitative data? (Select two).
- A . Discrete
- B . Ordinal
- C . Batch
- D . Continuous
- E . Nominal
- F . Real-time