Discuss Snowflake COF-C02 Exam Topic 5 Question 1

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

ANo virtual warehouse will be used, data will be read from the result cache.

BNo virtual warehouse will be used, data will be read from the local disk cache.

CThe default virtual warehouse will be used to read all data.

DThe virtual warehouse that is defined at the session level will be used to read all data.

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

16 comments · newest first

Twana 11 months ago

Hmm, I’m not convinced, could it really be A?

Skye 11 months ago

A makes the most sense, no need to reprocess!

Lilli 12 months ago

Wait, are you sure? I thought it would use the virtual warehouse.

Vivienne 12 months ago

I think it's B, local disk cache is more reliable.

Corinne 12 months ago

Definitely A, result cache is the way to go!

Frank 1 year ago

I lean towards A as well, but I wonder if the session settings could affect it.

Dwight 1 year ago

I feel like I saw a similar question where the virtual warehouse was involved, but I can't recall if it was C or D.

Cassandra 1 year ago

I'm not entirely sure, but I remember something about local disk cache. Maybe it's B?

Jordan 1 year ago

I think the answer might be A since the data hasn't changed, and they mentioned result caching in class.

Elena 1 year ago

I've got this! The answer is clearly A, transfer.

Cristy 1 year ago

Okay, let me think this through step-by-step. The question is asking about the RADIUS attribute used to set the inactivity timer for MAB users. That means it's likely one of the session-related attributes. I'm going to go with C, idle-timeout, since that sounds like the most relevant option.

Sherell 1 year ago

I feel pretty confident about this one. A well-stated communications objective should be directly linked to the overall business strategy, so I'm going to select D.

Mindy 1 year ago

Hmm, I'm not sure about this one. I'll need to think it through carefully to make sure I understand the requirements.

Nickolas 1 year ago

The connector could be a good choice if the on-premises data has a specific connector available. That would make it easy to integrate the data into the canvas app.

Lucina 1 year ago

This situation feels similar to a practice question we did on swaps. If they swap to a variable rate, it could be LIBOR plus some spread, right?

Blythe 1 year ago

I feel like this could be close to 10 times based on the profits they showed, but I'm worried I might have miscounted the operating profit.

Snowflake COF-C02 Exam - Topic 5 Question 1 Discussion