Brainscape's Knowledge GenomeTM

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


See full index

A Cloud Guru - AWS > DB > Flashcards

DB Flashcards

1
Q

What is abbreviation of RDS?

A

Relational database Service.

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

Is RDS is serverless?

A

No RDS is not serverless

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

Is aurora serverless?

A

Basic Aurora is not serverless

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

Is aurora serverless is serverless ?

A

Yes aurora serverless is serverless

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

List of database engines available in AWS RDS?

A 
SQL SERVER, 
ORACLE, 
MYSQL, 
POSTGRESQL, 
AURORA, 
MARIA DB
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are the two main features of RDS?

A

Multi AZ & Read Replica are main features of RDS

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

What is the purpose of Multi AZ?

A

Disaster Recovery is the main purpose of Multi AZ

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

What is the purpose of Read Replica?

A

Read Replica is user for Performance

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

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

A

Yes in Multi AZ failover is automatic.

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

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

A

NO in Read Replica failover is not automatic

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

Maximum no of Read replica AWS RDS support?

A

5

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

What is abbreviation of OLTP?

A

Online Transaction Processing

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

What is abbreviation of OLAP?

A

Online Analytic Processing

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

What is ElastiCache?

A

ElastiCache is a DB cache service for AWS

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

What is Redshift?

A

Redshift is AWS Data warehouse Service used for OLAP

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

What is Dynamodb?

A

Dynamodb is a no sql database service

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

RDS Service is used for what type of DB operation?

A

RDS is used for OLTP operations

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

What is the default port no for MySQL?

A

3306

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

Can you able to access to DB VM?

A

No

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

What are the different types of backups available for RDS?

A

Automated Backup & DB Snapshot

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

What is max retention period for Automated backup?

A

35 Days

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

Where do we store automated backup in AWS?

A

S3

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

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

A

All database backup are restored only to New database.

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

Can we encrypt RDS database?

A

Yes; RDS DB can be encrypted at rest.

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

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

A

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

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

To enable read replica what needs to be enabled?

A

Automated backup need to be enabled To enable read replica

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

Can you have read replica of read replica?

A

Yes; we can have read replica of read replica

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

Does Read replica has same DNS end point?

A

No; Each read replica has different DNS endpoint

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

Can you have read replica in different AZ?

A

Yes

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

Can you have read replica in different Region?

A

Yes

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

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

A

Replication will be broken.

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

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

A

SSD

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

What is the DynamoDB default setup for data replication?

A

DynamoDB Spread on 3 distinct data center

34
Q

What are the read models available for DynamoDB ?

A

Eventual Read & Strong Read

35
Q

What is Eventual Read?

A

Latency > 1 sec

36
Q

What is Strong Read?

A

Latency < 1 sec

37
Q

What is DynamoDB Accelerator (DAX)?

A

Fully managed, highly available in memory cache for DynamoDB

38
Q

Does DAX Support both Read & write performance?

A

True

39
Q

What is DAX Response time?

A

DAX Respond within a Microsecond

40
Q

What is DynamoDB Transaction capacity?

A

25 items or 4 MB of data

41
Q

Does DynamoDB enable point in time recovery by default?

A

NO

42
Q

What are streams in Dynamo DB?

A

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

43
Q

Stream values are stored for how long?

A

24 Hrs

44
Q

Stream stores what type of data?

A

Insert, update & delete

45
Q

How to get Store Procedure functionality in Stream ?

A

Stream with Lambda function provide Store Procedure functionality

46
Q

How fast does Data replication take place?

A

1 Second

47
Q

What is DMS?

A

Database Migration Service

48
Q

What are the different Node config available for Redshift?

A

Single node & multi node

49
Q

How AWS charge Redshift usage?

A

Based on Compute node hrs, backup & data transfer

50
Q

Can we configure Redshift in multi AZ?

A

No

51
Q

Aurora support which db engines?

A

MySQL & PostgreSQL

52
Q

Does Aurora backup affect performance?

A

NO

53
Q

Aurora backup is set by default?

A

Yes

54
Q

Can you share aurora snapshot to other aws accounts?

A

Yes

55
Q

What are 2 caching engine for elastic cache?

A

Memcached & Redis

56
Q

Where we use Memcached?

A

Memcached is used for Simple caching.

57
Q

Where we use Redis?

A

Redis is used for Complex caching.

58
Q

where we use elasticache?

A

We use along in web application performance?

59
Q

Redis is Multi AZ?

A

yes

60
Q

Can you do back up & restore on Redis?

A

Yes

61
Q

EMR Abbreviation?

A

Elastic Map Reduce

62
Q

What is EMR?

A

EMR is a Cloud based big data platform.

63
Q

How does EMR operates?

A

EMR Operate in Cluster of EC2 Instance.

64
Q

In EMR each EC2 instance is called as?

A

Node

65
Q

What are different type of EMR Nodes?

A

Master Node
Core Node
Task Node

66
Q

What is EMR Master node?

A

Master Node Manages Cluster

67
Q

What is EMR Core node?

A

Core Node handle software that runs task & store data

68
Q

What is EMR Task node?

A

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

69
Q

Where does RDS runs?

A

RDS Runs on Virtual Machines

70
Q

Can you update RDS instance?

A

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

71
Q

Why Read Replica is used for?

A

Read Replica is used for performance.

72
Q

Is dynamo DB serverless?

A

Yes

73
Q

What is default backup retention period for RedShift?

A

1 day

74
Q

What is max backup retention period for RedShift?

A

35 days

75
Q

What we can use to enable caching on Multi AZ?

A

Redis

76
Q

How many copy of data available for Redsift?

A

3 - Original, Replica & Backup

77
Q

How many copy of data available for Aurora?

A

6

78
Q

What is max aurora replica?

A

15

79
Q

What is max MySQL replica?

A

5

80
Q

What is max PostgreSQL replica?

A

1

A Cloud Guru - AWS (11 decks)

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