Professional-Cloud-Database-Engineer Free Exam Study Guide! (Updated 144 Questions)
Professional-Cloud-Database-Engineer Dumps for Google Cloud Certified Certified Exam Questions and Answer
Google Professional-Cloud-Database-Engineer certification exam is an excellent opportunity for professionals who want to demonstrate their expertise in designing, building, and managing databases on Google Cloud Platform. Google Cloud Certified - Professional Cloud Database Engineer certification is recognized globally and is highly valued by employers. By passing Professional-Cloud-Database-Engineer exam, candidates can prove their proficiency in database management and increase their chances of getting hired or promoted.
NEW QUESTION # 51
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. Create clones from a template Cloud SQL instance.
- B. Automate instance creation by setting up Terraform scripts.
- C. Create the instances using the Google Cloud Console UI.
- D. Automate instance creation by writing a Dataflow job.
Answer: C
NEW QUESTION # 52
Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?
- A. Use Cloud Spanner.
- B. Use Firestore.
- C. Use Bigtable.
- D. Use Cloud SQL for MySQL
Answer: A
Explanation:
Spanner covers the SLA
NEW QUESTION # 53
You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?
- A. Migrate the existing database to Cloud Spanner.
- B. Migrate the existing database to Firestore.
- C. Migrate the existing database to Cloud SQL for PostgreSQL.
- D. Migrate the existing database to PostgreSQL running on Compute Engine.
Answer: C
NEW QUESTION # 54
Your company's mission-critical, globally available application is supported by a Cloud Spanner database. Experienced users of the application have read and write access to the database, but new users are assigned read-only access to the database. You need to assign the appropriate Cloud Spanner Identity and Access Management (IAM) role to new users being onboarded soon. What roles should you set up?
- A. roles/spanner.databaseReader
- B. roles/spanner.backupWriter
- C. roles/spanner.databaseUser
- D. roles/spanner.viewer
Answer: A
Explanation:
https://cloud.google.com/spanner/docs/iam?hl=it
NEW QUESTION # 55
You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?
- A. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
- B. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
- C. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
- D. Create one regional Cloud SQL instance with a read replica in another region.
Answer: C
Explanation:
This answer is correct because it meets the requirements of having an optimal and highly available environment with automatic failover. According to the Google Cloud documentation1, a regional Cloud SQL instance is an instance that has a primary server in one zone and a standby server in another zone within the same region. The primary and standby servers are kept in sync using synchronous replication, which ensures zero data loss and minimal downtime in case of a zonal outage or an instance failure. If the primary server becomes unavailable, Cloud SQL automatically fails over to the standby server, which becomes the new primary server1.
NEW QUESTION # 56
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 the Cloud SQL recommenders for overprovisioned instances.
- C. Watch Cloud Trace for application requests that are failing.
- 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 largefor 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 # 57
You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?
- A. Migrate the existing database to Cloud Spanner.
- B. Migrate the existing database to Firestore.
- C. Migrate the existing database to Cloud SQL for PostgreSQL.
- D. Migrate the existing database to PostgreSQL running on Compute Engine.
Answer: C
Explanation:
You could migrate to Spanner leveraging the PostgreSQL dialect, but costs need to be minimized so that wouldn't be the cheapest option. Especially since the load doesn't justify Spanner. Again, you could migrate like-for-like to a GCE VM, but that defeats minimizing the migration effort. The cheapest and easiest way to migrate would be Database Migration Service to Cloud SQL for PostgreSQL.
NEW QUESTION # 58
You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?
- A. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
- B. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
- C. Use Cloud Composer to execute a select * from table(s) query and export results.
- D. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
Answer: D
Explanation:
https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler
NEW QUESTION # 59
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. Turn on automated backup, and turn on transaction log retention.
- B. Turn on automated backup, and turn off transaction log retention.
- C. Take no backups, and turn off transaction log retention.
- D. Take one manual backup per day, and turn off transaction log retention.
Answer: D
NEW QUESTION # 60
You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?
- A. Enable high availability (HA) for the database to make it regional.
- B. Create a read replica in another region, and promote the read replica if a failure occurs.
- C. Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
- D. Take nightly snapshots of the primary database instance, and restore them in a secondary zone.
Answer: A
NEW QUESTION # 61
Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?
- A. Use a combination of Database Migration Service and partner tools to support the data migration strategy.
- B. Use data replication tools and CDC tools to enable migration.
- C. Use Database Migration Service to migrate all databases to Cloud SQL.
- D. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
Answer: C
Explanation:
https://cloud.google.com/blog/products/databases/tips-for-migrating-across-compatible-database-engines
NEW QUESTION # 62
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
- A. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
- B. Migrate applications to Cloud SQL.
- C. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
- D. Migrate applications and Oracle databases to Compute Engine.
Answer: C
NEW QUESTION # 63
You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?
- A. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.
- B. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
- C. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
- D. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
Answer: A
NEW QUESTION # 64
You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud. What should you do?
- A. Migrate to Compute Engine.
- B. Migrate to Bare Metal Solution for Oracle.
- C. Migrate to Google Kubernetes Engine (GKE)
- D. Migrate to Google Cloud VMware Engine
Answer: A
NEW QUESTION # 65
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 Cloud SQL with a regional read replica to deploy the database.
- C. Use BigQuery to deploy the database
- D. Use Bigtable with clusters in multiple regions to deploy the database
Answer: A
Explanation:
Cloud Spanner is a fully managed, mission-critical, relational database service that offers transactional consistency at global scale, automatic, synchronous replication for high availability, and support for two SQL dialects: Google Standard SQL (ANSI 2011 with extensions) and PostgreSQL.
NEW QUESTION # 66
Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?
- A. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket. - B. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Keep backups older than one day stored in Actifio OnVault storage. - C. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket. - D. Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Keep backups older than one day stored in Actifio OnVault storage.
Answer: B
Explanation:
This answer meets the RTO and RPO requirements by using flash storage for the database and standard storage for the local backup copy. It also meets the cost-effectiveness requirement by using Actifio OnVault storage, which is a low-cost, high-performance, and scalable storage solution that integrates with Google Cloud Backup and DR Service1.
References := 1: Solution Guide: Google Cloud Backup and DR for Oracle on Bare Metal Solution1
NEW QUESTION # 67
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 data.
What should you do?
- A. Use customer-managed encryption keys (CMEK).
- B. Use VPC Service Controls to create a trusted network for the Bigtable service.
- C. Use Google Cloud Armor to add IP addresses to an allowlist.
- D. Use Identity and Access Management (IAM) for Bigtable access control.
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 # 68
You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage.
What should you do?
- A. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
- B. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
- C. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
- D. Create one regional Cloud SQL instance with a read replica in another region.
Answer: C
Explanation:
This answer is correct because it meets the requirements of having an optimal and highly available environment with automatic failover. According to the Google Cloud documentation1, a regional Cloud SQL instance is an instance that has a primary server in one zone and a standby server in another zone within the same region. The primary and standby servers are kept in sync using synchronous replication, which ensures zero data loss and minimal downtime in case of a zonal outage or an instance failure. If the primary server becomes unavailable, Cloud SQL automatically fails over to the standby server, which becomes the new primary server1.
NEW QUESTION # 69
You are deploying a Cloud SOL for MySQL database to serve a non-critical application. The database size is
10 GB and will be updated every night with data stored in a Cloud Storage bucket. The database serves read- only traffic from the application during the day. The data locally requirement of This application mandates that data must reside in a single region. You want to minimize the cost of running this database while maintaining an RTO of 1 day. What should you do?
- A. Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in a second region.
- B. Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in the same zone.
- C. Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Configure automated backups of the Cloud SQL instance and use a custom backup location to store backups in a Cloud Storage bucket in the same region.
- D. Create a Cloud SQL for MySQL instance with high availability (HA) enabled. Configure automated backups of the Cloud SQL instance and use the default backup location.
Answer: C
NEW QUESTION # 70
You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries.
What should you do?
- A. Review application logs to identify database calls.
- B. View Cloud SQL operations to view historical query information.
- C. White a Logs Explorer query to identify database queries with high execution times.
- D. Use the Query Insights dashboard to identify high execution times.
Answer: D
Explanation:
A Cloud SQL instance configured for HA is also called a regional instance and has a primary and secondary zone within the configured region. Within a regional instance, the configuration is made up of a primary instance and a standby instance. Through synchronous replication to each zone's persistent disk, all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed. In the event of an instance or zone failure, the standby instance becomes the new primary instance. Users are then rerouted to the new primary instance. This process is called a failover.
NEW QUESTION # 71
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.client and roles/spanner.databaseReader
- C. roles/cloudsql.editor and roles/spanner.admin
- D. roles/cloudsql.instanceUser and roles/spanner.databaseUser
Answer: A
Explanation:
To read data out of Cloud SQL for SQL Server, you need to use a service account with the roles/cloudsql.
viewer role on the Cloud SQL instance. This role grants the service account permission to read data from the instance. Whereas roles/cloudsql.instanceUser will only allow to login to cloud SQL instance. No resource will be allowed to view.
NEW QUESTION # 72
......
To be eligible for the Google Professional-Cloud-Database-Engineer certification exam, you must have at least three years of experience in managing databases on a cloud platform, including one year of experience in designing and implementing databases on Google Cloud. You should also have a good understanding of database concepts and technologies, such as SQL, NoSQL, and database management systems. Additionally, you should have hands-on experience with Google Cloud Platform services related to databases, such as Cloud SQL, Cloud Spanner, and Cloud Bigtable.
Google Professional-Cloud-Database-Engineer exam is a certification exam offered by Google Cloud that tests the individual's proficiency in designing, developing, and managing scalable, secure, and highly available database solutions. Professional-Cloud-Database-Engineer exam is designed to evaluate the candidate's ability to design, plan, and manage cloud database solutions using Google Cloud Platform services such as Cloud SQL, Cloud Spanner, and Cloud Bigtable.
Use Real Professional-Cloud-Database-Engineer Dumps - 100% Free Professional-Cloud-Database-Engineer Exam Dumps: https://quizmaterials.dumpsreview.com/Professional-Cloud-Database-Engineer-exam-dumps-review.html
