A Database Specialist is designing a new database infrastructure for a ride hailing application. The application
data includes a ride tracking system that stores GPS coordinates for all rides. Real-time statistics and metadata
lookups must be performed with high throughput and microsecond latency. The database should be fault
tolerant with minimal operational overhead and development effort.
Which solution meets these requirements in the MOST efficient way?

A.

Use Amazon RDS for MySQL as the database and use Amazon ElastiCache

B.

Use Amazon DynamoDB as the database and use DynamoDB Accelerator

C.

Use Amazon Aurora MySQL as the database and use Aurora’s buffer cache

D.

Use Amazon DynamoDB as the database and use Amazon API Gateway

A company has a web-based survey application that uses Amazon DynamoDB. During peak usage, when
survey responses are being collected, a Database Specialist sees the
ProvisionedThroughputExceededException error.
What can the Database Specialist do to resolve this error? (Choose two.)

A.

Change the table to use Amazon DynamoDB Streams

B.

Purchase DynamoDB reserved capacity in the affected Region

C.

Increase the write capacity units for the specific table

D.

Change the table capacity mode to on-demand

E.

Change the table type to throughput optimized

A company is deploying a solution in Amazon Aurora by migrating from an on-premises system. The IT
department has established an AWS Direct Connect link from the company’s data center. The company’s
Database Specialist has selected the option to require SSL/TLS for connectivity to prevent plaintext data from
being set over the network. The migration appears to be working successfully, and the data can be queried
from a desktop machine.
Two Data Analysts have been asked to query and validate the data in the new Aurora DB cluster. Both
Analysts are unable to connect to Aurora. Their user names and passwords have been verified as valid and
the Database Specialist can connect to the DB cluster using their accounts. The Database Specialist also
verified that the security group configuration allows network from all corporate IP addresses.
What should the Database Specialist do to correct the Data Analysts’ inability to connect?

A.

Restart the DB cluster to apply the SSL change.

B.

Instruct the Data Analysts to download the root certificate and use the SSL certificate on the connection string to connect.

C.

Add explicit mappings between the Data Analysts’ IP addresses and the instance in the security group
assigned to the DB cluster.

D.

Modify the Data Analysts’ local client firewall to allow network traffic to AWS.

A financial company wants to store sensitive user data in an Amazon Aurora PostgreSQL DB cluster. The
database will be accessed by multiple applications across the company. The company has mandated that all
communications to the database be encrypted and the server identity must be validated. Any non-SSL-based
connections should be disallowed access to the database.
Which solution addresses these requirements?

A.

Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS
certificatebundle and configure the PostgreSQL connection string with sslmode=allow.

B.

Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS
certificatebundle and configure the PostgreSQL connection string with sslmode=disable.

C.

Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS
certificatebundle and configure the PostgreSQL connection string with sslmode=verify-ca.

D.

Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS
certificatebundle and configure the PostgreSQL connection string with sslmode=verify-full.

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.