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?
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
Log sinks route logs to destinations like BigQuery, Cloud Storage, or Pub/Sub. Creating a sink with a filter is the correct approach.
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.
Go deeper
Related to this question
Learn chapter
Google Cloud Platform Overview
Key term
Cloud logging
Cloud logging is the practice of collecting, storing, and analyzing log data generated by cloud-based resources and applications to monitor performance, troubleshoot issues, and maintain security.
Key term
Pub/Sub
Pub/Sub is a messaging pattern where publishers send messages without knowing who receives them, and subscribers receive only the messages they care about.
About these practice questions
One of 769 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 by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.