2024 Updated Verified Pass Professional-Cloud-Database-Engineer Study Guides & Best Courses
Ultimate Guide to the Professional-Cloud-Database-Engineer - Latest Edition Available Now
The Google Professional-Cloud-Database-Engineer exam consists of multiple-choice and multiple-select questions, as well as scenario-based questions that require candidates to solve real-world problems. Professional-Cloud-Database-Engineer exam covers a range of topics, including database design, data modeling, data processing, data security, backup and recovery, and performance optimization.
NEW QUESTION # 28
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)
- A. Use an external read replica to migrate the databases to Cloud SQL.
- B. Use a read replica to migrate the databases to Cloud SQL.
- C. Use Database Migration Service to migrate the databases to Cloud SQL.
- D. Use a cross-region read replica to migrate the databases to Cloud SQL.
- E. Use replication from an external server to migrate the databases to Cloud SQL.
Answer: B,E
NEW QUESTION # 29
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 Cloud SQL.
- B. Migrate the Oracle databases to Compute Engine.
- C. Migrate the Oracle databases to Cloud Spanner.
- D. Migrate the Oracle databases to Bare Metal Solution for Oracle.
Answer: A
NEW QUESTION # 30
Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)
- A. Create a PostgreSQL database on-premises as the HA option.
- B. Schedule automated backups.
- C. Set up manual backups.
- D. Configure single zone availability for automated backups.
- E. Enable point-in-time recovery.
Answer: B,E
Explanation:
D) Enable point-in-time recovery - This feature allows you to restore your database to a specific point in time. It helps protect against data loss and can be used in the event of data corruption or accidental data deletion. E. Schedule automated backups - Automated backups allow you to take regular backups of your database without manual intervention. You can use these backups to restore your database in the event of data loss or corruption.
NEW QUESTION # 31
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. Take one manual backup per day, and turn off transaction log retention.
- B. Turn on automated backup, and turn on transaction log retention.
- C. Turn on automated backup, and turn off transaction log retention.
- D. Take no backups, and turn off transaction log retention.
Answer: A
NEW QUESTION # 32
Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?
- A. BigQuery
- B. Cloud SQL
- C. Cloud Spanner
- D. Bigtable
Answer: A
NEW QUESTION # 33
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 Google-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 customer-managed encryption keys.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/postgres/configure-cmek#createcmekinstance
NEW QUESTION # 34
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?
- A. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.
- B. Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .
- C. Restore the Cloud SQL instance from the automatic backups in region 3.
- D. Restore the Cloud SQL instance from the automatic backups in another zone in region 1.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery
NEW QUESTION # 35
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. Enable the Cloud SQL Admin API.
- B. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- C. Check whether your service account has cloudsql.instances.connect permission.
- D. Ensure that you are using an external (public) IP address interface.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/connect-auth-proxy#troubleshooting C because in docs it says "Make sure to enable the Cloud SQL Admin API. If it is not, you see output like Error 403: Access Not Configured in your Cloud SQL
NEW QUESTION # 36
An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?
- A. roles/cloudsql.viewer and roles/spanner.databaseUser
- B. roles/cloudsql.instanceUser and roles/spanner.databaseUser
- C. roles/cloudsql.editor and roles/spanner.admin
- D. roles/cloudsql.client and roles/spanner.databaseReader
Answer: D
NEW QUESTION # 37
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 Bigtable with multi-region clusters.
- C. Use Cloud Spanner with multi-region configuration.
- D. Use Cloud SQL for PostgreSQL with cross-region replicas.
Answer: D
NEW QUESTION # 38
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. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
- B. Create a read replica, and then use the mysqldump utility to export each table.
- C. Use the mysqldump utility on the primary database instance to export the backup.
- D. Use Cloud SQL serverless exports.
Answer: D
Explanation:
https://cloud.google.com/blog/products/databases/introducing-cloud-sql-serverless-exports
NEW QUESTION # 39
During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?
- A. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
- B. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
- C. Shut down your existing Cloud SQL for MySQL instance, and enable HA.
- D. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
Answer: B
NEW QUESTION # 40
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, standby, and read replica instances in zone A, all in the same region.
- B. 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.
- C. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
- D. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
Answer: C
NEW QUESTION # 41
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 with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.
- B. 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.
- C. 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.
- D. 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.
Answer: A
NEW QUESTION # 42
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 Google-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 customer-managed encryption keys.
Answer: B
NEW QUESTION # 43
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 the instances using the Google Cloud Console UI.
- C. Automate instance creation by setting up Terraform scripts.
- D. Create clones from a template Cloud SQL instance.
Answer: C
NEW QUESTION # 44
Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this dat a. What should you do?
- A. Use Google Cloud Armor to add IP addresses to an allowlist.
- B. Use VPC Service Controls to create a trusted network for the Bigtable service.
- C. Use Identity and Access Management (IAM) for Bigtable access control.
- D. Use customer-managed encryption keys (CMEK).
Answer: B
Explanation:
"Users can define a security perimeter around Google Cloud resources such as Cloud Storage buckets, Bigtable instances, and BigQuery datasets to constrain data within a VPC and control the flow of data." https://cloud.google.com/vpc-service-controls
NEW QUESTION # 45
......
Dumps MoneyBack Guarantee - Professional-Cloud-Database-Engineer Dumps Approved Dumps: https://www.practicematerial.com/Professional-Cloud-Database-Engineer-exam-materials.html
2024 Updated Verified Pass Professional-Cloud-Database-Engineer Exam - Real Questions and Answers: https://drive.google.com/open?id=1xt86nhUqFfYfr-v8Fj0tSnO-VDdhJZc4
