Google Cloud Professional Cloud Developer — Question 293

You are a developer at a company that operates an ecommerce website. The website stores the customer order data in a Cloud SQL for PostgreSQL database. Data scientists on the marketing team access this data to run their reports. Every time they run these reports, the website's performance is negatively affected. You want to provide access to up-to-date customer order datasets without affecting your website. What should you do?

Answer options

• A. Configure Cloud Scheduler to run an hourly Cloud Function that exports the data from the Cloud SQL database into CSV format and sends the data to a Cloud Storage bucket.
• B. Set up a Bigtable table for the data science team. Configure the application to perform dual writes to both Cloud SQL and Bigtable simultaneously.
• C. Set up a BigQuery dataset for the data science team. Configure Datastream to replicate the relevant Cloud SQL tables in BigQuery.
• D. Create a clone of the PostgreSQL database instance for the data science team. Schedule a job to create a new clone every 15 minutes.

Correct answer: C

Explanation

The correct answer is C because using BigQuery allows data scientists to run their analyses without affecting the performance of the ecommerce site, as BigQuery is optimized for such queries. Option A does not provide real-time data access, while B could lead to potential data consistency issues and would still impact performance. Option D would require significant resources and management overhead to maintain multiple clones.