Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Associate Cloud Engineer practice bank has an additional 2,014 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
A data analyst reports that a critical BigQuery query job recently completed with unexpected errors and consumed more resources than expected. You need to inspect the specific job's execution details, including total bytes processed, job state, and error results, using the bq command-line tool.
Which command should you run?
bq ls --jobs=true doesThe bq ls --jobs=true (or bq ls -j) command lists recent jobs submitted within a Google Cloud project or by the current user.
bq ls provides only a high-level tabular list of multiple jobs with basic columns (Job ID, Job Type, State, Start Time, and Duration). It does not display deep performance metrics, execution stage profiles, or full error structures for a specific job.JOB_ID that you later pass to bq show.You needed to find a list of recent job IDs submitted in a project to locate which job failed.
bq query --dry_run doesThe bq query --dry_run command validates SQL syntax and calculates an estimate of the total bytes that will be scanned before an actual query is executed.
--dry_run flag expects a SQL query string as input rather than an existing JOB_ID. It cannot inspect or retrieve the historical results of a previously completed job.You needed to validate SQL syntax and estimate the number of bytes a query would scan before executing it in BigQuery.
bq cancel doesThe bq cancel command sends a cancellation request to BigQuery to stop an active, running job before it finishes execution.
bigquery.jobs.update permission to abort executing jobs.RUNNING or PENDING state.A query was currently running, consuming excessive slots, and needed to be terminated immediately to prevent unnecessary resource consumption.
bq show --job=true isThe bq show --job=true command is the standard Google Cloud BigQuery CLI utility used to retrieve and display comprehensive metadata and execution statistics for a specific job.
JOB_ID with the --job=true flag instructs BigQuery to return detailed operational statistics, including job state (PENDING, RUNNING, DONE), creation time, start/end timestamps, and duration.total_bytes_processed and total_bytes_billed, allowing engineers to assess query cost and size.error_result record containing diagnostic error codes and descriptive messages.my-project:US.bquijob_123) and short-form job IDs.--location flag to inspect jobs across specific multi-region or regional locations.bq show --job=true directly targets the specific job record to provide the complete diagnostic summary needed to troubleshoot performance issues and review error details.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated