Google Professional-Cloud-Database-Engineer Exam Questions Free Practice Test

Viewing page 4 out of 5 pages

Viewing questions 31-40 out of questions

Questions # 31:

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. Thedatabase will soon run out of storage space. You need to implement a solution that avoids downtime. What should you do?

Options:

In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.

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

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.

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.

Questions # 32:

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?

Options:

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

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

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

Create 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.

Questions # 33:

You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

Options:

Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.

Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.

Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.

Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.

Questions # 34:

You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

Options:

Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.

Create your database with one primary node and one read replica in the region.

Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.

Configure your Cloud SQL instance with high availability enabled.

Questions # 35:

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?

Options:

Use gcloud sql instances failover .

Use gcloud sql instances promote-replica .

Questions # 36:

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over.

What should you do? (Choose two.)

Options:

Use an external read replica to migrate the databases to Cloud SQL.

Use a read replica to migrate the databases to Cloud SQL.

Use Database Migration Service to migrate the databases to Cloud SQL.

Use a cross-region read replica to migrate the databases to Cloud SQL.

Use replication from an external server to migrate the databases to Cloud SQL.

Questions # 37:

You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?

Options:

Automate instance creation by writing a Dataflow job.

Automate instance creation by setting up Terraform scripts.

Create the instances using the Google Cloud Console UI.

Create clones from a template Cloud SQL instance.

Questions # 38:

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?

Options:

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

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

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

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

Questions # 39:

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?

Options:

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.

Questions # 40:

You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?

Pass the Google Cloud Database Engineer Professional-Cloud-Database-Engineer Questions and answers with CertsForce