The latest Google Professional Cloud Database Engineer certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Google Professional Cloud Database Engineer exam and earn Google Professional Cloud Database Engineer certification.
Table of Contents
- Question 61
- Exam Question
- Correct Answer
- Question 62
- Exam Question
- Correct Answer
- Question 63
- Exam Question
- Correct Answer
- Question 64
- Exam Question
- Correct Answer
- Question 65
- Exam Question
- Correct Answer
- Question 66
- Exam Question
- Correct Answer
- Question 67
- Exam Question
- Correct Answer
- Question 68
- Exam Question
- Correct Answer
- Question 69
- Exam Question
- Correct Answer
- Question 70
- Exam Question
- Correct Answer
Question 61
Exam Question
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.
Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Use Cloud SQL Auth proxy to connect to the instance.
B.
Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Connect to the instance using a connection pool to best manage connections to the instance.
C.
Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Use Cloud SQL Auth proxy to connect to the instance.
D.
Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Connect to the instance using a connection pool to best manage connections to the instance.
Correct Answer
C.
Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Use Cloud SQL Auth proxy to connect to the instance.
Question 62
Exam Question
You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance.
What should you do?
A. Place the bulk of the read and write workloads closer to the default leader region.
B. Use staleness of at least 15 seconds.
C. Add more read-write replicas.
D. Keep the total CPU utilization under 45% in each region.
Correct Answer
C. Add more read-write replicas.
Question 63
Exam Question
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. Check whether your service account has cloudsql.instances.connect permission.
C. Enable the Cloud SQL Admin API.
D. Ensure that you are using an external (public) IP address interface.
Correct Answer
A. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
Question 64
Exam Question
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. Cloud SQL
B. BigQuery
C. Cloud Spanner
D. Bigtable
Correct Answer
B. BigQuery
Question 65
Exam Question
You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?
A. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
B. Use sharded Cloud SQL instances with one or more stores per database instance.
C. Use a Biglable cluster with autoscaling.
D. Use Cloud Spanner with a custom autoscaling solution.
Correct Answer
B. Use sharded Cloud SQL instances with one or more stores per database instance.
Question 66
Exam Question
You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?
A. Reduce the number of automated backups that are retained to two (2).
B. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
C. Set the automated backups to occur every other day to lower the frequency of backups.
D. Select a different region to store your backups.
Correct Answer
C. Set the automated backups to occur every other day to lower the frequency of backups.
Question 67
Exam Question
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 Identity and Access Management (IAM) for Bigtable access control.
B. Use VPC Service Controls to create a trusted network for the Bigtable service.
C. Use customer-managed encryption keys (CMEK).
D. Use Google Cloud Armor to add IP addresses to an allowlist.
Correct Answer
B. Use VPC Service Controls to create a trusted network for the Bigtable service.
Question 68
Exam Question
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 Bigtable for data storage.
D. Use Cloud SQL for data storage.
Correct Answer
D. Use Cloud SQL for data storage.
Question 69
Exam Question
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. Use backup and restore to roll out changes to higher environments.
C. Use Liquibase to roll out changes to higher environments.
D. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
Correct Answer
B. Use backup and restore to roll out changes to higher environments.
Question 70
Exam Question
Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?
A. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
B. Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.
C. Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
D. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
Correct Answer
A. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.