Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 311 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 311
Topic #: 1
[All SnowPro Core Questions]

Which SQL command can be used to see the CREATE definition of a masking policy?

  • A. SHOW MASKING POLICIES
  • B. DESCRIBE MASKING POLICY
  • C. GET_DDL
  • D. LIST MASKING POLICIES
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
AS314
Highly Voted 1 year, 10 months ago
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
upvoted 9 times
Def21
1 year, 5 months ago
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; |
upvoted 1 times
...
...
PrashantGupta1616
Most Recent 5 months, 2 weeks ago
Selected Answer: C
SELECT GET_DDL('MASKING POLICY', 'your_masking_policy_name');
upvoted 1 times
...
_yyukta
8 months, 3 weeks ago
Selected Answer: C
C. GET_DDL
upvoted 1 times
...
0e504b5
9 months, 3 weeks ago
Selected Answer: C
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)
upvoted 1 times
...
Bujji1234
9 months, 3 weeks ago
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.
upvoted 1 times
...
Pradeep_7869
1 year ago
B is the answer
upvoted 1 times
...
surya_lolla
1 year, 3 months ago
https://docs.snowflake.com/en/sql-reference/sql/desc-masking-policy DESC MASKING POLICY
upvoted 1 times
...
SatyamKishore
1 year, 6 months ago
Going by snowflake documentation, seems both b & c is correct. https://docs.snowflake.com/en/sql-reference/sql/create-masking-policy#usage-notes
upvoted 2 times
...
sailoo
1 year, 10 months ago
B is the correct answer
upvoted 1 times
...
sakis213
1 year, 10 months ago
Selected Answer: C
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
upvoted 4 times
...
yogen
1 year, 11 months ago
C for Sure
upvoted 1 times
...
scoob
1 year, 11 months ago
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.
upvoted 4 times
...
halol
1 year, 11 months ago
I think B&C https://docs.snowflake.com/en/sql-reference/sql/create-masking-policy.html#usage-notes
upvoted 3 times
...
harshagc180
1 year, 11 months ago
Correct answer DESCRIBE MASKING POLICY since the question is about command. If asked about the function then GET_DDL
upvoted 4 times
...
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.

SaveCancel
Loading ...