Here you have the best Google Professional Cloud Database Engineer practice exam questions
You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?
To connect to a Cloud SQL for PostgreSQL instance without requiring configuration changes to the database, you should use a database username and password to point to the internal (private) IP address of your Cloud SQL instance. This approach ensures that traffic remains within the corporate network, enhancing security by avoiding the public internet. SSL being disabled doesn't affect this method as no additional configuration changes are necessary.
Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)
To prepare your Cloud SQL instance for high availability, Google recommends enabling point-in-time recovery and scheduling automated backups. Point-in-time recovery allows you to restore your database to a specific point in time, helping you to recover from data loss or corruption. Scheduling automated backups ensures that you have a recent copy of your database available for recovery in case of an outage or other issue. Automated processes reduce the risk of human error and ensure regular, reliable backups, which are essential for maintaining high availability.
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
Migrating applications and Oracle databases to Google Cloud VMware Engine (VMware Engine) is the best approach for minimizing disruption while preserving the current architecture. This solution allows you to lift and shift your existing VMware-based Oracle environment directly to Google Cloud with minimal changes, maintaining the same structure and operational processes. This ensures continuity and makes the migration process simpler and less disruptive compared to other options, which would require significant architectural changes or are not fully supported for Oracle databases.
Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?
To address the issue of high read latency, it is crucial to gather data about read operations. Analyzing the SPANNER_SYS.READ_STATS* tables provides statistics on read operations, including the number of reads, read latency, and any read errors. This information is vital for understanding the root cause of the high read latency and taking appropriate corrective actions. Changing the configuration to single region or using query parameters may not directly address the issue of read latency and may have other unintended consequences.
Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?
For migrating PostgreSQL databases to Cloud SQL while following Google-recommended practices and using Google native data migration tools, the best approach is to use the Database Migration Service. This service is designed for both one-time migrations and change data capture (CDC) style migrations, making it suitable for reducing costs and downtime while allowing close monitoring of the migration process.