[Q46-Q62] Professional-Cloud-Database-Engineer Exam Brain Dumps - Study Notes and Theory [Jul-2024]

NEW QUESTION 46
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 MySQL.
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 -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.

Pause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
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.

NEW QUESTION 47
You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?

Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.

Check whether your service account has cloudsql.instances.connect permission.

Enable the Cloud SQL Admin API.

Ensure that you are using an external (public) IP address interface.

NEW QUESTION 48
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 MySQL.
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 -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.

Pause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
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.

NEW QUESTION 49
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 50
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?

Enable serializable isolation in the Firebase app.

Deploy a US multi-region Firestore location.

Build a Firestore bundle, and deploy bundles to Cloud CDN.

Create a Firestore index on the news story date.

NEW QUESTION 51
You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?

Configure Firestore, and modify your application to offload queries.

Configure Bigtable, and modify your application to offload queries.

Configure Cloud SQL for PostgreSQL read replicas to offload queries.

Configure Memorystore, and modify your application to offload queries.

NEW QUESTION 52
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 53
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?

Create a clone database from a read replica database, and restore the clone in the same region.

Create a clone database from a read replica database, and restore the clone into a different zone.

Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.

Use the Cloud SQL database import feature. Import last week’s dump file from Cloud Storage.

NEW QUESTION 54
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?

Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.

Use Cloud SQL Auth proxy.

Connect to Cloud SQL using a connection that has SSL encryption.

Use customer-managed encryption keys with Cloud SQL.

NEW QUESTION 55
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.

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

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.

Set up different organizations for each database type, and apply policy constraints at the organization level.

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.

Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

NEW QUESTION 57
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.

NEW QUESTION 58
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 59
You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?

Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.

Use sharded Cloud SQL instances with one or more stores per database instance.

Use a Biglable cluster with autoscaling.

Use Cloud Spanner with a custom autoscaling solution.

NEW QUESTION 60
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 61
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

Use Cloud SQL with cross-region replicas.

Use high availability (HA) Cloud SQL with multiple zones.

Use zonal Cloud SQL without high availability (HA).

Use Cloud Spanner in a regional configuration.

NEW QUESTION 62
Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?

Use Logs Explorer to analyze log data.

Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

Use Error Reporting to count, analyze, and aggregate the data.

Use Cloud Debugger to inspect the state of an application.

[Q46-Q62] Professional-Cloud-Database-Engineer Exam Brain Dumps – Study Notes and Theory [Jul-2024]

admin

Leave a Reply Cancel reply

Related posts:

admin

You might also like

Leave a Reply Cancel reply