This is the free Comptia DA0-002 practice question bank —
80 of 146 total questions, each with a full explanation, free to
read with no signup required. Updated 2026-10-03.
Every answer is verified against official Comptia documentation —
see our methodology.
Question 1
A data analyst is building a new report on sales data. The analyst wants to find the total sales per channel, but only for those channels which have a total sales higher than 20.0. Given the following:
Which of the following should the analyst use?
A.
B.
C.
D.
Show Answer
Correct Answer: A. SELECT CHANNEL, SUM(VALUE) FROM SALES GROUP BY CHANNEL HAVING SUM(VALUE) > 20.0;
Explanation: GROUP BY calculates each channel’s total, and HAVING filters those totals. The results are ONLINE = 25.0 and PHONE = 22.0.
Question 2
A company needs to display sales numbers on the intranet. This solution needs to be updated every day before the workday starts. Which of the following is the best solution to meet this objective?
A. Enhancing the current self-service portal with new download options
B. Running an ad hoc query that extracts data from the warehouse
C. Building a report that is emailed every morning
D. Developing a dynamic dashboard that refreshes nightly
Show Answer
Correct Answer: D
Explanation: A dynamic dashboard can be displayed on the intranet and configured to refresh nightly, ensuring the latest sales numbers are available before the workday starts.
Question 3
A data analyst is building a new report using data from a sales column. Upon review, the analyst finds that the sales date is stored as a character type. Which of the following function types should the analyst use to filter by a specific month?
A. Mathematical
B. String
C. Logical
D. Table
Show Answer
Correct Answer: B
Explanation: Because the sales date is stored as character data, string functions can extract or match the month for filtering. Ideally, convert the field to a date type before using date-specific functions.
Question 4
Which of the following explains the difference between a char and an nchar data field?
A. char is a fixed-size data type, and nchar is a varying-size data type
B. Even though both are fixed-size data types, nchar is compressed and char is not
C. nchar stores fixed-size, compressed Unicode characters and char stores varying-size, non-Unicode characters
D. Both are fixed-size data types, but nchar stores Unicode characters and uses twice the space
Show Answer
Correct Answer: D
Explanation: Both CHAR and NCHAR are fixed-length types. CHAR stores non-Unicode character data, while NCHAR stores Unicode data and typically uses twice the storage per character.
Question 5
A data analyst creates a report about the time that elapses between sequential events. The data set has several rows with negative integers in the elapsed time column. Which of the following is the best way to address this issue?
A. Analyze the data set as collected
B. Validate the data set before analysis
C. Delete the rows in the data set with negative values
D. Convert the negative values to positive values
Show Answer
Correct Answer: B
Explanation: Negative elapsed times may indicate incorrect timestamps, event ordering, or data-entry errors. Validate the data before deciding whether any values should be corrected or excluded.
Question 6
A data analyst must create a report to analyze the flow of services from call receipt to service completion using established time points. Which of the following techniques should the analyst use to create the needed variables?
A. Binning
B. Calculating
C. Scaling
D. Parsing
Show Answer
Correct Answer: B
Explanation: Calculating creates variables such as the elapsed time between call receipt and service completion, allowing the analyst to measure each stage of the service flow.
Question 7
A manager wants to know how the company's sales have improved over the last year. The manager asks a data analyst to provide a report with the required information. Which of the following approaches should the analyst use?
A. Granular
B. Mock-up
C. Key performance indicators
D. Accessibility
Show Answer
Correct Answer: C
Explanation: Key performance indicators (KPIs), such as year-over-year sales growth or revenue, measure and communicate how the company’s sales have changed over the last year.
Question 8
Which of the following is the best tool for database management?
A. Anaconda
B. RStudio
C. VS Code
D. Toad
Show Answer
Correct Answer: D
Explanation: Toad is specifically designed for database development and management, including working with database objects and SQL. Anaconda and RStudio primarily support data science workflows, while VS Code is a general-purpose code editor.
Question 9
Given the following table:
Which of the following data types should an analyst use for the numeric values in the Value column?
A. Double
B. Float
C. Boolean
D. Integer
Show Answer
Correct Answer: D
Explanation: Use Integer when the Value column contains whole numbers with no decimal or fractional parts.
Question 10
A data scientist is presenting a summary speech on current AI trends in the data industry to local high school students. Which of the following should the data scientist consider first when developing the presentation?
A. The technical knowledge of the audience
B. The frequency of reporting
C. The accessibility of the slide deck
D. The sensitivity of the data
Show Answer
Correct Answer: A
Explanation: Consider the audience’s technical knowledge first so you can tailor the language, examples, and level of detail to high school students.
$19
Get all 146 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
