Oct 10, 2024 Step by Step Guide to Prepare for Professional-Cloud-Database-Engineer Exam BrainDumps
Google Cloud Certified Professional-Cloud-Database-Engineer Real Exam Questions and Answers FREE Updated on 2024
Google Professional-Cloud-Database-Engineer exam is a certification offered by Google Cloud to individuals who want to prove their expertise in designing, building, and managing scalable and highly available database solutions on Google Cloud Platform. Google Cloud Certified - Professional Cloud Database Engineer certification validates the skills and knowledge required to perform database operations, including migration, maintenance, configuration, and optimization.
NEW QUESTION # 14
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?
- A. Use PostgreSQL database's built-in authentication.
- B. Use Identity and Access Management (IAM) authentication.
- C. Use Cloud SQL federated queries.
- D. Use Managed Active Directory authentication.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/postgres/authentication
NEW QUESTION # 15
Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?
- A. Use data replication tools and CDC tools to enable migration.
- B. Use Database Migration Service to migrate all databases to Cloud SQL.
- C. Use a combination of Database Migration Service and partner tools to support the data migration strategy.
- D. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
Answer: D
NEW QUESTION # 16
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
- A. Migrate applications to Cloud SQL.
- B. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
- C. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
- D. Migrate applications and Oracle databases to Compute Engine.
Answer: B
Explanation:
https://cloud.google.com/blog/products/databases/migrate-databases-to-google-cloud-vmware-engine-gcve
NEW QUESTION # 17
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?
- A. 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.
- B. Set up all read replicas in the same region as the primary instance with synchronous replication.
- C. 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.
- D. Set up all read replicas in a different region using asynchronous replication.
Answer: A
Explanation:
This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed1. This minimizes data loss and downtime in case of a zonal or an instance failure, and allows for a quick failover to the standby instance1.
This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2. This provides additional redundancy and backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.
NEW QUESTION # 18
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 Google Cloud Armor to add IP addresses to an allowlist.
- C. Use VPC Service Controls to create a trusted network for the Bigtable service.
- D. Use Identity and Access Management (IAM) for Bigtable access control.
Answer: C
Explanation:
"Users can define a security perimeter around Google Cloud resources such as Cloud Storage buckets, Bigtable instances, and BigQuery datasets to constrain data within a VPC and control the flow of data." https://cloud.google.com/vpc-service-controls
NEW QUESTION # 19
You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?
- A. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- B. Increase the amount of memory allocated to your instance.
- C. Close idle connections or restart the instance before beginning the import operation.
- D. Ensure that the service account has the Storage Admin role.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#troubleshooting
NEW QUESTION # 20
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 dat a. 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?
- A. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
- B. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
- C. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
- D. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
Answer: A
NEW QUESTION # 21
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?
- A. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
- B. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
- C. Migrate all the databases to Cloud SQL.
- D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
Answer: B
NEW QUESTION # 22
You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:
configure where data is stored
control where the encryption keys are stored
govern the access to data
What should you do?
- A. Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
- B. Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.
- C. Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.
- D. Replicate Cloud SQL databases across different zones.
Answer: C
NEW QUESTION # 23
You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional dat a. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?
- A. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
- B. Configure your Cloud SQL instance with high availability enabled.
- C. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
- D. Create your database with one primary node and one read replica in the region.
Answer: A
Explanation:
Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
NEW QUESTION # 24
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. Start the original primary instance and resume replication.
- D. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
Answer: B
Explanation:
Recovery Process: Once Zone-B becomes available again, Cloud SQL will initiate the recovery process for the impacted read replica. The recovery process involves the following steps: 1. Synchronization: Cloud SQL will compare the data in the recovered read replica with the primary instance in Zone-A. If there is any data divergence due to the unavailability period, Cloud SQL will synchronize the read replica with the primary instance to ensure data consistency. 2. Catch-up Replication: The recovered read replica will start catching up on the changes that occurred on the primary instance during its unavailability. It will apply the necessary updates from the primary instance's binary logs (binlogs) to bring the replica up to date. 3. Resuming Read Traffic: Once the synchronization and catch-up replication processes are complete, the read replica in Zone-B will resume its normal operation. It will be able to serve read traffic and stay updated with subsequent changes from the primary instance.
NEW QUESTION # 25
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 the mysqldump utility and binary logs.
- B. Use external server replication.
- C. Use Data Migration Service.
- D. Use Cloud SQL for MySQL external replica.
Answer: D
Explanation:
An external replica is a method that allows you to create a read-only copy of your Cloud SQL instance on an external server, such as a Compute Engine instance or an on-premises database server1. An external replica can help you scale reads and offload management operations from your data center to Google Cloud. You can also use an external replica for disaster recovery, migration, or reporting purposes1.
To create an external replica, you need to configure a Cloud SQL instance that replicates to one or more replicas external to Cloud SQL, and a source representation instance that represents the source database server in Cloud SQL1. You also need to enable access on the Cloud SQL instance for the IP address of the external replica, create a replication user, and export and import the data from the source database server to the external replica1.
NEW QUESTION # 26
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?
- A. Shut down your existing Cloud SQL for MySQL instance, and enable HA.
- B. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
- C. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
- D. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
Answer: C
NEW QUESTION # 27
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?
- A. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
- B. Migrate all the databases to Cloud SQL.
- C. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
- D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
Answer: A
NEW QUESTION # 28
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. Create a PostgreSQL database on-premises as the HA option.
- B. Schedule automated backups.
- C. Set up manual backups.
- D. Configure single zone availability for automated backups.
- E. Enable point-in-time recovery.
Answer: B,E
Explanation:
D) Enable point-in-time recovery - This feature allows you to restore your database to a specific point in time. It helps protect against data loss and can be used in the event of data corruption or accidental data deletion. E. Schedule automated backups - Automated backups allow you to take regular backups of your database without manual intervention. You can use these backups to restore your database in the event of data loss or corruption.
NEW QUESTION # 29
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?
- A. Use sharded Cloud SQL instances with one or more stores per database instance.
- B. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
- C. Use a Biglable cluster with autoscaling.
- D. Use Cloud Spanner with a custom autoscaling solution.
Answer: D
Explanation:
https://cloud.google.com/spanner/docs/autoscaling-overview
1. CloudSQL max out at 64TB, so unable to told 100TB of data. https://cloud.google.com/sql/docs/quotas#metrics_collection_limit 2. Scale is done manually on SQL Cloud
NEW QUESTION # 30
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?
- A. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
- B. 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.
- C. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
- D. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
Answer: D
Explanation:
Binary Logging enabled, with that you can identify the point of time the data was good and recover from that point time. https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#perform_the_point-in-time_recovery_using_binary_log_positions
NEW QUESTION # 31
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?
- A. Migrate the existing database to Cloud SQL for PostgreSQL.
- B. Migrate the existing database to Cloud Spanner.
- C. Migrate the existing database to Firestore.
- D. Migrate the existing database to PostgreSQL running on Compute Engine.
Answer: A
NEW QUESTION # 32
You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?
- A. Set your production instance's maintenance window to non-business hours.
- B. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
- C. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
- D. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
Answer: A
NEW QUESTION # 33
You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?
- A. Set up Cloud Composer, and create a task to export the table daily.
- B. Use Cloud Scheduler and Cloud Functions to run the daily export.
- C. Create a streaming Datatlow job to export the table.
- D. Run the cron job on a Compute Engine instance to continue the export.
Answer: A
NEW QUESTION # 34
......
Ultimate Guide to Prepare Professional-Cloud-Database-Engineer Certification Exam for Google Cloud Certified: https://www.fast2test.com/Professional-Cloud-Database-Engineer-premium-file.html
Professional-Cloud-Database-Engineer Ultimate Study Guide: https://drive.google.com/open?id=1Mg8pMkoiectBtM-VBzT4SJzqeU6uDY-w