Google Cloud Professional Data Engineer — Question 311

Your company wants to be able to retrieve large result sets of medical information from your current system, which has over 10 TBs in the database, and store the data in new tables for further query. The database must have a low-maintenance architecture and be accessible via SQL. You need to implement a cost-effective solution that can support data analytics for large result sets. What should you do?

Answer options

• A. Use Cloud SQL, but first organize the data into tables. Use JOIN in queries to retrieve data.
• B. Use BigQuery as a data warehouse. Set output destinations for caching large queries.
• C. Use a MySQL cluster installed on a Compute Engine managed instance group for scalability.
• D. Use Cloud Spanner to replicate the data across regions. Normalize the data in a series of tables.

Correct answer: B

Explanation

The correct choice is B, as BigQuery is specifically designed for handling large datasets and offers a cost-effective solution for data analytics. Options A and C require more maintenance and are not optimized for large-scale data analysis, while option D, while powerful, may be more complex and costly than necessary for the task at hand.