Snowflake Exam COF-R02 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

Iluminada

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

7 months ago

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

upvoted 0 times

...

Felicidad

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

6 months ago

Yes, those are key points to keep in mind.

upvoted 0 times

...

Magda

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

6 months ago

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

upvoted 0 times

...

Terry

6 months ago

B) Directory tables store data file metadata.

upvoted 0 times

...

Maryann

6 months ago

I agree, those are important considerations.

upvoted 0 times

...

Vince

6 months ago

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

upvoted 0 times

...

Art

6 months ago

B) Directory tables store data file metadata.

upvoted 0 times

...

Bulah

7 months ago

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

upvoted 0 times

...

Carma

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

6 months ago

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

upvoted 0 times

...

Winifred

6 months ago

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

upvoted 0 times

...

Delbert

7 months ago

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

upvoted 0 times

...

Onita

7 months ago

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

upvoted 0 times

...

Stephaine

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

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

Lon

7 months ago

Exactly, those are the considerations when using a directory table.

upvoted 0 times

...

Owen

7 months ago

So, the answer is B and D then.

upvoted 0 times

...

Charlene

7 months ago

Yes, that's correct. They also don't have their own grantable privileges.

upvoted 0 times

...

Irving

7 months ago

I think you're right, directory tables do store metadata about data files.

upvoted 0 times

...