The purpose of this Sample Question Set is to provide you with information about the CompTIA Data+ exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the DA0-002 certification test. To get familiar with real exam environment, we suggest you try our Sample CompTIA Data+ Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual CompTIA Data+ certification exam.
These sample questions are simple and basic questions that represent likeness to the real CompTIA DA0-002 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium CompTIA Data+ Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.
CompTIA DA0-002 Sample Questions:
01. A data analyst has been given the following dataset:
Which of the following would best describe the quality issue with the dataset?
a) Redundancy
b) Outliers
c) Missing Values
d) Duplication
02. 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) Sensitivity
b) Accessibility
c) Detail levels
d) Persona type
03. 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:
Which of the following visualizations is the most appropriate?
a) Pivot table
b) Pie chart
c) KPI card
d) Box plot
04. Which of the following is the best place to store digital documents?
a) Dimensional table
b) Data warehouse
c) Container
d) Non-relational database
05. A data analyst is combining data from these two tables:
Which of the following queries should the analyst use to produce a final data set consisting of five rows?
a) SELECT *
FROM SALES
INNER JOIN HEADCOUNT
WHERE SALES.COMPANY = HEADCOUNT.COMPANY
b) SELECT *
FROM SALES
FULL JOIN HEADCOUNT
WHERE SALES.COMPANY = HEADCOUNT.COMPANY
c) SELECT *
FROM SALES
RIGHT OUTER JOIN HEADCOUNT
WHERE SALES.COMPANY = HEADCOUNT.COMPANY
d) SELECT *
FROM SALES
LEFT OUTER JOIN HEADCOUNT
WHERE SALES.COMPANY = HEADCOUNT.COMPANY
06. An administrator needs to design a table that will include foreign words. Which of the following is the best option for storing non-native language characters?
a) varchar
b) nvarchar
c) CLOB
d) char
07. A data analyst receives the following sales data for a convenience store:
The analyst needs to provide information on the products that contain chocolate. Which of the following RegEx should the analyst use to filter for the chocolate products?
a) %Chocolate%
b) %Chocolate&
c) Chocolate%
d) Chocolate!
08. A data analyst receives a set of requirements to create an analytical report that focuses on locations and distances as they relate to a city. Which of the following visual elements is the most appropriate for this task?
a) Gantt chart
b) Infographic
c) Map
d) Storyboard
09. Which of the following is a NoSQL database?
a) PostgreSQL
b) MySQL
c) Oracle
d) MongoDB
10. Which of the following supports capabilities such as automatic versioning, corruption checks, KPIs, and user authentication?
a) Notebook
b) REST API
c) Source control
d) Pipeline
Answers:
Question: 01
Answer: a |
Question: 02
Answer: d |
Question: 03
Answer: b |
Question: 04
Answer: d |
Question: 05
Answer: b |
Question: 06
Answer: b |
Question: 07
Answer: a |
Question: 08
Answer: c |
Question: 09
Answer: d |
Question: 10
Answer: c |
Note: For any error in CompTIA Data+ (DA0-002) certification exam sample questions, please update us by writing an email on feedback@edusum.com.
