CertsTopics Logo

Weekend Sale Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Cloud Database Engineer Professional-Cloud-Database-Engineer Passing Score

Page: 2 / 10
Total 132 questions
Get Professional-Cloud-Database-Engineer Full Access Download Professional-Cloud-Database-Engineer PDF

Google Cloud Certified - Professional Cloud Database Engineer Questions and Answers

Question 5

Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?

Options:

A.

Enable serializable isolation in the Firebase app.

B.

Deploy a US multi-region Firestore location.

C.

Build a Firestore bundle, and deploy bundles to Cloud CDN.

D.

Create a Firestore index on the news story date.

Question 6

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.

Question 7

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?

Options:

A.

Use Cloud SQL serverless exports.

B.

Create a read replica, and then use the mysqldump utility to export each table.

C.

Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.

D.

Use the mysqldump utility on the primary database instance to export the backup.

Question 8

You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached data. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?

Options:

A.

Use Firestore and ensure that the PersistenceEnabled option is set to true.

B.

Use Memorystore for Memcached.

C.

Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.

D.

Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.

Page: 2 / 10
Total 132 questions
Get Professional-Cloud-Database-Engineer Full Access Download Professional-Cloud-Database-Engineer PDF