Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Professional Cloud Architect practice bank has 2,335 more like it. Try 10 free: instant score, no account.
A retail company ingests terabytes of raw transactional and customer activity data daily into Cloud Storage. Business analysts need an intuitive, code-free way to visually explore, clean, and profile ad-hoc datasets before reporting. Concurrently, the data engineering team needs to run automated, large-scale transformations across petabytes of historical data with minimal operational overhead and infrastructure management.
Which architecture should you recommend to meet these requirements?
This architecture builds a self-managed Apache Spark environment hosted on Compute Engine virtual machines to run custom batch jobs that parse, clean, and transform raw files before loading curated datasets into a Cloud SQL relational database.
The workload consisted of small transactional datasets requiring strict ACID guarantees and specific legacy Spark configurations on custom VM images.
This design constructs a rigid ETL streaming architecture using Dataflow pipelines written in Java to process incoming data, apply business transformations via User-Defined Functions (UDFs), and persist the resulting records into Cloud Bigtable.
The primary goal was real-time, low-latency streaming ingestion supporting millions of single-key lookups per second rather than analytical reporting and exploration.
An Extract, Load, Transform (ELT) architecture leverages the massive parallel processing power of BigQuery by loading raw data directly into the data warehouse and executing transformations using standard SQL. Combined with Cloud Dataprep, it provides an intelligent, visual data preparation interface for analysts that requires zero infrastructure management.

This solution cleanly aligns workload types to native Google Cloud services: visual, interactive profiling in Cloud Dataprep and ultra-fast, serverless analytical transformations in BigQuery, achieving maximum operational efficiency.
This approach uses database import and export mechanisms to load raw dumps into a Cloud SQL database, relying on relational database stored procedures to clean, aggregate, and transform data inside the database engine.
The goal was to clone or migrate a traditional MySQL or PostgreSQL database for OLTP reporting under moderate data volumes.
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