Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How can you grant your analytics team access to data from a high-traffic Cloud SQL for MySQL instance for monthly sales reporting without impacting performance?
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.