Question 1

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. Theapplication 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?

Options :

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

B : Check the Cloud Monitoring table/bytes_used metric from Bigtable.

C : Use Key Visualizer for Bigtable.

D : Add more nodes to the Bigtable cluster.

Answer: C

Question 2

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

Options :

A : Migrate the databases to Cloud Spanner.

B : Migrate the databases to Cloud SQL, and enable a standby database.

C : Migrate the databases to Compute Engine using regional persistent disks.

D : Migrate the databases to Bare Metal Solution for Oracle.

Answer: B

Question 3

Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?

Options :

A : Issue a gcloud sql instances patch command to increase the number of vCPUs.

B : Update a MySQL database flag to increase the number of vCPUs.

C : Issue a gcloud compute instances update command to increase the number of vCPUs.

D : Back up the database, create an instance with additional vCPUs, and restore the database.

Answer: A

Question 4

Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?

Options :

A : Use replication to roll out changes to higher environments.

B : Use backup and restore to roll out changes to higher environments.

C : Use Liquibase to roll out changes to higher environments.

D : Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

Answer: C

Question 5

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?

Options :

A : 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.

B : 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.

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

D : 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

Answer: B

Confidently Practice Online with Free Professional-Cloud-Database-Engineer Exam Cram

Buying Options: