Answer-first summary for fast verification
Answer: CREATE TABLE inventory (id INT, units FLOAT) TBLPROPERTIES (business_owner = ‘supply chain‘)
The correct syntax to set a table property, such as identifying the business owner, is by using the `TBLPROPERTIES` clause within the `CREATE TABLE` statement. This method is documented in Databricks SQL resources, specifically for defining table properties. Additionally, the `ALTER TABLE` command can be utilized to update these properties post-creation, for example, changing the business owner from 'supply chain' to 'operations'.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
To leverage table properties for identifying the business owner of each table, which of the following DDL syntaxes correctly populates a table property named 'business_owner'?
A
CREATE TABLE inventory (id INT, units FLOAT) SET TBLPROPERTIES business_owner = ‘supply chain‘
B
CREATE TABLE inventory (id INT, units FLOAT) SET (business_owner = ‘supply chain’)
C
CREATE TABLE inventory (id INT, units FLOAT) SET PROPERTY (business_owner = ‘supply chain’)
D
CREATE TABLE inventory (id INT, units FLOAT) TBLPROPERTIES (business_owner = ‘supply chain‘)
E
CREATE TABLE inventory (id INT, units FLOAT) SET TAG (business_owner = ‘supply chain’)