Answer-first summary for fast verification
Answer: Adding a table comment is a way to provide additional context or information about the table's purpose, schema, or usage. This can be done using the COMMENT ON TABLE statement in SQL.
Adding a table comment is a way to provide additional context or information about the table's purpose, schema, or usage. This can be done using the COMMENT ON TABLE statement in SQL. For example, to add a comment to a table 'sales_data' explaining its purpose, you would use the command: 'COMMENT ON TABLE sales_data IS 'This table contains sales data from 2020 to present.';'
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Explain the purpose of adding a table comment in a Delta Lake table. Describe how you would add a comment to an existing table to provide additional context about the table's purpose.
A
Adding a table comment is used to encrypt the table data, ensuring data security.
B
Adding a table comment is a way to provide additional context or information about the table's purpose, schema, or usage. This can be done using the COMMENT ON TABLE statement in SQL.
C
Adding a table comment is used to optimize query performance by reorganizing the table data.
D
Adding a table comment is a method to hide the table from other users in the database.