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

Go to page:

Question # 9

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).

Edit the instance to change the storage type from HDD to SSD.

Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.

Create a read replica of the instance with SSDs, and perform a failover to the new instance

Full Access

Question # 10

You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?

Disable and remove the internal IP address assignment.

Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.

Specify an authorized network with the CIDR range of the VM.

Disable and remove the external IP address assignment.

Full Access

Question # 11

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 byan 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?

Place the bulk of the read and write workloads closer to the default leader region.

Use staleness of at least 15 seconds.

Add more read-write replicas.

Keep the total CPU utilization under 45% in each region.

Full Access

Question # 12

Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?

Migrate to Cloud SQL for SQL Server.

Migrate to Cloud SQL for PostgreSQL.

Migrate to Compute Engine.

Migrate to Google Kubernetes Engine (GKE).

Full Access

Question # 13

You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?

Set up a Shared VPC, configure multiple service projects, and create firewall rules.

Set up Serverless VPC Access.

Set up Private Service Connect.

Set up Traffic Director.

Full Access

Question # 14

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?

Migrate all the databases to Cloud SQL.

Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.

Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.

Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.

Full Access

Question # 15

You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?

Deploy the database using Cloud SQL.

Use BigQuery, and load data in batches.

Deploy the database using Bigtable.

Deploy the database using Cloud Spanner.

Full Access

Question # 16

Your company's mission-critical, globally available application is supported by a Cloud Spanner database. Experienced users of the application have read and write access to the database, but new users are assigned read-only access to the database. You need to assign the appropriate Cloud Spanner Identity and Access Management (IAM) role to new users being onboarded soon. What roles should you set up?

roles/spanner.databaseReader

roles/spanner.databaseUser

roles/spanner.viewer

roles/spanner.backupWriter

Full Access