[Dec 15, 2024] Professional-Cloud-Database-Engineer Exam Dumps - Google Practice Test Questions
New Real Professional-Cloud-Database-Engineer Exam Dumps Questions
The Google Professional-Cloud-Database-Engineer exam consists of multiple choice and multiple select questions, with a total of 50 questions that must be completed within a time limit of two hours. To pass the exam, candidates must achieve a score of 70% or higher. Professional-Cloud-Database-Engineer exam can be taken online or in-person at a Google Cloud testing center.
Google Professional-Cloud-Database-Engineer certification exam is designed to test the skills and knowledge of professionals who work with databases on the Google Cloud Platform. It is intended for individuals who have experience in designing, developing, and managing databases, as well as those who are skilled in using Google Cloud's database services.
Google Professional-Cloud-Database-Engineer certification is a valuable certification for database engineers and administrators who work with the Google Cloud Platform. It demonstrates a high level of expertise and knowledge in database management on the cloud, which is becoming increasingly important in today's digital landscape. Candidates can prepare for the exam by studying database management principles and gaining hands-on experience with database administration on the Google Cloud Platform.
NEW QUESTION # 26
You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?
- A. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.
- B. Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.
- C. Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
- D. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
Answer: A
NEW QUESTION # 27
You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?
- A. Automate instance creation by setting up Terraform scripts.
- B. Create the instances using the Google Cloud Console UI.
- C. Create clones from a template Cloud SQL instance.
- D. Automate instance creation by writing a Dataflow job.
Answer: A
NEW QUESTION # 28
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 a Biglable cluster with autoscaling.
- C. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
- 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 # 29
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 store backups on tapes on-premises.
- 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 use Actifio to store backup files on Cloud Storage using the Nearline Storage class.
- D. Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.
Answer: C
Explanation:
https://www.actifio.com/solutions/cloud/google/
NEW QUESTION # 30
Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?
- A. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
- B. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
- C. Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
- D. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.
Answer: B
Explanation:
"Read replicas do not have the cloudsql.iam_authentication flag enabled automatically when it is enabled on the primary instance." https://cloud.google.com/sql/docs/postgres/replication/create-replica#configure_iam_replicas
NEW QUESTION # 31
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 Google Cloud VMware Engine
- B. Migrate to Bare Metal Solution for Oracle.
- C. Migrate to Google Kubernetes Engine (GKE)
- D. Migrate to Compute Engine.
Answer: D
NEW QUESTION # 32
You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?
- A. Turn on automated backup, and turn on transaction log retention.
- B. Turn on automated backup, and turn off transaction log retention.
- C. Take one manual backup per day, and turn off transaction log retention.
- D. Take no backups, and turn off transaction log retention.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/backup-recovery/backups
NEW QUESTION # 33
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. Identify and optimize slow running queries, or set parallel replication flags.
- B. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
- C. Edit the primary instance to add additional memory.
- D. Stop all running queries, and re-create the replicas.
Answer: B
NEW QUESTION # 34
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 VM in Compute Engine, and run a cron job.
- B. Create a Cloud Composer instance, and create a directed acyclic graph (DAG).
- C. Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.
- D. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
Answer: D
NEW QUESTION # 35
Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?
- A. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in compressed format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance. - B. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance. - C. Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
Schedule downtime to run each Cloud Data Fusion pipeline.
Verify that the migration was successful.
Re-point the applications to the Cloud SQL for MySQL instance. - D. Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.
Answer: D
Explanation:
https://cloud.google.com/database-migration/docs/mysql/configure-source-database To migrate the database while preserving transactions and minimizing downtime, you should use Database Migration Service. This service will allow you to migrate the database in a way that is transparent to your users and applications. It will also allow you to test the migration before you make it live, so that you can be sure that everything will work as expected.
NEW QUESTION # 36
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. Develop a custom data replication service to send data into BigQuery.
- B. Use Database Migration Service to replicate tables into BigQuery.
- C. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
- D. Use Cloud SQL federated queries.
Answer: C
NEW QUESTION # 37
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 a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
- B. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
- C. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
- D. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
Answer: B
NEW QUESTION # 38
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 store backups on tapes on-premises.
- 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 Compute Engine, and store backups on tapes on-premises.
- D. 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.
Answer: B
NEW QUESTION # 39
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. Schedule automated backups.
- D. Create a PostgreSQL database on-premises as the HA option.
- E. Enable point-in-time recovery.
Answer: D,E
NEW QUESTION # 40
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 compute instances update command to increase the number of vCPUs.
- B. Issue a gcloud sql instances patch command to increase the number of vCPUs.
- C. Back up the database, create an instance with additional vCPUs, and restore the database.
- D. Update a MySQL database flag to increase the number of vCPUs.
Answer: B
NEW QUESTION # 41
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?
- A. Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
- B. Create a clone database from a read replica database, and restore the clone in the same region.
- C. Create a clone database from a read replica database, and restore the clone into a different zone.
- D. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
Answer: D
Explanation:
Using import/export from last week is slow for large scale databases and will restore database from last week.
NEW QUESTION # 42
You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?
- A. Write a utility to scan database query logs.
- B. Use query tags to add application-centric database monitoring.
- C. Shut down and restart each application.
- D. Write a utility to scan application logs.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags
NEW QUESTION # 43
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 # 44
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 SQL Server Always On Availability Group dashboard.
- B. Use Cloud SQL instance monitoring.
- C. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
- D. Use Cloud SQL logs.
Answer: A
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 # 45
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. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
- B. Use backup and restore to roll out changes to higher environments.
- C. Use Liquibase to roll out changes to higher environments.
- D. Use replication to roll out changes to higher environments.
Answer: C
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 # 46
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. Develop a custom data replication service to send data into BigQuery.
- B. Use Database Migration Service to replicate tables into BigQuery.
- C. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
- D. Use Cloud SQL federated queries.
Answer: C
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 # 47
You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?
- A. Set up different organizations for each database type, and apply policy constraints at the organization level.
- B. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
- C. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
- D. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
Answer: B
NEW QUESTION # 48
......
Pass Your Professional-Cloud-Database-Engineer Exam Easily with Accurate PDF Questions: https://prepaway.dumptorrent.com/Professional-Cloud-Database-Engineer-braindumps-torrent.html