Question 1

Your organization has a ticketing system that needs an online marketing analytics and reporting application.

You need to select a relational database that can manage hundreds of terabytes of data to support this new

application. Which database should you use?

Options :

A : Cloud SQL

B : BigQuery

C : Cloud Spanner

D : Bigtable

Answer: B

Question 2

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?

Options :

A :

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.

B :

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.

C :

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.

D :

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.

Answer: B

Question 3

Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

Options :

A :

Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your

database changes to Cloud SQL.

Select the Backfill historical data check box on your stream configuration to initiate Datastream to

backfill any data that is out of sync between the source and destination.

Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application

to use the new instance.

B :

Create migration job using Database Migration Service.

Set the migration job type to Continuous, and allow the databases to complete the full dump phase and

start sending data in change data capture (CDC) mode.

Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and

wait for the migration job to complete.

Update your application connections to the new instance.

C :

Create migration job using Database Migration Service.

Set the migration job type to One-time, and perform this migration during a maintenance window.

Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded

into the Cloud SQL destination database and the destination database to be promoted to the primary

database.

Update your application connections to the new instance.

D :

Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance

window.

Move the files to Cloud Storage, and import each database into your Cloud SQL instance.

Continue to dump each database until all the databases are migrated.

Update your application connections to the new instance.

Answer: B

Question 4

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?

Options :

A : Use Firestore with Looker.

B : Use Cloud Spanner with Data Studio.

C : Use MongoD8 Atlas with Charts.

D : Use Bigtable with Looker.

Answer: C

Question 5

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?

Options :

A : Watch Query Insights for long running queries.

B :

Watch the Cloud SQL instance monitor for CPU utilization metrics.

C :

Watch the Cloud SQL recommenders for overprovisioned instances.

D :

Watch Cloud Trace for application requests that are failing.

Answer: A

Smartly Prepare Exam with Free Online Professional-Cloud-Database-Engineer Practice Test

Buying Options: