Db Flashcards

1
Q

EBS Volume

A

Virtual harddrive or block storage volumes.
Even if you stop/terminate an Amazon EC2 instance, all the data on the attached EBS volume remains available.

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

How do you create an EBS volume?

A

You define the configuration such as volume size and type and provision it.
You need to create Amazon EBS snapshots (backups)

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

Amazon EBS do volumes scale?

A

No + they need to be in the same AZ to attach EC2 instances

to attach an EBS to an EC2, they must be on the same AZ

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

What is an instance store?

A

Provides temporary block-level storage for an amazon ec2 instance.
So if the instance is terminated, the data is also lost

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

What are Amazon EC2 instances?

A

Virtual Servers.

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

Object Storage

A

each object consists of data, metadata and key

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

Object data?

A

image, video, text document and any type of file

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

Metadata

A

info about what the data is, how its used, the object size and so on.

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

Object key

A

unique identifier

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

Amazon Simple Storage Service (Amazon S3)

A

it is a service that provides object-level storage. Amazon S3 stores data as objects in buckets.

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

Max size for amazon s3?

A

5 TB

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

Why do you use amazon s3?

A

to store backup files, media files or archieved documents.

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

What factors affects Amazon s3?

A

how often you plan to retrieve you data
how available you need your data to be.

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

Amazon S3 Standard

A

Designed for frequently accessed data
Stores data in a minimum of 3 AZ (Available zones)
High cost

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

Amazon S3 Standard Infrequent Access S3 standard IA

A

Ideal for infrequently accessed data
Stores data in a minimum of 3 AZ (Available zones)

Similar to Amazon S3 Standard but low storage price and higher retrieval price

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

Amazon S3 One Zone-Infrequent Access [S3 One Zone IA]

A

Stores data in a single Availability zone
Has a lower storage price than Amazon S3 Standard IA

Benefits save on cost
easily reproduce data in the event of Availability zone failure

17
Q

Amazon S3 Intelligent Tiering

A

Ideal for data with unknown or changing access pattern
Requires a small monthly monitoring and automation fee per object

18
Q

Amazon S3 Glacier Instant Retrieval

A

Immediate access to data within milliseconds
Performance is like Amazon S3 Standard

19
Q

Amazon S3 Glacier Flexible Retrieval

A

Low cost storage designed for data archiving
Able to retrieve objects withing a few min to hours

For data archiving (insta)

20
Q

Amazon S3 Glacier Deep Archive

A

Lowest-cost object storage class ideal for archiving
Able to retrieve objects within 12 hours

All objects from this storage class are replicated and stored across at least three geographically dispersed Availability Zones.

21
Q

Amazon s3 outposts

A

Creates S3 buckets on Amazon S3 outposts
Makes it easier to retrieve, store and access data on AWS outposts

22
Q

Amazon Elastic File System (Amazon EFS)

A

multiple instances read and write simultaneously
Linux file system
Regional resource
Automaically scales

Serverleas file system

23
Q

Amazon Relational Database Service

A

a service that enables you to run relational databases in the AWS Cloud.

24
Q

Name 6 db engines that amazon rds supports

A

Amazon Aurora
PostgreSQL
MySQL
MariaDB
Oracle Database
Microsoft SQL Server

25
Q

Amazon Aurora?

A

5x faster than standard MySQL db and 3x faster than prostgres SQL
compatible with MySQL + prosgresSQL

1/10 cost of commercial
6 copies at any given time
15 read
conitinuous backup to s3

26
Q

Non relational Db

A

In a nonrelational database, you create tables
NoSQL databases

27
Q

Amazon DynamoDB

A

a key-value database service. It delivers single-digit millisecond performance at any scale.
It delivers single-digit millisecond performance at any scale.
serverless
scalability
purpose built
fully managed

28
Q

Amazon Redshift

A

based on postgresql
use for analytics & data warehouse
OLAP (Online analytical processing) not OLTP (transaction)
Column-based, not row-based
Has SQL console
Not access every seconds

29
Q

Amazon DocumentDB

A

Actually Mongo

30
Q

Neptune

A

Graph database (like Neo4J)
Highly available

such as recommendation engines, fraud detection, and knowledge graphs.

31
Q

QLDB

A

Quantum Ledger DB
For financial transaction
Like blockchain but not decentralized

32
Q

Managed Blockchain

A

Hyperledger fabric
Ethereum

33
Q

EC2

A

AZ

34
Q

s3 bucket

A

regional