[Oct 15, 2022] Fully Updated Google Cloud Certified (Professional-Cloud-Database-Engineer) Certification Sample Questions
Latest Google Professional-Cloud-Database-Engineer Real Exam Dumps PDF
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 |
|
NEW QUESTION 49
Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?
- A. Use Cloud Spanner.
- B. Use Bigtable.
- C. Use Firestore.
- D. Use Cloud SQL.
Answer: D
NEW QUESTION 50
You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)
- A. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- B. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
- C. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
- D. If the corruption is significant, use import and export.
- E. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
Answer: B,C
NEW QUESTION 51
You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?
- A. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
- B. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
- C. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
- D. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
Answer: D
NEW QUESTION 52
Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?
- A. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
- B. Edit the primary instance to add additional memory.
- C. Stop all running queries, and re-create the replicas.
- D. Identify and optimize slow running queries, or set parallel replication flags.
Answer: A
NEW QUESTION 53
Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?
- A. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner databaseReader for Application C - B. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner.backupWriter for Application C - C. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupAdmin for Application C - D. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupWriter for Application C
Answer: C
NEW QUESTION 54
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?
- A. Add more nodes to the Bigtable cluster.
- B. Use Key Visualizer for Bigtable.
- C. Isolate the data analysts and operations user groups to use different Bigtable instances.
- D. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
Answer: D
NEW QUESTION 55
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. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
- B. 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.
- 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. 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.
Answer: D
NEW QUESTION 56
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 57
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. 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.
- C. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
- D. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
Answer: D
NEW QUESTION 58
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 Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
- C. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
- D. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
Answer: D
NEW QUESTION 59
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?
- A. Use Liquibase to roll out changes to higher environments.
- B. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
- C. Use backup and restore to roll out changes to higher environments.
- D. Use replication to roll out changes to higher environments.
Answer: C
NEW QUESTION 60
You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?
- A. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
- B. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
- C. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
- D. Use Cloud Composer to execute a select * from table(s) query and export results.
Answer: B
NEW QUESTION 61
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?
- A. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
- B. Use the default configuration for the automated backups location.
- C. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
- D. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
Answer: D
NEW QUESTION 62
Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?
- A. Create another schema to load older data.
- B. Manually or automatically increase the storage capacity.
- C. Normalize the database to the third normal form.
- D. Compress the data using a different compression algorithm.
Answer: D
NEW QUESTION 63
Your organization is running a critical production database on a virtual machine (VM) on Compute Engine. The VM has an ext4-formatted persistent disk for data files. The database will soon run out of storage space. You need to implement a solution that avoids downtime. What should you do?
- A. In the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.
- B. In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.
- C. In the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.
- D. In the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use
Answer: C
NEW QUESTION 64
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?
- A. Migrate to Cloud SQL for PostgreSQL.
- B. Migrate to Compute Engine.
- C. Migrate to Cloud SQL for SQL Server.
- D. Migrate to Google Kubernetes Engine (GKE).
Answer: A
NEW QUESTION 65
Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?
- A. Create the database with customer-managed encryption keys.
- B. Create the database persistent disk with Google-managed encryption keys.
- C. Create the database persistent disk with customer-managed encryption keys.
- D. Create the database with Google-managed encryption keys.
Answer: C
NEW QUESTION 66
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. Use customer-managed encryption keys with Cloud SQL.
- B. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
- C. Connect to Cloud SQL using a connection that has SSL encryption.
- D. Use Cloud SQL Auth proxy.
Answer: C
NEW QUESTION 67
......
Google Professional-Cloud-Database-Engineer Dumps - Secret To Pass in First Attempt: https://pass4sure.verifieddumps.com/Professional-Cloud-Database-Engineer-valid-exam-braindumps.html
