[2024] Verified Professional-Cloud-Database-Engineer Dumps Q&As - 1 Year Free & Quickly Updates
Latest 2024 Realistic Verified Professional-Cloud-Database-Engineer Dumps - 100% Free Professional-Cloud-Database-Engineer Exam Dumps
Google Professional-Cloud-Database-Engineer certification exam is designed for individuals who possess advanced skills and knowledge in managing databases on the Google Cloud Platform. Google Cloud Certified - Professional Cloud Database Engineer certification is designed to validate your ability to design, develop, and administer scalable and secure databases on Google Cloud. Google Cloud Certified - Professional Cloud Database Engineer certification exam is intended for database administrators, database developers, and other IT professionals who want to demonstrate their expertise in managing databases on the Google Cloud Platform.
To pass the certification exam, candidates must demonstrate their ability to design, implement, and manage databases on the Google Cloud Platform. They must also show proficiency in monitoring, troubleshooting, and optimizing database performance. Professional-Cloud-Database-Engineer exam covers a range of topics, including database migration, data modeling, backup and recovery, and security. Google Cloud Certified - Professional Cloud Database Engineer certification exam is designed to help employers identify qualified professionals who have the expertise needed to develop and maintain efficient, scalable, and secure databases on the Google Cloud Platform.
To prepare for the exam, candidates can take advantage of various resources provided by Google Cloud, such as online courses, documentation, and practice exams. They can also attend instructor-led training or join study groups to learn from other professionals.
NEW QUESTION # 18
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 Database Admin role.
- B. Assign the Cloud Spanner 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
Explanation:
https://cloud.google.com/spanner/docs/iam#spanner.databaseUser
NEW QUESTION # 19
Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?
- A. Create the database persistent disk with Google-managed encryption keys.
- B. Create the database persistent disk with customer-managed encryption keys.
- C. Create the database with Google-managed encryption keys.
- D. Create the database with customer-managed encryption keys.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/postgres/configure-cmek#createcmekinstance
NEW QUESTION # 20
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. 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. - C. 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. - 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: B
Explanation:
https://cloud.google.com/datastream/docs/overview.
NEW QUESTION # 21
Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?
- A. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
- B. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
- C. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
- D. Migrate all the databases to Cloud SQL.
Answer: C
NEW QUESTION # 22
You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?
- A. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
- B. Use Bigtable, and add nodes as necessary to achieve the required throughput.
- C. Use Firestore, and rely on automatic serverless scaling.
- D. Use Cloud SQL with read replicas for throughput.
Answer: A
NEW QUESTION # 23
You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?
- A. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
- B. Set up different organizations for each database type, and apply policy constraints at the organization level.
- C. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
- D. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
Answer: B
NEW QUESTION # 24
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 Spanner in a regional configuration.
- B. Use Cloud SQL with cross-region replicas.
- C. Use zonal Cloud SQL without high availability (HA).
- D. Use high availability (HA) Cloud SQL with multiple zones.
Answer: A
Explanation:
https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform
NEW QUESTION # 25
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer dat a. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?
- A. Apply an instance data management pattern.
- B. Apply a database data management pattern.
- C. Apply a table data management pattern.
- D. Apply a schema data management pattern.
Answer: A
NEW QUESTION # 26
Your team is building an application that stores and analyzes streaming time series financial dat a. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?
- A. Use Bigtable
- B. Use Cloud Spanner.
- C. Use BigQuery.
- D. Use Firestore.
Answer: C
NEW QUESTION # 27
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. Increase the amount of memory allocated to your instance.
- B. Close idle connections or restart the instance before beginning the import operation.
- C. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- D. Ensure that the service account has the Storage Admin role.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#troubleshooting
NEW QUESTION # 28
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. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
- C. Use Database Migration Service to migrate your database.
- D. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
Answer: D
Explanation:
PgBouncer maintains a pool for connections for each database and user combination. PgBouncer either creates a new database connection for a client or reuses an existing connection for the same user and database. + PgBouncer is a simple PostgreSQL connection pool that allows for several thousand connections at a time. Using Kubernetes Engine to run a Helm Chart w/ PgBouncer based on the great article from futuretech-industries, we were able to set up an easily deployable system to get the most out of our CloudSQL DBs without breaking the bank. https://medium.com/google-cloud/increasing-cloud-sql-postgresql-max-connections-w-pgbouncer-kubernetes-engine-49b0b2894820#:~:text=That%20is%20where,breaking%20the%20bank.
NEW QUESTION # 29
Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?
- A. Create the database with customer-managed encryption keys.
- B. Create the database persistent disk with customer-managed encryption keys.
- C. Create the database persistent disk with Google-managed encryption keys.
- D. Create the database with Google-managed encryption keys.
Answer: B
NEW QUESTION # 30
You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:
configure where data is stored
control where the encryption keys are stored
govern the access to data
What should you do?
- A. Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.
- B. Replicate Cloud SQL databases across different zones.
- C. Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.
- D. Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
Answer: D
Explanation:
https://cloud.google.com/blog/products/identity-security/meet-data-residency-requirements-with-google-cloud
NEW QUESTION # 31
Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?
- A. Watch Query Insights for long running queries.
- B. Watch Cloud Trace for application requests that are failing.
- C. Watch the Cloud SQL recommenders for overprovisioned instances.
- D. Watch the Cloud SQL instance monitor for CPU utilization metrics.
Answer: A
Explanation:
Cloud Trace doesn't support Cloud SQL. Eliminate D. Cloud SQL recommenders for overprovisioned instances would tell you about Cloud SQL instances which are too large for their workload. Eliminate C. Monitoring CPU utilization wouldn't tell you why microservice calls are failing. Eliminate B. SQLcommenter integrates with Query Insights. So A is the best answer. https://cloud.google.com/blog/topics/developers-practitioners/introducing-sqlcommenter-open-source-orm-auto-instrumentation-library
NEW QUESTION # 32
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. Use the mysqldump utility on the primary database instance to export the backup.
- B. Create a read replica, and then use the mysqldump utility to export each table.
- 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 # 33
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 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 - C. 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 - 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 # 34
You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?
- A. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Connect to the instance using a connection pool to best manage connections to the instance. - B. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Use Cloud SQL Auth proxy to connect to the instance. - C. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Connect to the instance using a connection pool to best manage connections to the instance. - D. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Use Cloud SQL Auth proxy to connect to the instance.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/connect-run#configure https://cloud.google.com/sql/docs/mysql/connect-run#connection-pools
NEW QUESTION # 35
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: A
Explanation:
"Deny maintenance period. A block of days in which Cloud SQL does not schedule maintenance. Deny maintenance periods can be up to 90 days long. " https://cloud.google.com/sql/docs/mysql/maintenance
NEW QUESTION # 36
Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?
- A. Normalize the database to the third normal form.
- B. Create another schema to load older data.
- C. Compress the data using a different compression algorithm.
- D. Manually or automatically increase the storage capacity.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/mysql/instance-settings#storage-capacity-2ndgen
NEW QUESTION # 37
......
Professional-Cloud-Database-Engineer Dumps PDF and Test Engine Exam Questions: https://www.braindumpquiz.com/Professional-Cloud-Database-Engineer-exam-material.html
Get 2024 Updated Free Google Professional-Cloud-Database-Engineer Exam Questions and Answer: https://drive.google.com/open?id=1IXIfiWvpLOi3P7oEhi4o7gLyQFgqVG6h