[UPDATED Jun-2023] Best Value Available Preparation Guide for Professional-Cloud-Database-Engineer Exam
1 Full Professional-Cloud-Database-Engineer Practice Test and 120 Unique Questions, Get it Now!
The Google Professional-Cloud-Database-Engineer certification is a valuable certification for professionals who want to demonstrate their expertise in designing, developing, and managing GCP databases. The certification is highly valued in the industry, and it provides the candidate with a competitive edge in the job market. The exam tests the candidate’s ability to design, develop, and administer GCP databases, and it requires a thorough understanding of GCP database services.
The Google Professional-Cloud-Database-Engineer certification exam is designed for professionals who are interested in demonstrating their expertise in designing and managing database solutions on the Google Cloud Platform. This certification is an excellent way for professionals to validate their skills and knowledge in working with cloud-based databases and to enhance their career prospects.
NEW QUESTION # 50
Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?
- A. Create a read replica, and then use the mysqldump utility to export each table.
- B. Use the mysqldump utility on the primary database instance to export the backup.
- C. Use Cloud SQL serverless exports.
- D. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
Answer: D
NEW QUESTION # 51
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. Run the Recommender API to identify overprovisioned instances.
- B. Use Query Insights to identify idle instances.
- C. Build indexes on heavily accessed tables.
- D. Remove inactive user accounts.
Answer: A
NEW QUESTION # 52
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. Identify all tables that do not have a primary key.
- C. Identity all tables that do not have at least one foreign key.
- D. Identify whether the database has over 512 tables.
- E. Identify whether the source database uses customer-managed encryption keys (CMEK).
Answer: C,E
NEW QUESTION # 53
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 Memorystore for Redis with multi-zones within a region.
- B. Use Cloud SQL for PostgreSQL with cross-region replicas.
- C. Use Bigtable with multi-region clusters.
- D. Use Cloud Spanner with multi-region configuration.
Answer: B
NEW QUESTION # 54
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. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
- B. Use Database Migration Service to migrate your database.
- C. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
- D. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
Answer: C
NEW QUESTION # 55
Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?
- A. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
- B. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.
- C. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
- D. Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
Answer: B
NEW QUESTION # 56
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. Deploy a US multi-region Firestore location.
- B. Create a Firestore index on the news story date.
- C. Enable serializable isolation in the Firebase app.
- D. Build a Firestore bundle, and deploy bundles to Cloud CDN.
Answer: D
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. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
- B. 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.
- 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 1 AM, and deny maintenance periods between November 1 and January 15.
Answer: A
NEW QUESTION # 58
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 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. - 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 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. - 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 # 59
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 Private Service Connect.
- B. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
- C. Set up Serverless VPC Access.
- D. Set up Traffic Director.
Answer: B
NEW QUESTION # 60
You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?
- A. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- B. Enable the Cloud SQL Admin API.
- C. Ensure that you are using an external (public) IP address interface.
- D. Check whether your service account has cloudsql.instances.connect permission.
Answer: A
NEW QUESTION # 61
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?
- A. Use Cloud SQL with cross-region replicas.
- B. Use Cloud Spanner in a regional configuration.
- C. Use zonal Cloud SQL without high availability (HA).
- D. Use high availability (HA) Cloud SQL with multiple zones.
Answer: A
NEW QUESTION # 62
You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?
- A. Turn on automated backup, and turn on transaction log retention.
- B. Take no backups, and turn off transaction log retention.
- C. Take one manual backup per day, and turn off transaction log retention.
- D. Turn on automated backup, and turn off transaction log retention.
Answer: C
NEW QUESTION # 63
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. Automate instance creation by writing a Dataflow job.
- B. Create clones from a template Cloud SQL instance.
- C. Create the instances using the Google Cloud Console UI.
- D. Automate instance creation by setting up Terraform scripts.
Answer: C
NEW QUESTION # 64
Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?
- A. Recommend solid-state drives (SSD).
- B. Recommend hard disk drives (HDD).
- C. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
- D. Recommend mixed storage types.
Answer: C
NEW QUESTION # 65
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?
- A. Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.
- B. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
- C. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
- D. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
Answer: B
NEW QUESTION # 66
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. Run the cron job on a Compute Engine instance to continue the export.
- C. Create a streaming Datatlow job to export the table.
- D. Set up Cloud Composer, and create a task to export the table daily.
Answer: D
NEW QUESTION # 67
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. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
- C. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
- D. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
Answer: B
NEW QUESTION # 68
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 with HA enabled, and create read replicas in 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 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
- D. 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.
Answer: B
NEW QUESTION # 69
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 # 70
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. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
- C. Edit the instance to change the storage type from HDD to SSD.
- D. Create a read replica of the instance with SSDs, and perform a failover to the new instance
Answer: B
NEW QUESTION # 71
You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:
Can read tables, views, and DDL
Can write rows to the tables
Can add columns and indexes
Cannot drop the database
What should you do?
- A. Assign the Cloud Spanner Admin role.
- B. Assign the Cloud Spanner Database Admin role.
- C. Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.
- D. Assign the Cloud Spanner Database User role.
Answer: D
NEW QUESTION # 72
Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?
- A. Use Cloud Spanner.
- B. Use Bigtable.
- C. Use Cloud SQL.
- D. Use Firestore.
Answer: C
NEW QUESTION # 73
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 two read-write Cloud SQL instances in two different zones with a standby instance in another region.
- B. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
- C. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
- D. Create one regional Cloud SQL instance with a read replica in another region.
Answer: A
NEW QUESTION # 74
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. Check the cloudsql.googleapis.com/postgres.log instance log.
- B. Perform the gcloud sql operations list command.
- C. Use Cloud Audit Logs to verify the status.
- D. Use the Google Cloud Console.
Answer: C
NEW QUESTION # 75
......
The Google Professional-Cloud-Database-Engineer certification exam is designed to test the skills and knowledge of professionals who are responsible for managing and designing databases on the Google Cloud Platform. This certification is part of the Google Cloud Certified program, which recognizes individuals who have demonstrated their expertise in using Google Cloud technology.
Get Instant Access to Professional-Cloud-Database-Engineer Practice Exam Questions: https://www.actual4dumps.com/Professional-Cloud-Database-Engineer-study-material.html
The Best Professional-Cloud-Database-Engineer Exam Study Material Premium Files and Preparation Tool: https://drive.google.com/open?id=1KmL36ik2ytucU9jRg59qG2_fZDMYxDF5