Explanation:
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'.
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’)