hardMultiple Select
PDE Practice Question: Designing a data lake on Cloud Storage for…
A company is designing a data lake on Cloud Storage for analytics. They need to store data in various formats (Avro, Parquet, CSV) and enable efficient querying with BigQuery and Dataproc. Which THREE practices should they follow?
⚠ Common exam trap
Google Cloud often tests the misconception that disabling encryption improves performance, but Cloud Storage encryption is transparent and has no measurable impact on read throughput, so candidates should recognize that security controls are non-negotiable in cloud data lakes.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use BigLake to create BigQuery tables that reference Cloud Storage data.
BigLake allows you to create BigQuery tables that reference data stored in Cloud Storage, enabling unified governance and fine-grained access control without moving data. This is essential for a data lake architecture where BigQuery and Dataproc need to query the same underlying data in various formats like Avro, Parquet, and CSV.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Use BigLake to create BigQuery tables that reference Cloud Storage data.
Why this is correct
Enables querying data without loading.
- ✓
Store data in columnar formats like Parquet for analytics workloads.
Why this is correct
Columnar formats reduce scan size.
- ✗
Disable encryption on the bucket to improve read performance.
Why it's wrong here
Encryption is required by default and doesn't harm performance.
- ✓
Partition data by date in a logical folder structure (e.g., /data/yyyy/mm/dd).
Why this is correct
Improves query performance and cost.
- ✗
Store all data in CSV format for simplicity.
Why it's wrong here
CSV is not optimized for analytics; larger scans.
Go deeper
Related to this question
About these practice questions
This PDE question is part of Courseiva's 747-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PDE exam.