Correct Answer: BigQuery External Tables (via Cloud SQL connection)
BigQuery can perform federated queries against Cloud SQL (MySQL or PostgreSQL) using external tables, allowing you to query live relational data alongside petabyte-scale analytical...
Correct Answer
BigQuery External Tables (via Cloud SQL connection)
Why This Answer Is Correct
BigQuery can perform federated queries against Cloud SQL (MySQL or PostgreSQL) using external tables, allowing you to query live relational data alongside petabyte-scale analytical data.
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?
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?
Your company is audit-driven and needs to capture and analyze every SQL query executed against BigQuery for compliance purposes. How can they achieve this?