SnowPro Core Certification — Question 278
Which SQL command can be used to see the CREATE definition of a masking policy?
Answer options
- A. SHOW MASKING POLICIES
- B. DESCRIBE MASKING POLICY
- C. GET_DDL
- D. LIST MASKING POLICIES
Correct answer: C
Explanation
The correct answer is C, GET_DDL, as it retrieves the DDL statement for the specified object, in this case, a masking policy. Options A and D provide lists of masking policies but do not show their definitions, while option B, DESCRIBE MASKING POLICY, provides details about the masking policy but not its CREATE definition.