Which of the following data cleansing issues will be fixed when a DISTINCT function is
applied?
Correct answer:
B. Duplicate data
Question 42Choose 1
An analyst wants to determine whether a relationship between an individual's age and
voting preferences exists. Which of the following is the best statistical method for the
analyst to use?
Correct answer:
B. Chi-squared
Question 43Choose 1
Which one the following is not considered an aggregate function?
Correct answer:
C. SELECT
Question 44Choose 1
Given the following:
Which of the following is the most important thing for an analyst to do when transforming
the table for a trend analysis?
Correct answer:
D. Correct the dates so they have the same format.
Question 45Choose 1
An analyst in a consumer bank department wants to showcase the concentration of
accounts opened in the United States by ZIP Code to describe the effectiveness of the bank's marketing campaigns. Which of the following would be the best way to visualize the
data?
Correct answer:
D. A geographic map
Question 46Choose 1
Which of the following is the first step an analyst should perform upon receiving a business
request for analysis?
Correct answer:
C. Review the business questions to understand the scope.
Question 47Choose 1
An analyst for a small business with multiple locations is using each location’s quarterly
sales reports from last year to create a single revenue report for the year. Which of the
following data mining techniques should the analyst use to complete this task?
Correct answer:
A. Data merge
Question 48Choose 1
Which of the following would be the best way to identify multicollinear attributes in a data
set?
Correct answer:
A. Correlation coefficient
Question 49Choose 1
Angela is aggregating data from CRM system with data from an employee system.
While performing an initial quality check, she realizes that her employee ID is not
associated with her identifier in the CRM system.
What kind of issues is Angela facing?
Choose the best answer.
Correct answer:
B. Record linkage.
Question 50Choose 1
Which of the following value is the measure of dispersion "range" between the scores of
ten students in a test.
The scores of ten students in a test are 17, 23, 30, 36, 45, 51, 58, 66, 72, 77.
Correct answer:
B. 60
Practice Like It's Exam Day
Get exam-ready with a timed DA0 001 CompTIA Data+ Certification Exam mock exam designed to match the official exam's question format, question count, and time limit.