Google Cloud Professional Data Engineer — Question 108

Your United States-based company has created an application for assessing and responding to user actions. The primary table's data volume grows by 250,000 records per second. Many third parties use your application's APIs to build the functionality into their own frontend applications. Your application's APIs should comply with the following requirements:
✑ Single global endpoint
✑ ANSI SQL support
✑ Consistent access to the most up-to-date data
What should you do?

Answer options

• A. Implement BigQuery with no region selected for storage or processing.
• B. Implement Cloud Spanner with the leader in North America and read-only replicas in Asia and Europe.
• C. Implement Cloud SQL for PostgreSQL with the master in North America and read replicas in Asia and Europe.
• D. Implement Bigtable with the primary cluster in North America and secondary clusters in Asia and Europe.

Correct answer: B

Explanation

The correct answer is B because Cloud Spanner provides a single global endpoint, supports ANSI SQL, and ensures consistent access to the most current data through its distributed architecture. Option A does not meet the ANSI SQL requirement, while option C is not designed for global scaling and may not provide the same level of consistency. Option D, while scalable, does not support ANSI SQL and is not suited for transactional workloads.