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

Sharmaine

1 months ago

A) SHOW MASKING POLICIES is the way to go. It's simple, descriptive, and probably the most widely used command for this task. I'm not trying to overthink this one.

upvoted 0 times

...

Hmm, I've never heard of a 'masking policy' before. Is that like a secret society for database admins? In that case, B) DESCRIBE MASKING POLICY is probably the way to go to learn their mysterious ways.

upvoted 0 times

Ryan

23 days ago

Let's use that command and see what we can find out.

upvoted 0 times

...

Tammy

29 days ago

Yeah, DESCRIBE MASKING POLICY sounds like the right choice to uncover their secrets.

upvoted 0 times

...

Nickolas

1 months ago

I think it's more about hiding sensitive data in databases.

upvoted 0 times

...

France

2 months 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

Socorro

3 days ago

C) GET_DDL

upvoted 0 times

...

Skye

17 days ago

A) SHOW MASKING POLICIES

upvoted 0 times

...

Lajuana

2 months 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

2 months 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

Yuonne

1 months ago

Yeah, I use GET_DDL for other objects too, so it should work for masking policies.

upvoted 0 times

...

Keva

2 months ago

I think you're right, GET_DDL is the command to see the CREATE definition.

upvoted 0 times

...

Kandis

2 months ago

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

upvoted 0 times

...

Janna

2 months ago

I think the answer is C) GET_DDL.

upvoted 0 times

...

Snowflake Exam COF-C02 Topic 5 Question 17 Discussion

Contribute your Thoughts:

Sharmaine

Roslyn

Ryan

Tammy

Nickolas

France

Socorro

Skye

Lajuana

Nichelle

Yuonne

Keva

Kandis

Janna