Databases and Analytics

Question 1

RDS is for Online Transaction Processing (OLTP) workloads that _____ lots of _____ transactions

Answer 1

RDS is for Online Transaction Processing (OLTP) workloads that process lots of small transactions

Question 2

Online Transaction Processing (OLTP) workloads use cases would be:

_______ orders

_______ transactions

Payments

_______ systems

Answer 2

Online Transaction Processing (OLTP) workloads use cases would be

Customer orders

Banking transactions

Payments,

Booking systems

Question 3

Redshift is a ________ database that is used for Online ________ Processing (OLAP) or data ___________

Answer 3

Redshift is a relational database that is used for Online Analytics Processing (OLAP) or data warehousing

Question 4

Online Analytics Processing (OLAP) is ideal for tasks like analyzing large amounts of data _________ and sales ___________

Answer 4

Online Analytics Processing (OLAP) is ideal for tasks like analyzing large amounts of data reporting and sales forecasting

Question 5

Amazon RDS Read Replicas enable you to create one or more ____-____ _______ of your _______ instance within the _____ AWS Region or in a _________ AWS Region

Answer 5

Amazon RDS Read Replicas enable you to create one or more read-only copies of your database instance within the same AWS Region or in a different AWS Region

Question 6

Read replicas are primarily used for _______ and improving performance not ________ ________

Answer 6

Read replicas are primarily used for scaling and improving performance not disaster recovery

Question 7

Automatic ______ must be enabled in order to deploy a read ______

Answer 7

Automatic backups must be enabled in order to deploy a read replica

Question 8

Multi-AZ in regards to databases is used only for disaster recovery. In the event of a failure, RDS will automatically ________ to the _______ instance

Answer 8

Multi-AZ in regards to databases is used only for disaster recovery. In the event of a failure, RDS will automatically failover to the standby instance

Question 9

Scenario question: Your database is bottlenecking how can you get around it?

Answer 9

Create a Read Replicas

Question 10

Aurora is Amazon’s proprietary database that is compatible with ______, as well as __________.

Answer 10

Aurora is Amazon’s proprietary database that is compatible with MySQL, as well as PostgreSQL

Question 11

Amazon Aurora is very redundant. You always have __ copies of your data in each ___ within a minimum of __ AZ’s. Giving you a total of __ copies

Answer 11

Amazon Aurora is very redundant. You always have #2 copies of your data in each AZ with a minimum of #3 AZ’s. Giving you a total of #6 copies

Question 12

You can take ________ with Auroras and share them with other AWS ________

Answer 12

You can take snapshots with Auroras and share them with other AWS accounts

Question 13

DynamoDB is spread across #__ geographically ______ data centers to ensure _________

Answer 13

DynamoDB is spread across 3 geographically distinct data centers to ensure resiliency

Question 14

With DynamoDB you get eventually ________ reads by default

Answer 14

With DynamoDB you get eventually consistent reads by default

Question 15

What are the three read options you get with DynamoDB?

Answer 15

eventual consistency,
strong consistency,
transactional.

Question 16

The acronym ACID refers to the four key properties of a transaction:

Answer 16

Atomicity,
Consistency,
Isolation,
Durability

Question 17

Scenario questions that mention ACID requirements should make you think of _________ transactions

Answer 17

Scenario questions that mention ACID requirements should make you think of DynamoDB transactions

Question 18

What effect does DynamoDB On-Demand Backup have on the performance or availability of your tables?

____ impact on performance while offering ____ backups

Answer 18

Zero impact on performance while offering full backups

Question 19

In which region is DynamoDB On-Demand Backups retained?

Answer 19

Same region as the source table

Question 20

DynamoDB Point-in-Time Recovery protects against accidental ______ or _______

Answer 20

DynamoDB Point-in-Time Recovery protects against accidental writes or deletes

Question 21

When using DynamoDB Point-in-Time Recovery what is the last restorable point in the past?

Answer 21

5 minutes in the past.

Question 22

Streams are time-ordered sequences of ____ level changes in a ____.

Answer 22

