2025 Realistic Verified Free Google Professional-Cloud-Database-Engineer Exam Questions
Professional-Cloud-Database-Engineer Real Exam Questions and Answers FREE
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 high availability (HA) Cloud SQL with multiple zones.
- B. Use Cloud SQL with cross-region replicas.
- C. Use Cloud Spanner in a regional configuration.
- D. Use zonal Cloud SQL without high availability (HA).
Answer: C
Explanation:
https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform
NEW QUESTION # 38
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?
- A. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
- B. Use Cloud SQL Auth proxy.
- C. Connect to Cloud SQL using a connection that has SSL encryption.
- D. Use customer-managed encryption keys with Cloud SQL.
Answer: C
NEW QUESTION # 39
You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional dat a. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?
- A. Configure your Cloud SQL instance with high availability enabled.
- B. Create your database with one primary node and one read replica in the region.
- C. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
- D. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
Answer: C
NEW QUESTION # 40
You are setting up a new AlloyDB instance and want users to be able to use their existing identity and Access Managemen (IAM) identities to connect to AlloyDB. You have performed the following steps:
Manually enabled IAM authentication on the AlloyDB instance
Granted the allowdb-databaseUser and serviceusage.serviceusageConsumer IAM roles to the users Created new AllowDB database users based on corresponding IAM identities Users are able to connect but are reporting that they are not able to SELECT from application tables. What should you do?
- A. Grant the new database users access privileges to the appropriate tables.
- B. Grant the alloydb.alloydbreplica IAM role to each user.
- C. Grant the alloydb.viewer IAM role to each user.
- D. Grant the alloydb.client IAM role to each user.
Answer: A
NEW QUESTION # 41
You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?
- A. Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences
- B. Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
- C. Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
- D. Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
Answer: D
Explanation:
Use Firestore in Datastore mode for new server projects. Firestore in Datastore mode allows you to use established Datastore server architectures while removing fundamental Datastore limitations. Datastore mode can automatically scale to millions of writes per second. Use Firestore in Native mode for new mobile and web apps. Firestore offers mobile and web client libraries with real-time and offline features. Native mode can automatically scale to millions of concurrent clients.
NEW QUESTION # 42
You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?
- A. Use Cloud Spanner with default encryption.
- B. Use Bigtable with default encryption.
- C. Use Cloud SQL with a customer-managed encryption key (CMEK).
- D. Use Cloud Spanner with a customer-managed encryption key (CMEK).
Answer: D
Explanation:
Yes default encryption comes with AES-256 but the question states that you need to control where you store the encryption keys. that can be achieved by CMEK.
NEW QUESTION # 43
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 Private Service Connect.
- C. Set up Traffic Director.
- D. Set up Serverless VPC Access.
Answer: A
Explanation:
https://medium.com/google-cloud/shared-vpc-in-google-cloud-64527e0a409e#:~:text=Unlike%20VPC%
20peering%2C%20Shared%20VPC%20connects%20projects%20within%20the%20same%20organization.
&text=There%20are%20a%20lot%20of,between%20VPCs%20in%20different%20projects.
NEW QUESTION # 44
Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?
- A. Migrate to Cloud SQL for SQL Server.
- B. Migrate to Compute Engine.
- C. Migrate to Google Kubernetes Engine (GKE).
- D. Migrate to Cloud SQL for PostgreSQL.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/sqlserver/features
NEW QUESTION # 45
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?
- A. Use Cloud Audit Logs to verify the status.
- B. Check the cloudsql.googleapis.com/postgres.log instance log.
- C. Perform the gcloud sql operations list command.
- D. Use the Google Cloud Console.
Answer: A
NEW QUESTION # 46
You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?
- A. Use log messages produced by Cloud SQL.
- B. Use Query Insights for Cloud SQL.
- C. Use Cloud SQL instance monitoring in the Google Cloud Console.
- D. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
Answer: D
NEW QUESTION # 47
You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?
- A. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
- B. Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
- C. Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
- D. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
Answer: D
NEW QUESTION # 48
Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do?
- A. Use Bigtable with Looker.
- B. Use Cloud Spanner with Data Studio.
- C. Use MongoD8 Atlas with Charts.
- D. Use Firestore with Looker.
Answer: C
Explanation:
This scenario has BigTable written all over it - large amounts of data from many devices to be analysed in realtime. I would even argue it could qualify as a multicloud solution, given the links to HBASE. BUT it does not support SQL queries and is not therefore compatible (on its own) with Looker. Firestore + Looker has the same problem. Spanner + Data Studio is at least a compatible pairing, but I agree with others that it doesn't fit this use-case - not least because it's Google-native. By contrast, MongoDB Atlas is a managed solution (just not by Google) which is compatible with the proposed reporting tool (Mongo's own Charts), it's specifically designed for this type of solution and of course it can run on any cloud.
NEW QUESTION # 49
You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability.
What should you do?
- A. Configure the primary, standby, and read replica instances in zone A, all in the same region.
- B. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
- C. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
- D. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview
NEW QUESTION # 50
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 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 - 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 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
Answer: B
Explanation:
https://cloud.google.com/bigtable/docs/replication-settings#regional-failover
NEW QUESTION # 51
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 data replication tools and CDC tools to enable migration.
- B. Use a combination of Database Migration Service and partner tools to support the data migration strategy.
- 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 # 52
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 Bigtable for data storage.
- B. Use Memorystore for data storage.
- C. Use Cloud SQL for data storage.
- D. Use Cloud Spanner for data storage.
Answer: C
NEW QUESTION # 53
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. Ensure that you are using an external (public) IP address interface.
- B. Check whether your service account has cloudsql.instances.connect permission.
- C. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- D. Enable the Cloud SQL Admin API.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/mysql/connect-auth-proxy#troubleshooting C 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
NEW QUESTION # 54
......
Google Professional-Cloud-Database-Engineer is a certification exam designed for professionals who want to showcase their expertise in designing, building, and managing databases on Google Cloud Platform. Professional-Cloud-Database-Engineer exam is intended for individuals who have a deep understanding of database management, data migration, backup and recovery, and security on Google Cloud Platform. Successful completion of Professional-Cloud-Database-Engineer exam will earn candidates the Google Cloud Certified - Professional Cloud Database Engineer certification.
Exam Dumps Professional-Cloud-Database-Engineer Practice Free Latest Google Practice Tests: https://www.itpass4sure.com/Professional-Cloud-Database-Engineer-practice-exam.html
Professional-Cloud-Database-Engineer Exam Questions | Real Professional-Cloud-Database-Engineer Practice Dumps: https://drive.google.com/open?id=1J355Gz6fu1JbQlOfsuoKB6Lss4dofASk
