Databricks Certified Data Engineer Associate — Question 52

What is a benefit of creating an external table from Parquet rather than CSV when using a CREATE TABLE AS SELECT statement?

Answer options

• A. Parquet files can be partitioned
• B. Parquet files will become Delta tables
• C. Parquet files have a well-defined schema
• D. Parquet files have the ability to be optimized

Correct answer: C

Explanation

The correct answer is C because Parquet files are designed with a clearly defined schema, which allows for better data organization and querying efficiency. Options A, B, and D are incorrect because while Parquet files can be partitioned and optimized, these features do not specifically address the primary benefit of schema definition as it relates to CREATE TABLE AS SELECT statements.