Crucial Exams

GCP Professional Data Engineer Practice Question

A global SaaS platform streams about 5 TB of JSON application events into Cloud Storage each day. Product managers need an interactive SQL workspace that can return multi-year aggregations in seconds, automatically handle thousands of concurrent users, and charge primarily for the queries they run instead of for idle infrastructure. Which Google Cloud service best satisfies these requirements with minimal operational overhead?

  • Write the events to Cloud Bigtable and run scheduled Dataflow jobs to pre-aggregate metrics for analysts.

  • Deploy an always-on Dataproc cluster and use Apache Hive to query the Parquet files stored in Cloud Storage.

  • Load the data into partitioned BigQuery tables and expose the dataset through the BigQuery SQL interface.

  • Store the JSON in Cloud SQL for PostgreSQL with high-availability and autoscaling read replicas.

GCP Professional Data Engineer
Storing the data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot