Google Professional Cloud Database Engineer Exam Questions Instant Access

Question 1

Your company is developing a 24/7. global, real-lime analytics platform that needs to store and process large amounts of versioned time-series dat

a. You need to

design a platform that Is highly scalable to accommodate traffic spikes and ensure high availability for mission-critical operations. What should you do?

AImplement a single-cluster Bigtable Instance with autoscaling enabled and row key design

BImplement a multi-cluster Bigtable Instance with autoscaling enabled and optimal schema design.

CImplement a multi-cluster Billable instance across multiple regions with replication.

Dimplement AlloyDB for PostgreSQL to handle the analytical workload using read replica

Answer : C

Question 2

You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?

AUse Cloud SQL with read replicas for throughput.

BUse Firestore, and rely on automatic serverless scaling.

CUse Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.

DUse Bigtable, and add nodes as necessary to achieve the required throughput.

Answer : D

https://cloud.google.com/memorystore/docs/redis/redis-overview

Question 3

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

ACreate one regional Cloud SQL instance with a read replica in another region.

BCreate one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

CCreate two read-write Cloud SQL instances in two different zones with a standby instance in another region.

DCreate two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

Answer : B

This answer is correct because it meets the requirements of having an optimal and highly available environment with automatic failover.According to the Google Cloud documentation1, a regional Cloud SQL instance is an instance that has a primary server in one zone and a standby server in another zone within the same region. The primary and standby servers are kept in sync using synchronous replication, which ensures zero data loss and minimal downtime in case of a zonal outage or an instance failure.If the primary server becomes unavailable, Cloud SQL automatically fails over to the standby server, which becomes the new primary server1.

Question 4

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

AExport the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).

BEdit the instance to change the storage type from HDD to SSD.

CCreate a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.

DCreate a read replica of the instance with SSDs, and perform a failover to the new instance

Answer : A

https://stackoverflow.com/questions/72034607/can-i-change-storage-type-from-hdd-to-ssd-on-cloud-sql-after-creating-an-instanc

Question 5

You are deploying a Cloud SOL for MySQL database to serve a non-critical application. The database size is 10 GB and will be updated every night with data stored in a Cloud Storage bucket. The database serves read-only traffic from the application during the day. The data locally requirement of This application mandates that data must reside in a single region. You want to minimize the cost of running this database while maintaining an RTO of 1 day. What should you do?

ACreate a Cloud SQL for MySQL instance with high availability (HA) enabled. Configure automated backups of the Cloud SQL instance and use the default backup location.

BCreate a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in the same zone.

CCreate a Cloud SQL for MySQL instance with high availability (HA) disabled. Configure automated backups of the Cloud SQL instance and use a custom backup location to store backups in a Cloud Storage bucket in the same region.

DCreate a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in a second region.

Answer : C

Question 6

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SL

AYou want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

AManually scale down the number of nodes after the peak period has passed.

BUse interleaving to co-locate parent and child rows.

CUse the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

DUse granular instance sizing in Cloud Spanner and Autoscaler.

Answer : D

Granular instance is available in Public Preview. With this feature, you can run workloads on Spanner at as low as 1/10th the cost of regular instances, https://cloud.google.com/blog/products/databases/get-more-out-of-spanner-with-granular-instance-sizing

Question 7

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?

AIdentify and optimize slow running queries, or set parallel replication flags.

BStop all running queries, and re-create the replicas.

CEdit the primary instance to upgrade to a larger disk, and increase vCPU count.

DEdit the primary instance to add additional memory.

Answer : A

https://cloud.google.com/sql/docs/mysql/replication/replication-lag#optimize_queries_and_schema