[Jan-2025] Updated Google Cloud Certified Professional-Cloud-Database-Engineer Exam Questions BUNDLE PACK
Master The Google Content Professional-Cloud-Database-Engineer EXAM DUMPS WITH GUARANTEED SUCCESS!
Google Professional-Cloud-Database-Engineer exam is one of the latest certification exams offered by Google Cloud. It is designed to validate the skills and knowledge of database engineers who have expertise in designing, developing, and managing databases on Google Cloud Platform. Google Cloud Certified - Professional Cloud Database Engineer certification exam is intended for database engineers, cloud architects, and database administrators who want to demonstrate their ability to design, develop, deploy, and maintain databases on Google Cloud Platform.
NEW QUESTION # 21
You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA.
You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?
- A. Manually scale down the number of nodes after the peak period has passed.
- B. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
- C. Use interleaving to co-locate parent and child rows.
- D. Use granular instance sizing in Cloud Spanner and Autoscaler.
Answer: B
NEW QUESTION # 22
You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?
- A. Increase the amount of memory allocated to your instance.
- B. Ensure that the service account has the Storage Admin role.
- C. Close idle connections or restart the instance before beginning the import operation.
- D. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#troubleshooting
NEW QUESTION # 23
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. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Connect to the instance using a connection pool to best manage connections to the instance. - B. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Use Cloud SQL Auth proxy to connect to the instance. - C. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Use Cloud SQL Auth proxy to connect to the instance. - D. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Connect to the instance using a connection pool to best manage connections to the instance.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/mysql/connect-run#configure https://cloud.google.com/sql/docs/mysql/connect-run#connection-pools
NEW QUESTION # 24
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer dat a. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?
- A. Apply a schema data management pattern.
- B. Apply a table data management pattern.
- C. Apply an instance data management pattern.
- D. Apply a database data management pattern.
Answer: C
Explanation:
https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner#multi-tenancy-data-management-patterns
https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner
NEW QUESTION # 25
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 PostgreSQL running on Compute Engine.
- B. Migrate the existing database to Firestore.
- C. Migrate the existing database to Cloud Spanner.
- D. Migrate the existing database to Cloud SQL for PostgreSQL.
Answer: D
NEW QUESTION # 26
You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?
- A. Use query tags to add application-centric database monitoring.
- B. Shut down and restart each application.
- C. Write a utility to scan application logs.
- D. Write a utility to scan database query logs.
Answer: D
NEW QUESTION # 27
Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?
- A. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
- B. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
- C. Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
- D. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.
Answer: A
Explanation:
"Read replicas do not have the cloudsql.iam_authentication flag enabled automatically when it is enabled on the primary instance." https://cloud.google.com/sql/docs/postgres/replication/create-replica#configure_iam_replicas
NEW QUESTION # 28
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 Traffic Director.
- B. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
- C. Set up Serverless VPC Access.
- D. Set up Private Service Connect.
Answer: B
NEW QUESTION # 29
Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?
- A. Edit the primary instance to add additional memory.
- B. Stop all running queries, and re-create the replicas.
- C. Identify and optimize slow running queries, or set parallel replication flags.
- D. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
Answer: D
NEW QUESTION # 30
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?
- A. Set up a Cloud NAT gateway on the Compute Engine VM.
- B. Set up bring your own IP (BYOIP) in your VPC.
- C. Set up Cloud NAT service.
- D. Setup a static external IP address in your VPC network.
Answer: A
NEW QUESTION # 31
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 # 32
You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?
- A. Configure Memorystore, and modify your application to offload queries.
- B. Configure Bigtable, and modify your application to offload queries.
- C. Configure Firestore, and modify your application to offload queries.
- D. Configure Cloud SQL for PostgreSQL read replicas to offload queries.
Answer: A
NEW QUESTION # 33
Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?
- A. Use point-in-time-recovery (PITR) to recover the database.
- B. Set Terraform deletion_protection to true.
- C. Rerun terraform apply.
- D. Create a read replica.
Answer: B
Explanation:
. From Google's documentation, "For stateful resources, such as databases, ensure that deletion protection is enabled. The syntax is: lifecycle { prevent_destroy = true } https://cloud.google.com/docs/terraform/best-practices-for-terraform#stateful-resources
NEW QUESTION # 34
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 Database Migration Service to migrate the databases to Cloud SQL.
- B. Use replication from an external server to migrate the databases to Cloud SQL.
- C. Use a read replica to migrate the databases to Cloud SQL.
- D. Use a cross-region read replica to migrate the databases to Cloud SQL.
- E. Use an external read replica to migrate the databases to Cloud SQL.
Answer: A,B
NEW QUESTION # 35
You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?
- A. Use Dataflow to run the export in Avro format.
- B. Use Cloud Functions to run the export in Avro format.
- C. Use Cloud Functions to run the export in text format.
- D. Use Dataflow to run the export in text format.
Answer: A
NEW QUESTION # 36
You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?
- A. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
- B. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
- C. Set your production instance's maintenance window to non-business hours.
- D. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
Answer: D
NEW QUESTION # 37
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 Spanner in a regional configuration.
- B. Use high availability (HA) Cloud SQL with multiple zones.
- C. Use Cloud SQL with cross-region replicas.
- D. Use zonal Cloud SQL without high availability (HA).
Answer: C
NEW QUESTION # 38
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 Cloud SQL for data storage.
- C. Use Memorystore for data storage.
- D. Use Bigtable for data storage.
Answer: B
NEW QUESTION # 39
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 PostgreSQL running on Compute Engine.
- B. Migrate the existing database to Firestore.
- C. Migrate the existing database to Cloud Spanner.
- D. Migrate the existing database to Cloud SQL for PostgreSQL.
Answer: D
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 # 40
Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?
- A. Use Cloud Spanner.
- B. Use Bigtable.
- C. Use Firestore.
- D. Use Cloud SQL.
Answer: A
NEW QUESTION # 41
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 Cloud SQL for data storage.
- C. Use Memorystore for data storage.
- D. Use Bigtable for data storage.
Answer: A
Explanation:
google Cloud Spanner is a highly scalable, reliable, and fully managed relational database service that runs on Google's infrastructure. It's designed to handle large amounts of data and provide high availability, even in the face of failures. Spanner can be used to store and manage data for a variety of applications, including e-commerce websites. Spanner is a good choice for this scenario because it can handle high write throughput and provides 99.99% uptime. It's also a good fit for applications that need to be highly available, even in the face of failures.
NEW QUESTION # 42
You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:
Can read tables, views, and DDL
Can write rows to the tables
Can add columns and indexes
Cannot drop the database
What should you do?
- A. Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.
- B. Assign the Cloud Spanner Admin role.
- C. Assign the Cloud Spanner Database Admin role.
- D. Assign the Cloud Spanner Database User role.
Answer: D
NEW QUESTION # 43
You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)
- A. Ensure that all PostgreSQL tables have a primary key.
- B. Disable all foreign key constraints on the source PostgreSQL database.
- C. Shut down the database before the Data Migration Service task is started.
- D. Ensure that pglogical is installed on the source PostgreSQL database.
- E. Drop or disable all users except database administration users.
Answer: B,D
NEW QUESTION # 44
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 Cloud Data Fusion 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 the export and import option to migrate your data.
Answer: D
NEW QUESTION # 45
......
Pass Google Professional-Cloud-Database-Engineer Exam – Experts Are Here To Help You: https://endexam.2pass4sure.com/Google-Cloud-Certified/Professional-Cloud-Database-Engineer-actual-exam-braindumps.html