Free PROFESSIONAL-CLOUD-DATABASE-ENGINEER Exam Braindumps (page: 3)

Page 3 of 34

You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data.
Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users.
What should you do?

  1. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
  2. Create your database with one primary node and one read replica in the region.
  3. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
  4. Configure your Cloud SQL instance with high availability enabled.

Answer(s): A

Explanation:

Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.



Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag.
What should you do?

  1. Identify and optimize slow running queries, or set parallel replication flags.
  2. Stop all running queries, and re-create the replicas.
  3. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
  4. Edit the primary instance to add additional memory.

Answer(s): A

Explanation:

https://cloud.google.com/sql/docs/mysql/replication/replication- lag#optimize_queries_and_schema



Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.

You need to assign roles to team members for Cloud Spanner.
Which roles should you assign?

  1. roles/spanner.databaseAdmin for Person A
    roles/spanner.databaseReader for Person B
    roles/spanner.backupWriter for Application C
  2. roles/spanner.databaseAdmin for Person A
    roles/spanner.databaseReader for Person B
    roles/spanner.backupAdmin for Application C
  3. roles/spanner.databaseAdmin for Person A
    roles/spanner.databaseUser for Person B

    roles/spanner databaseReader for Application C
  4. roles/spanner.databaseAdmin for Person A
    roles/spanner.databaseUser for Person B
    roles/spanner.backupWriter for Application C

Answer(s): A

Explanation:

https://cloud.google.com/spanner/docs/iam#spanner.backupWriter



You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SL

  1. You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low.
    What should you do?
  2. Manually scale down the number of nodes after the peak period has passed.
  3. Use interleaving to co-locate parent and child rows.
  4. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
  5. Use granular instance sizing in Cloud Spanner and Autoscaler.

Answer(s): D

Explanation:

Granular instance is available in Public Preview. With this feature, you can run workloads on Spanner at as low as 1/10th the cost of regular instances,
https://cloud.google.com/blog/products/databases/get-more-out-of-spanner-with-granular- instance-sizing



Page 3 of 34



Post your Comments and Discuss Google PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam with other Community members:

muksgreen commented on March 01, 2024
brainstorming excellent
JAPAN
upvote