Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?

• A.roles/spanner.databaseAdmin for Person A
  roles/spanner.databaseUser for Person B
  roles/spanner.backupWriter for Application C
• B.roles/spanner.databaseAdmin for Person A
  roles/spanner.databaseReader for Person B
  roles/spanner.backupAdmin for Application C
• C.roles/spanner.databaseAdmin for Person A
  roles/spanner.databaseUser for Person B
  roles/spanner databaseReader for Application C
• D.roles/spanner.databaseAdmin for Person A
  roles/spanner.databaseReader for Person B
  roles/spanner.backupWriter for Application C

Comment: *

Name: *

Email: *

Verification: *

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

• A.Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
• B.Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
• C.Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
• D.Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.

Comment: *

Name: *

Email: *

Verification: *

Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?

• A.Use the mysqldump utility on the primary database instance to export the backup.
• B.Use Cloud SQL serverless exports.
• C.Create a read replica, and then use the mysqldump utility to export each table.
• D.Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.

Comment: *

Name: *

Email: *

Verification: *

Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?

• A.Migrate to Compute Engine.
• B.Migrate to Cloud SQL for PostgreSQL.
• C.Migrate to Google Kubernetes Engine (GKE).
• D.Migrate to Cloud SQL for SQL Server.

Comment: *

Name: *

Email: *

Verification: *

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

• A.Place the bulk of the read and write workloads closer to the default leader region.
• B.Use staleness of at least 15 seconds.
• C.Add more read-write replicas.
• D.Keep the total CPU utilization under 45% in each region.

Comment: *

Name: *

Email: *

Verification: *