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

You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

Options :

A : Export the data from the existing database, and load the data into a new Cloud SQL database.

B : Use Migrate for Compute Engine to complete the migration.

C : Use Datastream to complete the migration.

D : Use Database Migration Service to complete the migration.

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 developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

Options :

A : Use Firestore.

B : Use Cloud Spanner.

C : Use Cloud SQL.

D : Use Bigtable.

Answer: B

Confidently Practice Online with Free Professional-Cloud-Database-Engineer Exam Cram

Buying Options: