Google Professional Cloud Database Engineer Exam Practice Questions (P. 1)
- Full Access (132 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #1
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?
- ADefine a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
- BDefine a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
- CDefine a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.Most Voted
- DDefine a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
Correct Answer:
C
C

Correct choice C effectively combines security and connectivity. Using the Cloud SQL Auth proxy with a service account ensures secure connections over a private IP, pushing traffic within corporate confines, avoiding public internet exposure. This setup doesn’t call for SSL and doesn’t need database configuration tweaks, adhering closely to the needs for secure, internal-only network communication as inherent in the question's scenario. Remember, direct application-to-database connections might seem straightforward but introducing an intermediary like the Cloud SQL Auth Proxy greatly boosts security and management capabilities without sacrificing convenience or performance.
send
light_mode
delete
Question #2
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.)
- ASet up manual backups.
- BCreate a PostgreSQL database on-premises as the HA option.
- CConfigure single zone availability for automated backups.
- DEnable point-in-time recovery.Most Voted
- ESchedule automated backups.Most Voted
Correct Answer:
BD
BD

In preparing your Cloud SQL for high availability, enabling point-in-time recovery (Option D) is crucial as it allows database restoration to any specific point, safeguarding against data loss or corruption. Additionally, scheduling automated backups (Option E) ensures consistent data safety without requiring manual intervention, which is essential for maintaining 24/7 global access. Notably, Option B, creating a PostgreSQL database on-premises, does not align with the cloud-centric approach of enhancing database availability and is not typically recommended in cloud-native environments.
send
light_mode
delete
Question #3
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?
- AMigrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).Most Voted
- BMigrate applications and Oracle databases to Compute Engine.
- CMigrate applications to Cloud SQL.
- DMigrate applications and Oracle databases to Google Kubernetes Engine (GKE).
Correct Answer:
A
A

Opting for Google Cloud VMware Engine (GCVE) is indeed the most streamlined choice for migrating your Oracle applications with minimal disruption. This approach leverages the existing VMware-based infrastructure, allowing for a "lift and shift" of your current setup into the cloud without necessitating significant changes to the architecture or operations. This method avoids the licensing and compatibility issues that might arise with other options, ensuring a smoother and less disruptive migration process. Thus, maintaining operational continuity and efficiency during the transition.
send
light_mode
delete
Question #4
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?
- AUse query parameters to speed up frequently executed queries.
- BChange the Cloud Spanner configuration from multi-region to single region.
- CUse SQL statements to analyze SPANNER_SYS.READ_STATS* tables.Most Voted
- DUse SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
Correct Answer:
B
B

When experiencing high read latency in Cloud Spanner, a practical first step is to analyze the SPANNER_SYS.READ_STATS* tables. These introspection tables offer detailed metrics on read operations, including latency figures, which can help pinpoint the root causes of performance drops. This approach allows data-driven decisions on optimizations without prematurely altering your database configuration, potentially escalating costs or affecting availability in unforeseen ways. Reviewing these statistics should always precede major architectural changes to ensure that any response is appropriately calibrated to the actual issue.
send
light_mode
delete
Question #5
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?
- AUse Database Migration Service to migrate all databases to Cloud SQL.Most Voted
- BUse Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
- CUse data replication tools and CDC tools to enable migration.
- DUse a combination of Database Migration Service and partner tools to support the data migration strategy.
Correct Answer:
B
B

Utilizing the Database Migration Service (DMS) for a one-time migration and integrating third-party tools for CDC style migrations align perfectly with Google’s best practices for database migration. This approach allows a balance between automated migrations with DMS and continuous synchronization with CDC, thus providing efficient monitoring and reducing downtime during migration from various environments like AWS to Cloud SQL. Such a strategy ensures that migrations are not only effectively managed but also cater to specific operational needs during the migration process.
send
light_mode
delete
All Pages