Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer Exam Questions

QUESTION NO: 1
You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS.
You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

QUESTION NO: 2
Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?

QUESTION NO: 3
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day.
Theapplication team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?

QUESTION NO: 4
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?

QUESTION NO: 5
You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?

QUESTION NO: 6
You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

QUESTION NO: 7
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us- central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google- recommended practices to minimize performance impact on the currently running instance. What should you do?

QUESTION NO: 8
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQLdatabase. You need to ensure that stored data is encrypted with your keys. What should you do?

QUESTION NO: 9
You are migrating critical production database from Amazon RDS for MySQL to Cloud SQL for MYSQL by using Google Cloud's Migration Service.
You want to keep disruption to your production database to minimum and, at the same time, optimize migration performance. What should you do?

QUESTION NO: 10
Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?