Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 124 discussion

I have seen this official answer in the practical exam in the AWS Skills builder website

D focuses on the S3 prefix structure, which affects partitioning but not the creation of a single table. Consistency in file format and schema is much more important in determining how AWS Glue handles the data.

Answer is AD

To ensure that the AWS Glue crawler creates only one table and handles the object format, compression type, schema, and prefix structure consistently: Ensure Consistent Object Format, Compression Type, Schema, and Prefix Structure 1. **Consistent Object Format**: - Ensure that all objects in the S3 bucket are in the same format (e.g., CSV, JSON, Parquet). 2. **Consistent Compression Type**: - Ensure that all objects use the same compression type (e.g., GZIP, Snappy). 3. **Consistent Schema**: - Ensure that all objects have the same schema (i.e., the same fields with the same data types). 4. **Consistent Prefix Structure**: - Ensure that all objects follow a consistent naming convention and prefix structure in the S3 bucket (e.g., `s3://your-bucket/path/to/data/`).