Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?

Use workload identity federation to impersonate a service account.

Ask existing users to set their Google password to match their corporate password.

Migrate the application to Google Cloud, and use Identity and Access Management (IAM).

Use Google Workspace Password Sync to replicate passwords into Google Cloud.

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 external IP address assignment.

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.

You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest data. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?

Create a read replica for the Sales Reporting application.

Create two separate databases in the instance, and perform dual writes from the Order Management application.

Use a Cloud SQL federated query for the Sales Reporting application.

Queue up all the requested reports in PubSub, and execute the reports at night.

You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process data. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?

Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.

Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.

Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.

Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.

Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.

Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?

Use Database Migration Service.

Use the native export and import functionality of the source database.

Create a database on Google Cloud, and use database links to perform the migration.

Create a database on Google Cloud, and use Dataflow for database migration.

Use Database Migration Service.

Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?

Set Terraform deletion_protection to true.

Use point-in-time-recovery (PITR) to recover the database.

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?

C.Deploy the database using Bigtable.

Deploy the database using Cloud SQL.

Use BigQuery, and load data in batches.

C.Deploy the database using Bigtable.

Deploy the database using Cloud Spanner.

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

Use Identity and Access Management (IAM) authentication.

Use Managed Active Directory authentication.

Use Cloud SQL federated queries.

Use PostgreSQL database's built-in authentication.

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?

Use the SQL Server Always On Availability Group dashboard.

Use Cloud SQL instance monitoring.

Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.

Use the SQL Server Always On Availability Group dashboard.

Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency. What should you do?

Select Bare Metal Solution for Oracle.

Google Professional Cloud Database Engineer Practice Test 4

You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?

Become a Premium Member for full access

Unlock Premium Member

Google Professional Cloud Database Engineer Practice Test 4

Question

Google Professional Cloud Database Engineer Practice Tests

Practice Tests