Streams are time-ordered sequences of item level changes in a table.

Question 23

Every shard in a stream is stored for how long?

Answer 23

24 hours

Question 24

A Database on an EC2 is ideal if you need (2)

____ _______ over instance and database or have a _____-_____ database engine (not avail in RDS)

Answer 24

full control over instance and database or have a third-party database engine (not avail in RDS)

Question 25

Amazon RDS is ideal if you have data that is well-**\_\_\_\_\_\_** and **\_\_\_\_\_\_\_\_**

Answer 25

Amazon RDS is ideal if you have data that is well-**formed** and **structured**

Question 26

DynamoDB 4 main features:

Answer 26

NoSQL High I/O needs Dynamic Scaling In-memory performance

Question 27

Data Warehouse for large volumes of aggregated data

Answer 27

Amazon Redshift

Question 28

Amazon Elasticache is fast **\_\_\_\_\_\_\_\_\_** storage for **\_\_\_\_\_** amounts of data. Amazon Elasticache is an in-**\_\_\_\_\_\_\_** store.

Answer 28

Amazon Elasticache is fast **temporary** storage for **small** amounts of data. Amazon Elasticache is an in-**memory** store.

Question 29

Amazon EMR is an **\_\_\_\_\_\_\_\_** workload using the **\_\_\_\_\_\_\_\_** framework

Answer 29

Amazon EMR is an **Analytics** workload using the **Hadoop** framework

Question 30

What are the 6 Database engines that Amazon RDS supports? **\_\_\_\_\_** Server **\_\_\_\_\_\_** SQL **\_\_\_** Server \_\_\_\_\_ \_\_\_\_\_ \_\_\_\_\_\_

Answer 30

MySQL Server PostgreSQL SQL Server Aurora Oracle MariaDB

Question 31

Amazon RDS has a **\_\_\_\_\_\_** maintenance schedule by default but you can choose your own. OS & DB **\_\_\_\_\_\_\_\_** is what happens during the weekly maintenance window

Answer 31

Amazon RDS has a w**eekly** maintenance schedule by default but you can choose your own. OS & DB **patching** is what happens during the weekly maintenance window

Question 32

When is the only time you can enable encryption on an AWS RDS DB instance?

Answer 32

When you create it DBs that has encryption enabled cannot be disable it

Question 33

You cannot have an **\_\_\_\_\_\_\_\_** read replica of an **\_\_\_\_\_\_\_\_\_** DB instance

Answer 33

You cannot have an **encrypted** read replica of an **unencrypted** DB instance

Question 34

You cannot restore an unencrypted **\_\_\_\_\_\_\_** or **\_\_\_\_\_\_\_** to an encrypted **\_\_** instance

Answer 34

You cannot restore an unencrypted **backup** or **snapshot** to an encrypted **DB** instance

Question 35

Read replicas of encrypted primary instances are \_\_\_\_\_\_\_\_

Answer 35

Read replicas of encrypted primary instances are **encrypted**

Question 36

Amazon Aurora is up to five times faster than standard _____ databases and three times faster than standard _________ databases

Answer 36

Amazon Aurora is up to five times faster than standard **MySQL** databases and three times faster than standard **PostgresSQL** databases

Question 37

Aurora Serverless Use Cases (5) New or **\_\_\_\_\_\_\_\_\_\_\_** used applications * *\_\_\_\_\_**-tenant applicatons * *\_\_\_\_\_\_\_\_\_\_\_** Workloads * *\_\_\_\_\_\_\_** Workloads * *\_\_\_\_\_\_\_\_\_\_\_** and test databases

Answer 37

New or **Infrequently** used applications * *Multi**-tenant applicatons * *Unpredictable** Workloads * *Variable** Workloads * *Development** and **test** databases

Question 38

Amazon ElastiCache is a fully managed caching service for _____ and \_\_\_\_\_\_\_\_\_

Answer 38

Amazon ElastiCache is a fully managed caching service for **Redis** and **Memcached**

Question 39

Amazon ElastiCache is a \_\_\_\_/\_\_\_\_ store

