Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer Exam Practice Test

You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?

You need to issue a new server certificate because your old one is expiring. You need to avoid a restart of your Cloud SQL for MySQL instance. What should you do in your Cloud SQL instance?

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?

When comparing Google Cloud managed NoSQL services, which cost component should you consistently emphasize for a precise TCO analysis?

Your company is migrating one of its monolithic applications to a microservices architecture on Google Cloud. The new architecture involves a user authentication service that runs on Google Kubernetes Engine (GKE) and needs to access Cloud SQL for PostgreSQL instances. Your developers need to access the databases for local development and debugging purposes. You need to design a centralized, secure, and scalable database connectivity and access management strategy for both application service interfaces and developers. What should you do-

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi- regional instance. What should you do?

Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?

Your company uses a custom application to service thousands of users. The application is running on a Compute Engine and a Cloud SQL for PostgreSQL database. The company requires database passwords to be changed every 60-days. You need to ensure that the credentials used by the web application to connect to the database are managed securely. What should you do-

You have an application that performs numerous reads and writes all day running in a single Bigtable cluster. A new batch analytics job needs to read the same data and you want to make sure that the new job does not affect the existing workload. What should you do-

You are migrating your 10 TB on-premises PostgreSQL database to Cloud SQL for PostgreSQL by using Database Migration Service. During the migration, there will be schema changes in the source database. You need to ensure any schema changes are replicated, while keeping disruption to the ongoing migration to a minimum.
What should you do?

You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?

Your company has a critical application running on-premises on PostgreSQL. The application requires minimal migration downtime and the ability to withstand regional outages. You are considering a Cloud SQL Enterprise Plus edition instance on PostgreSQL. You need to ensure that the migration will meet your requirements with minimal effort.
What should you do?