A retail company is about to migrate its online and mobile store to AWS. The company’s CEO has strategic
plans to grow the brand globally. A Database Specialist has been challenged to provide predictable read and
write database performance with minimal operational overhead.
What should the Database Specialist do to meet these requirements?

A.

Use Amazon DynamoDB global tables to synchronize transactions

B.

Use Amazon EMR to copy the orders table data across Regions

C.

Use Amazon Aurora Global Database to synchronize all transactions

D.

Use Amazon DynamoDB Streams to replicate all DynamoDB transactions and sync them

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

An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes
critical business metrics that will be pulled from the core production database running on Amazon Aurora.
Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a
cost-effective solution. The solution needs to accommodate the unpredictable read workload from the
reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?

A.

Turn on the serverless option in the DB cluster so it can automatically scale based on demand.

B.

Provision a clone of the existing DB cluster for the new Application team.

C.

Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoingreplication using AWS DMS change data capture (CDC).

D.

Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on
CPUconsumption.

A company is building a new web platform where user requests trigger an AWS Lambda function that
performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new
platform yielded successful execution and fast response times. However, upon more extensive tests with the
actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive
too many connections errors.
Which of the following will resolve this issue?

A.

Edit the my.cnf file for the DB cluster to increase max_connections

B.

Increase the instance size of the DB cluster

C.

Change the DB cluster to Multi-AZ

D.

Increase the number of Aurora Replica

A company has multiple applications serving data from a secure on-premises database. The company is
migrating all applications and databases to the AWS Cloud. The IT Risk and Compliance department requires
that auditing be enabled on all secure databases to capture all log ins, log outs, failed logins, permission
changes, and database schema changes. A Database Specialist has recommended Amazon Aurora MySQL as
the migration target, and leveraging the Advanced Auditing feature in Aurora.
Which events need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing
requirements? (Choose three.)

A.

CONNECT

B.

QUERY_DCL

C.

QUERY_DDL

D.

QUERY_DML

E.

TABLE

F.

QUERY

A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL
Server environment. The cause of a recent spike in CPU utilization was not determined using the standard
metrics that were collected. The CPU spike caused the application to perform poorly, impacting users. A
Database Specialist needs to determine what caused the CPU spike.
Which combination of steps should be taken to provide more visibility into the processes and queries running
during an increase in CPU load? (Choose two.)

A.

Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.

B.

Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
I

C.

mplement a caching layer to help with repeated queries on the RDS SQL Server DB instance.

D.

Use Amazon QuickSight to view the SQL statement being run.

E.

Enable Amazon RDS Performance Insights to view the database load and filter the load by waits,
SQLstatements, hosts, or users.

A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has
noticed that the Development team is restoring their MySQL database multiple times a day when Developers
make mistakes in their schema updates. The Developers sometimes need to wait hours to the restores to
complete.
Multiple team members are working on the project, making it difficult to find the correct restore point for each
mistake.
Which approach should the Database Specialist take to reduce downtime?

A.

Deploy multiple read replicas and have the team members make changes to separate replica instances

B.

Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot

C.

Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature

D.

Enable the Amazon RDS for MySQL Backtrack feature

A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests
to be logged and retained for 180 days. The RDS for PostgreSQL DB instance is currently using the default
parameter group. A Database Specialist has identified that setting the log_connections parameter to 1 will
enable connections logging.
Which combination of steps should the Database Specialist take to meet the logging and retention
requirements? (Choose two.)

A.

Update the log_connections parameter in the default parameter group

B.

Create a custom parameter group, update the log_connections parameter, and associate the parameterwith the DB instance

C.

Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration
to180 days

D.

Enable publishing of database engine logs to an Amazon S3 bucket and set the lifecycle policy to 180
days

E.

Connect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf
file

A gaming company is designing a mobile gaming app that will be accessed by many users across the globe.
The company wants to have replication and full support for multi-master writes. The company also wants to
ensure low latency and consistent performance for app users.
Which solution meets these requirements?

A.

Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling

B.

Use Amazon Aurora for storage and enable cross-Region Aurora Replicas

C.

Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache

D.

Use Amazon Neptune for storage

A Database Specialist needs to speed up any failover that might occur on an Amazon Aurora PostgreSQL DB
cluster. The Aurora DB cluster currently includes the primary instance and three Aurora Replicas.
How can the Database Specialist ensure that failovers occur with the least amount of downtime for the
application?

A.

Set the TCP keepalive parameters low

B.

Call the AWS CLI failover-db-cluster command

C.

Enable Enhanced Monitoring on the DB cluster

D.

Start a database activity stream on the DB cluster