A financial services company is developing a shared data service that supports different applications from
throughout the company. A Database Specialist designed a solution to leverage Amazon ElastiCache for Redis
with cluster mode enabled to enhance performance and scalability. The cluster is configured to listen on port
6379.
Which combination of steps should the Database Specialist take to secure the cache data and protect it from
unauthorized access? (Choose three.)

A.

Enable in-transit and at-rest encryption on the ElastiCache cluster.

B.

Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.

C.

Ensure the security group for the ElastiCache cluster allows all inbound traffic from itself and inbound
traffic on TCP port 6379 from trusted clients only.

D.

Create an IAM policy to allow the application service roles to access all ElastiCache API actions.

E.

Ensure the security group for the ElastiCache clients authorize inbound TCP port 6379 and port 22
traffic from the trusted ElastiCache cluster’s security group.

F.

Ensure the cluster is created with the auth-token parameter and that the parameter is used in all
subsequent commands.

A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server.
Due to escalating support and maintenance costs, the company is exploring the option of moving the workload
to an Amazon Aurora PostgreSQL DB cluster.
What is the quickest way for the company to gather data on the migration compatibility?

A.

Perform a logical dump from the Db2 database and restore it to an Aurora DB cluster. Identify the gaps
andcompatibility of the objects migrated by comparing row counts from source and target tables.

B.

Run AWS DMS from the Db2 database to an Aurora DB cluster. Identify the gaps and compatibility of
theobjects migrated by comparing the row counts from source and target tables.

C.

Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate
themigration compatibility.

D.

Run the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB cluster.Create a migration assessment report to evaluate the migration compatibility.

A company is planning to close for several days. A Database Specialist needs to stop all applications
alongwith the DB instances to ensure employees do not have access to the systems during this time. All
databasesare running on Amazon RDS for MySQL.
The Database Specialist wrote and executed a script to stop all the DB instances. When reviewing the logs,the
Database Specialist found that Amazon RDS DB instances with read replicas did not stop.
How should the Database Specialist edit the script to fix this issue?

A.

Stop the source instances before stopping their read replicas

B.

Delete each read replica before stopping its corresponding source instance

C.

Stop the read replicas before stopping their source instances

D.

Use the AWS CLI to stop each read replica and source instance at the same

An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its
allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second
read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less
than half of its CPU and RAM resources.
What should a Database Specialist do in this situation to increase performance and return latency to
sub-second levels?

A.

Increase the size of the DB instance storage

B.

Change the underlying EBS storage type to General Purpose SSD (gp2)

C.

Disable EBS optimization on the DB instance

D.

Change the DB instance to an instance class with a higher maximum bandwidth

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

A company needs a data warehouse solution that keeps data in a consistent, highly structured format. The
company requires fast responses for end-user queries when looking at data from the current year, and users
must have access to the full 15-year dataset, when needed. This solution also needs to handle a fluctuating
number incoming queries. Storage costs for the 100 TB of data must be kept low.Which solution meets these requirements?

A.

Leverage an Amazon Redshift data warehouse solution using a dense storage instance type while
keeping all the data on local Amazon Redshift storage. Provision enough instances to support high
demand

B.

Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most
recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum
layer. Provision enough instances to support high demand

C.

Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most
recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum
layer. Enable Amazon Redshift Concurrency Scaling.

D.

Leverage an Amazon Redshift data warehouse solution using a dense storage instance to store the most
recent data. Keep historical data on Amazon S3 and access it using the Amazon Redshift Spectrum
layer. Leverage Amazon Redshift elastic resize

A user has a non-relational key-value database. The user is looking for a fully managed AWS service that will
offload the administrative burdens of operating and scaling distributed databases. The solution must be
cost-effective and able to handle unpredictable application traffic.
What should a Database Specialist recommend for this user?

A.

Create an Amazon DynamoDB table with provisioned capacity mode

B.

Create an Amazon DocumentDB cluster

C.

Create an Amazon DynamoDB table with on-demand capacity mode

D.

Create an Amazon Aurora Serverless DB cluster

A retail company with its main office in New York and another office in Tokyo plans to build a database
solution on AWS. The company’s main workload consists of a mission-critical application that updates its
application data in a data store. The team at the Tokyo office is building dashboards with complex analytical
queries using the application data. The dashboards will be used to make buying decisions, so they need to have
access to the application data in less than 1 second.
Which solution meets these requirements?

A.

Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the
apnortheast-1 Region. Create an Amazon ElastiCache cluster in the ap-northeast-1 Region to
cacheapplication data from the replica to generate the dashboards.

B.

Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the
ap-northeast-1Region. Use Amazon QuickSight for displaying dashboard results.

C.

Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read
replicainstance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.

D.

Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the
replicain the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1
Region.

A company’s Security department established new requirements that state internal users must connect to an
existing Amazon RDS for SQL Server DB instance using their corporate Active Directory (AD) credentials. A
Database Specialist must make the modifications needed to fulfill this requirement.
Which combination of actions should the Database Specialist take? (Choose three.)

A.

Disable Transparent Data Encryption (TDE) on the RDS SQL Server DB instance.

B.

Modify the RDS SQL Server DB instance to use the directory for Windows authentication. Createappropriate new logins.

C.

Use the AWS Management Console to create an AWS Managed Microsoft AD. Create a trust
relationshipwith the corporate AD.

D.

Stop the RDS SQL Server DB instance, modify it to use the directory for Windows authentication, and
startit again. Create appropriate new logins.

E.

Use the AWS Management Console to create an AD Connector. Create a trust relationship with
thecorporate AD.

F.

Configure the AWS Managed Microsoft AD domain controller Security Group.

After restoring an Amazon RDS snapshot from 3 days ago, a company’s Development team cannot connect
tothe restored RDS DB instance. What is the likely cause of this problem?

A.

The restored DB instance does not have Enhanced Monitoring enabled

B.

The production DB instance is using a custom parameter group

C.

The restored DB instance is using the default security group

D.

The production DB instance is using a custom option group