CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Google
  5. PROFESSIONAL-CLOUD-DATABASE-ENGINEER

Free PROFESSIONAL-CLOUD-DATABASE-ENGINEER Exam Braindumps (page: 12)

Page 12 of 34
PDF with 132 Questions

You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices.
What should you do?

  1. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
  2. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
  3. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
  4. Use Cloud Composer to execute a select * from table(s) query and export results.

Answer(s): B

Explanation:

https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using- cloud-functions-and-cloud-scheduler



You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history.
What should you do?

  1. Use Cloud SQL with read replicas for throughput.
  2. Use Firestore, and rely on automatic serverless scaling.
  3. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
  4. Use Bigtable, and add nodes as necessary to achieve the required throughput.

Answer(s): D

Explanation:

https://cloud.google.com/memorystore/docs/redis/redis-overview



You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key.
What should you do?

  1. Use Cloud Spanner with a customer-managed encryption key (CMEK).
  2. Use Cloud Spanner with default encryption.
  3. Use Cloud SQL with a customer-managed encryption key (CMEK).
  4. Use Bigtable with default encryption.

Answer(s): A

Explanation:

Yes default encryption comes with AES-256 but the question states that you need to control where you store the encryption keys. that can be achieved by CMEK.



You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working.
What should you do?

  1. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
  2. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
  3. Verify that the new replica is created automatically.
  4. Start the original primary instance and resume replication.

Answer(s): C

Explanation:

Recovery Process: Once Zone-B becomes available again, Cloud SQL will initiate the recovery process for the impacted read replica. The recovery process involves the following steps: 1. Synchronization:
Cloud SQL will compare the data in the recovered read replica with the primary instance in Zone-A. If there is any data divergence due to the unavailability period, Cloud SQL will synchronize the read replica with the primary instance to ensure data consistency. 2. Catch-up Replication: The recovered read replica will start catching up on the changes that occurred on the primary instance during its unavailability. It will apply the necessary updates from the primary instance's binary logs (binlogs) to bring the replica up to date. 3. Resuming Read Traffic: Once the synchronization and catch-up replication processes are complete, the read replica in Zone-B will resume its normal operation. It will be able to serve read traffic and stay updated with subsequent changes from the primary instance.



Page 12 of 34



Post your Comments and Discuss Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam with other Community members:

muksgreen commented on March 01, 2024
brainstorming excellent
JAPAN
upvote