Data

Question 1

What is the data breakpoint where you should choose AWS SnowMobile vs a large number of AWS SnowBalls

Answer 1

10 PetaBytes

Question 2

Do RDS Proxies work with Aurora?

Answer 2

Yes

Question 3

What is Redshift Spectrum

Answer 3

Service that utilizes shared redshift servers in AWS to query / retrieve data from S3 without needing to load data into dedicated redshift tables.

Question 4

What are the cost differences between S3, EFS, and EBS

Answer 4

At the time of this question, the following prices are true.
- Default s3 - $.023 / GB / Month
- EFS - $.3 / GB / Month
- EBS - $.1 / GB / Month
Note - s3 and EFS charge based on actual data stored. EBS storage must be pre-provisioned

Question 5

What is the advantage of using a Parquet / ORC vs a CSV?

Answer 5

Parquets and ORCs are both columnar data, allowing for fast retrieval. CSV is row based, and therefore slower.

Question 6

What is the Minimum storage duration charge for S3-IA

Answer 6

S3-Infrequent Access has a minimum storage duration charge of 30 days.

Question 7

What is AWS Neptune

Answer 7

Neptune is a fully managed graph database. It is not an in-memory database.

Question 8

When are you not charged for S3 Transfer Acceleration

Answer 8

When S3 Transfer Acceleration does not result in a faster data transfer

Question 9

What is S3 Transfer Acceleration

Answer 9

S3 Transfer Acceleration is a service that speeds up transfers to / from S3. It can speed up transfers from 50-500%

Question 10

What is the turnaround for AWS Snowball

Answer 10

5-7 Days

Question 11

Can CloudFront help with upload and download speed to S3?

Answer 11

Upload Speed - No
Download Speed - If content is cached in CloudFront, download speed will increase. If content is not cached, there will not be an increase in download speed.

Question 12

What Database solution allows writes to one table in multiple regions?

Answer 12

Dynamo DB Global Tables work across regions.
* Note - Aurora Global DBs allow reads across multiple regions, but not writes.

Question 13

What is a total storage on a single AWS Snowball unit?

Answer 13

80 TB

Question 14

What are the differences between Kinesis Data Stream and Kinesis Firehose

Answer 14

Kinesis Data Stream
- real time
- code not managed
- scaling not managed
- temporarily stores data

Kinesis Firehose
- near real time
- fully managed code
- fully managed scaling
- no data storage

Question 15

What is the ideal AWS Service for one-time or periodic data transfers from on-premises storage to AWS?

Answer 15

AWS Datasync

Question 16

What file size should S3 multipart uploads be considered?

Answer 16

100 MB

Question 17

For Redshift cross region replication, which region should the KMS key be? What region should the redshift snapshots be?

Answer 17

The KMS key should be in the target region.
The Redshift snapshots should be in the source region

Question 18

True / False - Kinesis Firehose can handle multiple delivery stream sources at the same time?

Answer 18

False. Each Firehose can only handle a single data source at a time

Question 19

How does one transfer data from AWS Snow Family to S3 Glacier?

Answer 19

AWS Snow Family -> S3 with lifecycle policy -> Glacier

Question 20

What are the four types of logs for Aurora? How are they configured?

Answer 20

1. Error Logs - enabled by default
2. Slow Query Logs - Enabled via parameter in db parameter group
3. General Logs - Enabled via parameter in db parameter group
4. Audit Logs - Also known as advanced audit logs, enabled in the db cluster

Question 21

What is Apache Hive Partitioning?

Answer 21

Partition strategy that splits data into multiple parts / files based on partition key