Question 67 of 139
Single answerYour 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?
ACreate 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.
✓BCreate 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.
CEnable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
DProvide 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
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.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.