← Back to exam page

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

Free demo downloads

Loading demo links...

Showing 7–9 of 10 questions

Question 7

Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?

Select an option, then click Submit answer.

  • ○

    Cloud SQL
  • ○

    BigQuery
  • ○

    Cloud Spanner
  • ○

    Bigtable
Question 8

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?

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

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

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