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?

Question

Options

• AParquet files can be partitioned
• BCREATE TABLE AS SELECT statements cannot be used on files
• CParquet files have a well-defined schema
• DParquet files have the ability to be optimized
• EParquet files will become Delta tables

• A
  4% (2)
• C
  92% (45)
• D
  2% (1)
• E
  2% (1)

Explanation

Parquet is a columnar binary file format that stores schema metadata (column names, data types, nullability) directly within the file itself. When using CREATE TABLE AS SELECT to create an external table from Parquet, the engine can automatically read and apply this embedded schema without requiring the user to manually define it. CSV files are plain text with no built-in schema information, so the engine must infer or be told the types explicitly. While Parquet files can also be partitioned and are optimized for performance (options A and D), those are general Parquet benefits not specific to the CREATE TABLE AS SELECT context. The well-defined schema is the direct, relevant benefit for table creation.

No community discussion yet for this question.