AWS AWS Database and Analytics Services 5

Question 1

A company wants to migrate an Oracle database to AWS with minimal code changes. Which service provides the highest compatibility?

Accepted Answer

Amazon RDS for Oracle

Answer

Amazon RDS for Oracle runs the actual Oracle engine, providing maximum compatibility with existing Oracle workloads and stored procedures.

Question 2

What does Amazon Neptune primarily support as a database service?

Accepted Answer

Graph data with relationships and traversals

Answer

Amazon Neptune is a fully managed graph database service supporting property graph (Gremlin) and RDF/SPARQL query languages.

Question 3

Which RDS feature provides a hot standby in a different Availability Zone that automatically takes over during a failure?

Accepted Answer

Multi-AZ Deployment

Answer

RDS Multi-AZ maintains a synchronous standby replica in a different AZ and automatically fails over during planned or unplanned outages.

Question 4

An IoT application collects sensor readings every second. Which AWS service is optimized to store and query this time-series data?

Accepted Answer

Amazon Timestream

Answer

Amazon Timestream is a fast, scalable, serverless time-series database purpose-built for IoT and operational applications.

Question 5

What is the maximum retention period for DynamoDB Streams records?

Accepted Answer

24 hours

Answer

DynamoDB Streams records are retained for 24 hours, after which they are automatically deleted.

AWS Practice Test