The Best Valid Professional-Cloud-Database-Engineer Dumps for Helping Passing Professional-Cloud-Database-Engineer Exam!
UPDATED Google Professional-Cloud-Database-Engineer Exam Questions & Answer
Google Professional-Cloud-Database-Engineer certification exam is designed for individuals who possess advanced skills and knowledge in managing databases on the Google Cloud Platform. Google Cloud Certified - Professional Cloud Database Engineer certification is designed to validate your ability to design, develop, and administer scalable and secure databases on Google Cloud. Google Cloud Certified - Professional Cloud Database Engineer certification exam is intended for database administrators, database developers, and other IT professionals who want to demonstrate their expertise in managing databases on the Google Cloud Platform.
Google Professional-Cloud-Database-Engineer exam is a professional certification that assesses an individual's knowledge and expertise in designing, developing, and managing Google Cloud Platform database solutions. Google Cloud Certified - Professional Cloud Database Engineer certification is intended for individuals with experience in database development and management who wish to validate their skills in the latest Google Cloud Platform database technologies.
NEW QUESTION # 17
Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?
- A. Migrate the Oracle databases to Compute Engine.
- B. Migrate the Oracle databases to Cloud Spanner.
- C. Migrate the Oracle databases to Bare Metal Solution for Oracle.
- D. Migrate the Oracle databases to Cloud SQL.
Answer: C
Explanation:
This answer is correct because Bare Metal Solution for Oracle is a service that provides dedicated physical servers and networking infrastructure for running Oracle databases on Google Cloud1. Bare Metal Solution for Oracle supports Oracle RAC, which is a cluster database that provides high availability, scalability, and performance for Oracle workloads2. By using Bare Metal Solution for Oracle, you can migrate your Oracle databases with minimal to no changes to the applications, and you can leverage the native Google Cloud services and interconnectivity1.
NEW QUESTION # 18
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 that will run a select * from table(s) query to call the cloudsql.instances.export API.
- B. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
- C. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
- D. Use Cloud Composer to execute a select * from table(s) query and export results.
Answer: A
NEW QUESTION # 19
Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?
- A. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east1-b.
Create a read replica in us-central1-b. - B. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east-b.
Create a read replica in us-east1-c. - C. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-central1-b.
Create a read replica in us-east1-b. - D. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-west1-b.
Create a read replica in us-east1-c.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/sqlserver/intro-to-cloud-sql-disaster-recovery
NEW QUESTION # 20
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?
- A. 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.
- B. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
- C. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
- D. 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.
Answer: D
NEW QUESTION # 21
You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)
- A. Ensure that pglogical is installed on the source PostgreSQL database.
- B. Ensure that all PostgreSQL tables have a primary key.
- C. Disable all foreign key constraints on the source PostgreSQL database.
- D. Drop or disable all users except database administration users.
- E. Shut down the database before the Data Migration Service task is started.
Answer: A,C
NEW QUESTION # 22
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 backup and restore to roll out changes to higher environments.
- B. Use Liquibase to roll out changes to higher environments.
- C. Use replication to roll out changes to higher environments.
- D. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
Answer: B
Explanation:
To satisfy audit reporting you would need a way to record what was changed and when. The best answer is one which uses some kind of source code control system (SCCS). That rules out A and B. Any mention of anything manual in a cloud environment should look suspicious, which leave option C. As it happens, Liquibase is an SCCS and can be integrated with Spanner. https://cloud.google.com/spanner/docs/use-liquibase
NEW QUESTION # 23
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 persistent disk with customer-managed encryption keys.
- B. Create the database with Google-managed encryption keys.
- C. Create the database with customer-managed encryption keys.
- D. Create the database persistent disk with Google-managed encryption keys.
Answer: A
NEW QUESTION # 24
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. Close idle connections or restart the instance before beginning the import operation.
- B. Increase the amount of memory allocated to your instance.
- C. Ensure that the service account has the Storage Admin role.
- D. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
Answer: C
NEW QUESTION # 25
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.READ_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.QUERY_STATS* tables.
Answer: A
Explanation:
To troubleshoot high read latency, you can use SQL statements to analyze the SPANNER_SYS.
READ_STATS* tables. These tables contain statistics about read operations in Cloud Spanner, including the number of reads, read latency, and the number of read errors. By analyzing these tables, you can identify the cause of the high read latency and take appropriate action to resolve the issue. Other options, such as using query parameters to speed up frequently executed queries or changing the Cloud Spanner configuration from multi-region to single region, may not be directly related to the issue of high read latency. Similarly, analyzing the SPANNER_SYS.QUERY_STATS* tables, which contain statistics about query operations, may not be relevant to the issue of high read latency.
NEW QUESTION # 26
You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions.
You want to follow Google-recommended practices for the migration. What should you do?
- A. Create a read replica in another region, and promote the read replica if a failure occurs.
- B. Enable high availability (HA) for the database to make it regional.
- C. Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
- D. Take nightly snapshots of the primary database instance, and restore them in a secondary zone.
Answer: B
NEW QUESTION # 27
Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?
- A. Use Logs Explorer to analyze log data.
- B. Use Error Reporting to count, analyze, and aggregate the data.
- C. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
- D. Use Cloud Debugger to inspect the state of an application.
Answer: C
NEW QUESTION # 28
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 failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
- B. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
- C. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
- D. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
Answer: B
NEW QUESTION # 29
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. Configure single zone availability for automated backups.
- B. Set up manual backups.
- C. Create a PostgreSQL database on-premises as the HA option.
- D. Schedule automated backups.
- E. Enable point-in-time recovery.
Answer: C,E
NEW QUESTION # 30
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?
- A. For each application code, set up a common shared user account.
- B. For the application server, set up a service account.
- C. For the application server, set up a common shared user account.
- D. For each application code, set up a dedicated user account.
Answer: D
NEW QUESTION # 31
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.
What should you do?
- A. Use gcloud sql instances failover <PrimaryInstanceName>.
- B. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
- C. Use gcloud sql instances failover <ReplicaInstanceName>.
- D. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
Answer: A
NEW QUESTION # 32
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 Identity and Access Management (IAM) authentication.
- B. Use Cloud SQL federated queries.
- C. Use Managed Active Directory authentication.
- D. Use PostgreSQL database's built-in authentication.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/postgres/authentication
NEW QUESTION # 33
Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?
- A. Build indexes on heavily accessed tables.
- B. Remove inactive user accounts.
- C. Run the Recommender API to identify overprovisioned instances.
- D. Use Query Insights to identify idle instances.
Answer: C
Explanation:
The Cloud SQL overprovisioned instance recommender helps you detect instances that are unnecessarily large for a given workload. It then provides recommendations on how to resize such instances and reduce cost. This page describes how this recommender works and how to use it. https://cloud.google.com/sql/docs/mysql/recommender-sql-overprovisioned#:~:text=The%20Cloud%20SQL%20overprovisioned%20instance%20recommender%20helps%20you%20detect%20instances%20that%20are%20unnecessarily%20large%20for%20a%20given%20workload.%20It%20then%20provides%20recommendations%20on%20how%20to%20resize%20such%20instances%20and%20reduce%20cost.%20This%20page%20describes%20how%20this%20recommender%20works%20and%20how%20to%20use%20it.
NEW QUESTION # 34
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.
What should you do?
- A. Use gcloud sql instances failover <ReplicaInstanceName>.
- B. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
- C. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
- D. Use gcloud sql instances failover <PrimaryInstanceName>.
Answer: B
NEW QUESTION # 35
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?
- A. Create a custom app profile with single-cluster routing.
- B. Create a custom app profile with multi-cluster routing.
- C. Use the default app profile with single-cluster routing.
- D. Use the default app profile with multi-cluster routing.
Answer: B
Explanation:
https://cloud.google.com/bigtable/docs/app-profiles#default-app-profile The question states that a single cluster existed first, then a second cluster was added. Google's documentation states, "if you created the instance with one cluster, the default app profile uses single-cluster routing. This ensures that adding additional clusters later does not change the behavior of your existing applications". Simply adding a second cluster does not change the default profile from single-cluster routing to multi-cluster routing. Since you need multi-cluster routing, you're going to need a custom app profile. So C is correct. https://cloud.google.com/bigtable/docs/app-profiles#default-app-profile
NEW QUESTION # 36
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 use Actifio to store backup files on Cloud Storage using the Nearline Storage class.
- B. Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
- C. Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.
- D. Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.
Answer: B
NEW QUESTION # 37
You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability.
What should you do?
- A. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
- B. Configure the primary, standby, and read replica instances in zone A, all in the same region.
- C. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
- D. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview
NEW QUESTION # 38
You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS.
You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?
- A. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
- B. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
- C. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
- D. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
Answer: B
Explanation:
Given that Google SSD performance is related to the size of the disk in an order of 30 IOPS for each GB, ti would require at least 833 GB to handle 25000 IOPS, the only answer that exceeds this value is C.
https://cloud.google.com/compute/docs/disks/performance
NEW QUESTION # 39
Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?
- A. Issue a gcloud sql instances patch command to increase the number of vCPUs.
- B. Update a MySQL database flag to increase the number of vCPUs.
- C. Issue a gcloud compute instances update command to increase the number of vCPUs.
- D. Back up the database, create an instance with additional vCPUs, and restore the database.
Answer: A
Explanation:
https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch
NEW QUESTION # 40
You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?
- A. Use highly available Cloud SQL with multiple zones.
- B. Use Cloud SQL with cross-region replicas.
- C. Use Cloud Spanner in a multi-region configuration.
- D. Use Cloud Spanner in a regional configuration.
Answer: D
Explanation:
https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform
NEW QUESTION # 41
......
Google Professional-Cloud-Database-Engineer is a certification exam designed for professionals who want to showcase their expertise in designing, building, and managing databases on Google Cloud Platform. Professional-Cloud-Database-Engineer exam is intended for individuals who have a deep understanding of database management, data migration, backup and recovery, and security on Google Cloud Platform. Successful completion of Professional-Cloud-Database-Engineer exam will earn candidates the Google Cloud Certified - Professional Cloud Database Engineer certification.
Updated Professional-Cloud-Database-Engineer Dumps Questions For Google Exam: https://actualtorrent.exam4pdf.com/Professional-Cloud-Database-Engineer-dumps-torrent.html
