Medium1 markMultiple Choice
Domain 1: Designing and Planning a Cloud Solution ArchitectureDomain 1BigtableBigQueryDatabase Selection

GCP PCA · Question 38 · Domain 1: Designing and Planning a Cloud Solution Architecture

You are designing the data architecture for a new application. You need to choose between Cloud Bigtable and BigQuery. Which TWO statements correctly describe the use cases for these services? (Select TWO)

Answer options:

A.

Bigtable is optimized for high-throughput, low-latency reads and writes of key-value data.

B.

Bigtable supports complex SQL queries and table joins.

C.

BigQuery is the best choice for a real-time user profile database serving a mobile app.

D.

BigQuery is an enterprise data warehouse optimized for analytical (OLAP) queries over petabytes of data.

E.

Both Bigtable and BigQuery require you to provision and manage the underlying compute instances.

How to approach this question

Contrast OLTP/NoSQL (Bigtable) with OLAP/Data Warehouse (BigQuery).

Full Answer

A,D
Cloud Bigtable is a NoSQL database designed for operational workloads requiring high throughput and low latency (e.g., time-series data, IoT). BigQuery is a serverless data warehouse designed for analytical workloads, allowing you to run complex SQL queries across petabytes of data. They serve entirely different architectural purposes.

Common mistakes

Thinking BigQuery can be used as a backend database for a web app (C). BigQuery's latency is measured in seconds, not milliseconds.

Practice the full GCP Professional Cloud Architect Practice Exam 3

50 questions · hints · full answers · grading

More questions from this exam