Get Special Discount Offer of Professional-Cloud-Database-Engineer Certification Exam Sample Questions and Answers
New Professional-Cloud-Database-Engineer Dumps For Preparing Google Cloud Certified Certified Google Exam Well
NEW QUESTION 45
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 instance in one region, the standby instance in a second region, and the read replica in a third region.
- B. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same 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: B
NEW QUESTION 46
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. Review application logs to identify database calls.
- B. White a Logs Explorer query to identify database queries with high execution times.
- C. View Cloud SQL operations to view historical query information.
- D. Use the Query Insights dashboard to identify high execution times.
Answer: D
NEW QUESTION 47
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 many smaller Cloud SQL instances.
- C. Use Cloud Spanner instead of Cloud SQL.
- D. Increase the number of CPUs for your instance.
Answer: C
NEW QUESTION 48
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 Compute Engine.
- B. Migrate to Google Cloud VMware Engine
- C. Migrate to Google Kubernetes Engine (GKE)
- D. Migrate to Bare Metal Solution for Oracle.
Answer: A
NEW QUESTION 49
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
- A. Use Data Migration Service.
- B. Use the mysqldump utility and binary logs.
- C. Use Cloud SQL for MySQL external replica.
- D. Use external server replication.
Answer: A
NEW QUESTION 50
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 the native export and import functionality of the source database.
- C. Use Database Migration Service.
- D. Create a database on Google Cloud, and use database links to perform the migration.
Answer: D
NEW QUESTION 51
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?
- A. Use the Google Cloud Console.
- B. Check the cloudsql.googleapis.com/postgres.log instance log.
- C. Use Cloud Audit Logs to verify the status.
- D. Perform the gcloud sql operations list command.
Answer: C
NEW QUESTION 52
You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?
- A. Ensure that the service account has the Storage Admin role.
- B. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- C. Increase the amount of memory allocated to your instance.
- D. Close idle connections or restart the instance before beginning the import operation.
Answer: A
NEW QUESTION 53
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 Database Migration Service to complete the migration.
- C. Use Datastream to complete the migration.
- D. Use Migrate for Compute Engine to complete the migration.
Answer: A
NEW QUESTION 54
You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?
- A. Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences
- B. Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
- C. Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
- D. Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
Answer: D
NEW QUESTION 55
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. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
- B. Use the default configuration for the automated backups location.
- C. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
- D. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
Answer: A
NEW QUESTION 56
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. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
- B. Identify and optimize slow running queries, or set parallel replication flags.
- C. Edit the primary instance to add additional memory.
- D. Stop all running queries, and re-create the replicas.
Answer: A
NEW QUESTION 57
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 HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
- D. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
Answer: B
NEW QUESTION 58
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 Cloud SQL for data storage.
- D. Use Bigtable for data storage.
Answer: C
NEW QUESTION 59
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 an external replica, and use Cloud SQL to synchronize the data to the replica.
- C. Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
- D. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
Answer: A
NEW QUESTION 60
Your organization is running a critical production database on a virtual machine (VM) on Compute Engine. The VM has an ext4-formatted persistent disk for data files. The database will soon run out of storage space. You need to implement a solution that avoids downtime. What should you do?
- A. In the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.
- B. In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.
- C. In the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.
- D. In the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use
Answer: C
NEW QUESTION 61
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. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
- B. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
- C. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
- D. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
Answer: D
NEW QUESTION 62
You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?
- A. Use Database Migration Service to migrate your database.
- B. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
- C. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
- D. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
Answer: C
NEW QUESTION 63
......
Updated Professional-Cloud-Database-Engineer Dumps Questions Are Available For Passing Google Exam: https://www.testsdumps.com/Professional-Cloud-Database-Engineer_real-exam-dumps.html
Free UPDATED Google Professional-Cloud-Database-Engineer Certification Exam Dumps is Online: https://drive.google.com/open?id=19UY6iafyGtsYE5UGLe1dwmSxYNSXiz61
