GCP Professional Cloud Architect Practice Question

You manage a BigQuery ingestion-time partitioned table called logs.raw in project analytics-prod (location US). A Cloud Scheduler job must run each morning and, using the bq CLI, export only the partition for the previous UTC day to Cloud Storage as compressed Newline-delimited JSON. The export must overwrite any existing objects and automatically split the output into multiple shards if it exceeds the per-file size limit. Which command pattern meets all of these requirements?

bq extract --destination_format=NEWLINE_DELIMITED_JSON analytics-prod:logs.raw@YYYYMMDD000000-YYYYMMDD235959 gs://acme-exports/logs/raw-range.json.gz
bq extract --compression=GZIP analytics-prod:logs.raw$YYYYMMDD gs://acme-exports/logs/raw.json
bq extract --destination_format=NEWLINE_DELIMITED_JSON --compression=GZIP analytics-prod:logs.raw$YYYYMMDD gs://acme-exports/logs/raw-*.json.gz
bq extract --destination_format=JSON --compression=GZIP analytics-prod:logs.raw gs://acme-exports/logs/raw.json.gz

Report Issue

Answer Description

The bq extract command is the correct tool for exporting table data to Cloud Storage.

Key requirements and how the command satisfies them:

Export a single ingestion-time partition from an ingestion-time partitioned table - use the partition decorator $YYYYMMDD (e.g. $20230915).
Output format must be Newline-delimited JSON - --destination_format=NEWLINE_DELIMITED_JSON.
Use compression - --compression=GZIP.
Allow BigQuery to shard the output when a wildcard (*) is present in the destination URI - gs://acme-exports/logs/raw-*.json.gz.
Overwrite existing objects - the extract job overwrites any objects whose names exactly match the destination URI pattern; therefore rerunning the command with the same wildcard names replaces the files for that partition.

The correct option incorporates all these flags, uses the $ partition decorator, specifies compression and destination format, and includes a wildcard in the Cloud Storage URI. The incorrect answers each violate at least one requirement:

An answer without the $YYYYMMDD decorator would export the entire table.
Using --format=JSON or omitting the format flag causes a syntax error or exports to CSV by default.
A command that omits the wildcard cannot create multiple shards and risks exceeding the 1 GB limit.
A command lacking --compression=GZIP produces uncompressed files.

Ask Bash

Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.