Professional Cloud Database Engineer Exam Dumps - Reliable Way to Pass and Get Certified

Professional Cloud Database Engineer Exam Dumps – Reliable Way to Pass and Get Certified

Category:

Comments:

0 Comments

Post Date:

January 9, 2024

If you are looking for a reliable and comprehensive way to prepare for your Professional Cloud Database Engineer certification exam, look no further than Professional Cloud Database Engineer exam questions. These Professional Cloud Database Engineer exam dumps questions are designed to help you assess your knowledge, identify your strengths and weaknesses, and improve your chances of passing the exam on the first try. These Professional Cloud Database Engineer dumps questions cover all the topics and concepts that are essential for the Professional Cloud Database Engineer exam, so you can be sure that you are fully prepared. Test Google Professional Cloud Database Engineer free dumps below.

Page 1 of 4

1. 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?

Issue a rollback, and download your server certificate.

Create a new client certificate, and download it.

Create a new server certificate, and download it.

Reset your SSL configuration, and download your server certificate.

2. 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.

3. 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?

Use external server replication.

Use Data Migration Service.

Use Cloud SQL for MySQL external replica.

Use the mysqldump utility and binary logs.

4. Your organization is running a critical production database on a virtual machine (VM) on Compute Engine. The VM has an ext4-formatted persistent disk for data files. The database will soon run out of storage space. You need to implement a solution that avoids downtime.

What should you do?

In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.

In the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use

In the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.

In the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.

5. Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible.

What should you do?

Migrate all the databases to Cloud SQ

Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.

Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.

Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.

6. 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?

Shut down and restart each application.

Write a utility to scan database query logs.

Write a utility to scan application logs.

Use query tags to add application-centric database monitoring.

7. You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached data. You need to ensure that the application has scalability, strong consistency, and multi-region replication.

What should you do?

Use Firestore and ensure that the PersistenceEnabled option is set to true.

Use Memorystore for Memcached.

Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.

Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.

8. You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future.

What should you do?

Set your production instance's maintenance window to non-business hours.

Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.

Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.

Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.

9. 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.)

If the corruption is significant, use backup and restore, and specify a recovery timestamp.

If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.

If the corruption is significant, use import and export.

If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.

If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.

10. 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?

Deploy the database using Cloud SQ

Use BigQuery, and load data in batches.

Deploy the database using Bigtable.

Deploy the database using Cloud Spanner.

Page 2 of 4

11. An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles.

What roles should you assign to the service account?

roles/cloudsql.viewer and roles/spanner.databaseUser

roles/cloudsql.editor and roles/spanner.admin

roles/cloudsql.client and roles/spanner.databaseReader

roles/cloudsql.instanceUser and roles/spanner.databaseUser

12. You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions.

What should you do?

Reuse the existing service account that populates this database.

Create a new service account, and grant it the Cloud Spanner Database Admin role.

Create a new service account, and grant it the Cloud Spanner Database Reader role.

Create a new service account, and grant it the spanner.databases.select permission.

13. Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL.

The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime.

What should you do?

Use Database Migration Service to connect to your on-premises database, and choose continuous replication. After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.

Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQ

Schedule downtime to run each Cloud Data Fusion pipeline. Verify that the migration was successful. Re-point the applications to the Cloud SQL for MySQL instance.

Pause the on-premises applications. Use the mysqldump utility to dump the database content in compressed format. Run gsutil Cm to move the dump file to Cloud Storage. Use the Cloud SQL for MySQL import option. After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

Pause the on-premises applications. Use the mysqldump utility to dump the database content in CSV format. Run gsutil Cm to move the dump file to Cloud Storage. Use the Cloud SQL for MySQL import option. After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.

14. 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. Ask existing users to set their Google password to match their corporate password.

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

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

15. You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags.

What should you do?

Automate instance creation by writing a Dataflow job.

Automate instance creation by setting up Terraform scripts.

Create the instances using the Google Cloud Console U

Create clones from a template Cloud SQL instance.

16. You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues.

You want the solution to minimize cost and operations overhead.

What should you do?

Use Cloud Scheduler and Cloud Functions to run the daily export.

Create a streaming Datatlow job to export the table.

Set up Cloud Composer, and create a task to export the table daily.

Run the cron job on a Compute Engine instance to continue the export.

17. 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?

Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.

Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.

Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.

Shut down your existing Cloud SQL for MySQL instance, and enable H

18. 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 data.

What should you do?

Use Identity and Access Management (IAM) for Bigtable access control.

Use VPC Service Controls to create a trusted network for the Bigtable service.

Use customer-managed encryption keys (CMEK).

Use Google Cloud Armor to add IP addresses to an allowlist.

19. 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.

20. You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task.

What should you do? (Choose two.)

Drop or disable all users except database administration users.

Disable all foreign key constraints on the source PostgreSQL database.

Ensure that all PostgreSQL tables have a primary key.

Shut down the database before the Data Migration Service task is started.

Ensure that pglogical is installed on the source PostgreSQL database.

Page 3 of 4

21. 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?

Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.

Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.

Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.

Create a CSV file by running the SQL statement SELEC

..INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.

22. You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key.

What should you do?

Use Cloud Spanner with a customer-managed encryption key (CMEK).

