MENU
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?
Suggested Answer: A
Get Premium COF-C02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
34 comments · newest first
IR
Irene
11 months ago
Not sure if Transient is the best choice, what if you need the data later?
TE
Tequila
11 months ago
Transient is the way to go, saves costs big time!
YU
Yuki
12 months ago
Wait, can you really use Transient tables without worrying about data loss?
FA
Fabiola
12 months ago
I disagree, Temporary tables might be better for quick data.
AR
Arlean
12 months ago
Definitely go with Transient tables for this!
MA
Maryann
1 year ago
I wonder if External tables could work, but I think they are more for data stored outside of Snowflake, so maybe not.
NI
Nichelle
1 year 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.
DE
Devorah
1 year 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.
AN
Anisha
1 year ago
I think the answer might be Transient tables since they don't incur storage costs for data that can be easily reconstructed.
BU
Buck
1 year 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.
SH
Sharen
1 year 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.
JO
Jonell
1 year 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.
FR
Frederick
1 year 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.
OL
Oliva
1 year ago
Hey, if you really want to minimize costs, just store the data in your brain. No storage fees there!
CO
Cortney
1 year ago
C) Permanent
JA
Jacqueline
1 year ago
B) Transient
AL
Alba
1 year ago
A) Temporary
PA
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.
ER
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.
FR
Francoise
1 year ago
D: External tables might be overkill for this situation, Temporary tables should suffice.
AL
Alecia
1 year ago
C: But what about using External tables?
JO
Johnetta
1 year ago
B: I agree, using Temporary tables would be the most cost-effective option.
AD
Adelina
1 year ago
A: I think the answer is C) Temporary.
SH
Sherell
1 year ago
User1: Yeah, using External tables would be overkill for this situation. Temporary tables are the way to go.
KA
Kanisha
1 year ago
User3: I'm not sure, but I think Temporary tables make the most sense in this scenario.
CA
Carli
1 year ago
User2: I agree, using Temporary tables would be the best option to minimize costs for transitory data.
LO
Lottie
1 year ago
User1: I think the answer is C) Temporary.
DE
Deangelo
2 years 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!
LO
Lorean
1 year ago
C) Temporary
RE
Renato
1 year ago
A) Temporary
WI
Willow
2 years 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.
JO
Josephine
2 years ago
I disagree. I think Transient tables would be more cost-effective in this scenario.
CA
Carolann
2 years ago
I agree with Nida. Using Temporary tables would help minimize the cost.
NI
Nida
2 years ago
I think the table type that should be used is Temporary.