[Jun 11, 2023] Today Updated Professional-Cloud-Database-Engineer Exam Dumps Actual Questions
Professional-Cloud-Database-Engineer exam dumps with real Google questions and answers
NEW QUESTION # 69
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. Use replication to roll out changes to higher environments.
- B. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
- C. Use backup and restore to roll out changes to higher environments.
- D. Use Liquibase to roll out changes to higher environments.
Answer: C
NEW QUESTION # 70
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 Dataflow to run the export in Avro format.
- B. Use Cloud Functions to run the export in text format.
- C. Use Cloud Functions to run the export in Avro format.
- D. Use Dataflow to run the export in text format.
Answer: A
NEW QUESTION # 71
You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?
- A. Specify an authorized network with the CIDR range of the VM.
- B. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
- C. Disable and remove the internal IP address assignment.
- D. Disable and remove the external IP address assignment.
Answer: B
NEW QUESTION # 72
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. Stop all running queries, and re-create the replicas.
- C. Edit the primary instance to add additional memory.
- D. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
Answer: D
NEW QUESTION # 73
Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?
- A. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupAdmin for Application C - B. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner databaseReader for Application C - C. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner.backupWriter for Application C - D. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupWriter for Application C
Answer: A
NEW QUESTION # 74
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. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods 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. 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. 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: B
NEW QUESTION # 75
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. Use the default app profile with multi-cluster routing.
- B. Create a custom app profile with multi-cluster routing.
- C. Create a custom app profile with single-cluster routing.
- D. Use the default app profile with single-cluster routing.
Answer: D
NEW QUESTION # 76
You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process dat a. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?
- A. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
- B. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
- C. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
- D. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
Answer: A
NEW QUESTION # 77
Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)
- A. Use an auto-incrementing value as the primary key.
- B. Promote low-cardinality attributes in multi-attribute primary keys.
- C. Promote high-cardinality attributes in multi-attribute primary keys.
- D. Use bit-reverse sequential value as the primary key.
- E. Normalize the data model.
Answer: A,C
NEW QUESTION # 78
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 Firestore.
- B. Use Cloud Spanner.
- C. Use Cloud SQL with an external (public) IP address.
- D. Use an in-app embedded database.
Answer: C
NEW QUESTION # 79
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 highly available Cloud SQL with multiple zones.
- B. Use Cloud Spanner in a multi-region configuration.
- C. Use Cloud SQL with cross-region replicas.
- D. Use Cloud Spanner in a regional configuration.
Answer: D
NEW QUESTION # 80
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
- A. Migrate applications and Oracle databases to Compute Engine.
- B. Migrate applications to Cloud SQL.
- C. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
- D. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
Answer: C
NEW QUESTION # 81
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. 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.
- B. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
- C. Create secondary indexes on the replica.
- D. Create additional read replicas, and partition your analytics users to use different read replicas.
- E. 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.
Answer: B,D
NEW QUESTION # 82
Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?
- A. Create migration job using Database Migration Service.
Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode.
Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete.
Update your application connections to the new instance. - B. Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window.
Move the files to Cloud Storage, and import each database into your Cloud SQL instance.
Continue to dump each database until all the databases are migrated.
Update your application connections to the new instance. - C. Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL.
Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination.
Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance. - D. Create migration job using Database Migration Service.
Set the migration job type to One-time, and perform this migration during a maintenance window.
Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database.
Update your application connections to the new instance.
Answer: D
NEW QUESTION # 83
You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?
- A. Use direct scaling to implement the Autoscaler-based architecture.
- B. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
- C. Use linear scaling to implement the Autoscaler-based architecture
- D. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
Answer: B
NEW QUESTION # 84
You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)
- A. Identify whether the source database is encrypted using pgcrypto extension.
- B. Identity all tables that do not have at least one foreign key.
- C. Identify all tables that do not have a primary key.
- D. Identify whether the database has over 512 tables.
- E. Identify whether the source database uses customer-managed encryption keys (CMEK).
Answer: B,E
NEW QUESTION # 85
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 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
- B. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
- C. 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.
- D. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
Answer: A
NEW QUESTION # 86
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 Logs Explorer to analyze log data.
- D. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
Answer: D
NEW QUESTION # 87
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, increase the size of the persistent disk, and use the resize2fs command to extend the disk.
- B. 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
- C. 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.
- D. 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.
Answer: D
NEW QUESTION # 88
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. Build indexes on heavily accessed tables.
- B. Run the Recommender API to identify overprovisioned instances.
- C. Use Query Insights to identify idle instances.
- D. Remove inactive user accounts.
Answer: B
NEW QUESTION # 89
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. Create clones from a template Cloud SQL instance.
- B. Create the instances using the Google Cloud Console UI.
- C. Automate instance creation by setting up Terraform scripts.
- D. Automate instance creation by writing a Dataflow job.
Answer: B
NEW QUESTION # 90
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. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
- B. 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.
- C. 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.
- D. 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.
Answer: C
NEW QUESTION # 91
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. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
- C. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
- D. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
Answer: C
NEW QUESTION # 92
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?
- A. For each application code, set up a dedicated user account.
- B. For the application server, set up a common shared user account.
- C. For the application server, set up a service account.
- D. For each application code, set up a common shared user account.
Answer: A
NEW QUESTION # 93
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. Create a database on Google Cloud, and use database links to perform the migration.
- C. Use Database Migration Service.
- D. Use the native export and import functionality of the source database.
Answer: B
NEW QUESTION # 94
......
The 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. The exam can be taken online or in-person at a Google Cloud testing center.
Exam Sure Pass Google Certification with Professional-Cloud-Database-Engineer exam questions: https://www.testbraindump.com/Professional-Cloud-Database-Engineer-exam-prep.html
Professional-Cloud-Database-Engineer Exam in First Attempt Guaranteed: https://drive.google.com/open?id=1ozFwHaGujz5sQni-coXYIcVu5sG3dkEm
