Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake COF-C02 Exam - Topic 5 Question 17 Discussion

Which SQL command can be used to see the CREATE definition of a masking policy?
B) DESCRIBE MASKING POLICY
A) SHOW MASKING POLICIES
C) GET_DDL
D) LIST MASKING POLICIES

Snowflake COF-C02 Exam - 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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Aleisha
9 months ago
Really? I had no idea GET_DDL was an option!
upvoted 0 times
...
Zita
9 months ago
Wait, I thought it was LIST MASKING POLICIES?
upvoted 0 times
...
Brittni
10 months ago
A is the right answer, SHOW MASKING POLICIES.
upvoted 0 times
...
Ilona
10 months ago
Definitely B, DESCRIBE MASKING POLICY!
upvoted 0 times
...
Lennie
10 months ago
I think it's C, GET_DDL.
upvoted 0 times
...
Lavonna
10 months ago
I don't think LIST MASKING POLICIES is correct; it sounds more like a command to just list them rather than show the definition.
upvoted 0 times
...
Cristen
10 months ago
I feel like DESCRIBE MASKING POLICY could be the answer, but I also have a nagging doubt about whether it's specific enough.
upvoted 0 times
...
Arlette
11 months ago
I remember practicing with SHOW MASKING POLICIES, but I can't recall if it actually shows the CREATE definition.
upvoted 0 times
...
Tom
11 months ago
I think the command might be GET_DDL, but I'm not entirely sure if that's the right one for masking policies.
upvoted 0 times
...
Carolann
11 months ago
This looks like a straightforward database question. I'll start by thinking about the relationships between the tables and which one is the parent.
upvoted 0 times
...
Roselle
11 months ago
I'm not sure about this one. I'll have to re-read the question a few times to make sure I understand it.
upvoted 0 times
...
Jaime
11 months ago
I think increasing the ISN MTU is important, but it seems like there might be other options too.
upvoted 0 times
...
Jackie
11 months ago
This question seems pretty straightforward. I think I can figure this out.
upvoted 0 times
...
Kenneth
11 months ago
I'm leaning towards Technical Safeguards, since evaluation could involve testing the security of systems and technologies. But I'll double-check my understanding before answering.
upvoted 0 times
...
Terry
11 months ago
Key strategy: Compare the MAC list price and actual payment for Drugs A and B. Then see which reimbursement scenario matches the facts given in the question.
upvoted 0 times
...
Sharmaine
1 year 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
...
Roslyn
1 year ago
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
1 year ago
Let's use that command and see what we can find out.
upvoted 0 times
...
Tammy
1 year ago
Yeah, DESCRIBE MASKING POLICY sounds like the right choice to uncover their secrets.
upvoted 0 times
...
Nickolas
1 year ago
I think it's more about hiding sensitive data in databases.
upvoted 0 times
...
...
France
1 year 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
Genevieve
1 year ago
I agree, D) LIST MASKING POLICIES seems like the most direct way to view the CREATE definition of a masking policy.
upvoted 0 times
...
Howard
1 year ago
D) LIST MASKING POLICIES
upvoted 0 times
...
Socorro
1 year ago
C) GET_DDL
upvoted 0 times
...
Skye
1 year ago
A) SHOW MASKING POLICIES
upvoted 0 times
...
...
Lajuana
1 year 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
1 year 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 year ago
Yeah, I use GET_DDL for other objects too, so it should work for masking policies.
upvoted 0 times
...
Keva
1 year ago
I think you're right, GET_DDL is the command to see the CREATE definition.
upvoted 0 times
...
...
Kandis
1 year ago
I agree with Janna, GET_DDL makes sense because it stands for Get Data Definition Language.
upvoted 0 times
...
Janna
1 year ago
I think the answer is C) GET_DDL.
upvoted 0 times
...

Save Cancel