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

4 months ago

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

upvoted 0 times

...

Tequila

4 months ago

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

upvoted 0 times

...

Yuki

4 months ago

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

upvoted 0 times

...

Fabiola

4 months ago

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

upvoted 0 times

...

Arlean

4 months ago

Definitely go with Transient tables for this!

upvoted 0 times

...

Maryann

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

10 months ago

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

upvoted 0 times

Cortney

9 months ago

C) Permanent

upvoted 0 times

...

Jacqueline

9 months ago

B) Transient

upvoted 0 times

...

Alba

9 months ago

A) Temporary

upvoted 0 times

...

Paola

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

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