Topic 1 Question 71
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?
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.
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.
Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
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.
ユーザの投票
コメント(8)
- 正解だと思う選択肢: A
B will still need grant database privileges to the IAM user where A we can assume they use built-in database authentication and database privileges are already granted
👍 3JayGeotab2023/01/28 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.
👍 1pk3492022/12/24You can enable IAM database authentication on an instance using the cloudsql.iam_authentication flag. Once you enable this flag, the instance enables logins from accounts that are configured for IAM database authentication. Cloud SQL IAM database authentication for different instance scenarios Read replicas IAM database authentication is not enabled in a read replica automatically, even when it is enabled on the primary instance. After you create a read replica, you need to add IAM database authentication. For more information, see Configuring read replica logins for IAM database authentication.
👍 1pk3492022/12/24
シャッフルモード