AWS AWS Database and Analytics Services 5 — Questions and Answers
Question 1: A company wants to migrate an Oracle database to AWS with minimal code changes. Which service provides the highest compatibility?
- Amazon Aurora MySQL
- Amazon DynamoDB
- Amazon Aurora PostgreSQL
- Amazon RDS for Oracle (Correct answer)
Correct answer: Amazon RDS for Oracle
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?
- Relational data with ACID transactions
- Graph data with relationships and traversals (Correct answer)
- Time-series metrics and sensor data
- Wide-column data for analytics
Correct 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.
Question 3: Which RDS feature provides a hot standby in a different Availability Zone that automatically takes over during a failure?
- Read Replica
- Multi-AZ Deployment (Correct answer)
- Automated Backups
- Performance Insights
Correct 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.
Question 4: An IoT application collects sensor readings every second. Which AWS service is optimized to store and query this time-series data?
- Amazon Keyspaces
- Amazon Timestream (Correct answer)
- Amazon DocumentDB
- Amazon MemoryDB for Redis
Correct answer: Amazon Timestream
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?
- 24 hours (Correct answer)
- 48 hours
- 7 days
- 30 days
Correct answer: 24 hours
DynamoDB Streams records are retained for 24 hours, after which they are automatically deleted.
Question 6: A company needs MongoDB-compatible managed database on AWS. Which service should they use?
- Amazon DynamoDB
- Amazon Keyspaces
- Amazon DocumentDB (Correct answer)
- Amazon Neptune
Correct answer: Amazon DocumentDB
Amazon DocumentDB is a fully managed document database service that is compatible with MongoDB workloads and drivers.
Question 7: Which Amazon Redshift feature allows you to query data in S3 without loading it into Redshift tables?
- Redshift Workload Management
- Redshift Spectrum (Correct answer)
- Redshift Concurrency Scaling
- Redshift AQUA
Correct answer: Redshift Spectrum
Redshift Spectrum extends queries to data stored in S3 without moving or copying data into Redshift.
AWS AWS Database and Analytics Services 5
A company wants to migrate an Oracle database to AWS with minimal code changes.
Which service provides the highest compatibility?