Failed Questions

Question 1

If items in DynamoDB are being overwritten by PuItem that have the same partition key, what can be done to prevent this?

Answer 1

Use conditional writes

Question 2

If there are more files than expected coming from Kinesis Firehose, what is the most likely root cause?

Answer 2

Kinesis Data Firehose scaled.

Question 3

Are Security Groups Stateful?

Answer 3

Yes

Question 4

Are NACLs stateful?

Answer 4

No

Question 5

When auto-scaling EMR, what is a good metric to scale based on compute?

Answer 5

YARNMemoryAvailablePercentage

Question 6

When recovering an EC2 instance, do you retain the public IP address that was assigned to it?

Answer 6

Yes

Question 7

What is contained in the Glue Data Catalog

Answer 7

Information contains references to data that is used as sources and targets of your extract, transform, and load (ETL) jobs in AWS Glue.

Question 8

What is the minimum storage duration for transitioning objects from S3 Standard to S3 One-Zone IA?

Answer 8

30 days

Question 9

Can Kinesis Data Firehose support multiple

Answer 9

No

Question 10

How do you schedule refreshing of materialized views in Redshift?

Answer 10

The Amazon Redshift query editor v2

Question 11

What is the Lambda maximum runtime?

Answer 11

30 minutes

Question 12

What is the percentage required for schemas to be considered similar in Glue?

Answer 12

70

Question 13

What is the minimum amount of data recommended for Snow Mobile?

Answer 13

10 PB

Question 14

Can RedShift Spectrum move data from S3 to Redshift?

Answer 14

No. It can only query

Question 15

Does Kinesis Data Analytics process all columns or subsets of columns that you define?

Answer 15

All columns

Question 16

Can S3 notifications support SQS Standard and FIFO destinations?

Answer 16

No, only standard queues

Question 17

Does SQS integrate with third party solutions?

Answer 17

No

Question 18

Does EventBridge integrate with third party solutions?

Answer 18

Yes

Question 19

Can Athena perform ETL

Answer 19

No

Question 20

What AWS service can be used to share data between organizations?

Answer 20

AWS Data Exchange

Question 21

Can Athena connect to third party resources?

Answer 21

No

Question 22

Can Quicksight support customer-provided keys?

Answer 22

No

Question 23

How can you programmatically ensure that an AWS Glue catalog is up to date as partitions are created in S3?

Answer 23

Boto3 using create_partition API call.

Question 24

What does Glue DataBrew NEST_TO_MAP do?

Answer 24

Converts user-selected columns into key value pairs. The order is not maintained

Question 25

What does Origin Access Control do in a cloudfront distribution?

Answer 25

It secures the content being served from cloudfront

Question 26

How do you copy snapshots between redshift clusters?

Answer 26

Copy grant in the destination region and configure cross-region snapshots in the source region.

Question 27

What is query result reuse in Athena?

Answer 27

Query Result Reuse allows results to be shared among users in a workgroup. Good for every query where the source data does not change.

Question 28

Where do you place the DMS replication instance for the best performance?

Answer 28

The target VPC

Question 29

What is map state in Step Functions?

Answer 29

It runs a set of workflow steps for each item in a dataset.

Question 30

Can an EMR cluster reside in multiple AZs?

Answer 30

No

Question 31

Can Quicksight read from a Kinesis Data Stream?

Answer 31

Not directly.

Question 32

What is low cardinality?

Answer 32

Dataset or a column in a database has a small number of distinct values.

Question 33

Can you share encrypted RDS snapshots with another account that use default KMS key?

Answer 33

No. It must be customer managed key

Question 34

What is the best way to store output data from an ECS cluster?

Answer 34

Use EFS

Question 35

Can Athena use PartiQL

Answer 35

Yes, to query DynamoDb

Question 36

How can you view a query run plan in Athena?

Answer 36

Use EXPLAIN ANALYZE

Question 37

Can Glue Workflows trigger Lambda?

Answer 37

No. Not meant for generic orchestration

Question 38

What tables in RedShift can be used to identify long running queries and table locks?

Answer 38

STL_ALERT_EVENT_LOG SVV_TRANSACTIONS

Question 39

Is Kinesis or SQS most cost effective?

Answer 39

SQS

Question 40

What is the best AWS service to aggregate CloudWatch Logs?

Answer 40

Kinesis Data Firehose

Question 41

When using Data Firehose for log aggregation, where should the service be configured?

Answer 41

In the logging account.

Question 42

What is an EC2 instance store?

Answer 42

An instance store provides temporary block-level storage for your instance. This storage is located on disks that are physically attached to the host computer.

Question 43

What is the default throughput of an SQS FIFO queue?

Answer 43

300 messages per second with batching up to 10 messages for a max of 3000.

Question 44

Can you attach an instance store volume?

Answer 44

No.

Question 45

What is the best use case for the Redshift ALL

Answer 45

Used for small tables that don't update often.

Question 46

If a RedShift cluster has a lot of load on one node and minimal on another, what can be done?

Answer 46

Change the distribution key to a column that has the largest dimension.

Question 47

What does largest dimension mean when talking about a database?

Answer 47

A column with the largest number of unique entries.

Question 48

What can be done when there are an excessive number of partitions in S3 that are impacting performance with Athena and Glue?

Answer 48

A Glue partition index Athena Partition projection

Question 49

Does DMS migrate empty tables?

Answer 49

No

Question 50

What service can be used to move data from S3 to Kinesis Data Streams?

Answer 50

DMS

Question 51

Can Kinesis Data Analytics ingest data directly?

Answer 51

No

Question 52

Can Redshift read streaming data from Kinesis?

Answer 52

Yes

Question 53

How do you configure Redshift to read from a Kinesis Data Stream?

Answer 53

CREATE EXTERNAL SCHEMA

Question 54

Can Kinesis Data Firehose write directly to DynamoDB?

Answer 54

No

Question 55

What configuration needs to be enabled to begin using Spark on Athena?

Answer 55

You need to create a spark enabled workgroup.

Question 56

Does each object in S3 have a unique key when it is encrypted with SSE-S3

Answer 56

Yes

Question 57

Can S3 Select query data in Glacier?

Answer 57

No. You need to move it into S3 first

Question 58

When a second KCL is added, what happens?

Answer 58

It load balances with the first. For example, there were 4 shards being read by 1 KCL and now there 2 shards being read by 2 KCL.

Question 59

What is AWS Application Auto Scaling

Answer 59

It is used by DynamoDB for autoscaling and adjusts provisioned throughput capacity on your behalf in response to actual traffic patterns.

Question 60

In S3 lifecycle policies, What takes precedence, Transition or Delete Markers

Answer 60

Transition

Question 61

In S3 lifecycle policies, What takes precedence, Transition or Permanent Deletion?

Answer 61

Permanent Deletion

Question 62

How can you save the output of an Athena query to S3?

Answer 62

Use the UNLOAD command

Question 63

What should cold storage in Open Search be used for?

Answer 63

Rarely accessed data

Question 64

Is OAUTHv2 a valid authentication mechanism for OpenSearch

Answer 64

No

Question 65

How can you reduce the time it takes for your queries to scan large tables in RedShift?

Answer 65

Use sortkey on columns that are friequently used in query filters.