Professional Cloud Database Engineer - Google Cloud Certified Exam Questions
Question 11 Single Choice
A Database Engineer is tasked with optimizing the cost and performance of a Cloud SQL instance running MySQL. The instance is used by an e-commerce application with a heavy read workload and occasionally experiences high latency during peak hours. Which of the following solutions should the engineer implement to best address this issue while optimizing cost and performance?
Question 12 Single Choice
Your company is planning to migrate a mission-critical application to Google Cloud Platform. This application requires a scalable and highly available database solution with a focus on strong consistency, low latency, and the ability to perform complex SQL queries. The database must also support multi-region replication for disaster recovery purposes. Which of the following database services should you choose to meet these requirements, and what replication and scaling configuration should you use?
Question 13 Single Choice
A Database Engineer is working on a project that involves a content management system (CMS) with a large number of images and documents being uploaded and accessed by users. The application is currently using Cloud Storage for storing the content, and the engineer is tasked with optimizing cost and performance. Which of the following strategies should the engineer implement to best achieve these objectives?
Question 14 Single Choice
You are managing a PostgreSQL instance on a Compute Engine virtual machine (VM). The application team reports occasional slow query performance but cannot identify a pattern. You need to collect detailed metrics and logs to troubleshoot and identify the slow queries without impacting the current workload. What should you do?
Question 15 Single Choice
As a Database Engineer, how can you minimize Cloud SQL instance expenditure with minimal effort when each developer and tester has their own instance for learning and experimentation purposes, and the team operates from Monday morning to Friday evening?
Question 16 Single Choice
You are the Database Engineer responsible for setting up IAM policies to ensure secure connectivity and access control for your organization's Google Cloud SQL databases. Which of the following IAM roles should be granted to a user who needs to manage the database instances but should not have access to the actual data stored in the databases?
Question 17 Single Choice
Your organization has an existing application that just went viral. The application uses a Cloud SQL for PostgreSQL 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?
Question 18 Single Choice
Your company's web application allows users to submit text feedback, which is then automatically analyzed for sentiment and categorized. The results are stored, and a monthly sentiment report is generated for product improvement discussions. You need to design a solution that is cost-effective and easy to maintain. What should you do?
Question 19 Single Choice
Your organization relies on Cloud Spanner to store data for a mission-critical, user-facing application that requires low-latency read operations. You need to recommend the optimal instance configuration to ensure consistent, high-performance reads. What should you do?
Question 20 Multiple Choice
You are managing a Cloud Spanner database that needs to handle an increasing number of read and write operations due to the growing number of users. You want to optimize the performance and scalability of the database. What should you do? (Choose two)
