Professional-Cloud-Database-Engineer Dumps for Pass Guaranteed - Pass Professional-Cloud-Database-Engineer Exam 2025
Professional-Cloud-Database-Engineer Exam Dumps - Try Best Professional-Cloud-Database-Engineer Exam Questions from Training Expert VCEDumps
NEW QUESTION # 67
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 zonal Cloud SQL without high availability (HA).
- D. Use Cloud Spanner in a regional configuration.
Answer: C
Explanation:
https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-
bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform
NEW QUESTION # 68
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. Perform the gcloud sql operations list command.
- B. Use Cloud Audit Logs to verify the status.
- C. Check the cloudsql.googleapis.com/postgres.log instance log.
- D. Use the Google Cloud Console.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/postgres/backup-recovery/backups#troubleshooting-backups Under Troubleshooting: Issue: "You can't see the current operation's status." The Google Cloud console reports only success or failure when the operation is done. It isn't designed to show warnings or other updates. Run the gcloud sql operations list command to list all operations for the given Cloud SQL instance.
NEW QUESTION # 69
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 one manual backup per day, and turn off transaction log retention.
- B. Turn on automated backup, and turn on transaction log retention.
- C. Turn on automated backup, and turn off transaction log retention.
- D. Take no backups, and turn off transaction log retention.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/backup-recovery/backups
NEW QUESTION # 70
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 Cloud SQL for MySQL
- C. Use Bigtable.
- D. Use Firestore.
Answer: B
NEW QUESTION # 71
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?
- A. Deploy a US multi-region Firestore location.
- B. Enable serializable isolation in the Firebase app.
- C. Build a Firestore bundle, and deploy bundles to Cloud CDN.
- D. Create a Firestore index on the news story date.
Answer: C
Explanation:
A global audience strongly suggests serving content via Google's Content Delivery Network. Changing the isolation level won't decrease cost or latency
NEW QUESTION # 72
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. Reduce the number of automated backups that are retained to two (2).
- B. Set the automated backups to occur every other day to lower the frequency of backups.
- C. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
- D. Select a different region to store your backups.
Answer: A
Explanation:
By default, for each instance, Cloud SQL retains seven automated backups, in addition to on-demand backups. You can configure how many automated backups to retain (from 1 to 365). We charge a lower rate for backup storage than for other types of instances. https://cloud.google.com/sql/docs/mysql/backup-recovery/backups
NEW QUESTION # 73
Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?
- A. Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.
- B. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
- C. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
- D. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
Answer: B
Explanation:
Binary Logging enabled, with that you can identify the point of time the data was good and recover from that point time. https://cloud.google.com/sql/docs/mysql/backup-recovery/pitr#perform_the_point-in-time_recovery_using_binary_log_positions
NEW QUESTION # 74
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 the Cloud SQL instance monitor for CPU utilization metrics.
- B. Watch the Cloud SQL recommenders for overprovisioned instances.
- C. Watch Query Insights for long running queries.
- D. Watch Cloud Trace for application requests that are failing.
Answer: C
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 # 75
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 and standby instances in zone A and the read replica in zone B, all in the same region.
- B. Configure the primary, standby, and read replica instances in zone A, all in the same region.
- C. 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.
- D. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview
NEW QUESTION # 76
Your team is building an application that stores and analyzes streaming time series financial dat a. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?
- A. Use Cloud Spanner.
- B. Use Firestore.
- C. Use Bigtable
- D. Use BigQuery.
Answer: C
Explanation:
Financial data, such as transaction histories, stock prices, and currency exchange rates.
https://cloud.google.com/bigtable/docs/overview#what-its-good-for
With SSD:
Reads - up to 10,000 rows per second
Writes - up to 10,000 rows per second
Scans - up to 220 MB/s
https://cloud.google.com/bigtable/docs/performance#typical-workloads
NEW QUESTION # 77
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. Specify an authorized network with the CIDR range of the VM.
- C. Disable and remove the external IP address assignment.
- D. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
Answer: C
Explanation:
It is always more secure to use an internal IP, so removing them doesn't make sense. Eliminate A. You can use Private Google Access when VM instances only have internal IP addresses, so disabling the internal IPs and use Private Google Access doesn't make sense. Eliminate B. Specifying an authorized network when they're on the same subnet doesn't make sense. Eliminate C. A way to improve network security would be to disable external IPs since they're not needed.
NEW QUESTION # 78
You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?
- A. Use linear scaling to implement the Autoscaler-based architecture
- B. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
- C. Use direct scaling to implement the Autoscaler-based architecture.
- D. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
Answer: D
NEW QUESTION # 79
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.viewer
- B. roles/spanner.backupWriter
- C. roles/spanner.databaseUser
- D. roles/spanner.databaseReader
Answer: D
Explanation:
https://cloud.google.com/spanner/docs/iam?hl=it
NEW QUESTION # 80
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 for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
- D. Use Database Migration Service to migrate all databases to Cloud SQL.
Answer: D
Explanation:
https://cloud.google.com/blog/products/databases/tips-for-migrating-across-compatible-database-engines
NEW QUESTION # 81
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. Create your database with one primary node and one read replica in the region.
- B. Configure your Cloud SQL instance with high availability enabled.
- C. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
- D. 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.
Answer: D
Explanation:
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.
NEW QUESTION # 82
......
Latest 100% Passing Guarantee - Brilliant Professional-Cloud-Database-Engineer Exam Questions PDF: https://testinsides.vcedumps.com/Professional-Cloud-Database-Engineer-examcollection.html
