You have an analytics application that runs hundreds of queries on BigQuery every few minutes using BigQuery API. You want to find out how much time these queries take to execute. What should you do?

Question

Options

• AUse Stackdriver Monitoring to plot slot usage.
• BUse Stackdriver Trace to plot API execution time.
• CUse Stackdriver Trace to plot query execution time.
• DUse Stackdriver Monitoring to plot query execution times.

• A
  4% (1)
• B
  4% (1)
• C
  9% (2)
• D
  83% (19)

Explanation

Cloud Monitoring (Stackdriver Monitoring) collects and exposes BigQuery-specific metrics, including query execution times, through its built-in BigQuery metric integrations. You can use Metrics Explorer or create dashboards to plot these metrics over time. Option A (slot usage) measures compute capacity consumed, not how long queries take. Options B and C (Stackdriver Trace) are incorrect because Trace is a distributed tracing tool designed for microservice latency analysis across API calls - it does not natively instrument or report BigQuery internal query execution durations. Trace measures application-level API call latency (including the time the client waits), not the actual query execution time as reported by BigQuery's engine.

No community discussion yet for this question.