Use Cloud Spanner with default encryption.

Use Cloud SQL with a customer-managed encryption key (CMEK).

Use Bigtable with default encryption.

23. 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?

Use Cloud Spanner in a regional configuration.

Use Cloud Spanner in a multi-region configuration.

Use Cloud SQL with cross-region replicas.

Use highly available Cloud SQL with multiple zones.

24. 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?

Bring DB-1 back online.

Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

Delete DB-2 so that DB-1 automatically reverts to the primary instance.

Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

25. Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical.

The operations team consists of:

Person A is a database administrator.

Person B is an analyst who generates metric reports.

Application C is responsible for automatic backups.

You need to assign roles to team members for Cloud Spanner.

Which roles should you assign?

roles/spanner.databaseAdmin for Person A roles/spanner.databaseReader for Person B roles/spanner.backupWriter for Application C

roles/spanner.databaseAdmin for Person A roles/spanner.databaseReader for Person B roles/spanner.backupAdmin for Application C

roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner databaseReader for Application C

roles/spanner.databaseAdmin for Person A roles/spanner.databaseUser for Person B roles/spanner.backupWriter for Application C

26. You are responsible for designing a new database for an airline ticketing application in Google Cloud.

This application must be able to:

- Work with transactions and offer strong consistency.

- Work with structured and semi-structured (JSON) data.

- Scale transparently to multiple regions globally as the operation grows.

You need a Google Cloud database that meets all the requirements of the application.

What should you do?

Use Cloud SQL for PostgreSQL with both cross-region read replicas.

Use Cloud Spanner in a multi-region configuration.

Use Firestore in Datastore mode.

Use a Bigtable instance with clusters in multiple regions.

27. 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?

Use the native export and import functionality of the source database.

Create a database on Google Cloud, and use database links to perform the migration.

Create a database on Google Cloud, and use Dataflow for database migration.

Use Database Migration Service.

28. 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?

Isolate the data analysts and operations user groups to use different Bigtable instances.

Check the Cloud Monitoring table/bytes_used metric from Bigtable.

Use Key Visualizer for Bigtable.

Add more nodes to the Bigtable cluster.

29. Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped.

What should you do?

Set Terraform deletion_protection to true.

Rerun terraform apply.

Create a read replica.

Use point-in-time-recovery (PITR) to recover the database.

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.

Page 4 of 4

31. 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?

Use Firestore.

Use Cloud Spanner.

Use Cloud SQ

Use Bigtable.

32. Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1.

What should you do?

Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-west1-b. Create a read replica in us-east1-c.

Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-central1-b. Create a read replica in us-east1-b.

Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-east-b. Create a read replica in us-east1-c.

Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-east1-b. Create a read replica in us-central1-b.

33. Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency.

What should you do?

Select Bare Metal Solution for Oracle.

Select Cloud SQ

Select Bigtable.

Select Cloud Spanner.

34. 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?

Watch Query Insights for long running queries.

Watch the Cloud SQL instance monitor for CPU utilization metrics.

Watch the Cloud SQL recommenders for overprovisioned instances.

Watch Cloud Trace for application requests that are failing.

35. You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have their own project.

What should you do to configure the networks?

Create a new VPC network in each project, and use VPC Network Peering to connect the two together.

Create a Shared VPC that both the application VMs and Cloud SQL instances will use.

Use the default networks, and leverage Cloud VPN to connect the two together.

Place both the application VMs and the Cloud SQL instances in the default network of each project.

36. You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations.

What should you do? (Choose two.)

Identify whether the database has over 512 tables.

Identify all tables that do not have a primary key.

Identity all tables that do not have at least one foreign key.

Identify whether the source database is encrypted using pgcrypto extension.

Identify whether the source database uses customer-managed encryption keys (CMEK).

37. 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.

38. You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working.

What should you do?

Use the Google Cloud Console or gcloud CLI to manually create a new clone database.

Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.

Verify that the new replica is created automatically.

Start the original primary instance and resume replication.

39. 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?

Use Cloud SQL with read replicas for throughput.

Use Firestore, and rely on automatic serverless scaling.

Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.

Use Bigtable, and add nodes as necessary to achieve the required throughput.

40. Connect to the instance using a connection pool to best manage connections to the instance.

TAGS:

Professional Cloud Database Engineer, Professional Cloud Database Engineer exam dumps

Notify of

Label

Name*

Email*

Website

Label

Name*

Email*

Website

0 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

Get Professional Cloud Database Engineer Dumps Full Version

Q&As: 132
Versions: PDF and Software Download Now

About Dumpsinfo

Dumpsinfo is a good platform providing the latest exam information and dumps questions for all IT certification exams. You can study all the latest exam dumps questions online.

[email protected]

Mon - Sat 9:00am - 6:00pm

Professional Cloud Database Engineer Exam Dumps – Reliable Way to Pass and Get Certified

Related

Posts

ChromeOS Administrator Dumps Questions – Effective Way to Get Certified

Get Certified Easily with Online Professional Cloud Network Engineer Dumps

Test Online Professional Cloud DevOps Engineer Dumps Questions to Be Certified

Valid Professional Machine Learning Engineer Exam Dumps are Your best Choice to Pass

About Us

EMAIL

Services

Opening Hours