Snowflake COF-R02 Exam - Topic 1 Question 4 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 4
Topic #: 1

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

ACHECK_OPTION

BIS_SECURE

CIS_UPDATEABLE

DTABLE_NAME

Show Suggested Answer

Suggested Answer: B

by Jina at Dec 08, 2022, 04:13 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Jacob

4 months ago

B makes sense, but I can see the confusion.

upvoted 0 times

...

Gracia

4 months ago

I thought it was A, CHECK_OPTION.

upvoted 0 times

...

Staci

4 months ago

Wait, are we sure about that?

upvoted 0 times

...

Stacey

4 months ago

Totally agree, B is the right answer!

upvoted 0 times

...

Zita

4 months ago

It's B, IS_SECURE.

upvoted 0 times

...

Pedro

5 months ago

I don't recall seeing TABLE_NAME being relevant for this. It seems more about the properties of the view itself.

upvoted 0 times

...

Tom

5 months ago

I’m leaning towards IS_SECURE as well, but I could be mixing it up with something else from the Information Schema.

upvoted 0 times

...

Odette

5 months ago

I remember practicing a question similar to this, and I feel like CHECK_OPTION was mentioned, but it doesn't seem to fit here.

upvoted 0 times

...

Renea

5 months ago

I think the column we're looking for is IS_SECURE, but I'm not entirely sure if that's the right one.

upvoted 0 times

...

Catalina

5 months ago

Hmm, I'm not sure about this one. The options seem a bit confusing. I might need to re-read the question and think it through more carefully.

upvoted 0 times

...

Gary

5 months ago

Hmm, I'm a bit unsure about this one. I think personalization strings could be used, but I'm not sure if that's considered a "feature" per se. I'll have to think this through carefully.

upvoted 0 times

...

Elbert

5 months ago

The key here is understanding how the Rules Centralization pattern affects the centralization or decentralization of different aspects of the system. I'll need to reason through that step-by-step.

upvoted 0 times

...