Professional learning platform GSS Pathway
Free video catalog

Certificate exam

Google Data Analytics Final Exam

Complete a focused 30-question multiple-choice assessment built around the same data analytics concepts covered in the Google Data Analytics course playlist.

30-question scored test
75 minutes recommended Pass mark: 70% (21/30) Save and download scored JSON

Exam format

  • 30 required multiple-choice questions
  • Automatic local score calculation when you submit
  • Pass mark set at 70%, which is 21 correct answers
  • Download a scored JSON copy for your records

Topics assessed

  • Data lifecycle, problem framing and stakeholder questions
  • Spreadsheets, SQL querying and data aggregation
  • R, Tableau, dashboards and data storytelling
  • Data integrity, metrics, ethics and analyst workflows

Before you submit

  • Confirm your candidate details are accurate
  • Answer every question because all 30 items are required
  • Review your result banner after the score is calculated
  • Keep your downloaded JSON copy as your saved submission record

Candidate Details and Assessment

Complete your details, answer every question, then submit the form to calculate your score instantly on this device.

Candidate information
Google Data Analytics MCQ Paper

Select one answer per question. You need at least 21 correct answers to pass.

1. The primary purpose of data analytics is to:

2. The first step in a typical analytics workflow is to:

3. Structured data is most commonly stored in:

4. Metadata is best described as:

5. Data cleaning matters because it helps analysts:

6. Duplicate rows in a dataset most directly risk:

7. In SQL, the WHERE clause is used to:

8. GROUP BY in SQL is mainly used to:

9. A JOIN operation is used when you need to:

10. In a spreadsheet, a pivot table is especially useful for:

11. R is commonly used in analytics for:

12. The ggplot2 package in R is mainly used to:

13. R Markdown is valuable because it lets analysts:

14. Tableau is best known for helping analysts:

15. An effective dashboard should primarily prioritize:

16. Data storytelling combines insights with:

17. Correlation between two variables means that they:

18. A sample differs from a population because a sample is:

19. Before removing an outlier, an analyst should first:

20. Null or missing values should be handled by:

21. Data integrity refers to data being:

22. At the start of a project, a stakeholder question should mainly clarify:

23. A KPI is best defined as:

24. A/B testing is used to compare:

25. The best chart for showing a trend over time is usually a:

26. When comparing values across categories, the most common chart choice is a:

27. Data ethics requires analysts to:

28. A strong analytics portfolio usually demonstrates:

29. To count the number of rows returned by a SQL query, you would commonly use:

30. A sound recommendation at the end of an analysis should be:

Return to Google Data Analytics Course Browse Free Video Courses