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?

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

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.

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, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.

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.

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?

Use Key Visualizer for Bigtable.

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.

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

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

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

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

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?

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

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.

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

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 but need to minimize operational costs and overhead. What should you do?

Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.

Create a VM in Compute Engine, and run a cron job.

Create a Cloud Composer instance, and create a directed acyclic graph (DAG).

Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.

Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.

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 ensure that replication is fast and reliable and uses Google-managed services. What should you do?

Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

Develop a custom data replication service to send data into BigQuery.

Use Cloud SQL federated queries.

Use Database Migration Service to replicate tables into BigQuery.

Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached data. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?

Use Firestore and ensure that the PersistenceEnabled option is set to true.

Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.

Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.

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?

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.

You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)

Use a change data capture (CDC) migration strategy.

Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

Use a change data capture (CDC) migration strategy.

Move the physical database servers from on-premises to Google Cloud.

Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.

Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.

Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

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?

Automate instance creation by setting up Terraform scripts.

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.

Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?

Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Keep backups older than one day stored in Actifio OnVault storage.

Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on all flash storage. Keep backups older than one day stored in Actifio OnVault storage.

Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Keep backups older than one day stored in Actifio OnVault storage.

Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.

Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on all flash storage. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.

You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:Can read tables, views, and DDLCan write rows to the tablesCan add columns and indexesCannot drop the databaseWhat should you do?

Assign the Cloud Spanner Database User role.

Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.

Assign the Cloud Spanner Database Admin role.

Assign the Cloud Spanner Database User role.

Assign the Cloud Spanner Admin role.

Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this data. What should you do?

Use VPC Service Controls to create a trusted network for the Bigtable service.

Use Identity and Access Management (IAM) for Bigtable access control.

Use VPC Service Controls to create a trusted network for the Bigtable service.

Use customer-managed encryption keys (CMEK).

Use Google Cloud Armor to add IP addresses to an allowlist.

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

Place the bulk of the read and write workloads closer to the default leader region.

Use staleness of at least 15 seconds.

Keep the total CPU utilization under 45% in each region.

Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?

Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.

Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.

Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.

Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.

Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.

You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.You want to set up the environment with minimal administrative effort. What should you do?

Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.

Set up different organizations for each database type, and apply policy constraints at the organization level.

Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.

Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

Delete DB-2 so that DB-1 automatically reverts to the primary instance.

Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?

Use the Query Insights dashboard to identify high execution times.

View Cloud SQL operations to view historical query information.

White a Logs Explorer query to identify database queries with high execution times.

Review application logs to identify database calls.

Use the Query Insights dashboard to identify high execution times.

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

Create one regional Cloud SQL instance with a read replica in another region.

Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.

Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?

Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

Shut down your existing Cloud SQL for MySQL instance, and enable HA.

You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

Configure the automated backups to use a regional Cloud Storage bucket as a custom location.

Use the default configuration for the automated backups location.

Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.

Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.

Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?

Use Cloud Scheduler and Cloud Functions to run the daily export.

Create a streaming Datatlow job to export the table.

Set up Cloud Composer, and create a task to export the table daily.

Run the cron job on a Compute Engine instance to continue the export.

Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?

Use Database Migration Service to connect to your on-premises database, and choose continuous replication. After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.

Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL. Schedule downtime to run each Cloud Data Fusion pipeline. Verify that the migration was successful. Re-point the applications to the Cloud SQL for MySQL instance.

Pause the on-premises applications. Use the mysqldump utility to dump the database content in compressed format. Run gsutil --m to move the dump file to Cloud Storage. Use the Cloud SQL for MySQL import option. After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

Pause the on-premises applications. Use the mysqldump utility to dump the database content in CSV format. Run gsutil --m to move the dump file to Cloud Storage. Use the Cloud SQL for MySQL import option. After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

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?

Use Cloud Spanner for data storage.

Use Cloud SQL for data storage.

Use Cloud Spanner for data storage.

Use Memorystore for data storage.

Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?

Run the Recommender API to identify overprovisioned instances.

Use Query Insights to identify idle instances.

Run the Recommender API to identify overprovisioned instances.

Build indexes on heavily accessed tables.

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?

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.

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?

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

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

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

Use Database Migration Service to migrate your database.

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

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?

Create a custom app profile with multi-cluster routing.

Use the default app profile with single-cluster routing.

Use the default app profile with multi-cluster routing.

Create a custom app profile with multi-cluster routing.

Create a custom app profile with single-cluster routing.

Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?

Use customer-managed encryption keys with Cloud SQL.

Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.

Connect to Cloud SQL using a connection that has SSL encryption.

Use customer-managed encryption keys with Cloud SQL.

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?

Use Cloud Spanner to deploy the database.

Use Bigtable with clusters in multiple regions to deploy the database

Use BigQuery to deploy the database

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

You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

Use Cloud Spanner in a regional configuration.

Use Cloud SQL with cross-region replicas.

Use high availability (HA) Cloud SQL with multiple zones.

Use zonal Cloud SQL without high availability (HA).

Use Cloud Spanner in a regional configuration.

You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud. What should you do?

Migrate to Bare Metal Solution for Oracle.

Migrate to Google Kubernetes Engine (GKE)

Migrate to Google Cloud VMware Engine

Google Professional Cloud Database Engineer Practice Test 3

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?

Become a Premium Member for full access

Unlock Premium Member

Google Professional Cloud Database Engineer Practice Test 3

Question

Google Professional Cloud Database Engineer Practice Tests

Practice Tests