Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

AWS > Databases > Flashcards

Databases Flashcards

1
Q

Q: What types of databases does AWS offer?

A

A: Relational databases, NoSQL databases, data warehouses, in-memory databases, graph databases, and time series databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Q: What is Amazon RDS?

A

A: Amazon Relational Database Service (RDS) is a managed service for running relational databases like MySQL, PostgreSQL, SQL Server, MariaDB, Oracle, and Amazon Aurora.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Q: What is Amazon Aurora?

A

A: A high-performance, managed relational database compatible with MySQL and PostgreSQL, offering up to 5 times the performance of standard databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Q: What is Amazon DynamoDB?

A

A: A fully managed NoSQL database service designed for key-value and document data models, known for low latency and scalability.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Q: What is Amazon Redshift?

A

A: A fully managed, petabyte-scale data warehouse for running complex queries and analytics on structured data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Q: What is Amazon ElastiCache?

A

A: A fully managed in-memory database service for caching and real-time data processing, supporting Redis and Memcached.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Q: What is Amazon Neptune?

A

A: A fully managed graph database service optimized for storing and querying graph data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Q: What is Amazon Timestream?

A

A: A fully managed time-series database optimized for IoT and operational applications.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Q: What is Amazon Keyspaces?

A

A: A fully managed database service compatible with Apache Cassandra for large-scale NoSQL workloads.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Q: What is the difference between relational and NoSQL databases?

A

A: Relational databases store structured data in tables with predefined schemas, while NoSQL databases store unstructured or semi-structured data in flexible formats like key-value, document, or graph models.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Q: How are backups handled in AWS databases?

A

A: Services like RDS and DynamoDB offer automated and manual backups, including point-in-time recovery.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Q: What is Multi-AZ deployment in RDS?

A

A: A high availability feature where a standby replica is created in another Availability Zone to ensure failover support.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Q: What are read replicas in RDS?

A

A: Copies of a primary database instance that support read-heavy workloads and reduce latency.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Q: Which database engines are supported by RDS?

A

A: MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Aurora.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Q: What are Global Tables in DynamoDB?

A

A: A multi-region replication feature that allows DynamoDB tables to span multiple AWS regions for low latency and disaster recovery.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Q: What query languages are used in AWS databases?

A

A: SQL (RDS, Redshift), PartiQL (DynamoDB), Gremlin/SPARQL (Neptune), and CQL (Keyspaces).

17
Q

Q: What tools are available for migrating databases to AWS?

A

A: AWS Database Migration Service (DMS), AWS Schema Conversion Tool (SCT), and Snowball.

18
Q

Q: What AWS service is used for data warehousing?

A

A: Amazon Redshift.

19
Q

Q: What is Aurora Serverless?

A

A: A serverless option for Amazon Aurora that automatically adjusts capacity based on application demand.

20
Q

Q: What is a partition key in DynamoDB?

A

A: A unique identifier for each item in a table, used to distribute data across partitions.

21
Q

Q: What are secondary indexes in DynamoDB?

A

A: Indexes that allow querying on non-primary key attributes, including Global Secondary Indexes (GSI) and Local Secondary Indexes (LSI).

22
Q

Q: What is the difference between a query and a scan in DynamoDB?

A

A: A query retrieves items based on the primary key, while a scan reads all items in a table.

23
Q

Q: What is Redshift Spectrum?

A

A: A feature that allows running SQL queries on data stored in S3 without loading it into Redshift.

24
Q

Q: Which AWS service is used for in-memory caching?

A

A: Amazon ElastiCache.

25
Q

Q: What are common use cases for Amazon Neptune?

A

A: Social networks, recommendation engines, fraud detection, and knowledge graphs.

26
Q

Q: What AWS database is optimized for time-series data?

A

A: Amazon Timestream.

27
Q

Q: What security features are available in AWS databases?

A

A: Encryption at rest and in transit, IAM roles, security groups, and audit logging.

28
Q

Q: How does DynamoDB scale?

A

A: Through auto-scaling or manually adjusting read and write capacity units (RCUs and WCUs).

29
Q

Q: How is data encryption implemented in AWS databases?

A

A: Using AWS KMS for encryption at rest and SSL/TLS for data in transit.

30
Q

Q: What is Aurora Global Database?

A

A: A feature that enables a single Aurora database to span multiple regions, providing low-latency reads and disaster recovery.

31
Q

Q: What are serverless database options in AWS?

A

A: Aurora Serverless, DynamoDB, and Timestream.

32
Q

Q: What is columnar storage, and which AWS service uses it?

A

A: A storage format optimized for analytical queries, used by Amazon Redshift.

33
Q

Q: How do AWS databases support elasticity?

A

A: By automatically scaling capacity based on demand (e.g., Aurora Auto Scaling, DynamoDB Auto Scaling).

34
Q

Q: What pricing models are available for AWS databases?

A

A: Pay-as-you-go, reserved instances, and on-demand pricing.

35
Q

Q: How does Aurora differ from standard RDS databases?

A

A: Aurora is more scalable, offers better performance, and supports distributed storage.

AWS (29 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions