Data Warehousing on AWS Training Data Lake Integration 2

Question 1

What AWS service acts as the centralized metadata catalog for organizing and discovering data lake assets?

Accepted Answer

AWS Glue Data Catalog

Answer

AWS CloudTrail

Answer

Amazon CloudWatch

Answer

AWS Config

Question 2

What is the primary function of AWS Glue crawlers in a data lake integration workflow?

Accepted Answer

Automatically discover data sources, infer schemas, and populate the Glue Data Catalog

Answer

Monitor network traffic into S3 buckets

Answer

Transfer data from on-premises databases to AWS

Answer

Encrypt objects stored in Amazon S3

Question 3

AWS Lake Formation adds which key governance capability on top of S3 and the Glue Data Catalog?

Accepted Answer

Fine-grained access control at the table, column, and row level for data lake resources

Answer

Automatic cross-region data replication

Answer

Real-time change data capture from operational databases

Answer

Automatic SQL query optimization across all analytics engines

Question 4

Which connection type does AWS Glue use when writing ETL job output directly into Amazon Redshift?

Accepted Answer

JDBC connection using a Redshift-compatible driver

Answer

HTTP REST API calls to the Redshift endpoint

Answer

SSH tunnel through a bastion host

Answer

S3 Transfer Acceleration upload

Question 5

What is the recommended method for loading large datasets from Amazon S3 into Amazon Redshift?

Accepted Answer

Use the COPY command to load data in parallel across all compute nodes

Answer

Use single-row INSERT INTO statements for each record

Answer

Use AWS DMS for every S3-to-Redshift data load

Answer

Use the AWS Management Console's manual file upload feature

Question 6

In a data lake context, what does 'schema-on-read' mean?

Accepted Answer

The schema is applied and interpreted at query time rather than when data is stored

Answer

Schemas are enforced at the moment data is written to S3

Answer

Data is validated against a fixed schema during ETL transformation

Answer

Only structured data conforming to a predefined schema can be stored in a data lake

Question 7

Which S3 data organization strategy most effectively improves Redshift Spectrum query performance and reduces cost?

Accepted Answer

Partition data by frequently filtered columns such as date, region, or category

Answer

Store all data in a single flat S3 prefix with no partitioning

Answer

Distribute files randomly across multiple S3 buckets

Answer

Consolidate all data into one large uncompressed file per table