Free Google Professional-Cloud-Database-Engineer Practice Test & Real Exam Questions

You are the DBA working at a large bank in Europe. Your business-critical banking application runs on Oracle 12.2 in your on-premises data center. You decided to modernize your on- premises Oracle database by migrating to AlloyDB. You must meet the following requirements:
- Remain on-premises and maintain open-source portability.
- Meet regulatory requirements for data residency.
- Support both OLTP and OLAP workloads.
- Maintain high availability (HA) mode and automatic failover.
What should you do-

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?

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?

Larkspur Systems is building a browser based workspace where teams coauthor very large documents in real time. Each document can reach 25 MB and the system must handle about
60,000 edits per minute from users spread across three regions and it must keep a complete version timeline for every file with strong consistency. Which managed database on Google Cloud best satisfies these requirements?

You are building the database layer for a multinational ticketing marketplace on Google Cloud.
Traffic is unpredictable and can spike by 8x during global presales and seasonal campaigns. The system must deliver strongly consistent transactions, sub second reads for users on three continents, and a 99.999% availability target while still keeping spend under control. Which Google Cloud database service and configuration should you choose to meet these goals?

Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users.
You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

You currently have a MySQL database running on Cloud SQL with a read replica in a different zone for non-mission critical analytics workloads. You want to enable high availability (HA) for the analytic workloads while keeping costs low. What should you do-

You are using Memorystore for Redis to cache frequently accessed data and improve your application's performance. Recently, your application is experiencing sudden spikes in latency when interacting with the Memorystore for Redis instance. Upon checking the logs, you discover a high number of "evicted keys" messages. You want to reduce the occurrences of latency spikes and their impact on the application. What should you do-

You are performing daily exports of native BAK files from Cloud SOL for SOL Server to Cloud Storage buckets by using gcloud sql export bakcommand at 6:00AM. You want to automate this routine using managed Google Cloud components so you can focus on other critical tasks of keeping your database healthy and performant. What should you do-

Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?

Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?

Your company has a critical application running on-premises on PostgreSQL. The application requires minimal migration downtime and the ability to withstand regional outages. You are considering a Cloud SQL Enterprise Plus edition instance on PostgreSQL. You need to ensure that the migration will meet your requirements with minimal effort.
What should you do?