Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)

• A.Use bit-reverse sequential value as the primary key.
• B.Use an auto-incrementing value as the primary key.
• C.Promote high-cardinality attributes in multi-attribute primary keys.
• D.Normalize the data model.
• E.Promote low-cardinality attributes in multi-attribute primary keys.

Comment: *

Name: *

Email: *

Verification: *

You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)

• A.Identify whether the database has over 512 tables.
• B.Identify whether the source database is encrypted using pgcrypto extension.
• C.Identify all tables that do not have a primary key.
• D.Identify whether the source database uses customer-managed encryption keys (CMEK).
• E.Identity all tables that do not have at least one foreign key.

Comment: *

Name: *

Email: *

Verification: *

You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

• A.Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
• B.Use the default configuration for the automated backups location.
• C.Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
• D.Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

Comment: *

Name: *

Email: *

Verification: *

Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google- recommended practices to optimize platform costs. What should you do?

• A.Use Query Insights to identify idle instances.
• B.Remove inactive user accounts.
• C.Run the Recommender API to identify overprovisioned instances.
• D.Build indexes on heavily accessed tables.

Comment: *

Name: *

Email: *

Verification: *

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)

• A.Use replication from an external server to migrate the databases to Cloud SQL.
• B.Use a read replica to migrate the databases to Cloud SQL.
• C.Use Database Migration Service to migrate the databases to Cloud SQL.
• D.Use a cross-region read replica to migrate the databases to Cloud SQL.
• E.Use an external read replica to migrate the databases to Cloud SQL.

Comment: *

Name: *

Email: *

Verification: *