Online Access Free Professional-Cloud-Database-Engineer Practice Test

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?

• A.Use Key Visualizer for Bigtable.
• B.Isolate the data analysts and operations user groups to use different Bigtable instances.
• C.Add more nodes to the Bigtable cluster.
• D.Check the Cloud Monitoring table/bytes_used metric from Bigtable.

You are the DBA of your organization. You provided a cloned instance from the production Cloud SQL for PostgreSQL database to the developers for testing purposes. After the creation of the clone, your developers notice missing data in one of the recently altered tables. What should you do to ensure that all data is included-

• A.Dump the production database to a file. Modify the dumped file to ALTER TABLEto SET LOGGED on tables that were unlogged in production. Reload the data in the new Cloud SQL for PostgreSQL instance.
• B.Take a back up of the production database, and restore it to another Cloud SQL for PostgreSQL instance. Provide access to the new instance to the developers.
• C.Check for missing roles and privileges in the cloned Cloud SQL instance. Grant missing privileges to the developers.
• D.Clone the current production database, and restore it to an earlier point-in-time (PITR). Provide access to the cloned instance to the developers.

Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?

• A.Migrate the Oracle databases to Bare Metal Solution for Oracle.
• B.Migrate the Oracle databases to Cloud Spanner.
• C.Migrate the Oracle databases to Compute Engine.
• D.Migrate the Oracle databases to Cloud SQL.

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 single-cluster routing.
• D.Create a custom app profile with multi-cluster routing.

Your organization is running a critical production database on a virtual machine (VM) on Compute Engine. The VM has an ext4-formatted persistent disk for data files. The database will soon run out of storage space. You need to implement a solution that avoids downtime. What should you do?

• A.In the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use
• B.In the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.
• C.In the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.
• D.In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.