2024 Verified Professional-Cloud-Database-Engineer dumps Q&As on your Google Cloud Certified Exam Questions Certain Success!
Professional-Cloud-Database-Engineer Exam Dumps - 100% Marks In Professional-Cloud-Database-Engineer Exam!
Achieving the Google Professional-Cloud-Database-Engineer certification demonstrates to employers and clients that you have the knowledge and skills needed to design, develop, and manage cloud-based database solutions using Google Cloud. It can also open up new career opportunities and increase earning potential.
The Google Professional-Cloud-Database-Engineer exam covers a wide range of topics related to database management, including database design, data modeling, database administration, data backup and recovery, and performance tuning. Candidates are also tested on their ability to use various Google Cloud tools and services, such as Cloud SQL, Cloud Spanner, and Bigtable.
NEW QUESTION # 39
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?
- A. Create a Firestore index on the news story date.
- B. Deploy a US multi-region Firestore location.
- C. Build a Firestore bundle, and deploy bundles to Cloud CDN.
- D. Enable serializable isolation in the Firebase app.
Answer: C
NEW QUESTION # 40
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
- A. Set up all read replicas in the same region as the primary instance with synchronous replication.
- B. Set up all read replicas in a different region using asynchronous replication.
- C. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
- D. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
Answer: C
Explanation:
This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed1. This minimizes data loss and downtime in case of a zonal or an instance failure, and allows for a quick failover to the standby instance1.
This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2. This provides additional redundancy and backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.
NEW QUESTION # 41
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 # 42
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. Take nightly snapshots of the primary database instance, and restore them in a secondary zone.
- B. Create a read replica in another region, and promote the read replica if a failure occurs.
- C. Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
- D. Enable high availability (HA) for the database to make it regional.
Answer: D
NEW QUESTION # 43
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-east-b.
Create a read replica in us-east1-c. - B. 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. - 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 # 44
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 Cloud SQL.
- 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 Compute Engine.
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 # 45
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 Cloud SQL for PostgreSQL.
- B. Migrate the existing database to PostgreSQL running on Compute Engine.
- C. Migrate the existing database to Cloud Spanner.
- D. Migrate the existing database to Firestore.
Answer: A
NEW QUESTION # 46
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
- A. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
- B. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
- C. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
- D. Move the physical database servers from on-premises to Google Cloud.
- E. Use a change data capture (CDC) migration strategy.
Answer: B,E
Explanation:
https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer
NEW QUESTION # 47
You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?
- A. Use Cloud Scheduler and Cloud Functions to run the daily export.
- B. Set up Cloud Composer, and create a task to export the table daily.
- C. Run the cron job on a Compute Engine instance to continue the export.
- D. Create a streaming Datatlow job to export the table.
Answer: B
NEW QUESTION # 48
You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?
- A. Set up Traffic Director.
- B. Set up Private Service Connect.
- C. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
- D. Set up Serverless VPC Access.
Answer: C
Explanation:
https://medium.com/google-cloud/shared-vpc-in-google-cloud-64527e0a409e#:~:text=Unlike%20VPC%20peering%2C%20Shared%20VPC%20connects%20projects%20within%20the%20same%20organization.&text=There%20are%20a%20lot%20of,between%20VPCs%20in%20different%20projects.
NEW QUESTION # 49
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?
- A. Set up Cloud NAT service.
- B. Set up bring your own IP (BYOIP) in your VPC.
- C. Set up a Cloud NAT gateway on the Compute Engine VM.
- D. Setup a static external IP address in your VPC network.
Answer: C
NEW QUESTION # 50
You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?
- A. Bring DB-1 back online.
- B. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
- C. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
- D. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
Answer: B
Explanation:
If you need to have the primary instance in the zone that had the outage, you can do a failback. A failback performs the same steps as the failover, only in the opposite direction, to reroute traffic back to the original instance. To perform a failback, use the procedure in Initiating failover. https://cloud.google.com/sql/docs/mysql/high-availability#failback
NEW QUESTION # 51
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 a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
- B. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
- C. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
- D. 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.
Answer: B
Explanation:
Cloud Monitoring collects metrics, events, and metadata from Google Cloud, Amazon Web Services (AWS), hosted uptime probes, and application instrumentation. Using the BindPlane service, you can also collect this data from over 150 common application components, on-premise systems, and hybrid cloud systems.
NEW QUESTION # 52
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 # 53
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 a cross-region read replica to migrate the databases to Cloud SQL.
- B. Use a read replica to migrate the databases to Cloud SQL.
- C. Use an external 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 Database Migration Service to migrate the databases to Cloud SQL.
Answer: D,E
NEW QUESTION # 54
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?
- A. Create a Firestore index on the news story date.
- B. Deploy a US multi-region Firestore location.
- C. Build a Firestore bundle, and deploy bundles to Cloud CDN.
- D. Enable serializable isolation in the Firebase app.
Answer: C
Explanation:
A global audience strongly suggests serving content via Google's Content Delivery Network. Changing the isolation level won't decrease cost or latency
NEW QUESTION # 55
Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?
- A. Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.
- B. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
- C. Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.
- D. Use Memorystore to handle your low-latency requirements and for real-time analytics.
Answer: B
Explanation:
Start with the lowest tier and smallest size and then grow your instance as needed. Memorystore provides automated scaling using APIs, and optimized node placement across zones for redundancy. Memorystore for Memcached can support clusters as large as 5 TB, enabling millions of QPS at very low latency
NEW QUESTION # 56
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?
- A. Restore the Cloud SQL instance from the automatic backups in another zone in region 1.
- B. Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .
- C. Restore the Cloud SQL instance from the automatic backups in region 3.
- D. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery
NEW QUESTION # 57
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 # 58
Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?
- A. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
- B. Edit the instance to change the storage type from HDD to SSD.
- C. Create a read replica of the instance with SSDs, and perform a failover to the new instance
- D. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
Answer: A
Explanation:
https://stackoverflow.com/questions/72034607/can-i-change-storage-type-from-hdd-to-ssd-on-cloud-sql-after-creating-an-instanc
NEW QUESTION # 59
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 all flash storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket. - B. 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. - 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: B
NEW QUESTION # 60
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. Create a PostgreSQL database on-premises as the HA option.
- B. Enable point-in-time recovery.
- C. Set up manual backups.
- D. Configure single zone availability for automated backups.
- E. Schedule automated backups.
Answer: B,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 # 61
You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?
- A. Use Cloud SQL with read replicas for throughput.
- B. Use Bigtable, and add nodes as necessary to achieve the required throughput.
- C. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
- D. Use Firestore, and rely on automatic serverless scaling.
Answer: C
NEW QUESTION # 62
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 # 63
......
Pass Your Professional-Cloud-Database-Engineer Exam Easily With 100% Exam Passing Guarantee: https://www.testkingpdf.com/Professional-Cloud-Database-Engineer-testking-pdf-torrent.html
Exam Dumps Use Real Google Cloud Certified Dumps With 134 Questions: https://drive.google.com/open?id=14YABW55XvLNtd_6zrPpreEm4ReFzEens
