Get 100% Authentic Google Professional-Cloud-Database-Engineer Dumps with Correct Answers
New Training Course Professional-Cloud-Database-Engineer Tutorial Preparation Guide
NEW QUESTION 47
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. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
- C. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
- D. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
Answer: C
NEW QUESTION 48
You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?
- A. Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
- B. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
- C. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
- D. Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
Answer: B
NEW QUESTION 49
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 one regional Cloud SQL instance with a read replica in another region.
- B. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
- C. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
- D. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
Answer: B
NEW QUESTION 50
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. Use many smaller Cloud SQL instances.
- B. Increase the storage size for the instance.
- C. Increase the number of CPUs for your instance.
- D. Use Cloud Spanner instead of Cloud SQL.
Answer: D
NEW QUESTION 51
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-west1-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-east-b.
Create a read replica in us-east1-c. - D. 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.
Answer: D
NEW QUESTION 52
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. BigQuery
- D. Bigtable
Answer: C
NEW QUESTION 53
Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?
- A. Create a database on Google Cloud, and use database links to perform the migration.
- B. Create a database on Google Cloud, and use Dataflow for database migration.
- C. Use the native export and import functionality of the source database.
- D. Use Database Migration Service.
Answer: A
NEW QUESTION 54
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 Cloud Functions to run the export in text format.
- B. Use Dataflow to run the export in Avro format.
- C. Use Cloud Functions to run the export in Avro format.
- D. Use Dataflow to run the export in text format.
Answer: B
NEW QUESTION 55
Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?
- A. Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.
- B. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
- C. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
- D. Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
Answer: C
NEW QUESTION 56
You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?
- A. Configure Cloud SQL for PostgreSQL read replicas to offload queries.
- B. Configure Bigtable, and modify your application to offload queries.
- C. Configure Memorystore, and modify your application to offload queries.
- D. Configure Firestore, and modify your application to offload queries.
Answer: C
NEW QUESTION 57
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. 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.
- C. Create secondary indexes on the replica.
- D. 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.
- E. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
Answer: A,E
NEW QUESTION 58
You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?
- A. Use Cloud Spanner with multi-region configuration.
- B. Use Cloud SQL for PostgreSQL with cross-region replicas.
- C. Use Bigtable with multi-region clusters.
- D. Use Memorystore for Redis with multi-zones within a region.
Answer: B
NEW QUESTION 59
You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?
- A. Create a new service account, and grant it the Cloud Spanner Database Admin role.
- B. Create a new service account, and grant it the spanner.databases.select permission.
- C. Create a new service account, and grant it the Cloud Spanner Database Reader role.
- D. Reuse the existing service account that populates this database.
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 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 - D. 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
Answer: A
NEW QUESTION 61
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 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.
- B. 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.
- C. Set up all read replicas in a different region using asynchronous replication.
- D. Set up all read replicas in the same region as the primary instance with synchronous replication.
Answer: B
NEW QUESTION 62
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. Use Datastream to complete the migration.
- C. Use Database Migration Service to complete the migration.
- D. Export the data from the existing database, and load the data into a new Cloud SQL database.
Answer: D
NEW QUESTION 63
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 and standby instances in zone A 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 instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
- D. Configure the primary, standby, and read replica instances in zone A, all in the same region.
Answer: A
NEW QUESTION 64
You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?
- A. Reduce the number of automated backups that are retained to two (2).
- B. Set the automated backups to occur every other day to lower the frequency of backups.
- C. Select a different region to store your backups.
- D. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
Answer: B
NEW QUESTION 65
You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
Work with transactions and offer strong consistency.
Work with structured and semi-structured (JSON) data.
Scale transparently to multiple regions globally as the operation grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?
- A. Use a Bigtable instance with clusters in multiple regions.
- B. Use Firestore in Datastore mode.
- C. Use Cloud Spanner in a multi-region configuration.
- D. Use Cloud SQL for PostgreSQL with both cross-region read replicas.
Answer: D
NEW QUESTION 66
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. 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.
- C. 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.
- 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 67
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. Build a Firestore bundle, and deploy bundles to Cloud CDN.
- C. Deploy a US multi-region Firestore location.
- D. Enable serializable isolation in the Firebase app.
Answer: B
NEW QUESTION 68
......
Dumps of Professional-Cloud-Database-Engineer Cover all the requirements of the Real Exam: https://www.pass4cram.com/Professional-Cloud-Database-Engineer_free-download.html
Correct Practice Tests of Professional-Cloud-Database-Engineer Dumps with Practice Exam: https://drive.google.com/open?id=1LtlzW1g1UK1_MtlN-5XheRB05I4vStZW