Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
In a scenario where you are working with Delta Lake tables in Databricks and need to add metadata to a table to provide additional information about its purpose or content, consider the following requirements: the solution must be cost-effective, comply with data governance policies, and easily scalable. Additionally, the method should allow for the comment to be easily viewed by other team members. Given these constraints, which of the following methods is the BEST to add a table comment, and why? Choose one option.
In a scenario where you are working with Delta Lake tables in Databricks and need to add metadata to a table to provide additional information about its purpose or content, consider the following requirements: the solution must be cost-effective, comply with data governance policies, and easily scalable. Additionally, the method should allow for the comment to be easily viewed by other team members. Given these constraints, which of the following methods is the BEST to add a table comment, and why? Choose one option.
Explanation:
Option A is the best choice because it directly modifies the table properties to include the comment, ensuring the comment is stored as part of the table's metadata. This method is cost-effective, complies with data governance policies by maintaining metadata within the table, and is scalable as it does not require additional resources. The comment is also easily viewable by other team members through standard metadata inspection commands. While Option B is also correct and follows standard SQL practices, Option A is more aligned with the specific requirements of being cost-effective, compliant, and scalable.