[Full-Version] 2024 New Professional-Cloud-Database-Engineer Actual Exam Dumps, Google Practice Test [Q18-Q42]

4/5 - (1 vote)

[Full-Version] 2024 New Professional-Cloud-Database-Engineer Actual Exam Dumps, Google Practice Test

Study HIGH Quality Professional-Cloud-Database-Engineer Free Study Guides and Exams Tutorials

Google Professional-Cloud-Database-Engineer certification exam is designed for individuals who possess advanced skills and knowledge in managing databases on the Google Cloud Platform. Google Cloud Certified – Professional Cloud Database Engineer certification is designed to validate your ability to design, develop, and administer scalable and secure databases on Google Cloud. Google Cloud Certified – Professional Cloud Database Engineer certification exam is intended for database administrators, database developers, and other IT professionals who want to demonstrate their expertise in managing databases on the Google Cloud Platform.

To be eligible for the Google Professional-Cloud-Database-Engineer Certification Exam, candidates must have experience in designing and managing databases on the Google Cloud Platform. They must also have a deep understanding of data modeling, database design, SQL, and other database management concepts.

NEW QUESTION 18
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?

Use Cloud Spanner instead of Cloud SQL.

Increase the number of CPUs for your instance.

Increase the storage size for the instance.

Use many smaller Cloud SQL instances.

NEW QUESTION 19
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?

Use workload identity federation to impersonate a service account.

Ask existing users to set their Google password to match their corporate password.

Migrate the application to Google Cloud, and use Identity and Access Management (IAM).

Use Google Workspace Password Sync to replicate passwords into Google Cloud.

NEW QUESTION 20
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?

Develop a custom data replication service to send data into BigQuery.

Use Cloud SQL federated queries.

Use Database Migration Service to replicate tables into BigQuery.

Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

NEW QUESTION 21
You recently launched a new product to the US market. You currently have two Bigtable clusters in one US region to serve all the traffic. Your marketing team is planning an immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability according to Google-recommended practices. What should you do?

Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone europe-west1-d
cluster-c in zone asia-east1-b

Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central1-b
cluster-c in zone us-east1-a

Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone australia-southeast1-a
cluster-c in zone europe-west1-d
cluster-d in zone asia-east1-b

Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central2-a
cluster-c in zone asia-northeast1-b
cluster-d in zone asia-east1-b

NEW QUESTION 22
Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?

Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.

Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.

Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.

Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.

NEW QUESTION 23
Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?

Use Cloud SQL for data storage.

Use Cloud Spanner for data storage.

Use Memorystore for data storage.

Use Bigtable for data storage.

NEW QUESTION 24
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?

Place the bulk of the read and write workloads closer to the default leader region.

Use staleness of at least 15 seconds.

Add more read-write replicas.

Keep the total CPU utilization under 45% in each region.

NEW QUESTION 25
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?

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.

Create your database with one primary node and one read replica in the region.

Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.

Configure your Cloud SQL instance with high availability enabled.

NEW QUESTION 26
Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?

Identify and optimize slow running queries, or set parallel replication flags.

Stop all running queries, and re-create the replicas.

Edit the primary instance to upgrade to a larger disk, and increase vCPU count.

Edit the primary instance to add additional memory.

NEW QUESTION 27
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.)

Use an auto-incrementing value as the primary key.

Normalize the data model.

Promote low-cardinality attributes in multi-attribute primary keys.

Promote high-cardinality attributes in multi-attribute primary keys.

Use bit-reverse sequential value as the primary key.

NEW QUESTION 28
You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

Export the data from the existing database, and load the data into a new Cloud SQL database.

Use Migrate for Compute Engine to complete the migration.

Use Datastream to complete the migration.

Use Database Migration Service to complete the migration.

NEW QUESTION 29
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?

Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.

Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.

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.

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.

NEW QUESTION 30
You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:
configure where data is stored
control where the encryption keys are stored
govern the access to data
What should you do?

Replicate Cloud SQL databases across different zones.

Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.

Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.

Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.

NEW QUESTION 31
Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?

Use query parameters to speed up frequently executed queries.

Change the Cloud Spanner configuration from multi-region to single region.

Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.

Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.

NEW QUESTION 32
Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?

Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Keep backups older than one day stored in Actifio OnVault storage.

Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Keep backups older than one day stored in Actifio OnVault storage.

Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.

Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.

NEW QUESTION 33
You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest dat a. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?

Create a read replica for the Sales Reporting application.

Create two separate databases in the instance, and perform dual writes from the Order Management application.

Use a Cloud SQL federated query for the Sales Reporting application.

Queue up all the requested reports in PubSub, and execute the reports at night.

NEW QUESTION 34
You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?

Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.

Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences

Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

NEW QUESTION 35
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?

Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.

Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.

Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.

Create an external replica, and use Cloud SQL to synchronize the data to the replica.

NEW QUESTION 36
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?

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.

Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.

Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.

Configure the primary, standby, and read replica instances in zone A, all in the same region.

NEW QUESTION 37
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)

Use a change data capture (CDC) migration strategy.

Move the physical database servers from on-premises to Google Cloud.

Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.

Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.

Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

NEW QUESTION 38
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?

Use Firestore with Looker.

Use Cloud Spanner with Data Studio.

Use MongoD8 Atlas with Charts.

Use Bigtable with Looker.

NEW QUESTION 39
You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?

Close idle connections or restart the instance before beginning the import operation.

Increase the amount of memory allocated to your instance.

Ensure that the service account has the Storage Admin role.

Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.

NEW QUESTION 40
You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.
You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?

Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.

Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.

Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.

Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.

NEW QUESTION 41
You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO. What should you do?

Use Cloud SQL instance monitoring.

Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.

Use Cloud SQL logs.

Use the SQL Server Always On Availability Group dashboard.

NEW QUESTION 42
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?

Set up all read replicas in a different region using asynchronous replication.

Set up all read replicas in the same region as the primary instance with synchronous replication.

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.

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.

Get 100% Real Free Google Cloud Certified Professional-Cloud-Database-Engineer Sample Questions: https://www.actualcollection.com/Professional-Cloud-Database-Engineer-exam-questions.html

Leave a comment Cancel reply