Certified Data Analyst AssociateDemo

Question

A data analyst must programmatically designate a Unity Catalog table, sales_data, as certified so it can be found as a trusted asset throughout their organization.

Which SQL command can be used to satisfy this requirement?

A ALTER TABLE sales_data SET TAGS (‘system.Certified’);
B ALTER TABLE sales_data SET TAGS (‘certified’ = ‘true’);
C GRANT CERTIFY ON TABLE sales_data TO analyst_group;
D UPDATE TABLE sales_data ADD COMMENT ‘Certified dataset’;

Explanation

Marking a Unity Catalog table as "certified" so it surfaces as a trusted asset is done with a governed system tag applied via ALTER TABLE ... SET TAGS — the documented tag lives in the system namespace (system.certification_status = certified). Only option A uses a system-namespace tag (system.Certified), which is the mechanism that produces the certified/trusted-asset designation. Option B applies an arbitrary user tag ('certified' = 'true') that carries no special meaning and does not certify the asset. Options C (GRANT CERTIFY) and D (UPDATE ... ADD COMMENT) are not valid ways to certify a table.

Learn more

Certified Data Analyst AssociateDemo

AstroTutor

Notes

Readiness

QuestionQ63

Community Discussion