Practice Test 4 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test

You need to design a data architecture to bring together all your data at any scale and provide insights into all your users.

You need to complete the below architecture.

Which of the following can be used in place of number 3 i.e. Storage (Data Warehouse)?

A. Cloud Pub/Sub
B. Cloud SQL
C. Big Query
D. Cloud Spanner

Correct Answer: C

Option C is CORRECT because Big Query is recommended as a SQL-complaint analytics data warehouse.

This is a serverless, highly scalable, and cost-effective multi-cloud SQL-complaint data warehouse.

Option A is incorrect because Cloud Pub/Sub is recommended for Streaming data ingestion.
Option B is incorrect because Cloud SQL is a fully-managed database service but not a data warehouse service.

You can use Cloud SQL with MySQL, PostgreSQL, or SQL Server

Option D is incorrect because Cloud Spanner is a distributed SQL database management and storage service.

For more information on the Big Query, please visit the below URL: