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.

Home/Exams/Google Cloud/PDE/Practice

PDEActiveGoogle Cloud · Professional

Google Cloud Certified Professional Data Engineer Practice Mode

342 total questions·103 questions in free preview

Practice questions

Question 47 of 103

Free Preview · 103 of 342 · questions 1–103 of 342 are free. Sign up free to sync your progress across devices.

0 of 103 answered

Question Map

103 available

Go to question number

1 / 3

Question 47

View question permalink page

Flag question for review

You are designing the database schema for a machine learning-based food ordering service that will predict what users want to eat. Here is some of the information you need to store: • The user profile: What the user likes and doesn't like to eat • The user account information: Name, address, preferred meal times • The order information: When orders are made, from where, to whom The database will be used to store all the transactional data of the product. You want to optimize the data schema. Which Google Cloud Platform product should you use?

Select one answer.

Marked answer: B

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

Chose B1
Best choice: B. Cloud SQL Relational database (MySQL/PostgreSQL/SQL Server) Ideal for structured, transactional data (OLTP) Supports schemas, joins, constraints, which fit: User profiles (likes/dislikes) Account info (name, address, meal times) Orders (relationships between users, restaurants, timestamps) This is exactly what you need for a normalized, transactional system.
Chose A1
BQ for storing ML tables
Chose A1
bq storing for machine learning

47 / 103

Keyboard:←→ previous / nextA–E chooseEnter check, then next