CALIFORNIA DATA ANALYST CERTIFICATION EXAM – PRACTICE TEST QUESTIONS AND
CORRECT ANSWERS (VERIFIED ANSWERS) PLUS RATIONALES 2026 Q&A | INSTANT
DOWNLOAD PDF
Core Domains
*- Data Collection and Extraction Methods*
*- Statistical Analysis and Interpretation*
*- SQL and Database Management*
*- Data Visualization and Reporting*
*- Python/R Programming for Analytics*
*- Data Quality and Cleaning Techniques*
*- Regulatory Compliance and Privacy Laws*
*- Ethics and Professional Standards*
*- Business Intelligence and Decision Support*
*- Real-World Scenario Application*
Introduction
This practice assessment is designed to evaluate comprehensive data analyst competencies essential for
professional success in contemporary business environments. The exam assesses critical skills including data
extraction, statistical analysis, database management, visualization techniques, programming proficiency,
and regulatory compliance knowledge. The multiple-choice and scenario-based structure emphasizes real-
world application, requiring candidates to demonstrate decision-making abilities in practical contexts.
Questions cover foundational theory alongside applied professional knowledge, ensuring candidates can
translate concepts into actionable business insights. This assessment serves as preparation material for
individuals pursuing data analyst roles, particularly in California's competitive job market where regulatory
knowledge and ethical standards are prioritized. Success requires mastery of both technical competencies and
professional judgment.
,SECTION ONE: QUESTIONS 1–100
Question 1
Which SQL clause is used to filter records before grouping in a query?
A. GROUP BY
B. ORDER BY
C. WHERE
D. HAVING
🟢 C. WHERE
🔴 RATIONALE: The WHERE clause filters records before grouping occurs, while HAVING filters after
grouping. GROUP BY creates the groups, and ORDER BY sorts results.
Question 2
A data analyst discovers missing values in 30% of a critical dataset. What is the MOST appropriate initial
action?
A. Immediately delete all rows with missing values
B. Replace missing values with mean or median
C. Document the issue and investigate the cause of missingness
D. Proceed with analysis ignoring the missing data
,🟢 C. Document the issue and investigate the cause of missingness
🔴 RATIONALE: Understanding why data is missing (random vs. systematic) is critical before choosing an
handling strategy. Documentation ensures transparency, and investigation prevents inappropriate treatment
that could bias results.
Question 3
Under California's CCPA (California Consumer Privacy Act), what right do consumers have regarding their
personal data?
A. Right to have data automatically deleted by all companies
B. Right to know what personal data is collected and how it's used
C. Right to prevent any data collection from occurring
D. Right to access data only in physical paper format
🟢 B. Right to know what personal data is collected and how it's used
🔴 RATIONALE: CCPA grants consumers the right to know what personal information is collected, the sources,
business purpose, and categories shared. Deletion rights exist but are not absolute, and electronic access is
permitted.
Question 4
Which visualization is BEST for showing the relationship between two continuous variables?
, A. Pie chart
B. Scatter plot
C. Bar chart
D. Histogram
🟢 B. Scatter plot
🔴 RATIONALE: Scatter plots display the relationship between two continuous variables by plotting points on
x and y axes, revealing patterns, correlations, and outliers. Pie charts show proportions, bar charts compare
categories, and histograms show distribution of one variable.
Question 5
In Python, what does the pandas function .isnull() return?
A. A boolean DataFrame indicating missing values
B. The count of missing values in each column
C. A new DataFrame with missing values removed
D. The mean value of non-missing data
🟢 A. A boolean DataFrame indicating missing values
🔴 RATIONALE: .isnull() returns a boolean DataFrame/Series where True indicates missing values (NaN,
None) and False indicates present values. .sum() on the result would give counts, but .isnull() itself returns
booleans.
CORRECT ANSWERS (VERIFIED ANSWERS) PLUS RATIONALES 2026 Q&A | INSTANT
DOWNLOAD PDF
Core Domains
*- Data Collection and Extraction Methods*
*- Statistical Analysis and Interpretation*
*- SQL and Database Management*
*- Data Visualization and Reporting*
*- Python/R Programming for Analytics*
*- Data Quality and Cleaning Techniques*
*- Regulatory Compliance and Privacy Laws*
*- Ethics and Professional Standards*
*- Business Intelligence and Decision Support*
*- Real-World Scenario Application*
Introduction
This practice assessment is designed to evaluate comprehensive data analyst competencies essential for
professional success in contemporary business environments. The exam assesses critical skills including data
extraction, statistical analysis, database management, visualization techniques, programming proficiency,
and regulatory compliance knowledge. The multiple-choice and scenario-based structure emphasizes real-
world application, requiring candidates to demonstrate decision-making abilities in practical contexts.
Questions cover foundational theory alongside applied professional knowledge, ensuring candidates can
translate concepts into actionable business insights. This assessment serves as preparation material for
individuals pursuing data analyst roles, particularly in California's competitive job market where regulatory
knowledge and ethical standards are prioritized. Success requires mastery of both technical competencies and
professional judgment.
,SECTION ONE: QUESTIONS 1–100
Question 1
Which SQL clause is used to filter records before grouping in a query?
A. GROUP BY
B. ORDER BY
C. WHERE
D. HAVING
🟢 C. WHERE
🔴 RATIONALE: The WHERE clause filters records before grouping occurs, while HAVING filters after
grouping. GROUP BY creates the groups, and ORDER BY sorts results.
Question 2
A data analyst discovers missing values in 30% of a critical dataset. What is the MOST appropriate initial
action?
A. Immediately delete all rows with missing values
B. Replace missing values with mean or median
C. Document the issue and investigate the cause of missingness
D. Proceed with analysis ignoring the missing data
,🟢 C. Document the issue and investigate the cause of missingness
🔴 RATIONALE: Understanding why data is missing (random vs. systematic) is critical before choosing an
handling strategy. Documentation ensures transparency, and investigation prevents inappropriate treatment
that could bias results.
Question 3
Under California's CCPA (California Consumer Privacy Act), what right do consumers have regarding their
personal data?
A. Right to have data automatically deleted by all companies
B. Right to know what personal data is collected and how it's used
C. Right to prevent any data collection from occurring
D. Right to access data only in physical paper format
🟢 B. Right to know what personal data is collected and how it's used
🔴 RATIONALE: CCPA grants consumers the right to know what personal information is collected, the sources,
business purpose, and categories shared. Deletion rights exist but are not absolute, and electronic access is
permitted.
Question 4
Which visualization is BEST for showing the relationship between two continuous variables?
, A. Pie chart
B. Scatter plot
C. Bar chart
D. Histogram
🟢 B. Scatter plot
🔴 RATIONALE: Scatter plots display the relationship between two continuous variables by plotting points on
x and y axes, revealing patterns, correlations, and outliers. Pie charts show proportions, bar charts compare
categories, and histograms show distribution of one variable.
Question 5
In Python, what does the pandas function .isnull() return?
A. A boolean DataFrame indicating missing values
B. The count of missing values in each column
C. A new DataFrame with missing values removed
D. The mean value of non-missing data
🟢 A. A boolean DataFrame indicating missing values
🔴 RATIONALE: .isnull() returns a boolean DataFrame/Series where True indicates missing values (NaN,
None) and False indicates present values. .sum() on the result would give counts, but .isnull() itself returns
booleans.
