A sales manager wants to understand how sales are trending year over year. Which of the following chart types is the most appropriate to display the information?
Correct Answer:A
This question falls under theVisualization and Reportingdomain, focusing on selecting the appropriate visualization for a specific data trend. The task is to show sales trends over time (year over year).
✑ Line (Option A): Line charts are ideal for displaying trends over time, such as year-
over-year sales, as they clearly show changes and patterns across a continuous
time axis.
✑ Donut (Option B): Donut charts show proportions or percentages of a whole, not suitable for time-based trends.
✑ Bubble (Option C): Bubble charts display three dimensions of data (e.g., size, x- axis, y-axis), not ideal for simple time trends.
✑ Hierarchy (Option D): Hierarchy charts (e.g., treemaps) show nested relationships, not time-based trends.
The DA0-002 Visualization and Reporting domain emphasizes "translating business requirements to form the appropriate visualization," and a line chart is best for time-series trends.
Reference: CompTIA Data+ DA0-002 Draft Exam Objectives, Domain 4.0 Visualization and Reporting.
==============
A Chief Executive Officer requests a report that must:
• Summarize the company metrics in a simple way.
• Be clear and concise.
• Be easily understood by all company levels.
• Be accessible and updated without manual intervention.
Which of the following communication approaches best meets these requirements?
Correct Answer:C
This question pertains to theVisualization and Reportingdomain, focusing on selecting the appropriate communication method for a report. The requirements emphasize simplicity, clarity, accessibility, and automatic updates, which point to a specific approach.
✑ Executive summary (Option A): An executive summary is a written document that
summarizes metrics but isn??t typically updated automatically and may not be accessible toall levels without distribution.
✑ Slide presentation (Option B): A slide presentation can be clear but requires
manual updates and isn??t inherently accessible to all company levels.
✑ Key performance indicator dashboard (Option C): A KPI dashboard provides a simple, visual summary of metrics, is clear and concise, can be understood by all levels, and can be set up to update automatically, meeting all requirements.
✑ Open data portal (Option D): An open data portal provides raw data access, which may not be simple or easily understood by all levels.
The DA0-002 Visualization and Reporting domain emphasizes "translating business requirements to form the appropriate visualization," and a KPI dashboard is the best approach for meeting these requirements.
Reference: CompTIA Data+ DA0-002 Draft Exam Objectives, Domain 4.0 Visualization and Reporting.
==============
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
001
1
10000
002
2
20000
003
2
256000
004
2
125000
001
1
10000
002
2
20000
Which of the following SQL statements resolves this issue?
Correct Answer:B
This question falls under theData Analysisdomain, focusing on SQL queries to handle duplicates while counting employees. The task is to count unique employees with a salary of $125,000 or more, addressing duplicates in the dataset.
✑ Option A: SELECT DISTINCT Employee_ID FROM Employee WHERE Salary >= 125000This lists unique Employee_IDs but doesn??t provide a count, which the department needs.
✑ Option B: SELECT COUNT(DISTINCT Employee_ID) FROM Employee WHERE
Salary >= 125000This counts unique Employee_IDs (using DISTINCT) with a salary of $125,000 or more, correctly addressing duplicates and providing the required count (2 employees: 003 and 004).
✑ Option C: SELECT DISTINCT Employee_ID FROM Employee WHERE Salary >
125000This lists unique Employee_IDs with a salary strictly greater than $125,000 (missing 004), and doesn??t provide a count.
✑ Option D: SELECT COUNT(Employee_ID) FROM Employee WHERE Salary >=
125000This counts all rows without addressing duplicates, resulting in an incorrect count (2 rows, but only 2 unique employees).
The DA0-002 Data Analysis domain includes "applying the appropriate descriptive statistical methods using SQL queries," and COUNT(DISTINCT) is the correct method to count unique employees while handling duplicates.
Reference: CompTIA Data+ DA0-002 Draft Exam Objectives, Domain 3.0 Data Analysis.
==============
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).
Correct Answer:CE
This question pertains to theData Governancedomain, focusing on data classification for security purposes. User information databases typically contain personal data, and security triggers (e.g., alerts for unauthorized access) require classifying data to determine protection levels.
✑ Public (Option A): Public data is openly accessible (e.g., company brochures), not suitable for user information requiring security triggers.
✑ Open (Option B): Open isn??t a standard data classification; it??s similar to public and not applicable here.
✑ Sensitive (Option C): Sensitive data includes information that, if exposed, could cause harm (e.g., user emails, roles), which fits user information and warrants security triggers.
✑ Non-Sensitive (Option D): Non-sensitive data doesn??t require protection, so it wouldn??t need security triggers.
✑ Private (Option E): Private data includes PII (e.g., names, addresses) in user information databases, requiring security measures like triggers to protect against breaches.
✑ Encrypted (Option F): Encrypted refers to a data state, not a classification; data can be classified as private or sensitive and then encrypted.
The DA0-002 Data Governance domain includes "data quality control concepts," such as
classifying data to apply appropriate security measures. Sensitive and private classifications are most relevant for user information.
Reference: CompTIA Data+ DA0-002 Draft Exam Objectives, Domain 5.0 Data Governance.
==============
Which of the following data repositories stores unaltered data?
Correct Answer:A
This question falls under theData Concepts and Environmentsdomain, focusing on data repositories. The task is to identify a repository that stores data in its original, unaltered form.
✑ Data lake (Option A): A data lake stores raw, unaltered data in its native format (structured, semi-structured, or unstructured), making it the correct choice.
✑ Data warehouse (Option B): A data warehouse stores processed, structured data, often transformed for analysis, not unaltered.
✑ Data table (Option C): A data table is a structure within a database, not a repository, and may contain altered data.
✑ Data factory (Option D): A data factory (e.g., Azure Data Factory) is a data integration service, not a repository for storing data.
The DA0-002 Data Concepts and Environments domain includes understanding "different types of databases and data repositories," and a data lake is designed to store unaltered data.
Reference: CompTIA Data+ DA0-002 Draft Exam Objectives, Domain 1.0 Data Concepts and Environments.
==============