Advanced Google Data Analytics Professional
Certificate Multiple Choice Questions
(MCQs) with Answers and Explanations for
Professional Certification Exams
1. A data analyst is evaluating a model where false negatives are significantly more costly
than false positives. Which metric should be prioritized?
A. Accuracy
B. Specificity
C. Precision
D. Recall
Explanation: Recall measures the proportion of actual positive cases correctly identified,
making it especially important when missing positive cases has severe consequences.
2. Which SQL clause is evaluated after the GROUP BY operation to filter aggregated
records?
A. WHERE
B. ORDER BY
C. DISTINCT
D. HAVING
Explanation: HAVING filters groups after aggregation, whereas WHERE filters individual rows
before grouping.
3. A dataset contains highly skewed numerical values with extreme outliers. Which measure
of central tendency is most robust?
A. Mean
B. Weighted Mean
C. Geometric Mean
, D. Median
Explanation: The median is less sensitive to extreme values and provides a better representation
of central tendency for skewed distributions.
4. Which spreadsheet function in Google Sheets is used to retrieve values based on a
vertical lookup?
A. INDEX
B. MATCH
C. OFFSET
D. VLOOKUP
Explanation: VLOOKUP searches for a value in the first column of a range and returns a
corresponding value from another column.
5. Which visualization is most appropriate for examining relationships between two
continuous variables?
A. Pie Chart
B. Histogram
C. Box Plot
D. Scatter Plot
Explanation: Scatter plots effectively reveal correlations, trends, clusters, and outliers between
numerical variables.
6. During data cleaning, duplicate records should primarily be removed because they:
A. Improve variance estimation
B. Increase sample representativeness
C. Enhance normalization
D. Can bias analytical results
Explanation: Duplicate observations may distort descriptive statistics and lead to inaccurate
conclusions.
Certificate Multiple Choice Questions
(MCQs) with Answers and Explanations for
Professional Certification Exams
1. A data analyst is evaluating a model where false negatives are significantly more costly
than false positives. Which metric should be prioritized?
A. Accuracy
B. Specificity
C. Precision
D. Recall
Explanation: Recall measures the proportion of actual positive cases correctly identified,
making it especially important when missing positive cases has severe consequences.
2. Which SQL clause is evaluated after the GROUP BY operation to filter aggregated
records?
A. WHERE
B. ORDER BY
C. DISTINCT
D. HAVING
Explanation: HAVING filters groups after aggregation, whereas WHERE filters individual rows
before grouping.
3. A dataset contains highly skewed numerical values with extreme outliers. Which measure
of central tendency is most robust?
A. Mean
B. Weighted Mean
C. Geometric Mean
, D. Median
Explanation: The median is less sensitive to extreme values and provides a better representation
of central tendency for skewed distributions.
4. Which spreadsheet function in Google Sheets is used to retrieve values based on a
vertical lookup?
A. INDEX
B. MATCH
C. OFFSET
D. VLOOKUP
Explanation: VLOOKUP searches for a value in the first column of a range and returns a
corresponding value from another column.
5. Which visualization is most appropriate for examining relationships between two
continuous variables?
A. Pie Chart
B. Histogram
C. Box Plot
D. Scatter Plot
Explanation: Scatter plots effectively reveal correlations, trends, clusters, and outliers between
numerical variables.
6. During data cleaning, duplicate records should primarily be removed because they:
A. Improve variance estimation
B. Increase sample representativeness
C. Enhance normalization
D. Can bias analytical results
Explanation: Duplicate observations may distort descriptive statistics and lead to inaccurate
conclusions.