Answer 39

Amazon ElastiCache is a **key/value** store

Question 40

Amazon ElastiCache can be put in front of databases such as ____ and \_\_\_\_\_\_\_\_\_

Answer 40

Amazon ElastiCache can be put in front of databases such as **RDS** and **DynamoDB**

Question 41

ElastiCache nodes run on ___ \_\_\_\_\_\_\_\_\_ so you must choose an ________ \_\_\_\_\_\_ type

Answer 41

ElastiCache nodes run on **EC2 instances** so you must choose an **instance family** type

Question 42

Between Memcached and Redis, which offers Data Persistence?

Answer 42

Between Memcached and Redis, which offers Data Persistence? Redis offers Data Persistence Memcached does not

Question 43

Memcached will place nodes in Multi-AZs but you will not get ________ or \_\_\_\_\_\_\_\_\_

Answer 43

Memcached will place nodes in Multi-AZs but you will not get **failover,** or **replication**

Question 44

You can use ElastiCache for caching, which accelerates ___________ and ________ performance

Answer 44

You can use ElastiCache for caching, which accelerates **application** and **database** performance

Question 45

Amazon ElastiCache can also be a primary data store for use cases that don't require durability like gaming \_\_\_\_\_\_\_\_, \_\_\_\_\_\_\_\_, and \_\_\_\_\_\_\_

Answer 45

Amazon ElastiCache can also be a primary data store for use cases that don't require durability like gaming **leaderboards**, **streaming, and analytics.**

Question 46

You can restore your DynamoDB database backup to any point in the last **\_\_\_** days, the backups are **\_\_\_\_\_\_\_\_\_\_**. This feature is not **\_\_\_\_\_\_\_\_\_** by \_\_\_\_\_\_\_\_\_.

Answer 46

At any point in the last **35** days, the backups are **incremental**. Not **enabled** by **default**.

Question 47

DynamoDB Accelerator is an **\_\_-\_\_\_\_\_\_\_** cache that increases **\_\_\_\_\_\_\_\_\_\_** (microsecond latency)

Answer 47

The acronym DAX represents DynamoDB Accelerator which is an **In-memory** cache that increases **performance** (microsecond latency)

Question 48

What type of backups and copies of your data does Redshift offer? Redshift offers continuous **\_\_\_\_\_\_\_\_\_** backups And always keeps **\_\_\_\_\_\_** copies of your data

Answer 48

continuous **incremental** backups Always keeps **three** copies of your data

Question 49

Amazon EMR can be used for ___________ and ______ large amounts of \_\_\_\_

Answer 49

Amazon EMR can be used for **transforming** and **moving** large amounts of **data**

Question 50

Kinesis Data Streams enables real-time processing of ________ \_\_\_ \_\_\_\_

Answer 50

Kinesis Data Streams enables real-time processing of **streaming big data**

Question 51

The Kinesis Client Library helps you ______ and ______ data from a Kinesis data stream

Answer 51

The Kinesis Client Library helps you **consume** and **process** data from a Kinesis data stream

Question 52

Kinesis Data Firehose \_\_\_\_\_, _____ and loads streaming data

Answer 52

Kinesis Data Firehose **Captures, Transforms**, and loads streaming data

Question 53

With Kinesis Data Firehose there are no \_\_\_\_, everything is \_\_\_\_\_\_

Answer 53

With Kinesis Data Firehose there are no **Shards**, everything is **automated**

Question 54

Between Memcached and Redis, which offers encryption?

Answer 54

Between Memcached and Redis, which offers encryption? Redis offers encryption Memcached does not

Question 55

Kinesis Data Firehose enables ____ real-time _______ with existing business intelligence tools and dashboards

Answer 55

Kinesis Data Firehose enables **near** real-time **analytics** with existing business intelligence tools and dashboards

Question 56

Kinesis Data Firehose possible destinations: S3 \_\_\_\_\_ Data\_\_\_ HTTP \_\_\_\_\_\_ Mongo\_\_\_

Answer 56

S3 Splunk Datadog HTTP **Endpoint** Mongo**DB**

