CDV DA Fundamentals and CDV DA Day 2
Quizzes Practice Exam questions and correct
answers– Updated 2026 (Graded A+) instant
download pdf
Subject: CDV DA Fundamentals
Subtopic: Introduction to Data Analytics Fundamentals
Question 1:
A data analyst receives sales data from multiple branches containing duplicate records, missing
values, and inconsistent date formats. Which action should be performed first before conducting
analysis?
A) Develop predictive models immediately
B) Create visualization dashboards
C) Perform data cleaning and preparation
D) Generate final management reports
Correct Answer: C - Perform data cleaning and preparation
Rationale: Data cleaning is a fundamental prerequisite to reliable analysis. Duplicate records,
missing values, and inconsistent formats can produce misleading conclusions. Predictive
modeling and visualization rely on accurate datasets. Management reporting should occur only
after data quality issues have been addressed.
Question 2:
Which characteristic best describes high-quality data in a business analytics environment?
A) Large data volume only
B) Confidential storage only
C) Accuracy, completeness, consistency, and timeliness
D) Complex calculations
Correct Answer: C - Accuracy, completeness, consistency, and timeliness
,Rationale: Data quality dimensions include accuracy, completeness, consistency, timeliness, and
reliability. Large volumes alone do not guarantee quality. Security is important but does not
define data quality itself.
Question 3:
A manager requests a report explaining why customer complaints increased during the previous
quarter. Which type of analytics is most appropriate?
A) Descriptive analytics
B) Diagnostic analytics
C) Predictive analytics
D) Prescriptive analytics
Correct Answer: B - Diagnostic analytics
Rationale: Diagnostic analytics investigates causes and relationships behind events. Descriptive
analytics summarizes past events, predictive analytics forecasts future events, and prescriptive
analytics recommends actions.
Question 4:
Descriptive analytics primarily answers which question?
A) What should happen next?
B) Why did it happen?
C) What happened?
D) How can risks be eliminated?
Correct Answer: C - What happened?
Rationale: Descriptive analytics summarizes historical performance and trends. Diagnostic
explains causes, predictive estimates future outcomes, and prescriptive recommends actions.
Question 5:
A predictive model estimating future customer demand is an example of:
A) Descriptive analytics
B) Predictive analytics
,C) Diagnostic analytics
D) Exploratory analysis
Correct Answer: B - Predictive analytics
Rationale: Predictive analytics uses historical patterns to forecast future events. The other
approaches focus on past or current conditions.
Subtopic: Data Collection and Sources
Question 6:
Primary data sources are best described as:
A) Previously published external reports
B) Data collected directly for a specific purpose
C) Government census reports only
D) Archived databases
Correct Answer: B - Data collected directly for a specific purpose
Rationale: Primary data are collected directly through surveys, interviews, observations, or
experiments. Secondary data already exist from previous studies or databases.
Question 7:
Which data source would be classified as secondary data?
A) Customer survey conducted this week
B) Direct observations in a retail store
C) Government statistical reports
D) Laboratory experiment results
Correct Answer: C - Government statistical reports
Rationale: Secondary data have already been collected by another organization for a different
purpose.
Question 8:
, A major advantage of secondary data is:
A) Guaranteed accuracy
B) Lower cost and faster availability
C) Complete customization
D) Elimination of bias
Correct Answer: B - Lower cost and faster availability
Rationale: Secondary data are usually less expensive and readily accessible, although they may
not perfectly fit the study objectives.
Question 9:
Data collected from customer transaction systems are generally considered:
A) Structured data
B) Unstructured data
C) Qualitative data only
D) Experimental data
Correct Answer: A - Structured data
Rationale: Transaction systems store organized information in predefined fields and tables,
making the data structured.
Question 10:
Unstructured data commonly include:
A) Spreadsheets
B) Database tables
C) Social media posts and emails
D) Financial ledgers
Correct Answer: C - Social media posts and emails
Rationale: Unstructured data lack predefined formats and often require additional processing
before analysis.
Quizzes Practice Exam questions and correct
answers– Updated 2026 (Graded A+) instant
download pdf
Subject: CDV DA Fundamentals
Subtopic: Introduction to Data Analytics Fundamentals
Question 1:
A data analyst receives sales data from multiple branches containing duplicate records, missing
values, and inconsistent date formats. Which action should be performed first before conducting
analysis?
A) Develop predictive models immediately
B) Create visualization dashboards
C) Perform data cleaning and preparation
D) Generate final management reports
Correct Answer: C - Perform data cleaning and preparation
Rationale: Data cleaning is a fundamental prerequisite to reliable analysis. Duplicate records,
missing values, and inconsistent formats can produce misleading conclusions. Predictive
modeling and visualization rely on accurate datasets. Management reporting should occur only
after data quality issues have been addressed.
Question 2:
Which characteristic best describes high-quality data in a business analytics environment?
A) Large data volume only
B) Confidential storage only
C) Accuracy, completeness, consistency, and timeliness
D) Complex calculations
Correct Answer: C - Accuracy, completeness, consistency, and timeliness
,Rationale: Data quality dimensions include accuracy, completeness, consistency, timeliness, and
reliability. Large volumes alone do not guarantee quality. Security is important but does not
define data quality itself.
Question 3:
A manager requests a report explaining why customer complaints increased during the previous
quarter. Which type of analytics is most appropriate?
A) Descriptive analytics
B) Diagnostic analytics
C) Predictive analytics
D) Prescriptive analytics
Correct Answer: B - Diagnostic analytics
Rationale: Diagnostic analytics investigates causes and relationships behind events. Descriptive
analytics summarizes past events, predictive analytics forecasts future events, and prescriptive
analytics recommends actions.
Question 4:
Descriptive analytics primarily answers which question?
A) What should happen next?
B) Why did it happen?
C) What happened?
D) How can risks be eliminated?
Correct Answer: C - What happened?
Rationale: Descriptive analytics summarizes historical performance and trends. Diagnostic
explains causes, predictive estimates future outcomes, and prescriptive recommends actions.
Question 5:
A predictive model estimating future customer demand is an example of:
A) Descriptive analytics
B) Predictive analytics
,C) Diagnostic analytics
D) Exploratory analysis
Correct Answer: B - Predictive analytics
Rationale: Predictive analytics uses historical patterns to forecast future events. The other
approaches focus on past or current conditions.
Subtopic: Data Collection and Sources
Question 6:
Primary data sources are best described as:
A) Previously published external reports
B) Data collected directly for a specific purpose
C) Government census reports only
D) Archived databases
Correct Answer: B - Data collected directly for a specific purpose
Rationale: Primary data are collected directly through surveys, interviews, observations, or
experiments. Secondary data already exist from previous studies or databases.
Question 7:
Which data source would be classified as secondary data?
A) Customer survey conducted this week
B) Direct observations in a retail store
C) Government statistical reports
D) Laboratory experiment results
Correct Answer: C - Government statistical reports
Rationale: Secondary data have already been collected by another organization for a different
purpose.
Question 8:
, A major advantage of secondary data is:
A) Guaranteed accuracy
B) Lower cost and faster availability
C) Complete customization
D) Elimination of bias
Correct Answer: B - Lower cost and faster availability
Rationale: Secondary data are usually less expensive and readily accessible, although they may
not perfectly fit the study objectives.
Question 9:
Data collected from customer transaction systems are generally considered:
A) Structured data
B) Unstructured data
C) Qualitative data only
D) Experimental data
Correct Answer: A - Structured data
Rationale: Transaction systems store organized information in predefined fields and tables,
making the data structured.
Question 10:
Unstructured data commonly include:
A) Spreadsheets
B) Database tables
C) Social media posts and emails
D) Financial ledgers
Correct Answer: C - Social media posts and emails
Rationale: Unstructured data lack predefined formats and often require additional processing
before analysis.