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.
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’)
No comments yet.