Brainscape's Knowledge GenomeTM

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


See full index

AWS Cloud > Databases > Flashcards

Databases Flashcards

1
Q

Unmanaged Services

A

Scaling, fault tolerance, and availability are managed by you.

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

Managed Services

A

Scaling, fault tolerance, and availability are typically built into the service.

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

Challenges of relational databases

A
  • Server maintenance and energy footprint,
  • Software installation and patches,
  • Database backups and high availability,
  • Limits on scalability,
  • Data security,
  • Operating system (OS) installation and patches;
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Amazon Relational Database Service (Amazon RDS)

A
  • Managed service
  • Sets up and Operates a relational database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Database in EC2

A

You are still responsible for patching the OS and handling all software and backup operations.

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

Database in RDS - Aurora (engine)

A
  • Automatically scale your database
  • Enable high availability
  • Manage backups,
  • Perform patching.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

DB Instance Class

A
  • CPU
  • Memory
  • Network performance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

DB Instance Storage

A
  • Magnetic
  • General Purpose (SSD)
  • Provisioned IOPS
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Multi - AZ deployment

A

Ability to configure your database instance for high availability. RDS automatically generates a standby copy of the database instance in another Availability Zone within the same VPC.

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

RDS Read Replicas

A

Features:
* Offers asynchronous replication
* Can be promoted to primary if needed

Functionality:
* Use for read-heavy database workloads
* Offload read queries

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

RDS Use Cases

A

Web and mobile applications,
Ecommerce applications,
Mobile and online games.

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

When to use RDS

A
  • Complex transactions / queries
  • Medium to high query or write rate
  • No more than a single worker node or shard * High durability
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Clock-hour billing

A

Resources incur charges when running.

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

Database characteristics

A

Physical capacity of database:
* Engine,
* Size,
* Memory class.

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

On-Demand Instances

A

Compute capacity by the hour.

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

Reserved Instances

A

Low, one-time, upfront payment for database instances that are reserved with a 1 year or 3 year term.

17
Q

Relational

A

Rows and Columns,
Fixed Schema,
SQL,
Vertical Scalability;

18
Q

Non-Relational

A
  • Key-Value/Document/Graph
  • Dynamic Schema
  • Focuses on collection of documents
  • Horizontal Scalability
19
Q

Amazon DynamoDB

A

Fast and flexible NoSQL database service for any scale. (SSD Exclusive).

  • Virtually unlimited storage,
  • Items can have differing attributes,
  • Low-latency queries,
  • Scalable read/write throughput.
20
Q

DynamoDB Core Components

A
  • Tables, items, and attributes are the core DynamoDB components.
  • DynamoDB supports two different kinds of primary keys:
    • Partition key
    • Partition and sort key(Composite Primary Key).
21
Q

Partition Key

A

Simple primary key, which is composed of one attribute called the sort key. (GUID).

22
Q

Composite Primary Key

A

Composed of two attributes:
* Partition key
* Sort key

23
Q

Partitioning

A

As data grows, table data is partitioned and indexed by the primary key.

24
Q

Data Retrieval DynamoDB

A
  • In the first method, the query operation takes advantage of partitioning to effectively locate items by using the primary key.
  • The second method is via a scan, which enables you to locate items in the table by matching conditions on non - key attributes. The second method gives you the flexibility to locate items by other attributes. However, the operation is less efficient because DynamoDB will scan through all the items in the table to find the ones that match your criteria.
25
Q

Amazon Redshift

A
  • Fast, fully managed data warehouse
  • Simple and cost-effective to analyze all your data by using standard SQL and your existing business intelligence (BI) tools
26
Q

Leader Node

A
  • Manages communications with client programs and all compute nodes.
  • It parses and develops plans to carry out database operations needed to obtain results for complex queries.
  • Compiles code and assigns to individual compute nodes.
27
Q

Compute Node

A

Run the compiled code and send intermediate results back to the leader node for final aggregation.

AWS Cloud (11 decks)

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