← Back to exam page

Professional-Cloud-Database-Engineer – Professional Cloud Database Engineer

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)

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

You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)

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

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

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.