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
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
Learn chapter
BigQuery Views and Materialized Views
Key term
Serverless
Serverless is a cloud computing model where the cloud provider manages the servers, and you only pay for the actual compute time your code uses, without having to worry about provisioning or maintaining infrastructure.
Key term
BigQuery
BigQuery is a fully managed, serverless data warehouse on Google Cloud that lets you run fast SQL queries on massive datasets without managing any infrastructure.
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 →
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.