Google Professional Data Engineer QUESTIONS AND
ANSWERS | VERIFIED AND WELL DETAILED
ANSWERS | PLUS RATIONALES | GUARANTEED PASS
| LATEST EXAM UPDATE | EXAM PREP | STUDY
GUIDE | PRACTICE TEST
, Section 1: Designing Data Processing Systems (Questions 1–25)
1. A company needs to ingest millions of clickstream events per second and query them with sub-second
latency for dashboards. Which service is MOST appropriate?
A) Cloud SQL
B) BigQuery
C) Cloud Spanner
D) Cloud Storage
Answer: B
Rationale: BigQuery is a serverless, highly scalable analytics warehouse that supports high-throughput
streaming inserts and can serve sub-second queries on large datasets. Cloud SQL and Spanner are OLTP
databases not optimized for analytical clickstream workloads at this scale, and Cloud Storage alone doesn't
provide query capability.
, 2. You need to move 50 TB of on-premises data to Cloud Storage once, with limited network bandwidth. What
should you use?
A) gsutil parallel composite upload
B) Transfer Appliance
C) Storage Transfer Service
D) Cloud VPN
Answer: B
Rationale: Transfer Appliance is designed for large one-time offline data transfers when network bandwidth is
insufficient. Storage Transfer Service is for online transfers, gsutil is limited by bandwidth, and Cloud VPN
doesn't address bandwidth constraints.
, 3. Which storage class is BEST for data accessed less than once a year with minimum storage duration of 365
days?
A) Standard
B) Nearline
C) Coldline
D) Archive
Answer: D
Rationale: Archive has the lowest storage cost, a 365-day minimum duration, and is designed for data
accessed less than once per year. Coldline is for data accessed less than once a quarter.
4. A team wants to run Apache Spark jobs with minimal operational overhead. Which is BEST?
A) Dataproc on Compute Engine
B) Dataproc Serverless
ANSWERS | VERIFIED AND WELL DETAILED
ANSWERS | PLUS RATIONALES | GUARANTEED PASS
| LATEST EXAM UPDATE | EXAM PREP | STUDY
GUIDE | PRACTICE TEST
, Section 1: Designing Data Processing Systems (Questions 1–25)
1. A company needs to ingest millions of clickstream events per second and query them with sub-second
latency for dashboards. Which service is MOST appropriate?
A) Cloud SQL
B) BigQuery
C) Cloud Spanner
D) Cloud Storage
Answer: B
Rationale: BigQuery is a serverless, highly scalable analytics warehouse that supports high-throughput
streaming inserts and can serve sub-second queries on large datasets. Cloud SQL and Spanner are OLTP
databases not optimized for analytical clickstream workloads at this scale, and Cloud Storage alone doesn't
provide query capability.
, 2. You need to move 50 TB of on-premises data to Cloud Storage once, with limited network bandwidth. What
should you use?
A) gsutil parallel composite upload
B) Transfer Appliance
C) Storage Transfer Service
D) Cloud VPN
Answer: B
Rationale: Transfer Appliance is designed for large one-time offline data transfers when network bandwidth is
insufficient. Storage Transfer Service is for online transfers, gsutil is limited by bandwidth, and Cloud VPN
doesn't address bandwidth constraints.
, 3. Which storage class is BEST for data accessed less than once a year with minimum storage duration of 365
days?
A) Standard
B) Nearline
C) Coldline
D) Archive
Answer: D
Rationale: Archive has the lowest storage cost, a 365-day minimum duration, and is designed for data
accessed less than once per year. Coldline is for data accessed less than once a quarter.
4. A team wants to run Apache Spark jobs with minimal operational overhead. Which is BEST?
A) Dataproc on Compute Engine
B) Dataproc Serverless
