Snowflake COF-R02 Exam - Topic 1 Question 47 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 47
Topic #: 1

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

AA directory table is a separate database object.

BDirectory tables store data file metadata.

CA directory table will be automatically added to a stage.

DDirectory tables do not have their own grantable privileges.

EDirectory table data can not be refreshed manually.

Show Suggested Answer

Suggested Answer: B, D

by Ollie at Nov 19, 2024, 06:50 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Daryl

4 months ago

Yep, they automatically get added to a stage, no doubt about it.

upvoted 0 times

...

Antione

4 months ago

I thought directory tables could be refreshed manually, that's surprising!

upvoted 0 times

...

Mee

4 months ago

Wait, are you sure they don't have grantable privileges?

upvoted 0 times

...

Casey

4 months ago

Totally agree, they store data file metadata too!

upvoted 0 times

...

Tonette

5 months ago

A directory table is indeed a separate database object.

upvoted 0 times

...

Nikita

5 months ago

I’m a bit confused about option A; I thought directory tables were more like views rather than separate database objects.

upvoted 0 times

...

Marsha

5 months ago

I recall that directory tables don't have their own privileges, so option D might be one of the answers.

upvoted 0 times

...

Hollis

5 months ago

I'm not entirely sure, but I remember something about directory tables being linked to stages. Maybe option C is correct?

upvoted 0 times

...

Fletcher

5 months ago

I think option B sounds familiar since we discussed how directory tables manage metadata for files.

upvoted 0 times

...

Cordelia

5 months ago

Refreshing the data in a directory table manually - that's a good thing to keep in mind. I'll make sure I know the process for that.

upvoted 0 times

...

Sabina

5 months ago

The privileges for a directory table are an interesting point. I'll make sure I understand how those work compared to regular tables.

upvoted 0 times

...

Marti

5 months ago

I'm a bit confused about whether a directory table is automatically added to a stage. I'll need to double-check that detail.

upvoted 0 times

...

Shala

5 months ago

Okay, let's see. I know a directory table is a separate database object, so that's one consideration. And it stores metadata about the data files, that's important too.

upvoted 0 times

...

Julene

5 months ago

Hmm, this seems like a tricky one. I'll need to think carefully about the key considerations for using a directory table with unstructured data.

upvoted 0 times

...

Iluminada

1 year ago

I'm not sure about option C, though. Can someone explain why a directory table will be automatically added to a stage?

upvoted 0 times

...

Justine

1 year ago

I agree with Bulah. Directory tables store data file metadata and do not have their own grantable privileges.

upvoted 0 times

...

Felicidad

1 year ago

B and D for sure. Although, I'm a little disappointed there's no option for 'All of the above, and also the kitchen sink.'

upvoted 0 times

Lettie

1 year ago

Yes, those are key points to keep in mind.

upvoted 0 times

...

Magda

1 year ago

I know, it would have been nice to have an option for 'All of the above, and also the kitchen sink.'

upvoted 0 times

...

Claudia

1 year ago

D) Directory tables do not have their own grantable privileges.

upvoted 0 times

...

Terry

1 year ago

B) Directory tables store data file metadata.

upvoted 0 times

...

Maryann

1 year ago

I agree, those are important considerations.

upvoted 0 times

...

Vince

1 year ago

D) Directory tables do not have their own grantable privileges.

upvoted 0 times

...

Art

1 year ago

B) Directory tables store data file metadata.

upvoted 0 times

...

Bulah

1 year ago

I think options B and D are considerations when using a directory table.

upvoted 0 times

...

Carma

1 year ago

Hmm, I'm not sure about C. I don't think a directory table is automatically added to a stage. Let me go with B and D.

upvoted 0 times

Tamekia

1 year ago

Sounds good, let's go with B and D as our choices.

upvoted 0 times

...

Winifred

1 year ago

I'm not sure about C either, let's stick with B and D.

upvoted 0 times

...

Delbert

1 year ago

I agree, and D is also true, directory tables do not have their own grantable privileges.

upvoted 0 times

...

Onita

1 year ago

I think B is correct, directory tables store data file metadata.

upvoted 0 times

...

Stephaine

1 year ago

I think A and B are the correct choices. A directory table is a separate database object, and it does store file metadata.

upvoted 0 times

...

Dannie

1 year ago

I'm pretty sure the answer is B and D. Directory tables store metadata about the data files, and they don't have their own privileges that can be granted.

upvoted 0 times