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: 16)

Page 16 of 34
PDF with 132 Questions

You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database.
What should you do?

  1. Create a clone database from a read replica database, and restore the clone in the same region.
  2. Create a clone database from a read replica database, and restore the clone into a different zone.
  3. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
  4. Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.

Answer(s): C

Explanation:

Using import/export from last week is slow for large scale databases and will restore database from last week.



Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit.
What should you do?

  1. Create the database with Google-managed encryption keys.
  2. Create the database with customer-managed encryption keys.
  3. Create the database persistent disk with Google-managed encryption keys.
  4. Create the database persistent disk with customer-managed encryption keys.

Answer(s): B

Explanation:

https://cloud.google.com/sql/docs/postgres/configure-cmek#createcmekinstance



Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times.
What should you do?

  1. Export the data from the existing instance, and import the data into a new instance with solid- state drives (SSDs).
  2. Edit the instance to change the storage type from HDD to SSD.
  3. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
  4. Create a read replica of the instance with SSDs, and perform a failover to the new instance

Answer(s): A

Explanation:

https://stackoverflow.com/questions/72034607/can-i-change-storage-type-from-hdd-to-ssd-on- cloud-sql-after-creating-an-instanc



You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions.
What should you do?

  1. Reuse the existing service account that populates this database.
  2. Create a new service account, and grant it the Cloud Spanner Database Admin role.
  3. Create a new service account, and grant it the Cloud Spanner Database Reader role.
  4. Create a new service account, and grant it the spanner.databases.select permission.

Answer(s): C

Explanation:

https://cloud.google.com/iam/docs/overview



Page 16 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