Databricks Certified Data Engineer Associate — Question 33

Which of the following describes 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. CREATE TABLE AS SELECT statements cannot be used on files
• C. Parquet files have a well-defined schema
• D. Parquet files have the ability to be optimized
• E. Parquet files will become Delta tables

Correct answer: C

Explanation

The correct answer is C because Parquet files are designed with a well-defined schema which allows for better data management and querying. Options A and D are also benefits of Parquet files, but they do not directly relate to the context of using CREATE TABLE AS SELECT. Option B is incorrect since CREATE TABLE AS SELECT statements can indeed be used on files, and Option E is misleading as not all Parquet files automatically transform into Delta tables.