support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Google
  4. PROFESSIONAL CLOUD DATABASE ENGINEER

Free PROFESSIONAL CLOUD DATABASE ENGINEER Exam Braindumps
Professional Cloud Database Engineer Questions 41–45 (page: 10)

Updated On: 10-Feb-2026
Page 10 of 28
PDF with 197 Questions

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance.
What should you do?

  1. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
  2. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
  3. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
  4. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SS

Answer(s): C

Explanation:

Given that Google SSD performance is related to the size of the disk in an order of 30 IOPS for each GB, ti would require at least 833 GB to handle 25000 IOPS, the only answer that exceeds this value is
C. https://cloud.google.com/compute/docs/disks/performance



You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance.
What should you do?

  1. Take no backups, and turn off transaction log retention.
  2. Take one manual backup per day, and turn off transaction log retention.
  3. Turn on automated backup, and turn off transaction log retention.
  4. Turn on automated backup, and turn on transaction log retention.

Answer(s): C

Explanation:

https://cloud.google.com/sql/docs/mysql/backup-recovery/backups



You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future.
What should you do?

  1. Set your production instance's maintenance window to non-business hours.
  2. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
  3. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
  4. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.

Answer(s): A



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?

  1. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
  2. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us- west1.
  3. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
  4. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us- east1 and us-west1.

Answer(s): A

Explanation:

https://cloud.google.com/sql/docs/mysql/quotas#table_limit



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



  PDF
Viewing page 10 of 28
Viewing questions 46 - 50 out of 197 questions


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

AI Tutor AI Tutor 👋 I’m here to help!