← Back to exam page

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

Loading demo links...

Showing 4–6 of 10 questions

Question 4

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

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

You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

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

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?

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.