Quiz 1 Question 2

You have data in PostgreSQL that was designed to reduce redundancy. You are transferring this data to BigQuery for analytics. The source data is hierarchical and frequently queried together. You need to design a BigQuery schema that is performant. What should you do?

Este exercício faz parte do curso

Preparing for your Professional Data Engineer Journey

Exercício interativo prático

Transforme a teoria em ação com um de nossos exercícios interativos

Começar o exercício

Este exercício faz parte do curso

Preparing for your Professional Data Engineer Journey

AvançadoNível de habilidade

5.0+

Iniciar curso de graça

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

Exercício atual

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 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