Brainscape's Knowledge GenomeTM

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


See full index

AWS Certified Solutions Consultant > Databases on AWS > Flashcards

Databases on AWS Flashcards

1
Q

Name the 6 types of RDS’s in AWS

A
  1. SQL Server 2. Oracle 3. My SQL Server 4. PostgreSQL 5. Aurora 6. MariaDB
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the two key features of RDS?

A

Multi AZ for DR and Read replicas for performance

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

Are key value pairs found in RDS or Non Relational DB’s?

A

Non relational DB’s

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

What is data warehousing used for?

A

business intelligence and pulling in very large and complex data sets

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

What is Amazon’s Data Warehouse Solution called?

A

Red Shift

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

What is Amazon’s noSQL DB solution called?

A

DynamoDB

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

What do RDS’s run on?

A

Virtual Machines (EC2 instances)

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

Who is responsible for patching of RDS’s?

A

Amazon

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

True of false: RDS is Serverless

A

False, with the only exception of Aurora Serverless

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

What are the two types of backups for RDS?

A

Automated and Database Snapshots

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

T or F: Multi AZ for RDS will give you an exact copy of your production DB in another AZ

A

True

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

Why use Read Replicas?

A

It improves performance of your DB

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

What must you have turned on in order to deploy a read replica?

A

Automatic backups

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

Where is DynamoDB stored?

A

SSD Storage

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

How many data centers is Dynamo DB spread across?

A

3

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

Difference between Eventual Consistent Read and Strongly Consistent Read for DyanmoDB

A

Eventual means usually read within a second and Strongly is less than a second

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

What is DynamoDB Accelerator (DAX)

A

fully managed, highly available, in memory cache. This will reduce request times from milliseconds to microseconds.

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

Why would a developer want to use DAX?

A

So they don’t have to manager the caching logic

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

What are transactions in DynamoDB?

A

Fulfilling orders. DynamoDB prepares two underlying reads or writes

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

What are streams in DynamoDB?

A

time ordered sequence of item level changes in a table

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

What are shards in DynamoDB?

A

Groups of stream records.

22
Q

What allows you to configure data migration logic from one DB to another?

A

Database Migration Service (DMS)

23
Q

What is AWS’s data warehousing option?

A

Redshift

24
Q

In what two options can you configure Redshift?

A

Single or multi node

25
Q

In a multi node configuration in Redshift, what are the types of nodes?

A

Leader node and Compute Node

26
Q

Explain leader nodes and compute nodes

A

Leader manages client connections and receives queries. Compute stores data and perform queries and computation. You can have up to 128 compute nodes

27
Q

What feature of Redshift allows it to use less space?

A

Advanced compression

28
Q

What is the benefit of using Aurora?

A

relational DB engine that combines speed and availability of high end commercial DB’s

29
Q

How is Aurora self healing?

A

data block and disks are continuously scanned for errors and repaired automatically

30
Q

3 types of Aurora replicas

A
  1. Aurora replica (in region, automated failover) 2. MySQL read replica (cross region, no automated failover) 3. PostgresQL
31
Q

What is Aurora Serverless and when would you use it?

A

on demand, autoscaling config for MySQL and PostgreSQL compatible editions of Aurora. Used for infrequent or unpredictable workloads

32
Q

What is Elasticache?

A

web service for deploying, operating and scaling and in memory cache in the cloud

33
Q

What are the 2 open source caching engines that are options in Elasticache?

A

Memcached & Redis

34
Q

When to use Memcached vs Redis

A

Memcached - simple and easy to start / Redis - need advanced data type, multi AZ, or ranking and sorting data sets

35
Q

Types of Data Migration Services (DMS) migrations

A
  1. homogenous migrations (DB’s of the same type 2. heterogenous migrations (one type of B to another)
36
Q

What must you use for heterogenous DMS migrations?

A

AWS Schema Conversion tool

37
Q

What is Amazon EMR?

A

big data platform for processing vast amounts of data using open source tools

38
Q

What is the central component of Amazon EMR?

A

The cluster, which is a collection of EC2 instances

39
Q

What are the node types in Amazon EMR and what do they do?

A
  1. Master Node - manages the cluster. Every cluster has one 2. Core Node - Runs tasks and stores data in Hadoop Distributed File System ( HDFS) 3. Task Node - runs tasks but does not store data in HDFS. These are optional
40
Q

Where is log data stored at by default in Amazon EMR?

A

The master node

41
Q

What happens to I/O operations of a single AZ RDS instance during a DB snapshot or backup?

A

I/O may be briefly suspended while backup process initializes and you may experience brief period of elevated latency

42
Q

T or F: You can RDP or SSH into an RDS instance

A

F

43
Q

T or F: RDS Reserved Instances are available for multi AZ deployments

A

T

44
Q

What is the max value for RDS backup retention periods?

A

35 days

45
Q

What storage option is recommended if you want to run a DB on an EC2 instance?

A

EBS

46
Q

Default port number for MySQL installation

A

3306

47
Q

Which AWS DB platform is most suitable for Online Transaction Processing (OLTP)

A

RDS

48
Q

Yes or No: Is there a data transfer charge incurred when replicating data from your primary RDS instance to your secondary?

A

No

49
Q

T or F: DynamoDB is a non relational DB

A

T

50
Q

T or F: When you add a rule to a RDS DB security group, you must specify a port number or protocol

A

F

AWS Certified Solutions Consultant (15 decks)

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