Google Professional Cloud Database Engineer Exam Practice Test Instant Access

Question 1

Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?

AEnable serializable isolation in the Firebase app.

BDeploy a US multi-region Firestore location.

CBuild a Firestore bundle, and deploy bundles to Cloud CDN.

DCreate a Firestore index on the news story date.

Answer : C

A global audience strongly suggests serving content via Google's Content Delivery Network. Changing the isolation level won't decrease cost or latency

Question 2

Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do?

AUse Firestore with Looker.

BUse Cloud Spanner with Data Studio.

CUse MongoD8 Atlas with Charts.

DUse Bigtable with Looker.

Answer : C

This scenario has BigTable written all over it - large amounts of data from many devices to be analysed in realtime. I would even argue it could qualify as a multicloud solution, given the links to HBASE. BUT it does not support SQL queries and is not therefore compatible (on its own) with Looker. Firestore + Looker has the same problem. Spanner + Data Studio is at least a compatible pairing, but I agree with others that it doesn't fit this use-case - not least because it's Google-native. By contrast, MongoDB Atlas is a managed solution (just not by Google) which is compatible with the proposed reporting tool (Mongo's own Charts), it's specifically designed for this type of solution and of course it can run on any cloud.

Question 3

You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?

ASet your production instance's maintenance window to non-business hours.

BMigrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.

CContact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.

DUse Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.

Answer : A

Question 4

You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?

ACreate and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.

BCreate two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.

CCreate a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.

DCreate a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.

Answer : C

https://cloud.google.com/sql/docs/mysql/import-export#serverless

Question 5

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 6

During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?

ACreate a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

BCreate a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

CUse the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

DShut down your existing Cloud SQL for MySQL instance, and enable HA.

Answer : C

Creating a new instance and migrating data can be time-consuming and disruptive to your application's availability. Shutting down the existing instance is not a recommended approach, as it will cause downtime for your application.

The recommended approach is to use the gcloud instances patch command to enable high availability on your existing Cloud SQL for MySQL instance. This command updates the instance's configuration to enable the failover replica, configure it, and enable automatic failover.

By following this approach, you can ensure minimal downtime, and your application can continue to operate during the process.

Question 7

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