Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Snowflake Exam COF-C02 Topic 5 Question 8 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 8
Topic #: 5

[All COF-C02 Questions]

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

Oliva

3 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

2 months ago

C) Permanent

upvoted 0 times

...

Jacqueline

2 months ago

B) Transient

upvoted 0 times

...

Alba

3 months ago

A) Temporary

upvoted 0 times

...

...

Paola

3 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

4 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

Francoise

2 months ago

D: External tables might be overkill for this situation, Temporary tables should suffice.

upvoted 0 times

...

Alecia

2 months ago

C: But what about using External tables?

upvoted 0 times

...

Johnetta

2 months ago

B: I agree, using Temporary tables would be the most cost-effective option.

upvoted 0 times

...

Adelina

2 months ago

A: I think the answer is C) Temporary.

upvoted 0 times

...

Sherell

2 months ago

User1: Yeah, using External tables would be overkill for this situation. Temporary tables are the way to go.

upvoted 0 times

...

Kanisha

2 months ago

User3: I'm not sure, but I think Temporary tables make the most sense in this scenario.

upvoted 0 times

...

Carli

2 months ago

User2: I agree, using Temporary tables would be the best option to minimize costs for transitory data.

upvoted 0 times

...

Lottie

2 months ago

User1: I think the answer is C) Temporary.

upvoted 0 times

...

...

Deangelo

4 months ago

Temporary tables? That's a bold move, but I guess it could work if the data is truly disposable. Might as well go all-in on cost-saving!

upvoted 0 times

Lorean

3 months ago

C) Temporary

upvoted 0 times

...

Renato

3 months ago

A) Temporary

upvoted 0 times

...

...

Willow

4 months ago

Hmm, I think Transient would be the best choice here. It's perfect for storing temporary data that doesn't need to be protected against failures.

upvoted 0 times

...

Josephine

4 months ago

I disagree. I think Transient tables would be more cost-effective in this scenario.

upvoted 0 times

...

Carolann

4 months ago

I agree with Nida. Using Temporary tables would help minimize the cost.

upvoted 0 times

...

Nida

4 months ago

I think the table type that should be used is Temporary.

upvoted 0 times

...