Google Cloud Professional Data Engineer · Free practice question 11 of 12
Scheduled queries for a single SQL job
Every morning at 06:00, Hesketh Foods needs one SQL statement to append the previous day's summarized sales into a reporting table in BigQuery. There are no other steps or dependencies. What is the simplest way to automate it?
- A.A Managed Service for Apache Airflow (formerly Cloud Composer) environment with a daily DAG
- B.A BigQuery scheduled query with the destination table set to append
- C.A Compute Engine VM running cron and the bq command-line tool
- D.A Dataflow batch pipeline launched by Cloud Scheduler
Show answer and explanation
Correct answer: B. A BigQuery scheduled query with the destination table set to append
Why: Scheduled queries run a SQL statement on a schedule through BigQuery Data Transfer Service and can append results to a destination table, with nothing else to manage. An Airflow environment is more than one statement needs and costs money while idle. A cron VM adds a server to maintain, and Dataflow is unnecessary for a single SQL statement.
More free Google Cloud Professional Data Engineer questions
- Sliding windows for moving averages
- Turbo replication on dual-region buckets
- Assured Workloads for sovereign controls
- Data Validation Tool after migration
- Pub/Sub Cloud Storage subscription archive
- Bigtable garbage collection by age
- Search indexes for log lookups
- Data Studio viewer's credentials
- Integer-range partitioning on an ID
- Approximate distinct counts for dashboards
- Pub/Sub message storage policy regions