Question 1

Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?

Options :

A : Use replication to roll out changes to higher environments.

B : Use backup and restore to roll out changes to higher environments.

C : Use Liquibase to roll out changes to higher environments.

D : Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

Answer: C

Question 2

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

Options :

A : Use Bigtable.

B : Use Firestore.

C : Use Cloud SQL for MySQL

D : Use Cloud Spanner.

Answer: D

Question 3

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA. You want to follow Googlerecommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

Options :

A : Manually scale down the number of nodes after the peak period has passed.

B : Use interleaving to co-locate parent and child rows.

C : Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

D : Use granular instance sizing in Cloud Spanner and Autoscaler.

Answer: D

Question 4

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?

Options :

A : Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in useast1 and us-west1.

B : Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and uswest1.

C : Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in uscentral1, us-east1, and us-west1.

D : Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, useast1 and us-west1.

Answer: A

Question 5

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.)

Options :

A : Use an external read replica 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 replication from an external server to migrate the databases to Cloud SQL.

Answer: C,E

Free Professional-Cloud-Database-Engineer Mock Exam – Practice Online Confidently

Buying Options: