Free Professional-Cloud-Database-Engineer – Professional Cloud Database Engineer Practice Test Question

Select all that apply, then click Submit answer.

• ○

  Create secondary indexes on the replica.

• ○

  Create additional read replicas, and partition your analytics users to use different read replicas.

• ○

  Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.

• ○

  Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.

• ○

  Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.

Select all that apply, then click Submit answer.

• ○

  Drop or disable all users except database administration users.

• ○

  Disable all foreign key constraints on the source PostgreSQL database.

• ○

  Ensure that all PostgreSQL tables have a primary key.

• ○

  Shut down the database before the Data Migration Service task is started.

• ○

  Ensure that pglogical is installed on the source PostgreSQL database.

Select all that apply, then click Submit answer.

• ○

  Set up manual backups.

• ○

  Create a PostgreSQL database on-premises as the HA option.

• ○

  Configure single zone availability for automated backups.

• ○

  Enable point-in-time recovery.

• ○

  Schedule automated backups.

Select all that apply, then click Submit answer.

• ○

  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.

• ○

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

• ○

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

Select all that apply, then click Submit answer.

• ○

  If the corruption is significant, use backup and restore, and specify a recovery timestamp.

• ○

  If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.

• ○

  If the corruption is significant, use import and export.

• ○

  If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.

• ○

  If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.

Select an option, then click Submit answer.

• ○

  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.

Select an option, then click Submit answer.

• ○

  Cloud SQL

• ○

  BigQuery

• ○

  Cloud Spanner

• ○

  Bigtable

Select an option, then click Submit answer.

• ○

  Use Query Insights to identify idle instances.

• ○

  Remove inactive user accounts.

• ○

  Run the Recommender API to identify overprovisioned instances.

• ○

  Build indexes on heavily accessed tables.

Select an option, then click Submit answer.

• ○

  Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).

• ○

  Edit the instance to change the storage type from HDD to SSD.

• ○

  Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.

• ○

  Create a read replica of the instance with SSDs, and perform a failover to the new instance

Select an option, then click Submit answer.

• ○

  Reuse the existing service account that populates this database.

• ○

  Create a new service account, and grant it the Cloud Spanner Database Admin role.

• ○

  Create a new service account, and grant it the Cloud Spanner Database Reader role.

• ○

  Create a new service account, and grant it the spanner.databases.select permission.