Brainscape's Knowledge GenomeTM

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


See full index

AWS > Udemy course - Sections 10-16 > Flashcards

Udemy course - Sections 10-16 Flashcards

1
Q

What does Amazon’s Relational Database Service (RDS) use?

A

EC2 instance, so you must choose and instance family/type

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

What are relational databases known as?

A

SQL - structured query language

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

What kind of database is RDS?

A

Online transition processing (OLTP) type

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

what are 4 benefits of RDS DBs?

A

1) easy to setup
2) highly available
3) fault tolerant
4) scalable

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

common use cases of RDS?

A

online stores and banking systems

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

what service does encryption use for RDS DBs?

A

KMS - key management service

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

how are RDS instances and snapshots recorded if setup?

A

encrypted and at rest

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

What DB engines does RDS support?

A

-sql server, oracle, mysql server, postgreSQL, Aurora, mariaDB

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

How do you scale RDS db?

A

increase instance size (computer/storage)

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

what kind of option do you have for heavy workloads on RDS DBs?

A

reading replicas (scales out for read/queries only)

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

What AZ options with disaster recovery for rds?

A

multi-AZ

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

What is aurora?

A

AWS db offering in rds family

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

what 2 db engines is aurora compatible with?

A

msql/postgreSQL buitl for cloud

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

what does amazon aurora feature?

A

fault-tolerant, self-healing storage system that auto-scales up to 128tb per database instance

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

5 features of dynamo db?

A

1) nosql db
2) key/value store and document store
3) non-relational, key/value type of db
4) serverless
5) push button scaling

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

what is redshift?

A

sql based data warehouse used for analytics

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

what kind of DB is redshift?

A

relational that is used for ONLAP (online analytics processing)

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

what does redshift use as an engine?

A

ec2 instances so you have to chose instance family/type

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

how many copies does redshift always keep/

A

3

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

what kind of backups does redshift provide?

A

continous/incremental

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

what is EMR?

A

Managed cluster platform that simplifies running big data
frameworks including Apache Hadoop and Apache Spark

22
Q

what is EMR used for?

A

Used for processing data for analytics and business
intelligence

23
Q

What is emr good for?

A

transforming and moving large amounts of data

24
Q

what can you do with emr as a data mechanism?

A

ETL functions

25
Q

what is elastichache?

A

1) Fully managed implementations Redis and Memcached
2) ElastiCache is a key/value store

26
Q

what does elasti cache offer?

A

in-memory db offering high performance and low latency

27
Q

can kind of dbs can elastic cache be put up in front?

A

RDS/DynamoDB

28
Q

what is Athena?

A

db, that queries data in S3 using sql

29
Q

what other sources can athena be connected to?

A

lambda

30
Q

what formats can data be in for athena?

A

csv, tsv, json, parquet and orc formats

31
Q

what does athena use to store information and schemas about db’s and tables?

A

aws glue

32
Q

what is aws glue?

A
  • Fully managed extract, transform and load (ETL) service
  • Used for preparing data for analytics
33
Q

what environment does glue run on?

A

fully managed/scaled out apache spark

34
Q

what does glue work with?

A

Works with data lakes (e.g. data on S3), data warehouses
(including RedShift), and data stores (including RDS or EC2
databases

35
Q

what is a kinesis data strem?

A
  • Producers send data which is stored in shards for up to 7
    days
  • Consumers process the data and save to another service
36
Q

2 things to know about kinesis data firehose?

A
  • No shards, completely automated and elastically scalable
  • Saves data directly to another service such as S3, Splunk,
    RedShift, or Elasticsearch
37
Q

what is kinesis data analytics?`

A

Provides real-time SQL processing for streaming data

38
Q

what is the data pipeline ?

A
  • Processes and moves data between different AWS compute and
    storage services
  • Save results to services including S3, RDS, DynamoDB, and EM
39
Q

what is quicksight?

A

*Business intelligence (BI) service
* Create and publish interactive BI dashboards for Machine
Learning-powered insights

40
Q

what is neptune?

A

Fully managed graph database service

41
Q

3 things about document db to know?

A
  • Fully managed document database service (non-relational)
  • Supports MongoDB workloads
  • Queries and indexes JSON data
42
Q

2 things to know about QLDB?

A

*Fully managed ledger database for immutable change history
* Provides cryptographically verifiable transaction logging

43
Q

1 thing to know about managed blockchain?

A

Fully managed service for joining public and private networks
using Hyperledger Fabric and Ethereum

44
Q

Which AWS database service offers seamless horizontal scaling?

A

DynamoDB

45
Q

How can fault tolerance be added to an Amazon RDS database?

A

Using multi-az

46
Q

How can an organization enable microsecond latency for a DynamoDB database?

A

use dynamoDB accelerator

47
Q

Which AWS database service is a relational, data warehouse?

A

redshift

48
Q

Why might an organization decide to move an on-premises database to Amazon RDS?

A

reduce operational overhead

49
Q

How do you increase the capacity of an Amazon RDS database?

A

scaling vertically by changing instance types

50
Q

Amazon DynamoDB is good for which use case?

A

unstructured data, flexible schema

51
Q

A company needs to run ETL jobs on data stored in S3. Which service should they use?

A

glue

52
Q
A

AWS (5 decks)

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