AWS Certified Data Engineer – Associate (DEA-C01) — Question 126

A finance company receives data from third-party data providers and stores the data as objects in an Amazon S3 bucket.

The company ran an AWS Glue crawler on the objects to create a data catalog. The AWS Glue crawler created multiple tables. However, the company expected that the crawler would create only one table.

The company needs a solution that will ensure the AVS Glue crawler creates only one table.

Which combination of solutions will meet this requirement? (Choose two.)

Answer options

• A. Ensure that the object format, compression type, and schema are the same for each object.
• B. Ensure that the object format and schema are the same for each object. Do not enforce consistency for the compression type of each object.
• C. Ensure that the schema is the same for each object. Do not enforce consistency for the file format and compression type of each object.
• D. Ensure that the structure of the prefix for each S3 object name is consistent.
• E. Ensure that all S3 object names follow a similar pattern.

Correct answer: A, D

Explanation

The correct answer is A and D because having the same object format, compression type, and schema (A) ensures that the AWS Glue crawler interprets the data consistently, leading to a single table creation. Additionally, having a consistent structure for the S3 object name prefixes (D) helps the crawler identify them as related data, further supporting the single table outcome. The other options allow for inconsistencies that would result in multiple tables being created.