comptia DA0-002 Exam Questions
Questions for the DA0-002 were updated on : Nov 23 ,2025
Page 1 out of 8. Viewing questions 1-15 out of 111
Question 1
SIMULATION
[Visualization and Reporting]
The director of operations at a power company needs data to help identify where company resources
should be allocated in order to monitor activity for outages and restoration of power in the entire
state. Specifically, the director wants to see the following:
* County outages
* Status
* Overall trend of outages
INSTRUCTIONS:
Please, select each visualization to fit the appropriate space on the dashboard and choose an
appropriate color scheme. Once you have selected all visualizations, please, select the appropriate
titles and labels, if applicable. Titles and labels may be used more than once.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All
button.
Answer:
Power
outages
Explanation:
This is a simulation question that requires you to create a dashboard with visualizations that meet
the director’s needs. Here are the steps to complete the task:
Drag and drop the visualization that shows the county outages on the top left space of the
dashboard. This visualization is a map of the state with different colors indicating the number of
outages in each county. You can choose any color scheme that suits your preference, but make sure
that the colors are consistent and clear. For example, you can use a gradient of red to show the
counties with more outages and green to show the counties with less outages.
Drag and drop the visualization that shows the status of the outages on the top right space of the
dashboard. This visualization is a pie chart that shows the percentage of outages that are active,
restored, or pending. You can choose any color scheme that suits your preference, but make sure
that the colors are distinct and easy to identify. For example, you can use red for active, green for
restored, and yellow for pending.
Drag and drop the visualization that shows the overall trend of outages on the bottom space of the
dashboard. This visualization is a line graph that shows the number of outages over time. You can
choose any color scheme that suits your preference, but make sure that the color is visible and
contrasted with the background. For example, you can use blue for the line and white for the
background.
Select appropriate titles and labels for each visualization. Titles and labels may be used more than
once. For example, you can use “County Outages” as the title for the map, “Status” as the title for the
pie chart, and “Trend” as the title for the line graph. You can also use “County”, “Number of
Outages”, “Active”, “Restored”, “Pending”, “Time”, and “Number of Outages” as labels for the axes
and legends of the visualizations.
Question 2
[Visualization and Reporting]
A data analyst needs to provide a weekly sales report for the Chief Financial Officer. Which of the
following delivery methods is the most appropriate?
- A. A granular daily report in a dashboard
- B. A detailed text document
- C. A spreadsheet with raw data
- D. A high-level email
Answer:
D
Question 3
[Data Concepts and Environments]
Which of the following is a NoSQL database?
- A. PostgreSQL
- B. MySQL
- C. Oracle
- D. MongoDB
Answer:
D
Question 4
[Data Analysis]
A data analyst receives a flat file that includes dates. The analyst needs to calculate the number of
days from the dates on the file to the current date. Which of the following is the best way to
complete this task?
- A. Convert data to date format and use date functions.
- B. Validate the date format with logical functions and use date functions to analyze.
- C. Use date functions to analyze the data with no conversion.
- D. Transform data to a numerical value and use mathematical functions.
Answer:
A
Question 5
[Data Governance]
A data analyst receives an email from the IT department about renewing the company password, and
the analyst follows the password reset link as required. Later in the week, the analyst receives the
following notification when running a recurring analysis that connects to the database:
Log-in failed for user ‘<username>’
Which of the following is most likely the reason for this issue?
- A. The company changed its database authentication method.
- B. The password expiration process locked the account.
- C. The analyst did not change the password used to launch the report.
- D. The company is experiencing issues with password replication.
Answer:
C
Question 6
[Data Concepts and Environments]
Which of the following best represents a type of infrastructure that requires a company to purchase
and maintain all of its own servers?
- A. Private
- B. Cloud
- C. Hybrid
- D. Public
Answer:
A
Question 7
[Data Analysis]
A marketing firm wants to find the average age of its consumers to better promote its products.
Given the following dataset:
Name
Date of birth
Age
Jane
March 24
John
July 17
Joe
November 29
Ann
December 13
Robert
December 14
63
Which of the following is the mean of the consumer ages?
- A. 29
- B. 36
- C. 40
- D. 63
Answer:
B
Question 8
[Data Governance]
A data analyst calculated the average score per student without making any changes to the following
table:
Student
Subject
Score
123
Math
100
123
Biology
80
234
Math
96
123
Biology
80
345
Biology
88
234
Math
96
Which of the following exploration techniques should the analyst have considered before calculating
the average?
- A. Duplication
- B. Redundancy
- C. Binning
- D. Grouping
Answer:
A
Question 9
[Data Analysis]
Given the following dataset:
Day
Number of Guests
Monday
455
Tuesday
346
Wednesday
382
Thursday
563
Friday
887
Saturday
934
Sunday
346
Which of the following is the mode?
- A. 346
- B. 446
- C. 455
- D. 559
Answer:
A
Question 10
[Data Analysis]
A data analyst wants to use the following tables to find all the customers who have not placed an
order:
Customers table
ID
Name
Address
Products table
ID
Name
Customer_ID
Which of the following SQL statements is the best way to accomplish this task?
- A. SELECT * FROM CUSTOMERS AS C LEFT JOIN PRODUCTS AS P ON C.ID = P.Customer_ID WHERE P.Customer_ID IS NULL
- B. SELECT * FROM CUSTOMERS AS C INNER JOIN PRODUCTS AS P ON C.ID = C.IDWHERE COUNT(P.) =
- C. SELECT * FROM PRODUCTS AS P INNER JOIN CUSTOMERS AS C ON P.Customer_ID = C.ID WHERE (SELECT COUNT(P.) = 0)
- D. SELECT * FROM PRODUCTS AS P LEFT JOIN CUSTOMERS AS C ON P.Customer_ID = C.ID WHERE P.Customer_ID IS NOT NULL
Answer:
A
Question 11
[Data Governance]
A data analyst needs to modify a dashboard that was created by another employee. Upon opening
the dashboard, the analyst notices that the information is not loading properly. Which of the
following should the analyst do to troubleshoot this error?
- A. Review the data layer and data source.
- B. Validate that the database is up-to-date.
- C. Check that the program is updated to the latest version.
- D. Ensure the correct filters are displaying on the dashboard.
Answer:
A
Question 12
[Data Concepts and Environments]
Which of the following best explains the purpose of data lineage?
- A. To see the steps and path of data flow through different systems
- B. To better understand the granularity of data variable relationships
- C. To track data transformations from acquisition through reporting
- D. To look up data definitions, ensuring consistent use across business units
Answer:
C
Question 13
[Data Analysis]
The human resources department wants to know the number of employees who earn $125,000 or
more. However, the department is concerned about duplicates in the dataset. Given the following
table:
Employee_ID
Level
Salary
10000
20000
256000
125000
10000
20000
Which of the following SQL statements resolves this issue?
- A. SELECT DISTINCT Employee_ID FROM Employee WHERE Salary >= 125000
- B. SELECT COUNT(DISTINCT Employee_ID) FROM Employee WHERE Salary >= 125000
- C. SELECT DISTINCT Employee_ID FROM Employee WHERE Salary > 125000
- D. SELECT COUNT(Employee_ID) FROM Employee WHERE Salary >= 125000
Answer:
B
Question 14
[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?
- A. Idioms
- B. Color contrast
- C. Refresh speed
- D. Granularity
Answer:
B
Question 15
[Visualization and Reporting]
A data analyst needs to identify outliers from a given dataset. Which of the following visualizations is
the best way to identify outliers?
- A. Box plot
- B. Scatter plot
- C. Gantt chart
- D. Waterfall chart
Answer:
A