ExamDumpster

Free PCDBE sample questions

These free PCDBE sample questions each show the right answer with an explanation. They include capacity planning, backup and recovery design, and data migration. Use them to test your database judgment before a full practice session.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 9 of 19 free sample questions.

Question 1Choose one

A financial analytics platform uses AlloyDB for PostgreSQL to serve a mix of transactional queries and complex, real-time analytical dashboards. During peak trading hours, dashboard loading times increase significantly. Initial investigation using Query Insights reveals that the analytical queries are consuming a large amount of CPU and I/O, impacting the transactional workload. The platform must maintain low latency for both workloads. What is the most effective way to isolate the analytical workload and improve overall performance using AlloyDB's features?

Question 2Choose one

You are managing a Cloud SQL for SQL Server instance that hosts a critical business application. The development team needs to perform a major application upgrade that includes significant schema changes and data modifications. You must ensure that you can quickly revert the database to its pre-upgrade state if the deployment fails. The entire process, including a potential rollback, must be completed within a 30-minute window. What is the most efficient method to prepare for this upgrade?

Question 3Choose one

A startup is building a serverless application using Cloud Functions and Firestore. To control costs, they want to implement a mechanism that prevents a single function invocation from performing an excessive number of database operations. For example, they want to cap the number of document writes per invocation to 100. How can they enforce this rule across their application?

Question 4Choose one

You are designing a database solution for a new mobile application that requires offline data access and automatic synchronization when the device comes back online. The data model is document-based and will be accessed directly by the client application. Which Google Cloud database and client-side feature set should you choose?

Question 5Choose 2

A lead engineer is reviewing the IAM policies for a project containing several Cloud SQL instances. They discover that a developer's service account has the `roles/cloudsql.editor` role bound at the project level. According to the principle of least privilege, the service account should only have permissions to connect to and query a specific database instance named `dev-db-instance`, but not modify it or other instances. Which IAM changes should you implement? (Select TWO)

Question 6Choose one

You are tasked with optimizing storage costs for a Cloud Bigtable instance that stores historical log data. The data is frequently accessed for the first 30 days, but access drops significantly after that. The data must be retained for a total of 365 days for compliance reasons. What is the most cost-effective and automated way to manage the lifecycle of this data in Bigtable?

Question 7Choose one

A DevOps team is building an automation script using Terraform to provision Cloud SQL for PostgreSQL instances. As part of the configuration, they need to set the `max_connections` flag for the database. However, they want the script to be reusable for different instance sizes (e.g., small, medium, large) without hardcoding the value, as the maximum allowed connections depend on the instance's available memory. How should they approach this in their automation?

Question 8Choose one

A new regulation requires your company to store certain customer data only within European Union member states. The application serving this data is deployed in multiple EU regions (e.g., `europe-west1`, `europe-west4`) for high availability and low latency. You need a database solution that is strongly consistent, supports SQL, and can enforce this data residency requirement while still being managed as a single logical database. Which solution should you choose?

Question 9Choose one

You have been hired as a consultant to optimize a company's Google Cloud database costs. You find they are running a large, development-focused Cloud SQL for MySQL instance 24/7, even though it is only actively used during business hours (9 AM to 5 PM, Monday-Friday). What is the most direct and effective recommendation to reduce the cost of this instance?

10 more free samples are waiting

Create a free account to unlock the whole PCDBE sample bank, or get full access to all 465 practice questions in the simulator.

Create account