Home / Google / Professional Cloud Database Engineer

Google Professional Cloud Database Engineer Practice Test - Questions Answers, Page 9

Question list

List of questions

Question 81

(0)

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica

Question 82

(0)

You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues w

Question 83

(0)

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the

Question 84

(0)

Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receiv

Question 85

(0)

Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database t

Question 86

(0)

You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What shoul

Question 87

(0)

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 decrea

Question 88

(0)

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.

Question 89

(0)

You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report bu

Question 90

(0)

Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ens

Question 81

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?

Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.

Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.

Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.

Configure the primary, standby, and read replica instances in zone A, all in the same region.

Show Answer Comment (0)

Question 82

You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?

Create a clone database from a read replica database, and restore the clone in the same region.

Create a clone database from a read replica database, and restore the clone into a different zone.

Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.

Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.

Show Answer Comment (0)

Question 83

Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.

Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.

Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.

Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.

Show Answer Comment (0)

Question 84

Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?

Isolate the data analysts and operations user groups to use different Bigtable instances.

Check the Cloud Monitoring table/bytes_used metric from Bigtable.

Use Key Visualizer for Bigtable.

Add more nodes to the Bigtable cluster.

Show Answer Comment (0)

Question 85

Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?

Use Firestore.

Use Cloud Spanner.

Use Cloud SQL.

Use Bigtable.

Show Answer Comment (0)

Question 86

You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)

Identify whether the database has over 512 tables.

Identify all tables that do not have a primary key.

Identity all tables that do not have at least one foreign key.

Identify whether the source database is encrypted using pgcrypto extension.

Identify whether the source database uses customer-managed encryption keys (CMEK).

Show Answer Comment (0)

Question 87

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?

Enable serializable isolation in the Firebase app.

Deploy a US multi-region Firestore location.

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

Create a Firestore index on the news story date.

Show Answer Comment (0)

Question 88

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.

What should you do?

Use gcloud sql instances failover <PrimaryInstanceName>.

Use gcloud sql instances failover <ReplicaInstanceName>.

Use gcloud sql instances promote-replica <PrimaryInstanceName>.

Use gcloud sql instances promote-replica <ReplicaInstanceName>.

Show Answer Comment (0)