Google Data Analytics Certification Test
Study Guide 2026–2027: Practice
Questions, SQL, Data Cleaning &
Visualization
60 Practice Q & A With Correct Answers & Detailed
Rationales - Google Data Analytics Certification
INSTRUCTIONS: Read each question, choose the best
answer, then check the correct answer and rationale. Google
Data Analytics covers
Ask-Prepare-Process-Analyze-Share-Act, SMART, Sheets,
SQL, cleaning, R, Tableau, visualization, statistics, ethics,
and storytelling. Think: Ask, Prepare, Process, Analyze,
Share, Act.
Google Data Analytics - 60 Questions | Page 1
,QUICK GOOGLE ANALYTICS KEY • Process =
Ask-Prepare-Process-Analyze-Share-Act / SMART =
Specific-Measurable-Action-Oriented-Relevant-Time-Bound •
Quantitative = Numeric / Qualitative = Descriptive / Structured =
Rows-Cols / First-Party = Own / Third-Party = Bought • Sheets:
VLOOKUP + XLOOKUP + INDEX-MATCH + Pivot / Filter + Sort +
Conditional Formatting + Validation • SQL:
SELECT-FROM-WHERE-ORDER BY-LIMIT / JOIN
INNER-LEFT-RIGHT-FULL-CROSS / GROUP BY + HAVING / CTE
+ CASE + UNION / AND-OR-NOT-IN-BETWEEN-LIKE • Cleaning:
Nulls + Duplicates + Outliers + Inconsistent + Misspelled /
OpenRefine + Truncate + Split • R: dplyr
filter-select-mutate-arrange-summarize / ggplot2 aes + geom +
facet / Tableau Workbook-Dashboard • Stats:
Mean-Median-Mode / Std Dev / Correlation vs Causation / Ethics
Privacy + GDPR
1. Google Analytics Certificate - 8 Courses / Capstone
Google Analytics Certificate - 8 Courses / Capstone:
A. Certificate = Google, Data, Analytics, 8 courses, Coursera,
capstone - Course 1 = Foundations, Ask, Data, Decisions -
Course 8 = Capstone, Case Study, Portfolio - Certificate =
Google, Data - Course 1 = Foundations, Ask
B. No Certificate
C. No Foundations
D. No Capstone
Correct Answer: A. Certificate = Google, Data, Analytics,
8 courses, Coursera, capstone - Course 1 = Foundations,
Google Data Analytics - 60 Questions | Page 2
,Ask, Data, Decisions - Course 8 = Capstone, Case Study,
Portfolio - Certificate = Google, Data - Course 1 =
Foundations, Ask
Rationale: Certificate: Google, Data, Analytics, 8 courses,
Coursera, capstone. Course 1: Foundations, Ask, Data,
Decisions. Course 8: Capstone, Case Study, Portfolio.
Certificate = Google, Data. Course 1 = Foundations, Ask.
2. Analytics Process - Ask / Prepare / Process / Analyze /
Share / Act
Analytics Process - Ask / Prepare / Process / Analyze / Share
/ Act:
A. Ask = define, problem, stakeholder, SMART - 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
B. No Ask
C. No Prepare
D. No Process
Correct Answer: A. Ask = define, problem, stakeholder,
SMART - 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
Google Data Analytics - 60 Questions | Page 3
, Rationale: Ask: define, problem, stakeholder, SMART.
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. SMART Questions / Stakeholders / Problem Types
SMART Questions / Stakeholders / Problem Types:
A. SMART = Specific, Measurable, Action-Oriented,
Relevant, Time-Bound - Stakeholder = person, interest,
decision, impact - Problem Types = make, predictions,
categorize, discover, patterns - SMART = Specific,
Measurable - Stakeholder = person, interest
B. No SMART
C. No Stakeholder
D. No Problem Types
Correct Answer: A. SMART = Specific, Measurable,
Action-Oriented, Relevant, Time-Bound - Stakeholder =
person, interest, decision, impact - Problem Types =
make, predictions, categorize, discover, patterns -
SMART = Specific, Measurable - Stakeholder = person,
interest
Rationale: SMART: Specific, Measurable, Action-Oriented,
Relevant, Time-Bound. Stakeholder: person, interest,
decision, impact. Problem Types: make, predictions,
categorize, discover, patterns. SMART = Specific,
Google Data Analytics - 60 Questions | Page 4
Study Guide 2026–2027: Practice
Questions, SQL, Data Cleaning &
Visualization
60 Practice Q & A With Correct Answers & Detailed
Rationales - Google Data Analytics Certification
INSTRUCTIONS: Read each question, choose the best
answer, then check the correct answer and rationale. Google
Data Analytics covers
Ask-Prepare-Process-Analyze-Share-Act, SMART, Sheets,
SQL, cleaning, R, Tableau, visualization, statistics, ethics,
and storytelling. Think: Ask, Prepare, Process, Analyze,
Share, Act.
Google Data Analytics - 60 Questions | Page 1
,QUICK GOOGLE ANALYTICS KEY • Process =
Ask-Prepare-Process-Analyze-Share-Act / SMART =
Specific-Measurable-Action-Oriented-Relevant-Time-Bound •
Quantitative = Numeric / Qualitative = Descriptive / Structured =
Rows-Cols / First-Party = Own / Third-Party = Bought • Sheets:
VLOOKUP + XLOOKUP + INDEX-MATCH + Pivot / Filter + Sort +
Conditional Formatting + Validation • SQL:
SELECT-FROM-WHERE-ORDER BY-LIMIT / JOIN
INNER-LEFT-RIGHT-FULL-CROSS / GROUP BY + HAVING / CTE
+ CASE + UNION / AND-OR-NOT-IN-BETWEEN-LIKE • Cleaning:
Nulls + Duplicates + Outliers + Inconsistent + Misspelled /
OpenRefine + Truncate + Split • R: dplyr
filter-select-mutate-arrange-summarize / ggplot2 aes + geom +
facet / Tableau Workbook-Dashboard • Stats:
Mean-Median-Mode / Std Dev / Correlation vs Causation / Ethics
Privacy + GDPR
1. Google Analytics Certificate - 8 Courses / Capstone
Google Analytics Certificate - 8 Courses / Capstone:
A. Certificate = Google, Data, Analytics, 8 courses, Coursera,
capstone - Course 1 = Foundations, Ask, Data, Decisions -
Course 8 = Capstone, Case Study, Portfolio - Certificate =
Google, Data - Course 1 = Foundations, Ask
B. No Certificate
C. No Foundations
D. No Capstone
Correct Answer: A. Certificate = Google, Data, Analytics,
8 courses, Coursera, capstone - Course 1 = Foundations,
Google Data Analytics - 60 Questions | Page 2
,Ask, Data, Decisions - Course 8 = Capstone, Case Study,
Portfolio - Certificate = Google, Data - Course 1 =
Foundations, Ask
Rationale: Certificate: Google, Data, Analytics, 8 courses,
Coursera, capstone. Course 1: Foundations, Ask, Data,
Decisions. Course 8: Capstone, Case Study, Portfolio.
Certificate = Google, Data. Course 1 = Foundations, Ask.
2. Analytics Process - Ask / Prepare / Process / Analyze /
Share / Act
Analytics Process - Ask / Prepare / Process / Analyze / Share
/ Act:
A. Ask = define, problem, stakeholder, SMART - 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
B. No Ask
C. No Prepare
D. No Process
Correct Answer: A. Ask = define, problem, stakeholder,
SMART - 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
Google Data Analytics - 60 Questions | Page 3
, Rationale: Ask: define, problem, stakeholder, SMART.
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. SMART Questions / Stakeholders / Problem Types
SMART Questions / Stakeholders / Problem Types:
A. SMART = Specific, Measurable, Action-Oriented,
Relevant, Time-Bound - Stakeholder = person, interest,
decision, impact - Problem Types = make, predictions,
categorize, discover, patterns - SMART = Specific,
Measurable - Stakeholder = person, interest
B. No SMART
C. No Stakeholder
D. No Problem Types
Correct Answer: A. SMART = Specific, Measurable,
Action-Oriented, Relevant, Time-Bound - Stakeholder =
person, interest, decision, impact - Problem Types =
make, predictions, categorize, discover, patterns -
SMART = Specific, Measurable - Stakeholder = person,
interest
Rationale: SMART: Specific, Measurable, Action-Oriented,
Relevant, Time-Bound. Stakeholder: person, interest,
decision, impact. Problem Types: make, predictions,
categorize, discover, patterns. SMART = Specific,
Google Data Analytics - 60 Questions | Page 4
