Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Pass the Google Cloud Database Engineer Professional-Cloud-Database-Engineer Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam Professional-Cloud-Database-Engineer Premium Access

View all detail and faqs for the Professional-Cloud-Database-Engineer exam

Go to Exam

412 Students Passed

95% Average Score

92% Same Questions

Viewing page 1 out of 5 pages

Viewing questions 1-10 out of questions

Questions # 1:

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

Options:

Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

Use Database Migration Service to migrate your database.

Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

Questions # 2:

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?

Options:

Migrate to Compute Engine.

Migrate to Bare Metal Solution for Oracle.

Migrate to Google Kubernetes Engine (GKE)

Migrate to Google Cloud VMware Engine

Questions # 3:

You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have their own project. What should you do to configure the networks?

Options:

Create a new VPC network in each project, and use VPC Network Peering to connect the two together.

Create a Shared VPC that both the application VMs and Cloud SQL instances will use.

Use the default networks, and leverage Cloud VPN to connect the two together.

Place both the application VMs and the Cloud SQL instances in the default network of each project.

Questions # 4:

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?

Options:

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.

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.

Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.

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.

Questions # 5:

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA. You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

Options:

Manually scale down the number of nodes after the peak period has passed.

Use interleaving to co-locate parent and child rows.

Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

Use granular instance sizing in Cloud Spanner and Autoscaler.

Questions # 6:

You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?

Options:

Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.

Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.

Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.

Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.

Questions # 7:

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?

Options:

Configure the automated backups to use a regional Cloud Storage bucket as a custom location.

Use the default configuration for the automated backups location.

Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

Questions # 8:

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?

Options:

Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.

Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.

Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

Questions # 9:

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

Options:

Create one regional Cloud SQL instance with a read replica in another region.

Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.

Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

Questions # 10:

You are setting up a new AlloyDB instance and want users to be able to use their existing identity and Access Managemen (IAM) identities to connect to AlloyDB. You have performed the following steps:

Manually enabled IAM authentication on the AlloyDB instance

Granted the allowdb-databaseUser and serviceusage.serviceusageConsumer IAM roles to the users

Created new AllowDB database users based on corresponding IAM identities

Users are able to connect but are reporting that they are not able to SELECT from application tables. What should you do?