Snowflake COF-C02 Exam - Topic 5 Question 8 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 8
Topic #: 5

A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.

What table type should be used?

APermanent

BTransient

CTemporary

DExterna

Show Suggested Answer

Suggested Answer: A

by Diane at Jan 04, 2023, 02:30 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Irene

9 months ago

Not sure if Transient is the best choice, what if you need the data later?

upvoted 0 times

...

Tequila

9 months ago

Transient is the way to go, saves costs big time!

upvoted 0 times

...

Yuki

9 months ago

Wait, can you really use Transient tables without worrying about data loss?

upvoted 0 times

...

Fabiola

10 months ago

I disagree, Temporary tables might be better for quick data.

upvoted 0 times

...

Arlean

10 months ago

Definitely go with Transient tables for this!

upvoted 0 times

...

Maryann

10 months ago

I wonder if External tables could work, but I think they are more for data stored outside of Snowflake, so maybe not.

upvoted 0 times

...

Nichelle

10 months ago

I feel like I've seen a similar question before, and I think Permanent tables are definitely not the right option for minimizing costs.

upvoted 0 times

...

Devorah

10 months ago

I'm not entirely sure, but I remember something about Temporary tables being session-specific, so they might not be the best choice here.

upvoted 0 times

...

Anisha

10 months ago

I think the answer might be Transient tables since they don't incur storage costs for data that can be easily reconstructed.

upvoted 0 times

...

Buck

10 months ago

Hmm, I'm not entirely sure about this one. I know some of the basics like AD authentication, but the other options like usbkey and dynamic password are less familiar to me. I'll have to think this through carefully.

upvoted 0 times

...

Sharen

10 months ago

I think the degree of the table is the number of columns, so I'll look at the image and count the columns to determine the answer.

upvoted 0 times

...

Jonell

10 months ago

I think option A sounds like the best approach. Isolating the business process steps that aren't specific to the business process seems like a good way to identify agnostic service candidates.

upvoted 0 times

...

Frederick

10 months ago

I'm a bit confused by this question. Does Aviatrix only support NAT in AWS, or in all the listed public clouds? I'll need to review my notes to see if I can find a clear answer.

upvoted 0 times

...

Oliva

1 year ago

Hey, if you really want to minimize costs, just store the data in your brain. No storage fees there!

upvoted 0 times

Cortney

1 year ago

C) Permanent

upvoted 0 times

...

Jacqueline

1 year ago

B) Transient

upvoted 0 times

...

Alba

1 year ago

A) Temporary

upvoted 0 times

...

Paola

1 year ago

Permanent tables? What is this, the stone age? With all the options available, that's definitely not the way to go here.

upvoted 0 times

...

Erasmo

1 year ago

External tables? Really? That seems like overkill for something as simple as minimizing costs for transitory data. I'll have to think this one through.

upvoted 0 times