AWS Database and Analytics Services Flashcards

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

Answer: Amazon RDS for Oracle

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

What does Amazon Neptune primarily support as a database service?

Answer: Graph data with relationships and traversals

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

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

Answer: Multi-AZ Deployment

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

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

Answer: Amazon Timestream

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

What is the maximum retention period for DynamoDB Streams records?

Answer: 24 hours

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

A company needs MongoDB-compatible managed database on AWS. Which service should they use?

Answer: Amazon DocumentDB

Amazon DocumentDB is a fully managed document database service that is compatible with MongoDB workloads and drivers.

Which Amazon Redshift feature allows you to query data in S3 without loading it into Redshift tables?

Answer: Redshift Spectrum

Redshift Spectrum extends queries to data stored in S3 without moving or copying data into Redshift.