Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer FREE EXAM DUMPS QUESTIONS & ANSWERS

You are building the database layer for a multinational ticketing marketplace on Google Cloud.
Traffic is unpredictable and can spike by 8x during global presales and seasonal campaigns. The system must deliver strongly consistent transactions, sub second reads for users on three continents, and a 99.999% availability target while still keeping spend under control. Which Google Cloud database service and configuration should you choose to meet these goals?

mcnz.com migrated its busy ticketing platform database to Cloud SQL for MySQL six months ago and monitoring now shows persistently low CPU and memory usage which indicates the instance is oversized. What is the most efficient action to reduce costs while maintaining the current performance levels?

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google- recommended practices. What should you do?

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS).
You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy.
What should you do?

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3).
During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

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

You run a toy sales ecommerce application on Spanner. The application contains details about the various product listings such as name, category, description, and review(s). Your leadership wants to enable customers to ask free-form questions about the product catalog. You want to implement this functionality in the easiest, quickest, and least expensive way possible.
What should you do?

How should you configure a Cloud SQL for PostgreSQL instance in us-central1 to use a customer-managed encryption key from a Cloud KMS key ring in us-central1 with key rotation every 30 days?

You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

You want to migrate an on-premises MySQL database to Cloud SQL. The on-premises database currently has 16 cores and 64-GB of RAM and averages 75% CPU utilization to support an application with over 100.000 tables. You need to specify the most cost-effective machine size you need when migrating to Cloud SQL for MySQL. What should you do-

Your company is rapidly expanding its user base across North America, nearly doubling in the last 6-months. This expansion causes a substantial increase in query volume on your mission- critical Cloud SQL database. This has led to noticeable performance issues and slower query response times. You suspect that your Cloud SQL instance may not be able to handle the incremental load. You need to identify the root cause of this performance bottleneck and ensure that your database can scale with your growing user base. What should you do-

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

You are the DBA of your organization. You provided a cloned instance from the production Cloud SQL for PostgreSQL database to the developers for testing purposes. After the creation of the clone, your developers notice missing data in one of the recently altered tables. What should you do to ensure that all data is included-

Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?

You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?