Google Professional-Cloud-Database-Engineer Exam Prep Guide: Prep guide for the Professional-Cloud-Database-Engineer Exam
2024 New Preparation Guide of Google Professional-Cloud-Database-Engineer Exam
The Google Professional-Cloud-Database-Engineer exam covers various topics such as database architecture, database design, data modeling, database security, database optimization, and database maintenance. Professional-Cloud-Database-Engineer exam also assesses an individual's ability to design, implement, and manage highly available and scalable database solutions using Google Cloud Platform services such as Cloud SQL, Cloud Spanner, and Cloud Bigtable.
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 # 36
Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?
- A. Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
- B. Create an external replica, and use Cloud SQL to synchronize the data to the replica.
- C. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
- D. Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
Answer: D
NEW QUESTION # 37
Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?
- A. Create the database persistent disk with Google-managed encryption keys.
- B. Create the database with customer-managed encryption keys.
- C. Create the database persistent disk with customer-managed encryption keys.
- D. Create the database with Google-managed encryption keys.
Answer: C
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 a combination of Database Migration Service and partner tools to support the data migration strategy.
- D. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
Answer: D
NEW QUESTION # 39
You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?
- A. Use Cloud Spanner in a multi-region configuration.
- B. Use Cloud SQL with cross-region replicas.
- C. Use highly available Cloud SQL with multiple zones.
- D. Use Cloud Spanner in a regional configuration.
Answer: D
NEW QUESTION # 40
You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)
- A. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
- B. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
- C. If the corruption is significant, use import and export.
- D. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- E. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
Answer: A,B
NEW QUESTION # 41
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 BigQuery.
- B. Use Cloud Spanner.
- C. Use Bigtable
- D. Use Firestore.
Answer: A
NEW QUESTION # 42
You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)
- A. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
- B. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- C. If the corruption is significant, use import and export.
- D. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
- E. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
Answer: A,B
Explanation:
https://cloud.google.com/spanner/docs/pitr#ways-to-recover
To recover the entire database, backup or export the database specifying a timestamp in the past and then restore or import it to a new database. This is typically used to recover from data corruption issues when you have to revert the entire database to a point-in-time before the corruption occurred.
This part describes significant corruption - A
To recover a portion of the database, perform a stale read specifying a query-condition and timestamp in the past, and then write the results back into the live database. This is typically used for surgical operations on a live database. For example, if you accidentally delete a particular row or incorrectly update a subset of data, you can recover it with this method.
This describes insignificant corruption case - E
https://cloud.google.com/spanner/docs/pitr https://cloud.google.com/spanner/docs/backup/restore-backup
NEW QUESTION # 43
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: A
NEW QUESTION # 44
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer dat a. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?
- A. Apply a schema data management pattern.
- B. Apply a database data management pattern.
- C. Apply an instance data management pattern.
- D. Apply a table data management pattern.
Answer: C
Explanation:
https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner#multi-tenancy-data-management-patterns
https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner
NEW QUESTION # 45
Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this dat a. What should you do?
- A. Use Identity and Access Management (IAM) for Bigtable access control.
- B. Use VPC Service Controls to create a trusted network for the Bigtable service.
- C. Use customer-managed encryption keys (CMEK).
- D. Use Google Cloud Armor to add IP addresses to an allowlist.
Answer: B
Explanation:
"Users can define a security perimeter around Google Cloud resources such as Cloud Storage buckets, Bigtable instances, and BigQuery datasets to constrain data within a VPC and control the flow of data." https://cloud.google.com/vpc-service-controls
NEW QUESTION # 46
During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?
- A. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
- B. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
- C. Shut down your existing Cloud SQL for MySQL instance, and enable HA.
- D. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
Answer: B
Explanation:
Creating a new instance and migrating data can be time-consuming and disruptive to your application's availability. Shutting down the existing instance is not a recommended approach, as it will cause downtime for your application.
The recommended approach is to use the gcloud instances patch command to enable high availability on your existing Cloud SQL for MySQL instance. This command updates the instance's configuration to enable the failover replica, configure it, and enable automatic failover.
By following this approach, you can ensure minimal downtime, and your application can continue to operate during the process.
NEW QUESTION # 47
You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?
- A. Set up different organizations for each database type, and apply policy constraints at the organization level.
- B. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
- C. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
- D. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
Answer: B
NEW QUESTION # 48
Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?
- A. Use Cloud SQL.
- B. Use Cloud Spanner.
- C. Use Bigtable.
- D. Use Firestore.
Answer: A
NEW QUESTION # 49
You need to issue a new server certificate because your old one is expiring. You need to avoid a restart of your Cloud SQL for MySQL instance. What should you do in your Cloud SQL instance?
- A. Reset your SSL configuration, and download your server certificate.
- B. Issue a rollback, and download your server certificate.
- C. Create a new client certificate, and download it.
- D. Create a new server certificate, and download it.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/sqlserver/configure-ssl-instance#server-certs
NEW QUESTION # 50
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 Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
- B. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
- C. Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
- D. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
Answer: B
Explanation:
https://severalnines.com/blog/how-achieve-postgresql-high-availability-pgbouncer/
https://cloud.google.com/blog/products/databases/using-haproxy-to-scale-read-only-workloads-on-cloud-sql-for-postgresql This answer is correct because PgBouncer is a lightweight connection pooler for PostgreSQL that can help you distribute read requests between the Cloud SQL primary and read replica instances1. PgBouncer can also improve performance and scalability by reducing the overhead of creating new connections and reusing existing ones1. You can install PgBouncer on a Compute Engine instance and configure it to connect to the Cloud SQL instances using private IP addresses or the Cloud SQL Auth proxy2.
NEW QUESTION # 51
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 Firestore with Looker.
- D. Use MongoD8 Atlas with Charts.
Answer: D
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 # 52
Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?
- A. Create another schema to load older data.
- B. Compress the data using a different compression algorithm.
- C. Manually or automatically increase the storage capacity.
- D. Normalize the database to the third normal form.
Answer: C
Explanation:
https://cloud.google.com/sql/docs/mysql/instance-settings#storage-capacity-2ndgen
NEW QUESTION # 53
You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?
- A. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.
- B. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
- C. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
- D. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
Answer: A
Explanation:
The Cloud SQL connectors are libraries that provide encryption and IAM-based authorization when connecting to a Cloud SQL instance. They can't provide a network path to a Cloud SQL instance if one is not already present. Other ways to connect to a Cloud SQL instance include using a database client or the Cloud SQL Auth proxy. https://cloud.google.com/sql/docs/postgres/connect-connectors https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory/blob/main/docs/jdbc-postgres.md
NEW QUESTION # 54
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?
- A. Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.
- B. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
- C. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
- D. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
Answer: B
NEW QUESTION # 55
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 number of CPUs for your instance.
- C. Use many smaller Cloud SQL instances.
- D. Increase the storage size for the instance.
Answer: A
NEW QUESTION # 56
Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?
- A. Use Cloud SQL serverless exports.
- B. Use the mysqldump utility on the primary database instance to export the backup.
- C. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
- D. Create a read replica, and then use the mysqldump utility to export each table.
Answer: A
Explanation:
https://cloud.google.com/blog/products/databases/introducing-cloud-sql-serverless-exports
NEW QUESTION # 57
......
Latest Questions Professional-Cloud-Database-Engineer Guide to Prepare Free Practice Tests: https://www.dumpsmaterials.com/Professional-Cloud-Database-Engineer-real-torrent.html
Professional-Cloud-Database-Engineer Practice Exam - 134 Unique Questions: https://drive.google.com/open?id=1cP7_wKoSZd7T9kkUnxUiVHWGs8hDe8lc
