Explanation:
Parquet files store schema information as part of their metadata, which is a key advantage over CSV files (which do not store schema). This makes it easier and more reliable to create external tables from Parquet files using CTAS in Databricks.
Ultimate access to all questions.
When utilizing a CREATE TABLE AS SELECT (CTAS) statement in a Databricks environment, which of the following benefits specifically pertains to creating an external table from Parquet files instead of CSV files?
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
No comments yet.