[UPDATED 2023] Getting Professional-Cloud-Database-Engineer Certification Made Easy!
Professional-Cloud-Database-Engineer Exam Crack Test Engine Dumps Training With 120 Questions
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 |
|
NEW QUESTION 34
You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud. What should you do?
- A. Migrate to Bare Metal Solution for Oracle.
- B. Migrate to Compute Engine.
- C. Migrate to Google Cloud VMware Engine
- D. Migrate to Google Kubernetes Engine (GKE)
Answer: B
NEW QUESTION 35
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. Remove inactive user accounts.
- B. Use Query Insights to identify idle instances.
- C. Run the Recommender API to identify overprovisioned instances.
- D. Build indexes on heavily accessed tables.
Answer: C
NEW QUESTION 36
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. Compress the data using a different compression algorithm.
- B. Create another schema to load older data.
- C. Normalize the database to the third normal form.
- D. Manually or automatically increase the storage capacity.
Answer: A
NEW QUESTION 37
You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?
- A. Use staleness of at least 15 seconds.
- B. Place the bulk of the read and write workloads closer to the default leader region.
- C. Keep the total CPU utilization under 45% in each region.
- D. Add more read-write replicas.
Answer: D
NEW QUESTION 38
Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?
- A. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
- B. Create an external replica, and use Cloud SQL to synchronize the data to the replica.
- C. Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
- D. Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
Answer: C
NEW QUESTION 39
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 clone database.
- B. Start the original primary instance and resume replication.
- C. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
- D. Verify that the new replica is created automatically.
Answer: C
NEW QUESTION 40
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)
- A. Use Database Migration Service to migrate the databases to Cloud SQL.
- B. Use a cross-region read replica to migrate the databases to Cloud SQL.
- C. Use a read replica to migrate the databases to Cloud SQL.
- D. Use replication from an external server to migrate the databases to Cloud SQL.
- E. Use an external read replica to migrate the databases to Cloud SQL.
Answer: C,D
NEW QUESTION 41
Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?
- A. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.
- B. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
- C. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
- D. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
Answer: C
NEW QUESTION 42
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 all the databases to Cloud SQL.
- 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 the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
Answer: C
NEW QUESTION 43
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 Cloud Spanner with a custom autoscaling solution.
- B. Use a Biglable cluster with autoscaling.
- C. Use sharded Cloud SQL instances with one or more stores per database instance.
- D. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
Answer: C
NEW QUESTION 44
You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?
- A. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
- B. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
- C. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
- D. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
Answer: A
NEW QUESTION 45
You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?
- A. Modify the database schema, and add additional indexes.
- B. Increase the number of processing units.
- C. Decrease the number of processing units.
- D. Shard data required by the application into multiple instances.
Answer: B
NEW QUESTION 46
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. Bigtable
- D. BigQuery
Answer: D
NEW QUESTION 47
You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?
- A. Use Cloud SQL instance monitoring in the Google Cloud Console.
- B. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
- C. Use Query Insights for Cloud SQL.
- D. Use log messages produced by Cloud SQL.
Answer: B
NEW QUESTION 48
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.client and roles/spanner.databaseReader
- B. roles/cloudsql.viewer and roles/spanner.databaseUser
- C. roles/cloudsql.editor and roles/spanner.admin
- D. roles/cloudsql.instanceUser and roles/spanner.databaseUser
Answer: A
NEW QUESTION 49
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. Disable and remove the internal IP address assignment.
- B. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
- C. Disable and remove the external IP address assignment.
- D. Specify an authorized network with the CIDR range of the VM.
Answer: B
NEW QUESTION 50
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 an in-app embedded database.
- B. Use Cloud Spanner.
- C. Use Firestore.
- D. Use Cloud SQL with an external (public) IP address.
Answer: D
NEW QUESTION 51
Your team is building an application that stores and analyzes streaming time series financial dat a. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?
- A. Use Cloud Spanner.
- B. Use Firestore.
- C. Use Bigtable
- D. Use BigQuery.
Answer: D
NEW QUESTION 52
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-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-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-west1-b.
Create a read replica in us-east1-c.
Answer: A
NEW QUESTION 53
You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?
- A. Use the Query Insights dashboard to identify high execution times.
- B. View Cloud SQL operations to view historical query information.
- C. Review application logs to identify database calls.
- D. White a Logs Explorer query to identify database queries with high execution times.
Answer: A
NEW QUESTION 54
......
Professional-Cloud-Database-Engineer Exam Dumps Contains FREE Real Quesions from the Actual Exam: https://preptorrent.actual4exams.com/Professional-Cloud-Database-Engineer-real-braindumps.html