Attested Professional-Cloud-Database-Engineer Dumps PDF Resource [2024]
Latest Professional-Cloud-Database-Engineer Actual Free Exam Questions Updated 134 Questions
Google Professional-Cloud-Database-Engineer certification exam is designed to test the skills and knowledge of professionals who work with databases on the Google Cloud Platform. It is intended for individuals who have experience in designing, developing, and managing databases, as well as those who are skilled in using Google Cloud's database services.
NEW QUESTION # 22
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. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
- B. Use direct scaling to implement the Autoscaler-based architecture.
- C. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
- D. Use linear scaling to implement the Autoscaler-based architecture
Answer: D
Explanation:
Linear scaling is best used with load patterns that change more gradually or have a few large peaks. The method calculates the minimum number of nodes or processing units required to keep utilization below the scaling threshold. The number of nodes or processing units added or removed in each scaling event is not limited to a fixed step amount. https://cloud.google.com/spanner/docs/autoscaling-overview#linear
NEW QUESTION # 23
You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?
- A. Create a Cloud Composer instance, and create a directed acyclic graph (DAG).
- B. Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.
- C. Create a VM in Compute Engine, and run a cron job.
- D. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
Answer: D
NEW QUESTION # 24
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 the application server, set up a service account.
- C. For the application server, set up a common shared user account.
- D. For each application code, set up a common shared user account.
Answer: A
NEW QUESTION # 25
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 Google Kubernetes Engine (GKE).
- B. Migrate to Cloud SQL for PostgreSQL.
- C. Migrate to Compute Engine.
- D. Migrate to Cloud SQL for SQL Server.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/sqlserver/features
NEW QUESTION # 26
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. Use workload identity federation to impersonate a service account.
- 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. Ask existing users to set their Google password to match their corporate password.
Answer: C
NEW QUESTION # 27
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 Cloud Spanner with Data Studio.
- B. Use MongoD8 Atlas with Charts.
- C. Use Bigtable with Looker.
- D. Use Firestore with Looker.
Answer: B
NEW QUESTION # 28
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
- A. Use external server replication.
- B. Use Cloud SQL for MySQL external replica.
- C. Use the mysqldump utility and binary logs.
- D. Use Data Migration Service.
Answer: D
NEW QUESTION # 29
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. Write a utility to scan application logs.
- B. Write a utility to scan database query logs.
- C. Use query tags to add application-centric database monitoring.
- D. Shut down and restart each application.
Answer: B
NEW QUESTION # 30
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: D
Explanation:
https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform
NEW QUESTION # 31
Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?
- A. Migrate the Oracle databases to Bare Metal Solution for Oracle.
- B. Migrate the Oracle databases to Compute Engine.
- C. Migrate the Oracle databases to Cloud Spanner.
- D. Migrate the Oracle databases to Cloud SQL.
Answer: A
Explanation:
This answer is correct because Bare Metal Solution for Oracle is a service that provides dedicated physical servers and networking infrastructure for running Oracle databases on Google Cloud1. Bare Metal Solution for Oracle supports Oracle RAC, which is a cluster database that provides high availability, scalability, and performance for Oracle workloads2. By using Bare Metal Solution for Oracle, you can migrate your Oracle databases with minimal to no changes to the applications, and you can leverage the native Google Cloud services and interconnectivity1.
NEW QUESTION # 32
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
- A. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
- B. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
- C. Set up all read replicas in the same region as the primary instance with synchronous replication.
- D. Set up all read replicas in a different region using asynchronous replication.
Answer: A
Explanation:
This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed1. This minimizes data loss and downtime in case of a zonal or an instance failure, and allows for a quick failover to the standby instance1.
This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2. This provides additional redundancy and backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.
NEW QUESTION # 33
You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?
- A. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
- B. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
- C. Bring DB-1 back online.
- D. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
Answer: A
Explanation:
If you need to have the primary instance in the zone that had the outage, you can do a failback. A failback performs the same steps as the failover, only in the opposite direction, to reroute traffic back to the original instance. To perform a failback, use the procedure in Initiating failover. https://cloud.google.com/sql/docs/mysql/high-availability#failback
NEW QUESTION # 34
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. Use Database Migration Service to migrate your database.
- C. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
- D. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
Answer: D
NEW QUESTION # 35
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. Add more read-write replicas.
- B. Use staleness of at least 15 seconds.
- C. Place the bulk of the read and write workloads closer to the default leader region.
- D. Keep the total CPU utilization under 45% in each region.
Answer: A
NEW QUESTION # 36
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 Bigtable with clusters in multiple regions 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 Cloud Spanner to deploy the database.
Answer: C
NEW QUESTION # 37
......
Google Professional-Cloud-Database-Engineer certification is a valuable certification for database engineers and administrators who work with the Google Cloud Platform. It demonstrates a high level of expertise and knowledge in database management on the cloud, which is becoming increasingly important in today's digital landscape. Candidates can prepare for the exam by studying database management principles and gaining hands-on experience with database administration on the Google Cloud Platform.
Professional-Cloud-Database-Engineer Certification Overview Latest Professional-Cloud-Database-Engineer PDF Dumps: https://www.testkingfree.com/Google/Professional-Cloud-Database-Engineer-practice-exam-dumps.html
Free Professional-Cloud-Database-Engineer Exam Braindumps certification guide Q&A: https://drive.google.com/open?id=1jtFQb5W48GykHVYdtK7YsDKUafmjqEsY