Brainscape's Knowledge GenomeTM

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


See full index

AWS-INTERVIEW-GUIDE > Databases & Storage Services > Flashcards

Databases & Storage Services Flashcards

1
Q

Q: What is Amazon Aurora?

A

Amazon Aurora is a fully managed relational database service provided by AWS that is compatible with MySQL and PostgreSQL.

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

What are some of Aurora benefits?

A

It offers high performance, scalability, and durability with built-in fault tolerance and automated backups.

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

What are the benefits of using AWS RDS? 5

A

Automated backups
Automated software patching
High availability, scalability
Multi-AZ deployments
Read replicas for improved performance

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

What use cases is AWS RDS is ideal for? 3

A

Web & Mobile applications
E-commerce platforms
Data analytics

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

What are the different types of Database stores? 4

A

Relational databases
NoSQL databases
Analytical databases
Object/Block/File storage

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

What does OLTP stand for?

A

OLTP stands for Online Transaction Processing

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

What is OLTP Database system designed to manage?

A

Designed for managing transaction-oriented workloads, like processing real-time business transactions.

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

Q: What are some common AWS services used for OLTP workloads? 3

A

Amazon RDS (Relational Database Service),
Amazon DynamoDB,
and Amazon Aurora.

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

Q: What is OLAP?

A

A: OLAP stands for Online Analytical Processing.

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

Q: What is the purpose of OLAP?

A

A: OLAP involves analyzing large volumes of data to gain insights and make informed business decisions. It is typically used for complex queries and reporting.

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

Q: What are some common AWS services used for OLAP workloads?

A

A: AWS services commonly used for OLAP workloads include Amazon Redshift, Amazon Athena, and Amazon EMR (Elastic MapReduce).

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

Q: How do OLTP and OLAP differ?

A

A: OLTP handles transactional processing for individual database operations

OLAP focuses on analytical processing for complex queries and aggregations on large datasets for business intelligence and reporting.

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

Q: What is DynamoDB?

A

A: DynamoDB is a fully managed NoSQL database service provided by AWS that offers low-latency and scalable storage for applications.

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

Q: How does DynamoDB ensure scalability and performance? 3

A

Through its distributed architecture
Automatic partitioning of data, and
Provisioned throughput capacity.

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

Q: What is the difference between a partition key and a sort key in DynamoDB?

A

The partition key helps divide the data into groups, while the sort key helps order the items within each group. Together, they allow for efficient querying and retrieval of data based on specific criteria.

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

Q: What is the purpose of DynamoDB streams?

A

A: DynamoDB streams enable capturing and processing changes made to items in a table in real-time. It

17
Q

What type of architectures does DynamoDb allow you to build?

A

allows building event-driven architectures and supporting use cases like change notifications and data analysis.

18
Q

Q: What are Global Secondary Indexes (GSIs) in DynamoDB?

A

They enable more flexible querying options.

GSIs are alternate indexes that allow querying a table using a different primary key or attributes other than the original table’s primary key.

19
Q

Q: What is a local secondary index in DynamoDB?

A

A: A local secondary index (LSI) is an index that shares the same partition key as the base table but has a different sort key. It allows querying items within a single partition using alternate sort keys.

20
Q

Q: What are the best practices for designing DynamoDB tables? 3

A

Best practices include
Carefully choosing partition keys
Distributing workload evenly across partitions
Utilizing appropriate read and write capacities, and

21
Q

Q: What is Amazon S3?

A

Secure, durable, and scalable object storage service for files, images, videos, backups, and more

22
Q

How can data in Amazon S3 be secured? 5

A

Server-side encryption
Client-side encryption
Bucket policies
IAM roles and policies
Access control lists (ACLs)

23
Q

How is Amazon S3 billed? 3

A

The amount of data stored
Data transfer in/out and
Requests made

24
Q

What are some advanced features within S3 that have cost associated with them? 3

A

Versioning
Cross-region replication
Lifecycle Management

25
Q

What is Amazon Glacier?

A

Amazon Glacier: Low-cost archival storage for infrequently accessed data. Provides durability, security, and cost optimization for large-scale data archiving.

26
Q

Q: How does Amazon EBS differ from Amazon S3?

A

EBS is primarily used for EC2 instance storage, while S3 is more suitable for storing and sharing files.

27
Q

What is a Multi-AZ deployment in Amazon RDS?

A

Multi-AZ deployment: Primary database has standby replica in different AZ for automatic failover and minimal downtime

AWS-INTERVIEW-GUIDE (7 decks)

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