File Info
| Exam | Professional Cloud Database Engineer |
| Number | Professional-Cloud-Database-Engineer |
| File Name | Google.Professional-Cloud-Database-Engineer.VCEplus.2024-08-18.92q.tqb |
| Size | 424 KB |
| Posted | Aug 18, 2024 |
| Download | Google.Professional-Cloud-Database-Engineer.VCEplus.2024-08-18.92q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?
- Setup a static external IP address in your VPC network.
- Set up bring your own IP (BYOIP) in your VPC.
- Set up a Cloud NAT gateway on the Compute Engine VM.
- Set up Cloud NAT service.
Correct answer: C
Explanation:
https://cloud.google.com/bare-metal/docs/bms-setup?hl=en#bms-access-internet-vm-natThe docs specifically says 'Setting up a NAT gateway on a Compute Engine VM' is the way to give BMS internet access. https://cloud.google.com/bare-metal/docs/bms-setup?hl=en#bms-access-internet-vm-natThe docs specifically says 'Setting up a NAT gateway on a Compute Engine VM' is the way to give BMS internet access.
Question 2
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?
- Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- Check whether your service account has cloudsql.instances.connect permission.
- Enable the Cloud SQL Admin API.
- Ensure that you are using an external (public) IP address interface.
Correct answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/connect-auth-proxy#troubleshootingC 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 https://cloud.google.com/sql/docs/mysql/connect-auth-proxy#troubleshootingC 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
Question 3
You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of data. 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?
- Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
- Use sharded Cloud SQL instances with one or more stores per database instance.
- Use a Biglable cluster with autoscaling.
- Use Cloud Spanner with a custom autoscaling solution.
Correct answer: D
Explanation:
https://cloud.google.com/spanner/docs/autoscaling-overview1. CloudSQL max out at 64TB, so unable to told 100TB of data. https://cloud.google.com/sql/docs/quotas#metrics_collection_limit2. Scale is done manually on SQL Cloud https://cloud.google.com/spanner/docs/autoscaling-overview
1. CloudSQL max out at 64TB, so unable to told 100TB of data. https://cloud.google.com/sql/docs/quotas#metrics_collection_limit2. Scale is done manually on SQL Cloud
