Brainscape's Knowledge GenomeTM

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


See full index

AWS Cert > Databases > Flashcards

Databases Flashcards

1
Q

Can you remote into RDS servers?

A

They run in Virtual machines and user cant log into those machine

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

Which RDS is serverless

A

Aurora is serverless, everything else needs a server

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

How Disaster recovery is done in RDS

A

Disaster recovery is achieved through multi AZ replication, that is data is replicated across multiple availability zones and if the data in one AZ is lost , then AWS automatically uses the one store in other AZ

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

What is the use of Read replicas?

A

They are used to improve the performance of RDS

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

What are the two kinds of backups for RDS?

A

Automated backups and Database Snapshots.

Automated backups and done in a scheduled maintenance window automatically and Database Snapshots are done manually.

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

How is data Secured in AWS-RDS?

A

Through Encryption at Rest. Key Management service is used to encrypt the data at the server

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

What are the different read modes in Dynamo db

A

Eventual consistency Reads: If data is read 1 sec after a read, then it is guaranteed to be the latest.

Strongly consistent reads: Data read is always the latest.

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

What is dynamo db?

A

schemaless, document database stored in SSD, replicated across three regions providing very high performance.

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

What is Redshift?

A

Data warehousing in the cloud. Falls under OLAP(Online Analytics processing).

It’s available in only one AZ.
Backups are enabled by default with a one day retention period to a max of 35 days

It manages 3 copies of data, the original, replica and another one in S3, Redshift can asynchronously replicate the data in S3 to another S3 for disaster recovery

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

What is aurora database?

A

It s Amazons own proprietary database, which maintains 2 copies of data in each availability zone with minimum 3 AZ. Which means we always have 6 copies of data.

Data from My sql can also be migrated to Aurora.

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

Use case for Elastic cache

A

Used to increase database and website performance by caching data in memory.Works for simple types . its simple in that its not available in multi AZ, scales horizontally. Whereas Redis can be put on multi-AZ and backed up

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

How many Requests can be handled by Dynamodb?

A

10 trillion request per day and 20 million request per second.

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

When to use dynamo db?

A

can handle millions of concurrent requests at single milliosecond delay.
No servers to maintain and it can scale automatically.
Any application which needs to be built in internet scale and has concurrency issues will benefit from Dynamodb.

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

How is dynamodb charged?

A

Pay on demand:Pay for reads and writes as it happens, good for apps with unpredictable workloads.The database scales up and down as per demand.
Pay as provisioned: Good for applications where we know how expected load.Billings happens by the hour, whether any read or write happens during that period The number of reads and writes are specified in the begining , auto scaling groups are used to grow the tables if required.
Dynamodb also charges for the stored data and any internet associated chrfes.

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

How is data secured in dynamodb?

A

Dynamo db synchronously replicates data across three availability zones in aws

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

Throughput limit for a single table in DynamoDb?

A

On Demand:
40,000 read request units and 40,000 write request units.

Provisioned:
40,000 read capacity units and 40,000 write capacity units

17
Q

What is write capacity unit for a table in Dynamo Db?

A

One write capacity unit represents one write per second for object upto 1 kb in size

18
Q

What is the minimum throughput which can be set for a table in Dynamodb?

A

1 RCU and 1 LCU.

19
Q

What is the free tier eligibility in DynamoDb?

A

25 RCU and 25 WCU.
This is calculated at account level and not table level.
So it is a combination of all tables inside an account

20
Q

What is the maximum amount of scan results which can be returned from dynamodb at a time.

A

1MB

21
Q

What is the max number of RDS instances, the customer can have>

A

Up to 40 RDS instances. Only 10 of these can be Oracle or MS Sql, unless you have your own licenses

22
Q

How to scale MySql in AWS?

A

You can scale storage and change the storage type for all DB engines except MS SQL

23
Q

Should the RDS instance be stopped while scaling?

A

Scaling storage can happen while the RDS instance is running without outage however there may be performance degradation

24
Q

Which Databases dont support Read replicas?

A

Sql Server and Oracle

25
Q

What happens if a source DB instance is deleted without deleting the replicas

A

Each replica becomes a standalone single-AZ DB instance

26
Q

What is the drawback of replicating database regionally?

A

The data wont be strongly consistent.

27
Q

What is the difference DataMigration Service and Schema Conversion Tool

A

The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases.
Schema Conversion Tool can copy database schemas for homogenous migrations (same database) and convert schemas for heterogeneous migrations (different database)

28
Q

What is one RCU in dynamoDb?

A

One read capacity unit represents one strongly consistent read per second, or two eventually consistent reads per second for items up to 4KB.
For items larger than 4KB, DynamoDB consumes additional read capacity units

29
Q

What are the two in memory data stores in AWS?

A

Redis cache and Memcached.
Redis is used for simple data types and data is stored in Nodes.
Memcached can store complex types and it is persistent.Data is stored in Shards than Nodes.

30
Q

What is Elasticache?

A

ElastiCache is a web service that makes it easy to deploy and run Memcached or Redis protocol.
The in-memory caching provided by ElastiCache can be used to significantly improve latency and throughput for many read-heavy application workloads or compute-intensive workloads

31
Q

What is Redshift spectrum?

A

Tool in redshift to query directly from data files on S3.

32
Q

How other AWS services can access S3 without traversing the public network.

A

By using a S3 VPC endpoint

AWS Cert (11 decks)

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