Quiz 1 Question 3

You have several large tables in your transaction databases. You need to move all the data to BigQuery for the business analysts to explore and analyze the data. How should you design the schema in BigQuery?

Deze oefening maakt deel uit van de cursus

Preparing for your Professional Data Engineer Journey

Cursus bekijken

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen

Deze oefening maakt deel uit van de cursus

Preparing for your Professional Data Engineer Journey

SkillTag.level.advancedSkillTag.label

5.0+

Begin de cursus gratis

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

Huidige oefening

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