This is the result of B
https://docs.snowflake.com/en/sql-reference/sql/desc-masking-policy.html#example
So B can't be the answer
And this is the result of C
https://docs.snowflake.com/en/sql-reference/functions/get_ddl.html#examples
So C is the answer
B result is
| 1 | SSN_MASK | (VAL VARCHAR) | VARCHAR(16777216) | case when current_role() in ('ANALYST') then val else '*********' end |
C result is
| create or replace view BOOKS_VIEW as select title, author from books_table; |
C
https://docs.snowflake.com/en/sql-reference/functions/get_ddl
Returns a DDL statement that can be used to recreate the specified object.
GET_DDL currently supports the following object types:
Policies (see CREATE MASKING POLICY , CREATE PASSWORD POLICY , CREATE ROW ACCESS POLICY , and CREATE SESSION POLICY , CREATE AUTHENTICATION POLICY)
B is the answer
if you want to replace an existing masking policy and need to see the current definition of the policy, call the GET_DDL function or run the DESCRIBE MASKING POLICY command.
should be GET_DDL, describe returns only the body, not the whole create statement definition , for example input & return column data types values will be missing
C - GET_DDL returns the create statement to recreate the object.
DESCRIBE will show the sql behind the policy but not in the form of a create statement.
Correct answer DESCRIBE MASKING POLICY since the question is about command. If asked about the function then GET_DDL
upvoted 4 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
AS314
Highly Voted 1 year, 10 months agoDef21
1 year, 5 months agoPrashantGupta1616
Most Recent 5 months, 2 weeks ago_yyukta
8 months, 3 weeks ago0e504b5
9 months, 3 weeks agoBujji1234
9 months, 3 weeks agoPradeep_7869
1 year agosurya_lolla
1 year, 3 months agoSatyamKishore
1 year, 6 months agosailoo
1 year, 10 months agosakis213
1 year, 10 months agoyogen
1 year, 11 months agoscoob
1 year, 11 months agohalol
1 year, 11 months agoharshagc180
1 year, 11 months ago