Easily To Pass New Professional-Cloud-Database-Engineer Verified & Correct Answers [Apr 22, 2023
Free Professional-Cloud-Database-Engineer Exam Files Downloaded Instantly
NEW QUESTION 13
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 Bigtable for data storage.
- C. Use Cloud SQL for data storage.
- D. Use Memorystore for data storage.
Answer: C
NEW QUESTION 14
You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?
- A. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
- B. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
- C. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
- D. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
Answer: B
NEW QUESTION 15
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. Add more read-write replicas.
- 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. Use staleness of at least 15 seconds.
Answer: A
NEW QUESTION 16
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 17
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. Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
- B. Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
- C. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
- D. Create an external replica, and use Cloud SQL to synchronize the data to the replica.
Answer: A
NEW QUESTION 18
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 failover replica from backup.
- B. Start the original primary instance and resume replication.
- 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: A
NEW QUESTION 19
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 Compute Engine.
- B. Migrate the Oracle databases to Cloud Spanner.
- C. Migrate the Oracle databases to Cloud SQL.
- D. Migrate the Oracle databases to Bare Metal Solution for Oracle.
Answer: C
NEW QUESTION 20
Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?
- A. Use Bigtable.
- B. Use Cloud SQL for MySQL
- C. Use Firestore.
- D. Use Cloud Spanner.
Answer: B
NEW QUESTION 21
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 number of CPUs for your instance.
- C. Use Cloud Spanner instead of Cloud SQL.
- D. Increase the storage size for the instance.
Answer: C
NEW QUESTION 22
You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA.
You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?
- A. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
- B. Use interleaving to co-locate parent and child rows.
- C. Manually scale down the number of nodes after the peak period has passed.
- D. Use granular instance sizing in Cloud Spanner and Autoscaler.
Answer: A
NEW QUESTION 23
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 Cloud SQL with an external (public) IP address.
- B. Use Firestore.
- C. Use an in-app embedded database.
- D. Use Cloud Spanner.
Answer: A
NEW QUESTION 24
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.READ_STATS* tables.
- B. Use SQL statements to analyze SPANNER_SYS.QUERY_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: C
NEW QUESTION 25
You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?
- A. Use Cloud SQL with cross-region replicas.
- B. Use Cloud Spanner in a multi-region configuration.
- C. Use highly available Cloud SQL with multiple zones.
- D. Use Cloud Spanner in a regional configuration.
Answer: D
NEW QUESTION 26
You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?
- A. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.
- B. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
- C. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
- D. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
Answer: A
NEW QUESTION 27
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 Dataflow for database migration.
- B. Use Database Migration Service.
- C. Use the native export and import functionality of the source database.
- D. Create a database on Google Cloud, and use database links to perform the migration.
Answer: D
NEW QUESTION 28
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. Build indexes on heavily accessed tables.
- D. Run the Recommender API to identify overprovisioned instances.
Answer: D
NEW QUESTION 29
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. Back up the database, create an instance with additional vCPUs, and restore the database.
- B. Issue a gcloud sql instances patch command to increase the number of vCPUs.
- C. Update a MySQL database flag to increase the number of vCPUs.
- D. Issue a gcloud compute instances update command to increase the number of vCPUs.
Answer: B
NEW QUESTION 30
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. 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.
- B. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
- C. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
- D. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
Answer: D
NEW QUESTION 31
You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?
- A. Create a custom app profile with single-cluster routing.
- B. Create a custom app profile with multi-cluster routing.
- C. Use the default app profile with multi-cluster routing.
- D. Use the default app profile with single-cluster routing.
Answer: D
NEW QUESTION 32
You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)
- A. Drop or disable all users except database administration users.
- B. Disable all foreign key constraints on the source PostgreSQL database.
- C. Shut down the database before the Data Migration Service task is started.
- D. Ensure that pglogical is installed on the source PostgreSQL database.
- E. Ensure that all PostgreSQL tables have a primary key.
Answer: B,D
NEW QUESTION 33
Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?
- A. Migrate to Google Kubernetes Engine (GKE).
- B. Migrate to Cloud SQL for SQL Server.
- C. Migrate to Cloud SQL for PostgreSQL.
- D. Migrate to Compute Engine.
Answer: C
NEW QUESTION 34
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. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
- D. Select a different region to store your backups.
Answer: B
NEW QUESTION 35
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. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
- D. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
Answer: B
NEW QUESTION 36
You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?
- A. Use Bigtable with default encryption.
- B. Use Cloud SQL with a customer-managed encryption key (CMEK).
- C. Use Cloud Spanner with default encryption.
- D. Use Cloud Spanner with a customer-managed encryption key (CMEK).
Answer: B
NEW QUESTION 37
......
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 |
|
100% Pass Guaranteed Free Professional-Cloud-Database-Engineer Exam Dumps: https://examsboost.pass4training.com/Professional-Cloud-Database-Engineer-test-questions.html
