Download Free Google Professional-Cloud-Database-Engineer Real Exam Questions Download
Latest Google Professional-Cloud-Database-Engineer Real Exam Dumps PDF
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 # 18
Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?
- A. Back up the database, create an instance with additional vCPUs, and restore the database.
- B. Issue a gcloud compute instances update command to increase the number of vCPUs.
- C. Issue a gcloud sql instances patch command to increase the number of vCPUs.
- D. Update a MySQL database flag to increase the number of vCPUs.
Answer: C
Explanation:
https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch
NEW QUESTION # 19
You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?
- A. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
- B. Use the default configuration for the automated backups location.
- C. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
- D. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
Answer: C
NEW QUESTION # 20
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 MongoD8 Atlas with Charts.
- B. Use Firestore with Looker.
- C. Use Cloud Spanner with Data Studio.
- D. Use Bigtable with Looker.
Answer: A
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 # 21
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 Spanner.
- B. Use BigQuery, and load data in batches.
- C. Deploy the database using Cloud SQL.
- D. C.Deploy the database using Bigtable.
Answer: D
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 # 22
You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process dat a. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?
- A. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
- B. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
- C. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
- D. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
Answer: A
Explanation:
Verify that the replica has processed all the transactions it has received from the primary. This ensures that when promoted, the replica reflects all transactions that were received before the primary became unavailable. https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#verify_failover_criteria
NEW QUESTION # 23
Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)
- A. Use an auto-incrementing value as the primary key.
- B. Promote low-cardinality attributes in multi-attribute primary keys.
- C. Normalize the data model.
- D. Use bit-reverse sequential value as the primary key.
- E. Promote high-cardinality attributes in multi-attribute primary keys.
Answer: D,E
Explanation:
https://cloud.google.com/spanner/docs/schema-design D because high cardinality means you have more unique values in the collumn. That's a good thing for a hot-spotting issue. E because Spanner specifically has this feature to reduce hot spotting. Basically, it generates unique values https://cloud.google.com/spanner/docs/schema-design#bit_reverse_primary_key D) Promote high-cardinality attributes in multi-attribute primary keys.
This is a correct answer because promoting high-cardinality attributes in multi-attribute primary keys can help avoid hotspots in Cloud Spanner. High-cardinality attributes are those that have many distinct values, such as UUIDs, email addresses, or timestamps1. By placing high-cardinality attributes first in the primary key, you can ensure that the rows are distributed more evenly across the key space, and avoid having too many requests sent to the same server2.
E) Use bit-reverse sequential value as the primary key.
This is a correct answer because using bit-reverse sequential value as the primary key can help avoid hotspots in Cloud Spanner. Bit-reverse sequential value is a technique that reverses the bits of a monotonically increasing value, such as a timestamp or an auto-incrementing ID1. By reversing the bits, you can create a pseudo-random value that spreads the writes across the key space, and avoid having all the inserts occurring at the end of the table2.
NEW QUESTION # 24
You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process dat a. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?
- A. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
- B. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
- C. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
- D. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
Answer: A
NEW QUESTION # 25
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 asynchronous replication, and set up read replicas in different regions with synchronous replication.
- B. Set up all read replicas in a different region using asynchronous replication.
- C. Set up all read replicas in the same region as the primary instance with synchronous replication.
- D. 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.
Answer: D
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 # 26
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)
- A. Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.
- B. Create additional read replicas, and partition your analytics users to use different read replicas.
- C. Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.
- D. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
- E. Create secondary indexes on the replica.
Answer: B,D
NEW QUESTION # 27
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 Cloud Trace for application requests that are failing.
- C. Watch Query Insights for long running queries.
- D. Watch the Cloud SQL recommenders for overprovisioned instances.
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 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 # 28
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. Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Connect to the instance using a connection pool to best manage connections to the instance. - B. Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Use Cloud SQL Auth proxy to connect to the instance. - C. Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Connect to the instance using a connection pool to best manage connections to the instance. - D. Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Use Cloud SQL Auth proxy to connect to the instance.
Answer: D
NEW QUESTION # 29
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 Cloud Functions to run the export in Avro format.
- B. Use Cloud Functions to run the export in text format.
- C. Use Dataflow to run the export in Avro format.
- D. Use Dataflow to run the export in text format.
Answer: C
Explanation:
https://cloud.google.com/spanner/docs/import-export-overview#file-format
NEW QUESTION # 30
You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?
- A. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
- B. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
- C. Use Cloud Composer to execute a select * from table(s) query and export results.
- D. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
Answer: B
NEW QUESTION # 31
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 Cloud SQL for PostgreSQL.
- D. Migrate to Google Kubernetes Engine (GKE).
Answer: C
NEW QUESTION # 32
Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring. What should you do?
- A. Use Cloud Spanner instead of Cloud SQL.
- B. Increase the storage size for the instance.
- C. Use many smaller Cloud SQL instances.
- D. Increase the number of CPUs for your instance.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/best-practices#data-arch
NEW QUESTION # 33
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
- A. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
- B. Migrate applications and Oracle databases to Compute Engine.
- C. Migrate applications to Cloud SQL.
- D. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
Answer: D
NEW QUESTION # 34
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?
- A. Add more nodes to the Bigtable cluster.
- B. Use Key Visualizer for Bigtable.
- C. Isolate the data analysts and operations user groups to use different Bigtable instances.
- D. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
Answer: D
NEW QUESTION # 35
Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?
- A. Use Database Migration Service.
- B. Use the native export and import functionality of the source database.
- C. Create a database on Google Cloud, and use Dataflow for database migration.
- D. Create a database on Google Cloud, and use database links to perform the migration.
Answer: A
Explanation:
Simplify migrations to the cloud. Available now for MySQL and PostgreSQL, with SQL Server and Oracle migrations in preview.
* Migrate to Cloud SQL and AlloyDB for PostgreSQL from on-premises, Google Cloud, or other clouds
* Replicate data continuously for minimal downtime migrations
* Serverless and easy to set up
NEW QUESTION # 36
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 both the external IP address and the internal IP address, and instead rely on Private Google Access.
- B. Specify an authorized network with the CIDR range of the VM.
- C. Disable and remove the internal IP address assignment.
- D. Disable and remove the external IP address assignment.
Answer: D
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 # 37
You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?
- A. Create a custom app profile with multi-cluster routing.
- B. Use the default app profile with single-cluster routing.
- C. Create a custom app profile with single-cluster routing.
- D. Use the default app profile with multi-cluster routing.
Answer: B
NEW QUESTION # 38
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 Database Migration Service to migrate all databases to Cloud SQL.
- 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 a combination of Database Migration Service and partner tools to support the data migration strategy.
Answer: A
Explanation:
https://cloud.google.com/blog/products/databases/tips-for-migrating-across-compatible-database-engines
NEW QUESTION # 39
......
PDF (New 2024) Actual Google Professional-Cloud-Database-Engineer Exam Questions: https://www.validvce.com/Professional-Cloud-Database-Engineer-exam-collection.html
Professional-Cloud-Database-Engineer Exam Dumps, Professional-Cloud-Database-Engineer Practice Test Questions: https://drive.google.com/open?id=1JHJb0QBw8w4nVzrO_tm8VmmKXc0gf6NI
