Courseiva

Google ACE Practice Question: Ensuring Successful Operation of a Cloud Solution

You want to export a subset of Cloud Logging logs to BigQuery for long-term analysis. Which method should you use?

⚠ Common exam trap

Watch out — candidates often confuse log-based metrics (numeric Monitoring time series) with log sinks (raw log routing), causing candidates to pick the metric option when the question asks for exporting actual log data.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Create a log sink with a filter and destination BigQuery

A log sink is the native Cloud Logging mechanism for routing log entries to supported destinations, and BigQuery is a first-class sink destination. By attaching an inclusion filter to the sink, you can export only the subset of logs you care about, and Cloud Logging handles the delivery and schema management automatically. This is the designed, serverless, and most operationally sound approach for long-term log analysis in BigQuery.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Create a log-based metric and export the metric to BigQuery

    Why it's wrong here

    Log-based metrics only aggregate matching log entries into counter or distribution metrics; they produce numeric time series, not raw log data. Exporting the metric to BigQuery would give you aggregate counts or value distributions, not the underlying log entries and their structured payloads. Thus this approach cannot satisfy the requirement to export a subset of logs themselves.

  • ✓

    Create a log sink with a filter and destination BigQuery

    Why this is correct

    A log sink with a filter and a BigQuery destination is the fully managed, native way to export logs: Cloud Logging continuously routes any newly ingested log entries that match the filter into a specified BigQuery dataset. The sink automatically creates a table with the log schema, and you can use the _PARTITIONTIME pseudo-column for time-based partitioning. This gives reliable, near-real-time export without custom code or manual intervention.

  • ✗

    Set up a Cloud Function that triggers on logs and inserts into BigQuery

    Why it's wrong here

    A Cloud Function triggered by logs and inserting into BigQuery lacks the managed, schema-aware routing and buffering that a log sink provides, failing to meet the requirement for a reliable, long-term export of a defined subset. This approach is tempting because it offers custom processing logic for real-time log enrichment or alerting, and would be correct for scenarios requiring immediate, event-driven transformations before storage.

  • ✗

    Use gcloud logging read and pipe to bq load

    Why it's wrong here

    Running `gcloud logging read` to fetch logs and piping the output into `bq load` is a point-in-time, manual process that is not suitable for an ongoing, continuous export. It would require your own scheduling, pagination, and error handling, and it consumes time and compute while risking data loss with large log volumes. Additionally, it cannot stream new logs as they arrive, so it actually fails the core requirement of exporting a defined subset in a managed way.

Quick reference

Cloud Service Model Comparison

ModelYou ManageProvider ManagesExamples
IaaSOS, runtime, apps, dataHardware, hypervisor, networkingEC2, Azure VMs, GCP Compute Engine
PaaSApps and dataOS, runtime, middleware, hardwareElastic Beanstalk, Azure App Service
SaaSData and settings onlyEverything elseMicrosoft 365, Salesforce, Workday
FaaS / ServerlessFunction code onlyInfra, scaling, runtimeLambda, Azure Functions, Cloud Run
CaaSContainers and appsKubernetes, OS, hardwareEKS, AKS, GKE

About these practice questions

One of 775 original ACE practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written and reviewed by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

Last reviewed September 2026 · checked against the official Google Cloud exam blueprint

This ACE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the ACE exam.