Question 1

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?

Accepted Answer

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

Question 2

Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud
SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?

Accepted Answer

Correct answer: D

Question 3

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real
Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides
the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

Accepted Answer

BMS is the only Google database service which supports Oracle aside from GCVE. It allows you to use all native Oracle features including RAC. Since GCVE isn't
mentioned, it has to be D - Bare Metal Solution.

Question 4

You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to
migrate this database. What should you do? (Choose two.)

Accepted Answer

https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer

Question 5

You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud.
You want to
launch the game in multiple regions. What should you do?

Accepted Answer

Cloud Spanner is a fully managed, mission-critical, relational database service that offers transactional consistency at global scale, automatic, synchronous
replication for high availability, and support for two SQL dialects: Google Standard SQL (ANSI 2011 with extensions) and PostgreSQL.

Question 6

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?

100% Valid and Newest Version Professional-Cloud-Database-Engineer Questions & Answers shared by Certleader
/Professional-Cloud-Database-Engineer-dumps.html (132 Q&As)

Accepted Answer

https://www.cloudskillsboost.google/focuses/22792?parent=catalog

Question 7

You plan to use Database Migration Service to migrate data from a PostgreSQL on- premises instance to Cloud SQL. You need to identify the prerequisites for
creating and automating the task. What should you do? (Choose two.)

Accepted Answer

https://cloud.google.com/database-migration/docs/postgres/faq

Question 8

You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of data. You are planning a
gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each
regional rollout and can scale up or down on nights and holidays. What should you do?

Accepted Answer

https://cloud.google.com/spanner/docs/autoscaling-overview
* 1. CloudSQL max out at 64TB, so unable to told 100TB of data. https://cloud.google.com/sql/docs/quotas#metrics_collection_limit 2. Scale is done manually on
SQL Cloud

Question 9

You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is
slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7
during the holidays. What should you do?

Accepted Answer

"Deny maintenance period. A block of days in which Cloud SQL does not schedule maintenance. Deny maintenance periods can be up to 90 days long. "
https://cloud.google.com/sql/docs/mysql/maintenance

Question 10

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery
time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You
need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

Accepted Answer

This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary
instance are replicated to disks in both zones before a transaction is reported as committed1. This minimizes data loss and downtime in case of a zonal or an
instance failure, and allows for a quick failover to the standby instance1.

100% Valid and Newest Version Professional-Cloud-Database-Engineer Questions & Answers shared by Certleader
/Professional-Cloud-Database-Engineer-dumps.html (132 Q&As)
This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the
data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2. This provides additional redundancy and
backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.