Brainscape's Knowledge GenomeTM

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


See full index

AWS Database Specialty > Random > Flashcards

Random Flashcards

1
Q

____ is a collection of values or information

A

data

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

____ is an organized collection of data

A

database

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

Three types f data:

A

structured

semi-structured

unstructured

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

This type of data is typically stored in tables with predefined structures (ie: schema)

A

structured data

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

structured data is suitable for OLTP (transactional) and OLAP (analytical) workloads

A

T

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

This type of data is typical of relational databases (indexed tables linked with foreign key relationships)

A

structured data

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

this type of data is suited for complex queries an analytics ie: complex table join operaitons

A

Structured data

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

This type of data is organized data, but not constrained by a fixed schema

A

semi-structured data

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

this type of data the schema accomodates variable data structures

A

semi-structured data

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

this type of data is typical of non-relational databases

A

semi structured data

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

this type of data is well suited for big data and low latency apps

A

semi structured data

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

this type of data is stored as XML and JSON, which makes it easy to read and easy to process

A

semi structured data

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

this type of data is unorganized

A

unstructured data

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

thistype fo data has no defined schema ie: docs, photos, videos, music, text mesasges, etc.

A

unstructured data

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

this type of data is typical ofnon relational databases, file systems, data stores, or data lakes like amazon S3

A

unstructured data

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

these types of database have a pre defined schema

A

relational databases

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

this type of database enforces a strict ACID compliance and supports “joins”

A

relational databases

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

the typical use case for these databases is OLTP and OLAP

A

relaitonal databaess

19
Q

MySQL, PostgreSQL, MariaDB, Oracle, SQL Server are examples of this type of DB

A

relational databases

20
Q

aws RDS and Aurora for OLTP and redshift for OLAP are types of these databases

A

relational databases

21
Q

these types of adtabases are characterized by multiple tables interconencted through foreign key relationships

A

relational databses

22
Q

Table INdexes

  • relational databases are written to and queried using SQL
  • for efficient query performance, we add indexes to the table
  • tables are indexed by their primary key by default
  • secondary indexed can be added on non-key fields
A

t

23
Q

what i ACID?

A

Atomicity

Consistency

Isolation

Durability

24
Q

____ means all or nothing - a transaction executes compltely or not at all

A

Atomicity

25
Q

____ means once a transaction has been committed, the data must conform to teh given schema

A

Consistency

26
Q

____ requires that concurent transactions execute separately from one another

A

Isolation

27
Q

____ is the ability to recover form an unexpected system failure or outage

A

Durability

28
Q

___ compliance refers only to the compliance enforced by the DB

A

ACID

29
Q

ACID behavior an also be enforced by your app:

ie: your app can maintain strict foreign key relationships between two DynamoDB tables. however, dynamoDB by itself will not enfore this relationship. another app can always override this behavior.

if it were mysql tables with relationships defined on teh DB, no app would be able to override the behavior

A

T

30
Q

this type of database is sometimes called NoSQL

A

non relational databases

31
Q

this type of database is suitable for semi strutured and unstructured data

A

non relational database

32
Q

this type of database has data stored in denomalize form

A

non relational database

33
Q

this type of database is suited for big data apps

big data = high volume, high velocity, high variety

A

non-relational database

34
Q

this type of database is also suited for low latency (high-speed) apps

A

non-relational databases

35
Q

this type of database is NOT suited for OLAP

A

non relational database

36
Q

this type of database has a flexible data model (trades some ACID properties)

A

non relational database

37
Q

BASE =

A

Basically Available Soft-state Eventually-consistent

38
Q

_____ ___ - basic R/W operations are available

A

Basically Available

39
Q

___ ___ non consistency gurantees, data state may change

A

Soft-state

40
Q

____ - data is expected to be consistent over time

A

Eventually CONsistent

41
Q

if you prefer high performance over stringly consistent databases, use this…

A

BASE compliance

42
Q
  • data stored as tables linked trough foreign key relationships
  • strict ACID compliance

fixed schema

vertical scaling

uses SQL

suited for OLTP and OLAP

A

Relational (SQL)

43
Q
  • data stored as collections or key value pairs
  • not so strict ACID compliance

-flexible schema (semi structured and unstructured data)
horizontal scaling

  • uses object based APIs
  • suited forOLTP (web/mobile apps)
A

Non-Relational (NoSQL)

44
Q
A

AWS Database Specialty (13 decks)

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