Pass Professional-Cloud-Database-Engineer Brain Dump Updated Certification Sample Questions [Q63-Q87]

5/5 - (2 votes)

Pass Professional-Cloud-Database-Engineer Brain Dump Updated Certification Sample Questions

Online Professional-Cloud-Database-Engineer Test Brain Dump Question and Test Engine

Google Professional-Cloud-Database-Engineer Exam Syllabus Topics:

Topic	Details
Topic 1	Manage database users, including authentication and access Continuously assess and optimize the cost of running a database solution
Topic 2	Provision high availability database solutions in Google Cloud Design scalable and highly available cloud database solutions
Topic 3	Differentiate between managed and unmanaged database services Analyze the cost of running database solutions in Google Cloud
Topic 4	Analyze relevant variables to perform database capacity and usage planning Design scalable, highly available, and secure databases
Topic 5	Reverse replication from Google Cloud to source Evaluate appropriate database solutions on Google Cloud
Topic 6	Justify the use of session pooler services Given a scenario, perform solution sizing based on current environment workload metrics and future requirements
Topic 7	Apply concepts to implement highly scalable and available databases in Google Cloud Given a scenario, define maintenance windows and notifications based on application availability requirements
Topic 8	Evaluate performance and cost tradeoffs of different database configurations Plan database upgrades for Google Cloud-managed databases
Topic 9	Deploy scalable and highly available databases in Google Cloud Determine database connectivity and access management considerations

QUESTION 63
You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?

Set the automated backups to occur every other day to lower the frequency of backups.

Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).

Select a different region to store your backups.

Reduce the number of automated backups that are retained to two (2).

QUESTION 64
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)

Use a change data capture (CDC) migration strategy.

Move the physical database servers from on-premises to Google Cloud.

Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.

Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.

Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

QUESTION 65
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?

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.

QUESTION 66
Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?

Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.

Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.

Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.

Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.

QUESTION 67
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?

For each application code, set up a common shared user account.

For each application code, set up a dedicated user account.

For the application server, set up a service account.

For the application server, set up a common shared user account.

QUESTION 68
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?

Develop a custom data replication service to send data into BigQuery.

Use Cloud SQL federated queries.

Use Database Migration Service to replicate tables into BigQuery.

Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

QUESTION 69
You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company’s disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?

Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.

Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.

Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.

Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.

QUESTION 70
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

Set up all read replicas in a different region using asynchronous replication.

Set up all read replicas in the same region as the primary instance with synchronous replication.

Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.

Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.

QUESTION 71
You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?

Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.

Use sharded Cloud SQL instances with one or more stores per database instance.

Use a Biglable cluster with autoscaling.

Use Cloud Spanner with a custom autoscaling solution.

QUESTION 72
You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?

Use the default app profile with single-cluster routing.

Use the default app profile with multi-cluster routing.

Create a custom app profile with multi-cluster routing.

Create a custom app profile with single-cluster routing.

QUESTION 73
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?

Use replication to roll out changes to higher environments.

Use backup and restore to roll out changes to higher environments.

Use Liquibase to roll out changes to higher environments.

Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

QUESTION 74
Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?

Use Cloud SQL for data storage.

Use Cloud Spanner for data storage.

Use Memorystore for data storage.

Use Bigtable for data storage.

QUESTION 75
You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

Bring DB-1 back online.

Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

Delete DB-2 so that DB-1 automatically reverts to the primary instance.

Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

QUESTION 76
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)

Create secondary indexes on the replica.

Create additional read replicas, and partition your analytics users to use different read replicas.

Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.

Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.

Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.

QUESTION 77
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.

QUESTION 78
You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?

Use the Google Cloud Console or gcloud CLI to manually create a new clone database.

Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.

Verify that the new replica is created automatically.

Start the original primary instance and resume replication.

QUESTION 79
You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)

Identify whether the database has over 512 tables.

Identify all tables that do not have a primary key.

Identity all tables that do not have at least one foreign key.

Identify whether the source database is encrypted using pgcrypto extension.

Identify whether the source database uses customer-managed encryption keys (CMEK).

QUESTION 80
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?

Migrate the existing database to Firestore.

Migrate the existing database to Cloud SQL for PostgreSQL.

Migrate the existing database to Cloud Spanner.

Migrate the existing database to PostgreSQL running on Compute Engine.

QUESTION 81
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?

Setup a static external IP address in your VPC network.

Set up bring your own IP (BYOIP) in your VPC.

Set up a Cloud NAT gateway on the Compute Engine VM.

Set up Cloud NAT service.

QUESTION 82
You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?

Use Firestore.

Use Cloud SQL with an external (public) IP address.

Use an in-app embedded database.

Use Cloud Spanner.

QUESTION 83
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?

Enable serializable isolation in the Firebase app.

Deploy a US multi-region Firestore location.

Build a Firestore bundle, and deploy bundles to Cloud CDN.

Create a Firestore index on the news story date.

QUESTION 84
Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?

Use Cloud SQL serverless exports.

Create a read replica, and then use the mysqldump utility to export each table.

Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.

Use the mysqldump utility on the primary database instance to export the backup.

QUESTION 85
During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?

Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

Shut down your existing Cloud SQL for MySQL instance, and enable HA.

QUESTION 86
Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

Use Bigtable.

Use Firestore.

Use Cloud SQL for MySQL

Use Cloud Spanner.

QUESTION 87
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.