ExamFreeIT Certification Practice, Made Simple

Preparing Practice Exam…

Please wait a moment while the system generates the exam questions, answers, and study session.

ExamFree

Free practice questions with explanations for AWS, Microsoft, CompTIA, Google Cloud, PMI, and more.

Explore

Browse All Exams
About ExamFree
Report a Question

Providers

Microsoft practice exams
Google Cloud practice exams
CompTIA practice exams
PMI practice exams
AWS practice exams
Databricks practice exams
Cisco practice exams
Snowflake practice exams
Anthropic practice exams
Linux Foundation practice exams
HashiCorp practice exams
ITIL practice exams
Red Hat practice exams

© 2026 ExamFree. ExamFree is an independent practice platform and is not affiliated with or endorsed by AWS, Microsoft, Google, CompTIA, PMI, or any certification provider. All certification names and trademarks belong to their respective owners.

PDE Question 180: You are migrating an application that tracks library… | ExamFree

Home/Google Cloud/PDE/Question 180

PDE Question 180

Google Cloud Certified Professional Data Engineer · Google Cloud

Previous Next

180

Question 180

View question permalink page

You are migrating an application that tracks library books and information about each book, such as author or year published, from an on-premises data warehouse to BigQuery. In your current relational database, the author information is kept in a separate table and joined to the book information on a common key. Based on Google's recommended practice for schema design, how would you structure the data to ensure optimal speed of queries about the author of each book that has been borrowed?

Select one answer.

Purchase Full Access to view answer options & explanation

The first 103 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 342 questions.

Unlock Full Access Try Free Preview (Q1–Q103)

Continue in Practice Mode for PDE