Free Professional-Cloud-Database-Engineer Exam Dumps

Question 16

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?

A. 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.
B. Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.Schedule downtime to run each Cloud Data Fusion pipelin
C. Verify that the migration was successful.Re-point the applications to the Cloud SQL for MySQL instance.
D. Pause the on-premises applications.Use the mysqldump utility to dump the database content in compressed forma
E. Run gsutil –m 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.
F. Pause the on-premises applications.Use the mysqldump utility to dump the database content in CSV forma
G. Run gsutil –m 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.

Correct Answer:A
https://cloud.google.com/database-migration/docs/mysql/configure-source- database
To migrate the database while preserving transactions and minimizing downtime, you should use Database Migration Service. This service will allow you to migrate the database in a way that is transparent to your users and applications. It will also allow you to test the migration before you make it live, so that you can be sure that everything will work as expected.

Question 17

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?

A. Use Firestore and ensure that the PersistenceEnabled option is set to true.
B. Use Memorystore for Memcached.
C. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
D. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.

Correct Answer:A
https://firebase.google.com/docs/firestore/manage-data/enable-offline

Question 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?

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.

Correct Answer:B
“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

Question 19

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?

A. Use Cloud SQL with read replicas for throughput.
B. Use Firestore, and rely on automatic serverless scaling.
C. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
D. Use Bigtable, and add nodes as necessary to achieve the required throughput.

Correct Answer:D
https://cloud.google.com/memorystore/docs/redis/redis-overview

Question 20

Your company's mission-critical, globally available application is supported by a Cloud Spanner database. Experienced users of the application have read and write access to the database, but new users are assigned read-only access to the database. You need to assign the appropriate Cloud Spanner Identity and Access Management (IAM) role to new users being onboarded soon. What roles should you set up?

A. roles/spanner.databaseReader
B. roles/spanner.databaseUser
C. roles/spanner.viewer
D. roles/spanner.backupWriter

Correct Answer:A
https://cloud.google.com/spanner/docs/iam?hl=it