Quiz 1 Question 5

You need to optimize the performance of queries in BigQuery. Your tables are not partitioned or clustered. What optimization technique can you use?

This exercise is part of the course

Preparing for your Professional Data Engineer Journey

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

This exercise is part of the course

Preparing for your Professional Data Engineer Journey

AdvancedSkill Level

5.0+

Start Course for Free

Welcome to Preparing for the Professional Cloud Data Engineer Journey. In this introductory module, you learn about the role of a Professional Data Engineer. We discuss the types of resources available to support your study, and how to use the workbook to create your study plan.

Exercise 1: Course Introduction Exercise 2: Module Overview Exercise 3: Introduction to the Professional Data Engineer role Exercise 4: Certification value and benefits Exercise 5: Certification process Exercise 6: Creating your study plan Exercise 7: Course Workbook

In this module, you’ll explore considerations for designing data processing systems, which correspond to section 1 of the Professional Data Engineer Exam Guide. You start by discussing how a Professional Data Engineer performs this role at Cymbal Retail. Next, you’ll assess your skills in this section through 10 diagnostic questions. Then you’ll review these questions. Based on the areas you need to learn more about, you’ll identify resources to include in your study plan.

Exercise 1: Module Overview Exercise 2: Migrating data from private data centers to Google Cloud for Cymbal Retail Exercise 3: Introduction: Diagnostic questions Exercise 4: Diagnostic Questions Practice Demo Exercise 5: Quiz 1 Question 1 Exercise 6: Quiz 1 Question 2 Exercise 7: Quiz 1 Question 3 Exercise 8: Quiz 1 Question 4 Exercise 9: Quiz 1 Question 5 Exercise 10: Quiz 1 Question 6 Exercise 11: Quiz 1 Question 7 Exercise 12: Quiz 1 Question 8 Exercise 13: Quiz 1 Question 9 Exercise 14: Quiz 1 Question 10 Exercise 15: Your study plan Exercise 16: Study plan resources Exercise 17: Quiz 2 Question 1 Exercise 18: Quiz 2 Question 2

In this module you’ll explore considerations for ingesting and processing data, which corresponds to section 2 of the Professional Data Engineer Exam Guide. You’ll start by discussing how a Professional Data Engineer performs this role at Cymbal Retail. Next, you’ll assess your skills in this section through 10 diagnostic questions. Then you’ll review these questions. Based on the areas you need to learn more about, you’ll identify resources to include in your study plan.

Exercise 1: Module Overview Exercise 2: Ingesting and processing data for Cymbal Retail Exercise 3: Introduction: Diagnostic questions Exercise 4: Quiz 1 Question 1 Exercise 5: Quiz 1 Question 2 Exercise 6: Quiz 1 Question 3 Exercise 7: Quiz 1 Question 4 Exercise 8: Quiz 1 Question 5 Exercise 9: Quiz 1 Question 6 Exercise 10: Quiz 1 Question 7 Exercise 11: Quiz 1 Question 8 Exercise 12: Quiz 1 Question 9 Exercise 13: Quiz 1 Question 10 Exercise 14: Your study plan Exercise 15: Study plan resources Exercise 16: Quiz 2 Question 1 Exercise 17: Quiz 2 Question 2

In this module you’ll explore considerations for storing data, which corresponds to section 3 of the Professional Data Engineer Exam Guide. You start by discussing how a Professional Data Engineer performs this role at Cymbal Retail. Next, you’ll assess your skills in this section through 10 diagnostic questions. Then you’ll review these questions. Based on the areas you need to learn more about, you’ll identify resources to include in your study plan.

Exercise 1: Module Overview Exercise 2: Storing Cymbal Retail’s data Exercise 3: Introduction: Diagnostic questions Exercise 4: Quiz 1 Question 1 Exercise 5: Quiz 1 Question 2 Exercise 6: Quiz 1 Question 3 Exercise 7: Quiz 1 Question 4 Exercise 8: Quiz 1 Question 5 Exercise 9: Quiz 1 Question 6 Exercise 10: Quiz 1 Question 7 Exercise 11: Quiz 1 Question 8 Exercise 12: Quiz 1 Question 9 Exercise 13: Quiz 1 Question 10 Exercise 14: Your study plan Exercise 15: Study plan resources Exercise 16: Quiz 2 Question 1 Exercise 17: Quiz 2 Question 2

In this module, you’ll explore considerations when preparing and using data for analysis, which corresponds to section 4 of the Professional Data Engineer Exam Guide. You start by discussing how a Professional Data Engineer performs this role at Cymbal Retail. Next, you’ll assess your skills in this section through 10 diagnostic questions. Then you’ll review these questions. Based on the areas you need to learn more about, you’ll identify resources to include in your study plan.

Exercise 1: Module Overview Exercise 2: Preparing and using Cymbal Retail’s data for analysis Exercise 3: Introduction: Diagnostic questions Exercise 4: Quiz 1 Question 1 Exercise 5: Quiz 1 Question 2 Exercise 6: Quiz 1 Question 3 Exercise 7: Quiz 1 Question 4 Exercise 8: Quiz 1 Question 5

Current Exercise

Exercise 9: Quiz 1 Question 6 Exercise 10: Quiz 1 Question 7 Exercise 11: Quiz 1 Question 8 Exercise 12: Quiz 1 Question 9 Exercise 13: Quiz 1 Question 10 Exercise 14: Your study plan Exercise 15: Study plan resources Exercise 16: Quiz 2 Question 1 Exercise 17: Quiz 2 Question 2

In this module you’ll explore considerations for maintaining and automating data workloads, which corresponds to section 5 of the Professional Data Engineer Exam Guide. You start by discussing how a Professional Data Engineer performs this role at Cymbal Retail. Next, you’ll assess your skills in this section through 10 diagnostic questions. Then you’ll review these questions. Based on the areas you need to learn more about, you’ll identify resources to include in your study plan.

Exercise 1: Module Overview Exercise 2: Maintaining and automating data workloads at Cymbal Retail Exercise 3: Introduction: Diagnostic questions Exercise 4: Quiz 1 Question 1 Exercise 5: Quiz 1 Question 2 Exercise 6: Quiz 1 Question 3 Exercise 7: Quiz 1 Question 4 Exercise 8: Quiz 1 Question 5 Exercise 9: Quiz 1 Question 6 Exercise 10: Quiz 1 Question 7 Exercise 11: Quiz 1 Question 8 Exercise 12: Quiz 1 Question 9 Exercise 13: Quiz 1 Question 10 Exercise 14: Your study plan Exercise 15: Study plan resources Exercise 16: Quiz 2 Question 1 Exercise 17: Quiz 2 Question 2

In this module, you focus on creating your individualized study plan. You will use the notes you’ve been taking throughout this course to put together a study plan for each week in your Professional Data Engineer journey.

Exercise 1: Module Overview Exercise 2: Weekly Study Goals