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.
An e-commerce enterprise generates several terabytes of transactional sales data daily. The data analytics team needs to execute complex SQL queries and aggregate calculations across specific data columns to generate daily business intelligence reports.
The workload has the following requirements:
Which storage and analytics architecture should you recommend?
Cloud Bigtable is a sparsely populated, massively scalable NoSQL database engineered for high-throughput, sub-millisecond read/write operations on single-keyed records. It is optimized for operational time-series data, Internet of Things (IoT) streams, and real-time lookup engines.
The workload required a real-time key-value database capable of ingesting millions of writes per second with single-digit millisecond lookup latency for individual customer IDs.
Cloud SQL is a fully managed relational database service for MySQL, PostgreSQL, and SQL Server designed for online transaction processing (OLTP). Filestore is a managed Network Attached Storage (NAS) service providing POSIX-compliant file shares for compute instances.
The core workload was a low-latency transactional application requiring ACID compliance with strict relational constraints and frequent single-row updates.
BigQuery External Tables allow users to query structured or semi-structured data directly from Cloud Storage without loading the data into native BigQuery-managed storage. Cloud Storage Nearline provides low-cost object storage for data accessed less than once a month.
The requirement was to inspect raw external data lakes occasionally without ingesting data into a managed data warehouse environment.
BigQuery is an enterprise, serverless cloud data warehouse built for large-scale analytics, utilizing a proprietary columnar storage format (Capacitor) and a distributed query execution engine (Dremel). Cloud Storage provides scalable, highly durable object storage with distinct storage classes—such as Coldline and Archive—governed by automated Object Lifecycle Management policies.

This architecture directly addresses high-throughput columnar analytics while fully utilizing native Google Cloud billing models and storage lifecycle rules, eliminating manual maintenance scripts and compute provisioning.
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