[Apr 20, 2024] Get New Professional-Cloud-Database-Engineer Certification – Valid Exam Dumps Questions
100% Passing Guarantee - Brilliant Professional-Cloud-Database-Engineer Exam Questions PDF
NEW QUESTION # 74
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 Identity and Access Management (IAM) for Bigtable access control.
- D. Use VPC Service Controls to create a trusted network for the Bigtable service.
Answer: D
NEW QUESTION # 75
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. Set up manual backups.
- B. Configure single zone availability for automated backups.
- C. Enable point-in-time recovery.
- D. Create a PostgreSQL database on-premises as the HA option.
- E. Schedule automated backups.
Answer: C,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 # 76
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 Cloud Spanner instead of Cloud SQL.
- C. Use many smaller Cloud SQL instances.
- D. Increase the number of CPUs for your instance.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/best-practices#data-arch
NEW QUESTION # 77
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. Use the default configuration for the automated backups location.
- B. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
- C. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
- D. Disable automated backups, and create an on-demand backup routine 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 # 78
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?
- A. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
- B. Use Database Migration Service to replicate tables into BigQuery.
- C. Develop a custom data replication service to send data into BigQuery.
- D. Use Cloud SQL federated queries.
Answer: A
Explanation:
"Datastream is a serverless and easy-to-use Change Data Capture (CDC) and replication service that allows you to synchronize data across heterogeneous databases, storage systems, and applications reliably and with minimal latency. Datastream supports change data streaming from Oracle and MySQL databases to Google Cloud Storage (GCS). The service offers streamlined integration with Dataflow templates to power up to date materialized views in BigQuery for analytics, replicate their databases into Cloud SQL or Cloud Spanner for database synchronization, or leverage the event stream directly from GCS to realize event-driven architectures."
NEW QUESTION # 79
Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?
- A. Recommend mixed storage types.
- B. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
- C. Recommend hard disk drives (HDD).
- D. Recommend solid-state drives (SSD).
Answer: B
NEW QUESTION # 80
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 Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
- 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 all the databases to Cloud SQL.
Answer: C
NEW QUESTION # 81
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 PostgreSQL running on Compute Engine.
- B. Migrate the existing database to Cloud SQL for PostgreSQL.
- C. Migrate the existing database to Cloud Spanner.
- D. Migrate the existing database to Firestore.
Answer: B
NEW QUESTION # 82
You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?
- A. Use Dataflow to run the export in text format.
- B. Use Cloud Functions to run the export in Avro format.
- C. Use Dataflow to run the export in Avro format.
- D. Use Cloud Functions to run the export in text format.
Answer: C
NEW QUESTION # 83
You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO. What should you do?
- A. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
- B. Use Cloud SQL logs.
- C. Use Cloud SQL instance monitoring.
- D. Use the SQL Server Always On Availability Group dashboard.
Answer: D
Explanation:
Note, you cannot create a read replica in Cloud SQL for SQL Server unless you use an Enterprise Edition. Which is also a requirement for configuring SQL Server AG. That's not a coincidence. That's how Cloud SQL for SQL Server creates SQL Server read replicas. To find out about the replication, use the AG Dashboard in SSMS. https://cloud.google.com/sql/docs/sqlserver/replication/manage-replicas#promote-replica
NEW QUESTION # 84
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. Review application logs to identify database calls.
- C. View Cloud SQL operations to view historical query information.
- D. White a Logs Explorer query to identify database queries with high execution times.
Answer: A
Explanation:
A Cloud SQL instance configured for HA is also called a regional instance and has a primary and secondary zone within the configured region. Within a regional instance, the configuration is made up of a primary instance and a standby instance. Through synchronous replication to each zone's persistent disk, all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed. In the event of an instance or zone failure, the standby instance becomes the new primary instance. Users are then rerouted to the new primary instance. This process is called a failover.
NEW QUESTION # 85
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. Use the default configuration for the automated backups location.
- B. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
- C. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
- D. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
Answer: D
NEW QUESTION # 86
Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?
- A. Use Cloud Spanner for data storage.
- B. Use Memorystore for data storage.
- C. Use Bigtable for data storage.
- D. Use Cloud SQL for data storage.
Answer: A
Explanation:
google Cloud Spanner is a highly scalable, reliable, and fully managed relational database service that runs on Google's infrastructure. It's designed to handle large amounts of data and provide high availability, even in the face of failures. Spanner can be used to store and manage data for a variety of applications, including e-commerce websites. Spanner is a good choice for this scenario because it can handle high write throughput and provides 99.99% uptime. It's also a good fit for applications that need to be highly available, even in the face of failures.
NEW QUESTION # 87
You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?
- A. Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.
- B. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
- C. Create a VM in Compute Engine, and run a cron job.
- D. Create a Cloud Composer instance, and create a directed acyclic graph (DAG).
Answer: B
Explanation:
Cloud Scheduler triggers actions at regular fixed intervals, whereas Cloud Tasks triggers actions based on how the individual task object is configured. Reference: https://cloud.google.com/tasks/docs/comp-tasks-sched
NEW QUESTION # 88
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.QUERY_STATS* tables.
- B. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
- C. Change the Cloud Spanner configuration from multi-region to single region.
- D. Use query parameters to speed up frequently executed queries.
Answer: B
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 # 89
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. Stop all running queries, and re-create the replicas.
- B. Edit the primary instance to add additional memory.
- C. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
- D. Identify and optimize slow running queries, or set parallel replication flags.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/mysql/replication/replication-lag#optimize_queries_and_schema
NEW QUESTION # 90
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. Start the original primary instance and resume replication.
- B. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
- C. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
- D. Verify that the new replica is created automatically.
Answer: B
NEW QUESTION # 91
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 Compute Engine.
- C. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
- D. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
Answer: D
NEW QUESTION # 92
You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached dat a. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?
- A. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
- B. Use Memorystore for Memcached.
- C. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
- D. Use Firestore and ensure that the PersistenceEnabled option is set to true.
Answer: D
Explanation:
https://firebase.google.com/docs/firestore/manage-data/enable-offline
NEW QUESTION # 93
You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?
- A. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
- B. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
- C. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
- D. Create one regional Cloud SQL instance with a read replica in another region.
Answer: A
NEW QUESTION # 94
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 promote-replica <ReplicaInstanceName>.
- B. Use gcloud sql instances failover <ReplicaInstanceName>.
- C. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
- D. Use gcloud sql instances failover <PrimaryInstanceName>.
Answer: D
NEW QUESTION # 95
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 Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
- C. Use a Biglable cluster with autoscaling.
- D. Use sharded Cloud SQL instances with one or more stores per database instance.
Answer: A
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 # 96
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 two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
- B. Create and run a Dataflow job that uses JdbcIO to copy data 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 a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#serverless
NEW QUESTION # 97
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. Use Cloud SQL Auth proxy.
- C. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
- D. Connect to Cloud SQL using a connection that has SSL encryption.
Answer: D
NEW QUESTION # 98
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. Export the data from the existing database, and load the data into a new Cloud SQL database.
- B. Use Datastream to complete the migration.
- C. Use Migrate for Compute Engine to complete the migration.
- D. Use Database Migration Service to complete the migration.
Answer: D
Explanation:
https://www.cloudskillsboost.google/focuses/22792?parent=catalog
NEW QUESTION # 99
......
The Google Professional-Cloud-Database-Engineer exam is intended for individuals who have experience in database management and want to validate their skills in the cloud database engineering domain. Professional-Cloud-Database-Engineer exam requires the candidate to have a strong understanding of database concepts, SQL, data modeling, database design, and database implementation. Additionally, the exam tests the candidate's ability to develop automation scripts and manage database security and compliance. Google Cloud Certified - Professional Cloud Database Engineer certification demonstrates the individual's ability to design and manage scalable, reliable, and secure database solutions on the Google Cloud Platform.
Free Professional-Cloud-Database-Engineer braindumps download: https://www.passsureexam.com/Professional-Cloud-Database-Engineer-pass4sure-exam-dumps.html
Professional-Cloud-Database-Engineer Dumps 2024 - NewGoogle Exam Questions: https://drive.google.com/open?id=1IHk82edh3WdTyx8oq9EOGsM6FdhRwO-D