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

5 days 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

8 days ago

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

upvoted 0 times

...

Felicidad

9 days 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

...

Bulah

14 days ago

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

upvoted 0 times

...

Carma

20 days 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

Winifred

2 days ago

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

upvoted 0 times

...

Delbert

4 days ago

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

upvoted 0 times

...

Onita

8 days ago

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

upvoted 0 times

...

Stephaine

24 days 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

26 days 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

11 days ago

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

upvoted 0 times

...

Owen

12 days ago

So, the answer is B and D then.

upvoted 0 times

...

Charlene

14 days ago

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

upvoted 0 times

...

Irving

16 days ago

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

upvoted 0 times

...