Google Cloud Professional Cloud Database Engineer — Question 95

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

Answer options

• A. Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
• B. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
• C. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
• D. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.

Correct answer: B

Explanation

The correct answer is B because setting up a read replica with the cloudsql.iam_authentication flag allows secure access for the analytics team while keeping the primary instance's performance intact. Option A lacks IAM authentication, while C and D provide direct access to the primary instance, which could negatively impact performance.