DBS-C01 Amazon-Web-Services Exam Questions and Free Practice Test

Question 7

A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to accommodate migration efforts. Post-migration, the company purged unwanted data from the instance. The company now want to downsize storage to save money. The solution must have the least impact on production and near-zero downtime.
Which solution would meet these requirements?

A. Create a snapshot of the old databases and restore the snapshot with the required storage

B. Create a new RDS DB instance with the required storage and move the databases from the old instancesto the new instance using AWS DMS

C. Create a new database using native backup and restore

D. Create a new read replica and make it the primary by terminating the existing primary

Correct Answer:A

Question 8

A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.
Which migration method should a Database Specialist use?

A. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.

B. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.

C. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.

D. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.

Correct Answer:A

Question 9

A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. The schema and the data have been migrated successfully. The on-premises database server was also being used to run database maintenance cron jobs written in Python to perform tasks including data purging and generating data exports. The logs for these jobs show that, most of the time, the jobs completed within 5 minutes, but a few jobs took up to 10 minutes to complete. These maintenance jobs need to be set up for Aurora PostgreSQL.
How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?

A. Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.

B. Connect to the Aurora host and create cron jobs to run the maintenance jobs following the requiredschedule.

C. Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatchEvents.

D. Create the maintenance job using the Amazon CloudWatch job scheduling plugin.

Correct Answer:D

Question 10

An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store. The database should be designated to support the following use cases:
DBS-C01 dumps exhibit Update scores in real time whenever a player is playing the game.
Retrieve a player’s score details for a specific game session.
A Database Specialist decides to implement a DynamoDB table. Each player has a unique user_id and each game has a unique game_id.
Which choice of keys is recommended for the DynamoDB table?

A. Create a global secondary index with game_id as the partition key

B. Create a global secondary index with user_id as the partition key

C. Create a composite primary key with game_id as the partition key and user_id as the sort key

D. Create a composite primary key with user_id as the partition key and game_id as the sort key

Correct Answer:B

Question 11

A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three Aurora Replicas for a highly intensive, business-critical application. The Aurora DB cluster has one mediumsized primary instance, one large-sized replica, and two medium sized replicas. The Database Specialist did not assign a promotion tier to the replicas.
In the event of a primary failure, what will occur?

A. Aurora will promote an Aurora Replica that is of the same size as the primary instance

B. Aurora will promote an arbitrary Aurora Replica

C. Aurora will promote the largest-sized Aurora Replica

D. Aurora will not promote an Aurora Replica

Correct Answer:A

Question 12

A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster with multiple Aurora Replicas that had been running with no issues for the past 2 months. The connection failure lasted for 5 minutes and corrected itself after that. The Database Specialist reviewed the Amazon RDS events and determined a failover event occurred at that time. The failover process took around 15 seconds to complete.
What is the MOST likely cause of the 5-minute connection outage?

A. After a database crash, Aurora needed to replay the redo log from the last database checkpoint

B. The client-side application is caching the DNS data and its TTL is set too high

C. After failover, the Aurora DB cluster needs time to warm up before accepting client connections

D. There were no active Aurora Replicas in the Aurora DB cluster

Correct Answer:C

START DBS-C01 EXAM