[Feb-2024] Verified Google Exam Dumps with Professional-Cloud-Database-Engineer Exam Study Guide
Best Quality Google Professional-Cloud-Database-Engineer Exam Questions SureTorrent Realistic Practice Exams [2024]
The Google Professional-Cloud-Database-Engineer exam tests candidates' knowledge in various areas, including database design, data modeling, database security, and database migration. Candidates are also expected to have a deep understanding of the different Google Cloud database services, such as Cloud SQL, Cloud Spanner, and Cloud Bigtable. Professional-Cloud-Database-Engineer exam assesses candidates' ability to design and implement highly available, scalable, and secure database solutions using Google Cloud.
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 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 on transaction log retention.
- D. Turn on automated backup, and turn off transaction log retention.
Answer: B
NEW QUESTION # 70
You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?
- A. Use Bigtable, and add nodes as necessary to achieve the required throughput.
- B. Use Firestore, and rely on automatic serverless scaling.
- C. Use Cloud SQL with read replicas for throughput.
- D. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
Answer: A
Explanation:
https://cloud.google.com/memorystore/docs/redis/redis-overview
NEW QUESTION # 71
You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?
- A. Deploy the database using Cloud SQL.
- B. Use BigQuery, and load data in batches.
- C. C.Deploy the database using Bigtable.
- D. Deploy the database using Cloud Spanner.
Answer: C
Explanation:
Bigtable is a scalable, fully managed, and high-performance NoSQL database service that can handle semi-structured data and support real-time monitoring and analysis. Cloud SQL is a relational database service that does not support semi-structured dat a. BigQuery is a data warehouse service that is optimized for batch processing and analytics, not real-time monitoring. Cloud Spanner is a relational database service that supports semi-structured data with JSON data type, but it is more expensive and complex than Bigtable for this use case.
NEW QUESTION # 72
Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?
- A. Use backup and restore to roll out changes to higher environments.
- B. Use replication to roll out changes to higher environments.
- C. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
- D. Use Liquibase to roll out changes to higher environments.
Answer: A
NEW QUESTION # 73
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 SQL for PostgreSQL.
- B. Migrate the existing database to Cloud Spanner.
- C. Migrate the existing database to PostgreSQL running on Compute Engine.
- D. Migrate the existing database to Firestore.
Answer: A
NEW QUESTION # 74
Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?
- A. Ask existing users to set their Google password to match their corporate password.
- B. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
- C. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
- D. Use workload identity federation to impersonate a service account.
Answer: D
Explanation:
Updating passwords represents user disruption. Eliminate B. Eliminate C for the same reason. D doesn't make sense, leaves A. From Google's documentation, "Traditionally, applications running outside Google Cloud can use service account keys to access Google Cloud resources. However, service account keys are powerful credentials, and can present a security risk if they are not managed correctly. With identity federation, you can use Identity and Access Management (IAM) to grant external identities IAM roles, including the ability to impersonate service accounts. This approach eliminates the maintenance and security burden associated with service account keys." https://cloud.google.com/iam/docs/workload-identity-federation
NEW QUESTION # 75
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 a read replica to migrate the databases to Cloud SQL.
- C. Use an external 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 replication from an external server to migrate the databases to Cloud SQL.
Answer: B,E
NEW QUESTION # 76
Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?
- A. Recommend mixed storage types.
- B. Recommend hard disk drives (HDD).
- C. Recommend solid-state drives (SSD).
- D. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
Answer: D
NEW QUESTION # 77
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. Use granular instance sizing in Cloud Spanner and Autoscaler.
- B. Manually scale down the number of nodes after the peak period has passed.
- C. Use interleaving to co-locate parent and child rows.
- D. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
Answer: A
Explanation:
Granular instance is available in Public Preview. With this feature, you can run workloads on Spanner at as low as 1/10th the cost of regular instances, https://cloud.google.com/blog/products/databases/get-more-out-of-spanner-with-granular-instance-sizing
NEW QUESTION # 78
You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?
- A. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
- B. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
- C. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
- D. Use Database Migration Service to migrate your database.
Answer: B
Explanation:
PgBouncer maintains a pool for connections for each database and user combination. PgBouncer either creates a new database connection for a client or reuses an existing connection for the same user and database. + PgBouncer is a simple PostgreSQL connection pool that allows for several thousand connections at a time. Using Kubernetes Engine to run a Helm Chart w/ PgBouncer based on the great article from futuretech-industries, we were able to set up an easily deployable system to get the most out of our CloudSQL DBs without breaking the bank. https://medium.com/google-cloud/increasing-cloud-sql-postgresql-max-connections-w-pgbouncer-kubernetes-engine-49b0b2894820#:~:text=That%20is%20where,breaking%20the%20bank.
NEW QUESTION # 79
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 recommenders for overprovisioned instances.
- B. Watch the Cloud SQL instance monitor for CPU utilization metrics.
- C. Watch Cloud Trace for application requests that are failing.
- D. Watch Query Insights for long running queries.
Answer: D
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 large for 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 # 80
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?
- A. For each application code, set up a dedicated user account.
- B. For each application code, set up a common shared user account.
- C. For the application server, set up a service account.
- D. For the application server, set up a common shared user account.
Answer: A
NEW QUESTION # 81
You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?
- A. Use staleness of at least 15 seconds.
- B. Keep the total CPU utilization under 45% in each region.
- C. Add more read-write replicas.
- D. Place the bulk of the read and write workloads closer to the default leader region.
Answer: C
NEW QUESTION # 82
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. Setup a static external IP address in your VPC network.
- C. Set up Cloud NAT service.
- D. Set up bring your own IP (BYOIP) in your VPC.
Answer: A
Explanation:
https://cloud.google.com/bare-metal/docs/bms-setup?hl=en#bms-access-internet-vm-nat The docs specifically says "Setting up a NAT gateway on a Compute Engine VM" is the way to give BMS internet access.
NEW QUESTION # 83
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?
- A. Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
- B. Create a clone database from a read replica database, and restore the clone in the same region.
- C. Create a clone database from a read replica database, and restore the clone into a different zone.
- D. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
Answer: D
Explanation:
Using import/export from last week is slow for large scale databases and will restore database from last week.
NEW QUESTION # 84
......
Authentic Best resources for Professional-Cloud-Database-Engineer: https://www.suretorrent.com/Professional-Cloud-Database-Engineer-exam-guide-torrent.html
Professional-Cloud-Database-Engineer Test Engine Practice Exam: https://drive.google.com/open?id=1amo6hfdgE5dUO6ozfAYLA5nC55qPZS0o