A company is running a finance application on an Amazon RDS for MySQL DB instance. The application is
governed by multiple financial regulatory agencies. The RDS DB instance is set up with security groups to
allow access to certain Amazon EC2 servers only. AWS KMS is used for encryption at rest.
Which step will provide additional security?

A.

Set up NACLs that allow the entire EC2 subnet to access the DB instance

B.

Disable the master user account

C.

Set up a security group that blocks SSH to the DB instance

D.

Set up RDS to use SSL for data in transit

A gaming company has recently acquired a successful iOS game, which is particularly popular during
theholiday season. The company has decided to add a leaderboard to the game that uses Amazon
DynamoDB.The application load is expected to ramp up over the holiday season.
Which solution will meet these requirements at the lowest cost?

A.

DynamoDB Streams

B.

DynamoDB with DynamoDB Accelerator

C.

DynamoDB with on-demand capacity mode

D.

DynamoDB with provisioned capacity mode with Auto Scaling

An IT consulting company wants to reduce costs when operating its development environment databases. The
company’s workflow creates multiple Amazon Aurora MySQL DB clusters for each development group. The
Aurora DB clusters are only used for 8 hours a day. The DB clusters can then be deleted at the end of the
development cycle, which lasts 2 weeks.
Which of the following provides the MOST cost-effective solution?

A.

Use AWS CloudFormation templates. Deploy a stack with the DB cluster for each development group.Delete the stack at the end of the development cycle

B.

Use the Aurora DB cloning feature. Deploy a single development and test Aurora DB instance, and
createclone instances for the development groups. Delete the clones at the end of the development cycle.

C.

Use Aurora Replicas. From the master automatic pause compute capacity option, create replicas for
eachdevelopment group, and promote each replica to master. Delete the replicas at the end of the
developmentcycle.

D.

Use Aurora Serverless. Restore current Aurora snapshot and deploy to a serverless cluster for
eachdevelopment group. Enable the option to pause the compute capacity on the cluster and set an
appropriatetimeout

A company is concerned about the cost of a large-scale, transactional application using Amazon DynamoDB
that only needs to store data for 2 days before it is deleted. In looking at the tables, a Database Specialist
notices that much of the data is months old, and goes back to when the application was first deployed.
What can the Database Specialist do to reduce the overall cost?

A.

Create a new attribute in each table to track the expiration time and create an AWS Glue transformation
to delete entries more than 2 days old.

B.

Create a new attribute in each table to track the expiration time and enable DynamoDB Streams on each
table.

C.

Create a new attribute in each table to track the expiration time and enable time to live (TTL) on each
table.

D.

Create an Amazon CloudWatch Events event to export the data to Amazon S3 daily using AWS Data
Pipeline and then truncate the Amazon DynamoDB table

A Database Specialist is planning to create a read replica of an existing Amazon RDS for MySQL Multi-AZ
DB instance. When using the AWS Management Console to conduct this task, the Database Specialist
discovers that the source RDS DB instance does not appear in the read replica source selection box, so the read
replica cannot be created.
What is the most likely reason for this?

A.

The source DB instance has to be converted to Single-AZ first to create a read replica from it.

B.

Enhanced Monitoring is not enabled on the source DB instance.

C.

The minor MySQL version in the source DB instance does not support read replicas.

D.

Automated backups are not enabled on the source DB instance.

A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for
MySQLDB instance. Immediately after creating the read replica, users that query it report slow response
times.
What could be causing these slow response times?

A.

New volumes created from snapshots load lazily in the background

B.

Long-running statements on the master

C.

Insufficient resources on the master

D.

Overload of a single replication thread by excessive writes on the master

A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon
RDS for PostgreSQL using AWS DMS. The application requires minimal downtime when the RDS DB
instance goes live.
What change should the Database Specialist make to enable the migration?

A.

Configure the on-premises application database to act as a source for an AWS DMS full load with
ongoing change data capture (CDC)

B.

Configure the AWS DMS replication instance to allow both full load and ongoing change data
capture(CDC)

C.

Configure the AWS DMS task to generate full logs to allow for ongoing change data capture (CDC)

D.

Configure the AWS DMS connections to allow two-way communication to allow for ongoing change
datacapture (CDC)

A company is running an Amazon RDS for PostgeSQL DB instance and wants to migrate it to an Amazon
Aurora PostgreSQL DB cluster. The current database is 1 TB in size. The migration needs to have minimal
downtime.
What is the FASTEST way to accomplish this?

A.

Create an Aurora PostgreSQL DB cluster. Set up replication from the source RDS for PostgreSQL DB
instance using AWS DMS to the target DB cluster.

B.

Use the pg_dump and pg_restore utilities to extract and restore the RDS for PostgreSQL DB instance to
the Aurora PostgreSQL DB cluster.

C.

Create a database snapshot of the RDS for PostgreSQL DB instance and use this snapshot to create the
Aurora PostgreSQL DB cluster.

D.

Migrate data from the RDS for PostgreSQL DB instance to an Aurora PostgreSQL DB cluster using an
Aurora Replica. Promote the replica during the cutover.

A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL
DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific
database wait events to better understand the situation.
How can the Database Specialists accomplish this?

A.

Enable the option to push all database logs to Amazon CloudWatch for advanced analysis

B.

Create appropriate Amazon CloudWatch dashboards to contain specific periods of time

C.

Enable Amazon RDS Performance Insights and review the appropriate dashboard

D.

Enable Enhanced Monitoring will the appropriate settings

A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly databasebackups for compliance purposes. A Database Administrator must provide Auditors with data within 24 hours.
Which solution will meet these requirements and is the MOST operationally efficient?

A.

Create an AWS Lambda function to run on the first day of every month to take a manual RDS
snapshot.Move the snapshot to the company’s Amazon S3 bucket.

B.

Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.

C.

Create an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30
days.

D.

Create an AWS Lambda function to run on the first day of every month to create an automated
RDSsnapshot