| Exam Code | Professional-Cloud-Database-Engineer |
| Exam Name | Google Cloud Certified - Professional Cloud Database Engineer |
| Questions | 132 Questions Answers With Explanation |
| Update Date | July 11,2024 |
| Price |
Was : |
Are you ready to take your career to the next level with Google Cloud Certified - Professional Cloud Database Engineer? At Prep4Certs, we're dedicated to helping you achieve your goals by providing high-quality Professional-Cloud-Database-Engineer Dumps and resources for a wide range of certification exams.
At Prep4Certs, we're committed to your success in the Google Professional-Cloud-Database-Engineer exam. Our comprehensive study materials and resources are designed to equip you with the knowledge and skills needed to ace the exam with confidence:
Start Your Certification Journey Today
Whether you're looking to advance your career, expand your skill set, or pursue new opportunities, Prep4Certs is here to support you on your certification journey. Explore our comprehensive study materials, take your exam preparation to the next level, and unlock new possibilities for professional growth and success.
Ready to achieve your certification goals? Begin your journey with Prep4Certs today!
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.
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 high availability (HA) Cloud SQL with multiple zones.
C. Use zonal Cloud SQL without high availability (HA).
D. Use Cloud Spanner in a regional configuration.
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. Set the automated backups to occur every other day to lower the frequency of backups.
B. Change the storage tier of the automated backups from solid-state drive (SSD) to hard
disk drive (HDD).
C. Select a different region to store your backups.
D. Reduce the number of automated backups that are retained to two (2).
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. Create a streaming Datatlow job to export the table.
C. Set up Cloud Composer, and create a task to export the table daily.
D. Run the cron job on a Compute Engine instance to continue the export.
You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?
A. Disable and remove the internal IP address assignment.
B. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
C. Specify an authorized network with the CIDR range of the VM.
D. Disable and remove the external IP address assignment.
You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?
A. Use Cloud Spanner to deploy the database.
B. Use Bigtable with clusters in multiple regions to deploy the database
C. Use BigQuery to deploy the database
D. Use Cloud SQL with a regional read replica to deploy the database.
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 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
B. 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
C. 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
D. 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
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 no backups, and turn off transaction log retention.
B. Take one manual backup per day, and turn off transaction log retention.
C. Turn on automated backup, and turn off transaction log retention.
D. Turn on automated backup, and turn on transaction log retention.
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.
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 a Shared VPC, configure multiple service projects, and create firewall rules.
B. Set up Serverless VPC Access.
C. Set up Private Service Connect.
D. Set up Traffic Director.
