
Answer-first summary for fast verification
Answer: External table
Creating a table with the `LOCATION` keyword designates it as an external table. The syntax `CREATE TABLE table_name (column column_data_type...) USING format LOCATION 'dbfs:/'` where `format` can be DELTA, JSON, CSV, PARQUET, or TEXT, explicitly creates an external table. Omitting the `LOCATION` keyword would result in a managed table instead.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.