Practice Free Professional Cloud Database Engineer Exam Online Questions
Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the
applications during the database migration.
What should you do?
- A . Migrate the Oracle databases to Cloud Spanner.
- B . Migrate the Oracle databases to Compute Engine.
- C . Migrate the Oracle databases to Cloud SQL.
- D . Migrate the Oracle databases to Bare Metal Solution for Oracle.
D
Explanation:
This answer is correct because Bare Metal Solution for Oracle is a service that provides dedicated physical servers and networking infrastructure for running Oracle databases on Google Cloud1. Bare Metal Solution for Oracle supports Oracle RAC, which is a cluster database that provides high availability, scalability, and performance for Oracle workloads2. By using Bare Metal Solution for Oracle, you can migrate your Oracle databases with minimal to no changes to the applications, and you can leverage the native Google Cloud services and interconnectivity1.
Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases.
What should you do?
- A . Use replication to roll out changes to higher environments.
- B . Use backup and restore to roll out changes to higher environments.
- C . Use Liquibase to roll out changes to higher environments.
- D . Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
C
Explanation:
To satisfy audit reporting you would need a way to record what was changed and when. The best answer is one which uses some kind of source code control system (SCCS). That rules out A and B. Any mention of anything manual in a cloud environment should look suspicious, which leave option C. As it happens, Liquibase is an SCCS and can be integrated with Spanner. https://cloud.google.com/spanner/docs/use-liquibase
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?
- A . Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
- B . Use the default configuration for the automated backups location.
- C . Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
- D . Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
A
Explanation:
https://cloud.google.com/sql/docs/mysql/backup-recovery/backing-up#locationbackups You can use a custom location for on-demand and automatic backups. For a complete list of valid location values, see the Instance locations.
You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud.
What should you do?
- A . Migrate to Compute Engine.
- B . Migrate to Bare Metal Solution for Oracle.
- C . Migrate to Google Kubernetes Engine (GKE)
- D . Migrate to Google Cloud VMware Engine
B
Explanation:
Oracle is neither licensed nor supported in GCE. The only platform which supports RAC and all existing Oracle features is BMS.
You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future.
What should you do?
- A . Set your production instance’s maintenance window to non-business hours.
- B . Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
- C . Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
- D . Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer data. You want to design a multi-tenancy strategy to efficiently manage costs and operations.
What should you do?
- A . Apply a schema data management pattern.
- B . Apply an instance data management pattern.
- C . Apply a table data management pattern.
- D . Apply a database data management pattern.
B
Explanation:
https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner#multi-tenancy-data-management-patterns
https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer data. You want to design a multi-tenancy strategy to efficiently manage costs and operations.
What should you do?
- A . Apply a schema data management pattern.
- B . Apply an instance data management pattern.
- C . Apply a table data management pattern.
- D . Apply a database data management pattern.
B
Explanation:
https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner#multi-tenancy-data-management-patterns
https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner
You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO.
What should you do?
- A . Use Cloud SQL instance monitoring.
- B . Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
- C . Use Cloud SQL logs.
- D . Use the SQL Server Always On Availability Group dashboard.
D
Explanation:
Note, you cannot create a read replica in Cloud SQL for SQL Server unless you use an Enterprise Edition.
Which is also a requirement for configuring SQL Server AG. That’s not a coincidence. That’s how Cloud SQL for SQL Server creates SQL Server read replicas. To find out about the replication, use the AG Dashboard in SSMS. https://cloud.google.com/sql/docs/sqlserver/replication/manage-replicas#promote-replica
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?
- A . Automate instance creation by writing a Dataflow job.
- B . Automate instance creation by setting up Terraform scripts.
- C . Create the instances using the Google Cloud Console UI.
- D . Create clones from a template 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?
- A . Create the database with Google-managed encryption keys.
- B . Create the database with customer-managed encryption keys.
- C . Create the database persistent disk with Google-managed encryption keys.
- D . Create the database persistent disk with customer-managed encryption keys.
B
Explanation:
https://cloud.google.com/sql/docs/postgres/configure-cmek#createcmekinstance