[Mar-2024] Google Cloud Certified Professional-Cloud-Database-Engineer Exam Practice Test Questions Dumps Bundle!
2024 Updated Professional-Cloud-Database-Engineer PDF for the Professional-Cloud-Database-Engineer Tests Free Updated Today!
Google Professional-Cloud-Database-Engineer exam comprises of multiple choice and scenario-based questions, and it requires a thorough understanding of GCP database services. Professional-Cloud-Database-Engineer exam is designed to test the candidate’s ability to design, develop, and administer GCP databases in a real-world scenario. Professional-Cloud-Database-Engineer exam is conducted online, and the candidates are given a time limit of 2 hours to complete it. The passing score for the exam is 70%, and the certification is valid for two years.
NEW QUESTION # 44
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 instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
- B. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
- C. Configure the primary, standby, and read replica instances in zone A, all in the same region.
- D. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
Answer: D
NEW QUESTION # 45
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?
- A. Use Cloud SQL with an external (public) IP address.
- B. Use Firestore.
- C. Use an in-app embedded database.
- D. Use Cloud Spanner.
Answer: A
NEW QUESTION # 46
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 MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
- B. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
- C. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
- D. Migrate all the databases to Cloud SQL.
Answer: A
NEW QUESTION # 47
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 external server replication.
- B. Use Data Migration Service.
- C. Use the mysqldump utility and binary logs.
- 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 # 48
Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring. What should you do?
- A. Increase the storage size for the instance.
- B. Use many smaller Cloud SQL instances.
- C. Increase the number of CPUs for your instance.
- D. Use Cloud Spanner instead of Cloud SQL.
Answer: D
NEW QUESTION # 49
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 a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
- B. 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.
- C. 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.
- D. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
Answer: B
NEW QUESTION # 50
You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?
- A. Enable the Cloud SQL Admin API.
- B. Ensure that you are using an external (public) IP address interface.
- C. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- D. Check whether your service account has cloudsql.instances.connect permission.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/connect-auth-proxy#troubleshooting C because in docs it says "Make sure to enable the Cloud SQL Admin API. If it is not, you see output like Error 403: Access Not Configured in your Cloud SQL
NEW QUESTION # 51
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. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job 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. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
- D. 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.
Answer: C
Explanation:
"Deny maintenance period. A block of days in which Cloud SQL does not schedule maintenance. Deny maintenance periods can be up to 90 days long. " https://cloud.google.com/sql/docs/mysql/maintenance
NEW QUESTION # 52
You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?
- A. Use Bigtable with clusters in multiple regions to deploy the database
- B. Use BigQuery to deploy the database
- C. Use Cloud SQL with a regional read replica to deploy the database.
- D. Use Cloud Spanner to deploy the database.
Answer: B
NEW QUESTION # 53
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 amount of memory allocated to your instance.
- B. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- 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: D
NEW QUESTION # 54
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 Error Reporting to count, analyze, and aggregate the data.
- B. Use Cloud Debugger to inspect the state of an application.
- C. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
- D. Use Logs Explorer to analyze log data.
Answer: C
NEW QUESTION # 55
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 create an on-demand backup routine to a regional Cloud Storage bucket.
- B. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
- C. Use the default configuration for the automated backups location.
- D. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/backup-recovery/backing-up#locationbackups You can use a custom location for on-demand and automatic backups. For a complete list of valid location values, see the Instance locations.
NEW QUESTION # 56
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. Enable point-in-time recovery.
- C. Configure single zone availability for automated backups.
- D. Set up manual backups.
- E. Create a PostgreSQL database on-premises as the HA option.
Answer: B,E
NEW QUESTION # 57
You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?
- A. Use Migrate for Compute Engine to complete the migration.
- B. Export the data from the existing database, and load the data into a new Cloud SQL database.
- C. Use Database Migration Service to complete the migration.
- D. Use Datastream to complete the migration.
Answer: B
NEW QUESTION # 58
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?
- A. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
- B. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
- C. Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.
- D. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#serverless
NEW QUESTION # 59
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. Run the Recommender API to identify overprovisioned instances.
- B. Use Query Insights to identify idle instances.
- C. Build indexes on heavily accessed tables.
- D. Remove inactive user accounts.
Answer: A
NEW QUESTION # 60
You recently launched a new product to the US market. You currently have two Bigtable clusters in one US region to serve all the traffic. Your marketing team is planning an immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability according to Google-recommended practices. What should you do?
- A. Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central2-a
cluster-c in zone asia-northeast1-b
cluster-d in zone asia-east1-b - B. Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central1-b
cluster-c in zone us-east1-a - C. Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone europe-west1-d
cluster-c in zone asia-east1-b - D. Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone australia-southeast1-a
cluster-c in zone europe-west1-d
cluster-d in zone asia-east1-b
Answer: A
NEW QUESTION # 61
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 standard storage.
Keep backups older than one day stored in Actifio OnVault storage. - 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.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket. - C. 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. - 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.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.
Answer: A
Explanation:
This answer meets the RTO and RPO requirements by using flash storage for the database and standard storage for the local backup copy. It also meets the cost-effectiveness requirement by using Actifio OnVault storage, which is a low-cost, high-performance, and scalable storage solution that integrates with Google Cloud Backup and DR Service1.
NEW QUESTION # 62
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-central1-b.
Create a read replica in us-east1-b. - B. 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. - C. 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. - D. 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.
Answer: A
NEW QUESTION # 63
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 High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
- B. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
- C. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
- D. 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).
Answer: A
NEW QUESTION # 64
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.)
- A. Create additional read replicas, and partition your analytics users to use different read replicas.
- B. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
- C. Create secondary indexes on the replica.
- D. 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.
- E. 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.
Answer: A,E
Explanation:
Replication lag and slow report performance. E is eliminated because using BigQuery would mean changes to the current reports. Report slowness could be the result of poor indexing or just too much read load (or both!). Since excessive load is mentioned in the question, creating additional read replicas and spreading the analytics workload around makes B correct and eliminates A as a way to speed up reporting. That leaves the replication problem. Cloud SQL enables single threaded replication by default, so it stands to reason enabling parallel replication would help the lag. To do that you disable replication on the replica (not the primary), set flags on the replica and optionally set flags on the primary instance to optimize performance for parallel replication. That makes C correct and D incorrect. https://cloud.google.com/sql/docs/mysql/replication/manage-replicas#configuring-parallel-replication
NEW QUESTION # 65
......
To pass the Professional-Cloud-Database-Engineer exam, candidates must demonstrate a deep understanding of GCP's database services, such as Cloud SQL, Cloud Spanner, and Cloud Bigtable. They must also have experience working with SQL, NoSQL, and other database technologies.
To earn the Google Professional-Cloud-Database-Engineer certification, candidates must pass a two-hour exam that consists of multiple-choice and multiple-select questions. Professional-Cloud-Database-Engineer exam fee is $200, and it can be taken online or at a testing center. Professional-Cloud-Database-Engineer exam is available in English, Japanese, Spanish, and Portuguese. Professional-Cloud-Database-Engineer exam is designed to test the candidate's understanding of key concepts related to database engineering on the Google Cloud Platform.
Fully Updated Dumps PDF - Latest Professional-Cloud-Database-Engineer Exam Questions and Answers: https://www.practicedump.com/Professional-Cloud-Database-Engineer_actualtests.html
100% Free Professional-Cloud-Database-Engineer Exam Dumps to Pass Exam Easily: https://drive.google.com/open?id=1CpRo2EgPuqrb6uTYKOn133u4chLoVBfP