Snowflake Exam COF-C02 Topic 5 Question 17 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 17
Topic #: 5

[All COF-C02 Questions]

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

ASHOW MASKING POLICIES

BDESCRIBE MASKING POLICY

CGET_DDL

DLIST MASKING POLICIES

Show Suggested Answer

Suggested Answer: B

According to the Snowflake documentation1, a directory table stores a catalog of staged files in cloud storage and can be queried to retrieve theSnowflake-hosted file URLto each file in the stage. A file URL has the following format:

https:///api/files/<db_name>.<schema_name>.<stage_name>/<relative_path>

Based on this information, I think the query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage isB. select * from directory(@bronzestage);

by Gail at Aug 08, 2023, 11:52 AM

Limited Time Offer

25%

Off

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

France

6 days ago

D) LIST MASKING POLICIES sounds like the most straightforward option to me. Why overcomplicate things when there's a command specifically for listing masking policies?

upvoted 0 times

...

Lajuana

11 days ago

I'm not sure, but I think it could also be A) SHOW MASKING POLICIES because it sounds like it would show the policies.

upvoted 0 times

...

Nichelle

11 days ago

I'm pretty sure it's C) GET_DDL. That's the command I use to see the definition of other database objects, so it makes sense it would work for masking policies too.

upvoted 0 times

...

Kandis

19 days ago

I agree with Janna, GET_DDL makes sense because it stands for Get Data Definition Language.

upvoted 0 times

...

Janna

20 days ago

I think the answer is C) GET_DDL.

upvoted 0 times

...