Verified Professional-Cloud-Database-Engineer dumps Q&As - 2022 Latest Professional-Cloud-Database-Engineer Download
Dumps Questions [2022] Pass for Professional-Cloud-Database-Engineer Exam
NEW QUESTION 38
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?
- A. Create a clone database from a read replica database, and restore the clone into a different zone.
- B. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
- C. Create a clone database from a read replica database, and restore the clone in the same region.
- D. Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
Answer: B
NEW QUESTION 39
You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?
- A. Turn on automated backup, and turn on transaction log retention.
- B. Take no backups, and turn off transaction log retention.
- C. Turn on automated backup, and turn off transaction log retention.
- D. Take one manual backup per day, and turn off transaction log retention.
Answer: D
NEW QUESTION 40
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
- A. Use Cloud SQL for MySQL external replica.
- B. Use Data Migration Service.
- C. Use the mysqldump utility and binary logs.
- D. Use external server replication.
Answer: B
NEW QUESTION 41
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 Google-recommended practices. What should you do?
- A. Shut down and restart each application.
- B. Write a utility to scan database query logs.
- C. Use query tags to add application-centric database monitoring.
- D. Write a utility to scan application logs.
Answer: B
NEW QUESTION 42
Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?
- A. Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
- B. Use query parameters to speed up frequently executed queries.
- C. Change the Cloud Spanner configuration from multi-region to single region.
- D. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
Answer: C
NEW QUESTION 43
Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?
- A. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket. - B. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Keep backups older than one day stored in Actifio OnVault storage. - C. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket. - D. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Keep backups older than one day stored in Actifio OnVault storage.
Answer: D
NEW QUESTION 44
An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?
- A. roles/cloudsql.viewer and roles/spanner.databaseUser
- B. roles/cloudsql.editor and roles/spanner.admin
- C. roles/cloudsql.instanceUser and roles/spanner.databaseUser
- D. roles/cloudsql.client and roles/spanner.databaseReader
Answer: D
NEW QUESTION 45
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?
- A. Specify an authorized network with the CIDR range of the VM.
- B. Disable and remove the internal IP address assignment.
- C. Disable and remove the external IP address assignment.
- D. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
Answer: D
NEW QUESTION 46
You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?
- A. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
- B. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
- C. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
- D. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
Answer: B
NEW QUESTION 47
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?
- A. 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.
- B. 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.
- C. 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.
- D. 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.
Answer: A
NEW QUESTION 48
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?
- A. Perform the gcloud sql operations list command.
- B. Check the cloudsql.googleapis.com/postgres.log instance log.
- C. Use Cloud Audit Logs to verify the status.
- D. Use the Google Cloud Console.
Answer: C
NEW QUESTION 49
You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?
- A. Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
- B. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
- C. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
- D. Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
Answer: C
NEW QUESTION 50
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?
- A. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
- B. Verify that the new replica is created automatically.
- C. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
- D. Start the original primary instance and resume replication.
Answer: A
NEW QUESTION 51
Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?
- A. Cloud SQL
- B. Cloud Spanner
- C. BigQuery
- D. Bigtable
Answer: C
NEW QUESTION 52
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?
- A. Edit the instance to change the storage type from HDD to SSD.
- B. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
- C. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
- D. Create a read replica of the instance with SSDs, and perform a failover to the new instance
Answer: C
NEW QUESTION 53
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?
- A. Use Cloud Spanner for data storage.
- B. Use Bigtable for data storage.
- C. Use Cloud SQL for data storage.
- D. Use Memorystore for data storage.
Answer: C
NEW QUESTION 54
Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)
- A. Schedule automated backups.
- B. Set up manual backups.
- C. Enable point-in-time recovery.
- D. Create a PostgreSQL database on-premises as the HA option.
- E. Configure single zone availability for automated backups.
Answer: C,D
NEW QUESTION 55
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?
- A. Connect to Cloud SQL using a connection that has SSL encryption.
- B. Use customer-managed encryption keys with Cloud SQL.
- C. Use Cloud SQL Auth proxy.
- D. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
Answer: A
NEW QUESTION 56
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?
- A. Set up Traffic Director.
- B. Set up Private Service Connect.
- C. Set up Serverless VPC Access.
- D. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
Answer: D
NEW QUESTION 57
Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?
- A. Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
- B. Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.
- C. Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.
- D. Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.
Answer: A
NEW QUESTION 58
Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this dat a. What should you do?
- A. Use customer-managed encryption keys (CMEK).
- B. Use VPC Service Controls to create a trusted network for the Bigtable service.
- C. Use Google Cloud Armor to add IP addresses to an allowlist.
- D. Use Identity and Access Management (IAM) for Bigtable access control.
Answer: B
NEW QUESTION 59
You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?
- A. Use Bigtable with default encryption.
- B. Use Cloud Spanner with a customer-managed encryption key (CMEK).
- C. Use Cloud SQL with a customer-managed encryption key (CMEK).
- D. Use Cloud Spanner with default encryption.
Answer: C
NEW QUESTION 60
......
Google Professional-Cloud-Database-Engineer Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
| Topic 12 |
|
| Topic 13 |
|
Updated Google Study Guide Professional-Cloud-Database-Engineer Dumps Questions: https://www.testsimulate.com/Professional-Cloud-Database-Engineer-study-materials.html