Question 57

Kinesis Data Analytics provides \_\_\_\_-\_\_\_\_ SQL processing for streaming data

Answer 57

Kinesis Data Analytics provides **real-time** SQL processing for streaming data

Question 58

Kinesis Data Analytics destination can be Kinesis \_\_\_\_\_\_\_\_ Kinesis \_\_\_\_\_\_\_\_\_ Lambda

Answer 58

Kinesis Data **Streams** Kinesis Data **Firehose** Lambda

Question 59

Amazon Athena is used for _______ \_\_\_\_ in S3 using SQL

Answer 59

Amazon Athena is used for **querying data** in S3 using SQL

Question 60

You would connect Amazon Athena to data sources other than S3 by using \_\_\_\_\_.

Answer 60

You would connect Amazon Athena to data sources other than S3 by using **Lambda**

Question 61

The methods that can be used to optimize Amazon Athena include: \_\_\_\_\_\_\_ you data \_\_\_\_\_\_ your data \_\_\_\_\_\_\_\_ your data

Answer 61

* *Partition** you data * *Bucket** your data **Compress** your data

Question 62

AWS Glue is a fully managed extract, \_\_\_\_\_\_\_, and ____ service that is used for preparing data for analytics.

Answer 62

AWS Glue is a fully managed extract, **transform** and **load** service that is used for preparing data for analytics.

Question 63

AWS Glue discovers data and stores the associated metadata in the AWS ____ \_\_\_\_ Catalog

Answer 63

AWS Glue discovers data and stores the associated metadata in the AWS **Glue Data** Catalog

Question 64

You can use a _______ to populate the AWS Glue Data Catalog with \_\_\_\_\_\_\_

Answer 64

You can use a **crawler** to populate the AWS Glue Data Catalog with **tables**

Question 65

Between Memcached and Redis, which offers Multithreading?

Answer 65

Between Memcached and Redis, which offers Multithreading? Redis offers Multithreading Memcached does not

Question 66

A crawler can crawl multiple data stores in a ______ \_\_\_

Answer 66

A crawler can crawl multiple data stores in a **single run**

Question 67

A real-time solution to process or move data is called \_\_\_\_\_.

Answer 67

A real-time solution to process or move data is called **Kinesis**

Question 68

Simple Queue Service (SQS) and Kinesis can both be queues, but each has its pros and cons: SQS is _____ and \_\_\_\_\_ Kinesis is _____ & can store data for up to a \_\_\_\_

Answer 68

SQS is **easier** and **simpler** Kinesis is **faster** & can store data for up to a **year**

Question 69

Anytime Serverless SQL comes up on the test think of _______ \_\_\_\_\_\_\_.

Answer 69

Anytime Serverless SQL comes up on the test think of **Amazon Athena**

Question 70

Quicksight is a service that is used for _______ the data in a dashboard or \_\_\_\_\_

Answer 70

Quicksight is a service that is used for **visualizing** the data in a dashboard or **graph**

Question 71

The acronym DAX represents __________ \_\_\_\_\_\_\_\_\_\_\_

Answer 71

The acronym DAX represents DynamoDB Accelerator

Question 72

An Aurora global database consists of **\_\_\_** primary AWS Region where your data is mastered and up to **\_\_\_\_** read-only, **\_\_\_\_\_\_\_\_\_** AWS Regions

Answer 72

An Aurora global database consists of **one** primary AWS Region where your data is mastered and up to **five** read-only, **secondary** AWS Regions

Question 73

Amazon Athena is an interactive **\_\_\_\_\_** service that makes it easy to **\_\_\_\_\_\_\_** data in Amazon **\_\_** using standard SQL.

Answer 73

Amazon Athena is an interactive **query** service that makes it easy to **analyze** data in Amazon S3 using standard **SQL**.

Question 74

Athena is serverless, so there is no infrastructure to manage, and you pay only for the **\_\_\_\_\_\_** that you run.

Answer 74

Athena is serverless, so there is no infrastructure to manage, and you pay only for the **queries** that you run.