DB

Question 1

What is abbreviation of RDS?

Answer 1

Relational database Service.

Question 2

Is RDS is serverless?

Answer 2

No RDS is not serverless

Question 3

Is aurora serverless?

Answer 3

Basic Aurora is not serverless

Question 4

Is aurora serverless is serverless ?

Answer 4

Yes aurora serverless is serverless

Question 5

List of database engines available in AWS RDS?

Answer 5

SQL SERVER, 
ORACLE, 
MYSQL, 
POSTGRESQL, 
AURORA, 
MARIA DB

Question 6

What are the two main features of RDS?

Answer 6

Multi AZ & Read Replica are main features of RDS

Question 7

What is the purpose of Multi AZ?

Answer 7

Disaster Recovery is the main purpose of Multi AZ

Question 8

What is the purpose of Read Replica?

Answer 8

Read Replica is user for Performance

Question 9

In case of DB failure; DB failover in Multi AZ is it automatic?

Answer 9

Yes in Multi AZ failover is automatic.

Question 10

In case of DB failure; DB failover in Read Replica is it automatic?

Answer 10

NO in Read Replica failover is not automatic

Question 11

Maximum no of Read replica AWS RDS support?

Answer 11

5

Question 12

What is abbreviation of OLTP?

Answer 12

Online Transaction Processing

Question 13

What is abbreviation of OLAP?

Answer 13

Online Analytic Processing

Question 14

What is ElastiCache?

Answer 14

ElastiCache is a DB cache service for AWS

Question 15

What is Redshift?

Answer 15

Redshift is AWS Data warehouse Service used for OLAP

Question 16

What is Dynamodb?

Answer 16

Dynamodb is a no sql database service

Question 17

RDS Service is used for what type of DB operation?

Answer 17

RDS is used for OLTP operations

Question 18

What is the default port no for MySQL?

Answer 18

3306

Question 19

Can you able to access to DB VM?

Answer 19

No

Question 20

What are the different types of backups available for RDS?

Answer 20

Automated Backup & DB Snapshot

Question 21

What is max retention period for Automated backup?

Answer 21

35 Days

Question 22

Where do we store automated backup in AWS?

Answer 22

S3

Question 23

If we restore DB Backup will it be restored in Existing DB or new database?

Answer 23

All database backup are restored only to New database.

Question 24

Can we encrypt RDS database?

Answer 24

Yes; RDS DB can be encrypted at rest.

Question 25

If encryption is enabled for DB does it apply for DB related items?

Answer 25

Yes; Encryption is applied for Read Replica, Backup & snapshot

Question 26

To enable read replica what needs to be enabled?

Answer 26

Automated backup need to be enabled To enable read replica

Question 27

Can you have read replica of read replica?

Answer 27

Yes; we can have read replica of read replica

Question 28

Does Read replica has same DNS end point?

Answer 28

No; Each read replica has different DNS endpoint

Question 29

Can you have read replica in different AZ?

Answer 29

Yes

Question 30

Can you have read replica in different Region?

Answer 30

Yes

Question 31

What is the downside; if you enable Read replica as main db?

Answer 31

Replication will be broken.

Question 32

In DynamoDB database data is stored in which type of disk?

Answer 32

SSD

Question 33

What is the DynamoDB default setup for data replication?

Answer 33

DynamoDB Spread on 3 distinct data center

Question 34

What are the read models available for DynamoDB ?

Answer 34

Eventual Read & Strong Read

Question 35

What is Eventual Read?

Answer 35

Latency > 1 sec

Question 36

What is Strong Read?

Answer 36

Latency < 1 sec

Question 37

What is DynamoDB Accelerator (DAX)?

Answer 37

Fully managed, highly available in memory cache for DynamoDB

Question 38

Does DAX Support both Read & write performance?

Answer 38

True

Question 39

What is DAX Response time?

Answer 39

DAX Respond within a Microsecond

Question 40

What is DynamoDB Transaction capacity?

Answer 40

25 items or 4 MB of data

Question 41

Does DynamoDB enable point in time recovery by default?

Answer 41

NO

Question 42

What are streams in Dynamo DB?

Answer 42

Streams are the time order sequence of item level changes in a table.

Question 43

Stream values are stored for how long?

Answer 43

24 Hrs

Question 44

Stream stores what type of data?

Answer 44

Insert, update & delete

Question 45

How to get Store Procedure functionality in Stream ?

Answer 45

Stream with Lambda function provide Store Procedure functionality

Question 46

How fast does Data replication take place?

Answer 46

1 Second

Question 47

What is DMS?

Answer 47

Database Migration Service

Question 48

What are the different Node config available for Redshift?

Answer 48

Single node & multi node

Question 49

How AWS charge Redshift usage?

Answer 49

Based on Compute node hrs, backup & data transfer

Question 50

Can we configure Redshift in multi AZ?

Answer 50

No

Question 51

Aurora support which db engines?

Answer 51

MySQL & PostgreSQL

Question 52

Does Aurora backup affect performance?

Answer 52

NO

Question 53

Aurora backup is set by default?

Answer 53

Yes

Question 54

Can you share aurora snapshot to other aws accounts?

Answer 54

Yes

Question 55

What are 2 caching engine for elastic cache?

Answer 55

Memcached & Redis

Question 56

Where we use Memcached?

Answer 56

Memcached is used for Simple caching.

Question 57

Where we use Redis?

Answer 57

Redis is used for Complex caching.

Question 58

where we use elasticache?

Answer 58

We use along in web application performance?

Question 59

Redis is Multi AZ?

Answer 59

yes

Question 60

Can you do back up & restore on Redis?

Answer 60

Yes

Question 61

EMR Abbreviation?

Answer 61

Elastic Map Reduce

Question 62

What is EMR?

Answer 62

EMR is a Cloud based big data platform.

Question 63

How does EMR operates?

Answer 63

EMR Operate in Cluster of EC2 Instance.

Question 64

In EMR each EC2 instance is called as?

Answer 64

Node

Question 65

What are different type of EMR Nodes?

Answer 65

Master Node Core Node Task Node

Question 66

What is EMR Master node?

Answer 66

Master Node Manages Cluster

Question 67

What is EMR Core node?

Answer 67

Core Node handle software that runs task & store data

Question 68

What is EMR Task node?

Answer 68

Task Node handle software that runs task & not to store data; Its optional Node.

Question 69

Where does RDS runs?

Answer 69

RDS Runs on Virtual Machines

Question 70

Can you update RDS instance?

Answer 70

No you don’t have access to RDS VM; RDS VM will be maintained by AWS.

Question 71

Why Read Replica is used for?

Answer 71

Read Replica is used for performance.

Question 72

Is dynamo DB serverless?

Answer 72

Yes

Question 73

What is default backup retention period for RedShift?

Answer 73

1 day

Question 74

What is max backup retention period for RedShift?

Answer 74

35 days

Question 75

What we can use to enable caching on Multi AZ?

Answer 75

Redis

Question 76

How many copy of data available for Redsift?

Answer 76

3 - Original, Replica & Backup

Question 77

How many copy of data available for Aurora?

Answer 77

6

Question 78

What is max aurora replica?

Answer 78

15

Question 79

What is max MySQL replica?

Answer 79

5

Question 80

What is max PostgreSQL replica?

Answer 80

1