Correct Answer: Enable 'Data Access' Audit Logs for BigQuery and export them to a security dataset
Data Access audit logs capture detailed information about BigQuery activity, including identity, time, and the specific query text for every job....
Correct Answer
Enable 'Data Access' Audit Logs for BigQuery and export them to a security dataset
Why This Answer Is Correct
Data Access audit logs capture detailed information about BigQuery activity, including identity, time, and the specific query text for every job.
This question evaluates your knowledge of BigQuery — a core concept tested in Professional Cloud Architect. Understanding BigQuery is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
You are analyzing petabytes of data for business intelligence reports. You need a fully managed, serverless enterprise data warehouse that supports SQL queries. Which service is best suited for this task?
A data analytics team needs to process streaming data from millions of IoT devices. The data arrives at unpredictable intervals and must be analyzed in real-time before being stored in BigQuery. Which architecture is most scalable and cost-effective?
A data warehouse team needs to join data from BigQuery with data stored in a Cloud SQL PostgreSQL instance in real-time. Which BigQuery feature allows this federated query without moving the data?
Your data science team wants to use SQL to build and deploy a machine learning model for predicting customer churn directly where the data resides. They want to avoid complex ETL and data movement. Which service should they use?
To optimize costs for a BigQuery project, you want to identify which queries are consuming the most 'Slots' and which datasets are never accessed. Which tool should you use?