📘 Free PROFESSIONAL-CLOUD-DATABASE-ENGINEER Sample Questions
You deployed an application into a large Standard Google Kubernetes Engine (GKE) cluster. The application is
stateless and multiple pods run at the same time. Your application receives inconsistent traffic. You need to ensure
that the user experience remains consistent regardless of changes in traffic and that the resource usage of the
cluster is optimized.
A
Configure a cron job to scale the deployment on a schedule
B
Configure a Horizontal Pod Autoscaler.
C
Configure a Vertical Pod Autoscaler
D
Configure cluster autoscaling on the node pool.
Correct Answer:
B. Configure a Horizontal Pod Autoscaler.
Explanation:
Configure a Horizontal Pod Autoscaler (HPA). HPA automatically adjusts the number of replica pods based on
observed CPU utilization or other custom metrics. In the context of varying traffic patterns, HPA dynamically scales
the number of pods to meet demand, ensuring that there are enough instances to handle increased traffic and
scaling down during periods of lower demand. This helps maintain consistent performance while optimizing resource
utilization in response to changing workloads.
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?
A
Define a connection string using your Google username and password to point to the external (public) IP
address of your Cloud SQL instance.
B
Define a connection string using a database username and password to point to the internal (private) IP
address of your Cloud SQL instance.
C
Define 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.
D
Define 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. Define 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.
Explanation:
C is correct answer. First of all SSL is disabled and it is not secure to get it exposed to Internet.
https://cloud.google.com/sql/docs/postgres/connect-overview#authentication_options
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.)
A
Set up manual backups.
B
Create a PostgreSQL database on-premises as the HA option.
C
Configure single zone availability for automated backups.
D
Enable point-in-time recovery.
E
Schedule automated backups.
Correct Answer:
D. Enable point-in-time recovery.
Explanation:
1. Only valid options.
2. Vote for DE, seems only reasonable options to me
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?
A
Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
B
Migrate applications and Oracle databases to Compute Engine.
C
Migrate applications to Cloud SQL.
D
Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
Correct Answer:
A. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
Explanation:
A GCVE VMware environment runs natively on Google Cloud bare metal infrastructure in some Google Cloud
locations, and the GCVE service includes all the features required to help consume the VMware platforms
efficiently and securely.
https://cloud.google.com/blog/products/databases/migrate-databases-to-google-cloud-vmware-engine-gcve
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?
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?
A
Use query parameters to speed up frequently executed queries.
B
Change the Cloud Spanner configuration from multi-region to single region.
C
Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
D
Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
Correct Answer:
C. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
Explanation:
C. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables
C. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.To troubleshoot high read latency,
you can use SQL statements to analyze the SPANNER_SYS.READ_STATS* tables. These tables contain
statistics about read operations in Cloud Spanner, including the number of reads, read latency, and the
number of read errors. By analyzing these tables, you can identify the cause of the high read latency and take
appropriate action to resolve the issue. Other options, such as using query parameters to speed up frequently
executed queries or changing the Cloud Spanner configuration from multi-region to single region, may not be
directly related to the issue of high read latency. Similarly, analyzing the SPANNER_SYS.QUERY_STATS*
tables, which contain statistics about query operations, may not be relevant to the issue of high read latency.
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest
version. You need to connect the Bare Metal Solution environment to the internet so you can receive software
updates. What should you do?
A
Setup a static external IP address in your VPC network.
B
Set up bring your own IP (BYOIP) in your VPC.
C
Set up a Cloud NAT gateway on the Compute Engine VM.
D
Set up Cloud NAT service.
Correct Answer:
C. Set up a Cloud NAT gateway on the Compute Engine VM.
Explanation:
Some of the options for accessing the internet include:Routing outgoing traffic through a NAT
gateway.Routing traffic through a Compute Engine VM that serves as a proxy server.Routing traffic through
Cloud VPN or Dedicated Interconnect to on-premises gateways to the
internet..https://cloud.google.com/bare-metal/docs/bms-setup#bms-access-internet-vm-nat
Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database
performance. You need to identify the root cause of the performance degradation. What should you do?
A
Use Logs Explorer to analyze log data.
B
Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
C
Use Error Reporting to count, analyze, and aggregate the data.
D
Use Cloud Debugger to inspect the state of an application.
Correct Answer:
B. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
Explanation:
If your instance stops responding to connections or performance is degraded, make sure it conforms to the
Operational Guidelines https://cloud.google.com/sql/docs/mysql/diagnose-
issues#:~:text=If%20your%20instance%20stops%20responding%20to%20connections%20or%20performance%2
2C%20make%20sure%20it%20conforms%20to%20the%20Operational%20GuidelinesAnd then checking
resource constraints:Storage fullCPU overloadedToo many database
tableshttps://cloud.google.com/sql/docs/mysql/operational-guidelines#resource_
constraintsCloud Monitoring seems like the only way to check 2/3 of those, so for me answer is B
You work for a large retail and ecommerce company that is starting to extend their business globally. Your
company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions
with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales
transactions and current inventory levels. You want to retain the same relational schema that your existing
platform uses. What should you do?
A
Store your data in Firestore in a multi-region location, and place your compute resources in one of the
constituent regions.
B
Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default
leader region.
C
Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your
application resides.
D
Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
Correct Answer:
B. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default
leader region.
Explanation:
Spanner seems to be the only option, since it's the only relational DB. Plus "scale easily", which is another
clear indication of Spanner.
You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for
transactional data. Most of your users are located in the same time zone and expect the application to be available
7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance
without creating downtime for your users. What should you do?
A
Configure a maintenance window during a period when no users will be on the system. Control the order of
update by setting non-production instances to earlier and production instances to later.
B
Create your database with one primary node and one read replica in the region.
C
Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after
notifications have been sent.
D
Configure your Cloud SQL instance with high availability enabled.
Correct Answer:
A. Configure a maintenance window during a period when no users will be on the system. Control the order of
update by setting non-production instances to earlier and production instances to later.
Explanation:
Since we don't really need HA and we have a window that users are not need our app - A is fine, and D looks
like an overkill
Your team recently released a new version of a highly consumed application to accommodate additional user
traffic. Shortly after the release, you received an alert from your production monitoring team that there is
consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for
MySQL instances. You need to resolve the replication lag. What should you do?
A
Identify and optimize slow running queries, or set parallel replication flags.
B
Stop all running queries, and re-create the replicas.
C
Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
D
Edit the primary instance to add additional memory.
Correct Answer:
A. Identify and optimize slow running queries, or set parallel replication flags.
Explanation:
A. Optimize query for resolve replication lag. Docs:
https://cloud.google.com/sql/docs/mysql/replication/replication-lag#optimize_queries_and_schema
A. But in reality, none. You need to analyze the root cause. Network connection latency or bandwidth might be
relevant too.
Questions: 1-10 out of 132
Continue Full Practice..
GET ALL 132 QUESTIONS