The latest Google Professional Cloud Database Engineer certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Google Professional Cloud Database Engineer exam and earn Google Professional Cloud Database Engineer certification.
Table of Contents
- Question 91
- Exam Question
- Correct Answer
- Question 92
- Exam Question
- Correct Answer
- Question 93
- Exam Question
- Correct Answer
- Question 94
- Exam Question
- Correct Answer
- Question 95
- Exam Question
- Correct Answer
- Question 96
- Exam Question
- Correct Answer
- Question 97
- Exam Question
- Correct Answer
- Question 98
- Exam Question
- Correct Answer
- Question 99
- Exam Question
- Correct Answer
- Question 100
- Exam Question
- Correct Answer
Question 91
Exam Question
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.
What should you do?
A. Use gcloud sql instances failover <PrimaryInstanceName>.
B. Use gcloud sql instances failover <ReplicaInstanceName>.
C. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
D. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
Correct Answer
D. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
Question 92
Exam Question
Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?
A. Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
B. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
C. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
D. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.
Correct Answer
D. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.
Question 93
Exam Question
Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?
A. Migrate all the databases to Cloud SQL.
B. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
C. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
Correct Answer
B. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
Question 94
Exam Question
You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?
A. Use linear scaling to implement the Autoscaler-based architecture
B. Use direct scaling to implement the Autoscaler-based architecture.
C. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
D. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
Correct Answer
C. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
Question 95
Exam Question
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.
Correct Answer
C. Migrate the Oracle databases to Cloud SQL.
Question 96
Exam Question
You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database.
What should you do?
A. Use Bigtable with multi-region clusters.
B. Use Memorystore for Redis with multi-zones within a region.
C. Use Cloud SQL for PostgreSQL with cross-region replicas.
D. Use Cloud Spanner with multi-region configuration.
Correct Answer
C. Use Cloud SQL for PostgreSQL with cross-region replicas.
Question 97
Exam Question
You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?
A. Use Cloud Spanner in a regional configuration.
B. Use Cloud Spanner in a multi-region configuration.
C. Use Cloud SQL with cross-region replicas.
D. Use highly available Cloud SQL with multiple zones.
Correct Answer
A. Use Cloud Spanner in a regional configuration.
Question 98
Exam Question
Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?
A. Watch Query Insights for long running queries.
B. Watch the Cloud SQL instance monitor for CPU utilization metrics.
C. Watch the Cloud SQL recommenders for overprovisioned instances.
D. Watch Cloud Trace for application requests that are failing.
Correct Answer
A. Watch Query Insights for long running queries.
Question 99
Exam Question
You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Googlerecommended practices. What should you do?
A. Shut down and restart each application.
B. Write a utility to scan database query logs.
C. Write a utility to scan application logs.
D. Use query tags to add application-centric database monitoring.
Correct Answer
B. Write a utility to scan database query logs.
Question 100
Exam Question
You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions.
What should you do?
A. Reuse the existing service account that populates this database.
B. Create a new service account, and grant it the Cloud Spanner Database Admin role.
C. Create a new service account, and grant it the Cloud Spanner Database Reader role.
D. Create a new service account, and grant it the spanner.databases.select permission.
Correct Answer
B. Create a new service account, and grant it the Cloud Spanner Database Admin role.