A data analyst is creating a new dataset that involves bringing together the following datasets:
Name
ID
Date of birth
Frank
23525
3/19
Martha
11290
6/13
Ellen
12141
11/4
ID
Address
City
State
23525
1234 Harding
Chicago
IL
11040
935 Terrace Hills
Chino
CA
11290
2 Speedway
Miami
FL
Which of the following would be the output if the data analyst does a FULL JOIN?
The sales department wants to include the composition of total sales amounts across all three sales channels in a report. Given the following sample sales table:
Sales channel
Month
Sales (million $)
Digital
January
135
Store
February
145
Online
March
165
Store
April
200
Store
May
125
Online
June
155
Digital
July
120
Online
August
145
Digital
September
160
Which of the following visualizations is the most appropriate?
A data analyst is creating a report about cars sold within the last twelve months. The current data set only contains information from the last ten months. Which of the following is the most appropriate way to accomplish this task?
A data analyst receives a new data source that contains employee IDs, job titles, dates of birth, addresses, years of service, and employees’ birth months. Which of the following inconsistencies should the analyst identify?
A database administrator needs to implement security triggers for an organization's user information database. Which of the following data classifications is the administrator most likely using? (Select two).
An analyst needs to create a collection of dashboards for multiple teams within their organization. Which of the following should the analyst do first before starting the project?
An analyst must use the same data to create reports for police patrol supervisors, the city council, and a public website. Which of the following is the best way to differentiate the reports?
A data analyst needs to identify outliers from a given dataset. Which of the following visualizations is the best way to identify outliers?
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 business intelligence analyst is creating an employee retention dashboard that looks at data from the last five years. The analyst is interested in identifying patterns that can be studied further. Which of the following is the best method to apply to the dashboard?
Exam style questions across every DA0-002 domain
Last Update 3 days ago
Total Questions : 121
Start with our free DA0-002 practice questions, carefully crafted to mirror the domains, phrasing, and difficulty of the real CompTIA Data+ exam. Each DA0-002 exam question comes with a detailed rationale that explains not just which answer is correct but why the others fall short. That's how concepts stick. Use the free set to benchmark yourself: identify your CompTIA weak domains, see where you're losing marks, and build a focused study plan in minutes.
