AWS Data

Question 1

Query Only S3

Answer 1

S3 Select

Question 2

Which service can set permissions at both the column and row levels ?

Answer 2

AWS Lake Formation

Question 3

Columnar format

Answer 3

Apache Parquet, ORC

Question 4

Why use columnar format such as Apache Parquet with Athena

Answer 4

reading only the necessary columns, thereby reducing the amount of data scanned and lowering costs.

Question 5

VACUUM FULL vs VACUUM REINDEX

Answer 5

VACUUM FULL – Reclaims disk space, rebuilds indexes, and re-sorts all rows in the table. This is the default VACUUM operation in Redshift.
VACUUM REINDEX - Re-analyzes distribution of sort key columns + VACUUM FULL

Question 6

Redshift is better for batch analytics or low-latency queries ?

Answer 6

Redshift is better suited for batch analytics

Question 7

Apache Spark DataFrames

Answer 7

are distributed data collections arranged into named columns that enable parallel SQL operations on massive datasets

Question 8

Glue DataBrew

Answer 8

Visual tool
Visual data preparation tools, preprocessing data
The T of ETL

Question 9

AwsGlueSessionUserRestrictedServiceRole

Answer 9

Provides full access to all AWS Glue resources except for sessions. Allows users to create and use only the interactive sessions that are associated with the user. This policy also includes other permissions needed by AWS Glue to manage Glue resources in other AWS services

Question 10

AWS Glue workflow can only trigger

Answer 10

EventBridge

Question 11

The organization wants to retrieve all medical records for each patient. However, the records don’t have a common unique identifier.

Answer 11

AWS Glue FindMatches ML

Question 12

AWS-managed KMS Key: automatic rotation every

Answer 12

1 year

Question 13

rotation of Customer-managed KMS Key: (must be enabled) automatic every

Answer 13

1 year

Question 14

GRANT EXECUTE

Answer 14

In redshift, permission allows users to run a stored procedure

Question 15

oversee and document all activities within its Amazon Redshift resource, for audit and traceability purposes.
witch service ?

Answer 15

With cloudTrail
and
Enable Amazon Redshift’s built-in audit logging feature

Question 16

AWS Glue crawler in account 11111 to access S3 bucket in account 99999

Answer 16

1. Configure an IAM role in the 11111’s account with permissions to access the S3 bucket in the 99999’s account and associate this role with the AWS Glue crawler.
2. Implement a bucket policy on the S3 bucket in the 99999‘s account that explicitly permits the AWS Glue crawler’s IAM role in the 11111‘s account access to the bucket.
3. Update the AWS Glue crawler’s configuration in the 11111‘s account to target the S3 bucket containing the VPC flow logs in the 99999‘s account.