Google Data Analyst Exam Guide
2026–2027: Data Analytics Study Guide,
Practice Questions & Certification Prep
60 Practice Q & A With Correct Answers & Detailed
Rationales - Google Data Analyst
INSTRUCTIONS: Read each question, choose the best
answer, then check the correct answer and rationale. Google
Data Analyst covers
Ask-Prepare-Process-Analyze-Share-Act, Sheets, SQL, R,
Tableau, visualization, cleaning, statistics, ethics, and
storytelling. Think: Ask, Prepare, Process, Analyze, Share,
Act.
QUICK GOOGLE ANALYST KEY • Process =
Ask-Prepare-Process-Analyze-Share-Act • Quantitative =
Numeric / Qualitative = Descriptive / Structured = Rows-Cols /
Unstructured = Text-Images • Sheets: VLOOKUP + XLOOKUP +
Pivot Table / Filter + Sort + Conditional Formatting • SQL:
SELECT-FROM-WHERE-ORDER BY / JOIN
INNER-LEFT-RIGHT-FULL / GROUP BY + HAVING / Subquery +
CTE + CASE • R: dplyr filter-select-mutate-summarize / ggplot2
Aesthetics + Geom / Tableau Workbook-Dashboard • Stats:
Mean-Median-Mode / Std Dev / Correlation vs Causation /
Hypothesis + Sampling + Bias • Ethics: Privacy + Fairness /
Storytelling = Narrative + Context + Insight
1. Google Data Analyst - Certificate / Courses
Google Data Analyst - 60 Questions | Page 1
,Google Data Analyst - Certificate / Courses:
A. Certificate = Google, Data, Analytics, 8 courses, Coursera
- Ask = Ask, Questions, Make, Data-Driven, Decisions -
Prepare = Prepare, Data, Exploration - Process = Process,
Data, Cleaning - Certificate = Google, Data - Ask = Ask,
Questions
B. No Certificate
C. No Ask
D. No Prepare
Correct Answer: A. Certificate = Google, Data, Analytics,
8 courses, Coursera - Ask = Ask, Questions, Make,
Data-Driven, Decisions - Prepare = Prepare, Data,
Exploration - Process = Process, Data, Cleaning -
Certificate = Google, Data - Ask = Ask, Questions
Rationale: Certificate: Google, Data, Analytics, 8 courses,
Coursera. Ask: Ask, Questions, Make, Data-Driven,
Decisions. Prepare: Prepare, Data, Exploration. Process:
Process, Data, Cleaning. Certificate = Google, Data. Ask =
Ask, Questions.
2. Data Analytics - Ask / Prepare / Process / Analyze /
Share / Act
Data Analytics - Ask / Prepare / Process / Analyze / Share /
Act:
A. Ask = define, problem, stakeholder, question - Prepare =
collect, data, sources, structure - Process = clean, transform,
format - Analyze = patterns, insights, calculations - Share =
Google Data Analyst - 60 Questions | Page 2
,visualize, communicate, story - Act = decide, recommend,
action - Ask = define, problem - Prepare = collect, data
B. No Ask
C. No Prepare
D. No Process
Correct Answer: A. Ask = define, problem, stakeholder,
question - Prepare = collect, data, sources, structure -
Process = clean, transform, format - Analyze = patterns,
insights, calculations - Share = visualize, communicate,
story - Act = decide, recommend, action - Ask = define,
problem - Prepare = collect, data
Rationale: Ask: define, problem, stakeholder, question.
Prepare: collect, data, sources, structure. Process: clean,
transform, format. Analyze: patterns, insights, calculations.
Share: visualize, communicate, story. Act: decide,
recommend, action. Ask = define, problem. Prepare = collect,
data.
3. Data - Types / Quantitative / Qualitative
Data - Types / Quantitative / Qualitative:
A. Quantitative = numeric, measurable, count, amount -
Qualitative = categorical, descriptive, text, observations -
Discrete = whole, count, separate - Continuous = range,
measured, decimal - Quantitative = numeric, measurable -
Qualitative = categorical, descriptive
B. No Quantitative
C. No Qualitative
Google Data Analyst - 60 Questions | Page 3
, D. No Discrete
Correct Answer: A. Quantitative = numeric, measurable,
count, amount - Qualitative = categorical, descriptive,
text, observations - Discrete = whole, count, separate -
Continuous = range, measured, decimal - Quantitative =
numeric, measurable - Qualitative = categorical,
descriptive
Rationale: Quantitative: numeric, measurable, count, amount.
Qualitative: categorical, descriptive, text, observations.
Discrete: whole, count, separate. Continuous: range,
measured, decimal. Quantitative = numeric, measurable.
Qualitative = categorical, descriptive.
4. Data - Structured / Unstructured / First-Party /
Third-Party
Data - Structured / Unstructured / First-Party / Third-Party:
A. Structured = organized, rows, columns, database -
Unstructured = text, images, video, no schema - First-Party =
collected, own, customers, direct - Third-Party = bought,
external, aggregator, vendor - Structured = organized, rows -
Unstructured = text, images
B. No Structured
C. No Unstructured
D. No First-Party
Correct Answer: A. Structured = organized, rows,
columns, database - Unstructured = text, images, video,
no schema - First-Party = collected, own, customers,
Google Data Analyst - 60 Questions | Page 4
2026–2027: Data Analytics Study Guide,
Practice Questions & Certification Prep
60 Practice Q & A With Correct Answers & Detailed
Rationales - Google Data Analyst
INSTRUCTIONS: Read each question, choose the best
answer, then check the correct answer and rationale. Google
Data Analyst covers
Ask-Prepare-Process-Analyze-Share-Act, Sheets, SQL, R,
Tableau, visualization, cleaning, statistics, ethics, and
storytelling. Think: Ask, Prepare, Process, Analyze, Share,
Act.
QUICK GOOGLE ANALYST KEY • Process =
Ask-Prepare-Process-Analyze-Share-Act • Quantitative =
Numeric / Qualitative = Descriptive / Structured = Rows-Cols /
Unstructured = Text-Images • Sheets: VLOOKUP + XLOOKUP +
Pivot Table / Filter + Sort + Conditional Formatting • SQL:
SELECT-FROM-WHERE-ORDER BY / JOIN
INNER-LEFT-RIGHT-FULL / GROUP BY + HAVING / Subquery +
CTE + CASE • R: dplyr filter-select-mutate-summarize / ggplot2
Aesthetics + Geom / Tableau Workbook-Dashboard • Stats:
Mean-Median-Mode / Std Dev / Correlation vs Causation /
Hypothesis + Sampling + Bias • Ethics: Privacy + Fairness /
Storytelling = Narrative + Context + Insight
1. Google Data Analyst - Certificate / Courses
Google Data Analyst - 60 Questions | Page 1
,Google Data Analyst - Certificate / Courses:
A. Certificate = Google, Data, Analytics, 8 courses, Coursera
- Ask = Ask, Questions, Make, Data-Driven, Decisions -
Prepare = Prepare, Data, Exploration - Process = Process,
Data, Cleaning - Certificate = Google, Data - Ask = Ask,
Questions
B. No Certificate
C. No Ask
D. No Prepare
Correct Answer: A. Certificate = Google, Data, Analytics,
8 courses, Coursera - Ask = Ask, Questions, Make,
Data-Driven, Decisions - Prepare = Prepare, Data,
Exploration - Process = Process, Data, Cleaning -
Certificate = Google, Data - Ask = Ask, Questions
Rationale: Certificate: Google, Data, Analytics, 8 courses,
Coursera. Ask: Ask, Questions, Make, Data-Driven,
Decisions. Prepare: Prepare, Data, Exploration. Process:
Process, Data, Cleaning. Certificate = Google, Data. Ask =
Ask, Questions.
2. Data Analytics - Ask / Prepare / Process / Analyze /
Share / Act
Data Analytics - Ask / Prepare / Process / Analyze / Share /
Act:
A. Ask = define, problem, stakeholder, question - Prepare =
collect, data, sources, structure - Process = clean, transform,
format - Analyze = patterns, insights, calculations - Share =
Google Data Analyst - 60 Questions | Page 2
,visualize, communicate, story - Act = decide, recommend,
action - Ask = define, problem - Prepare = collect, data
B. No Ask
C. No Prepare
D. No Process
Correct Answer: A. Ask = define, problem, stakeholder,
question - Prepare = collect, data, sources, structure -
Process = clean, transform, format - Analyze = patterns,
insights, calculations - Share = visualize, communicate,
story - Act = decide, recommend, action - Ask = define,
problem - Prepare = collect, data
Rationale: Ask: define, problem, stakeholder, question.
Prepare: collect, data, sources, structure. Process: clean,
transform, format. Analyze: patterns, insights, calculations.
Share: visualize, communicate, story. Act: decide,
recommend, action. Ask = define, problem. Prepare = collect,
data.
3. Data - Types / Quantitative / Qualitative
Data - Types / Quantitative / Qualitative:
A. Quantitative = numeric, measurable, count, amount -
Qualitative = categorical, descriptive, text, observations -
Discrete = whole, count, separate - Continuous = range,
measured, decimal - Quantitative = numeric, measurable -
Qualitative = categorical, descriptive
B. No Quantitative
C. No Qualitative
Google Data Analyst - 60 Questions | Page 3
, D. No Discrete
Correct Answer: A. Quantitative = numeric, measurable,
count, amount - Qualitative = categorical, descriptive,
text, observations - Discrete = whole, count, separate -
Continuous = range, measured, decimal - Quantitative =
numeric, measurable - Qualitative = categorical,
descriptive
Rationale: Quantitative: numeric, measurable, count, amount.
Qualitative: categorical, descriptive, text, observations.
Discrete: whole, count, separate. Continuous: range,
measured, decimal. Quantitative = numeric, measurable.
Qualitative = categorical, descriptive.
4. Data - Structured / Unstructured / First-Party /
Third-Party
Data - Structured / Unstructured / First-Party / Third-Party:
A. Structured = organized, rows, columns, database -
Unstructured = text, images, video, no schema - First-Party =
collected, own, customers, direct - Third-Party = bought,
external, aggregator, vendor - Structured = organized, rows -
Unstructured = text, images
B. No Structured
C. No Unstructured
D. No First-Party
Correct Answer: A. Structured = organized, rows,
columns, database - Unstructured = text, images, video,
no schema - First-Party = collected, own, customers,
Google Data Analyst - 60 Questions | Page 4
