AWS AWS Database and Analytics Services 2 — Questions and Answers
Question 1: Which Amazon Aurora feature allows you to serve read traffic from up to 15 low-latency read replicas?
- Aurora Multi-Master
- Aurora Serverless
- Aurora Replicas (Correct answer)
- Aurora Global Database
Correct answer: Aurora Replicas
Aurora Replicas share the same underlying storage as the primary instance and support up to 15 replicas with millisecond replica lag for read scaling.
Question 2: Which AWS analytics service allows you to run SQL queries directly on data stored in Amazon S3 without loading it into a database?
- Amazon Redshift Spectrum
- Amazon Athena (Correct answer)
- Amazon EMR
- AWS Glue
Correct answer: Amazon Athena
Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL without managing any infrastructure.
Question 3: What is the purpose of AWS Database Migration Service (DMS)?
- To automatically back up RDS databases
- To migrate databases to AWS with minimal downtime (Correct answer)
- To replicate data between S3 buckets
- To convert SQL queries to NoSQL format
Correct answer: To migrate databases to AWS with minimal downtime
AWS DMS helps migrate databases to AWS quickly and securely, keeping the source database fully operational during migration to minimize downtime.
Question 4: Which AWS service is used to process large amounts of data using Apache Hadoop and Spark frameworks?
- Amazon Kinesis
- Amazon EMR (Correct answer)
- AWS Glue
- Amazon Athena
Correct answer: Amazon EMR
Amazon EMR (Elastic MapReduce) is a managed cluster platform that simplifies running big data frameworks like Apache Hadoop and Spark on AWS.
Question 5: Which DynamoDB feature enables you to capture a time-ordered sequence of item-level changes in a table?
- DynamoDB Accelerator (DAX)
- DynamoDB Global Tables
- DynamoDB Streams (Correct answer)
- DynamoDB Transactions
Correct answer: DynamoDB Streams
DynamoDB Streams captures a time-ordered sequence of item-level modifications in a DynamoDB table, enabling event-driven architectures and change data capture.
Question 6: What type of database engine does Amazon Neptune provide?
- Relational database
- Graph database (Correct answer)
- Time-series database
- Document database
Correct answer: Graph database
Amazon Neptune is a fully managed graph database service that supports property graph and RDF models, optimized for storing and querying highly connected datasets.
AWS AWS Database and Analytics Services 2
Which Amazon Aurora feature allows you to serve read traffic from up to 15 low-latency read replicas?