Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Associate Cloud Engineer practice bank has an additional 2,014 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
A data analyst needs to generate a unified reporting view. The analyst has customer demographic data stored in a BigQuery dataset and needs to join it in real time with live transactional order records stored in an operational Cloud SQL for PostgreSQL database instance.
The solution must execute a single SQL query in BigQuery without requiring data replication, batch export pipelines, or moving the operational database beforehand.
Which query execution approach should the analyst use?
Datastream is a serverless Change Data Capture (CDC) and replication service that synchronizes data across heterogeneous databases, storage systems, and BigQuery. It captures row-level inserts, updates, and deletes from operational sources (such as PostgreSQL, MySQL, and Oracle) and replicates them continuously into target data stores for downstream analytics.
The requirement called for building an enterprise real-time data pipeline to offload heavy, continuous analytics queries from the transactional database to BigQuery, where data movement and storage duplication are acceptable.
Cloud Bigtable is a sparsely populated, wide-column NoSQL database engine optimized for massive analytical and operational workloads with high-throughput reads and writes. Bigtable does not use traditional relational database structures or SQL semantics; instead, data retrieval relies primarily on row-key lookups, prefix scans, and programmatic API calls or SDK methods.
EXTERNAL_QUERY.EXTERNAL_QUERY relational connection service.The workload involved querying petabytes of unstructured or time-series event data stored directly in Cloud Bigtable using specific row-key ranges rather than querying an operational PostgreSQL database.
Cloud SQL supports database stored procedures in native dialects such as PL/pgSQL and T-SQL. These stored procedures execute procedural logic within the database engine itself to manipulate local tables, enforce transactional integrity, and perform operational business logic.
A transactional application running on Cloud SQL needed to trigger an event-driven database hook or retrieve a single aggregated score from an external system during a row transaction.
BigQuery query federation allows users to send SQL queries to external relational databases—including Cloud SQL, AlloyDB, and Spanner—and retrieve live query results directly back into BigQuery without copying or migrating data. The EXTERNAL_QUERY function takes a connection identifier and a SQL statement written in the dialect of the source database, running the external query remotely and streaming the results into the outer BigQuery GoogleSQL statement.
EXTERNAL_QUERY function runs directly against the live Cloud SQL for PostgreSQL instance in real time, completely bypassing the need for ETL or replication tools.JOIN, WHERE, and GROUP BY.information_schema views on external instances to inspect live schemas and table definitions.roles/bigquery.connectionUser) IAM role.
Using EXTERNAL_QUERY is the native, fully supported mechanism in Google Cloud for combining operational relational datasets with BigQuery analytical warehouses in real time. It avoids data staleness, requires no intermediate storage buckets, and executes seamlessly within standard SQL.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated