PROFESSIONAL-CLOUD-DATABASE-ENGINEER Online Practice Questions and Answers

You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?

A. Use Cloud Spanner to deploy the database.

B. Use Bigtable with clusters in multiple regions to deploy the database

C. Use BigQuery to deploy the database

D. Use Cloud SQL with a regional read replica to deploy the database.

You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

A. Export the data from the existing database, and load the data into a new Cloud SQL database.

B. Use Migrate for Compute Engine to complete the migration.

C. Use Datastream to complete the migration.

D. Use Database Migration Service to complete the migration.

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.

You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?

A. Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.

B. Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences

C. Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

D. Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

A. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

B. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

C. Use Database Migration Service to migrate your database.

D. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?

A. Use Cloud SQL for data storage.

B. Use Cloud Spanner for data storage.

C. Use Memorystore for data storage.

D. Use Bigtable for data storage.

You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?

A. Use the default app profile with single-cluster routing.

B. Use the default app profile with multi-cluster routing.

C. Create a custom app profile with multi-cluster routing.

D. Create a custom app profile with single-cluster routing.

You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?

A. Increase the number of processing units.

B. Modify the database schema, and add additional indexes.

C. Shard data required by the application into multiple instances.

D. Decrease the number of processing units.

Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?

A. Recommend solid-state drives (SSD).

B. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.

C. Recommend hard disk drives (HDD).

D. Recommend mixed storage types.

You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO. What should you do?

A. Use Cloud SQL instance monitoring.

B. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.

C. Use Cloud SQL logs.

D. Use the SQL Server Always On Availability Group dashboard.