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

- Free Preparation Discussions

Snowflake COF-C03 Exam - Topic 4 Question 6 Discussion

Posted by Myong on Jun 30, 2026 at 02:47 PM

Which command will allow users to query data from files in cloud storage without ingesting the data?

Suggested Answer: A

An external table allows users to query files stored in external stages (e.g., S3, Azure Blob, GCS) without loading them into Snowflake tables. This enables cost-effective access to external datasets.


Snowflake Docs: External Tables

===========

Get Premium COF-C03 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
27 comments · newest first
LI
Linwood 14 hours ago
D) CREATE FILE FORMAT is just for formatting.
JA
James 6 days ago
Yeah, that requires data ingestion.
LI
Linwood 11 days ago
C) CREATE TABLE is definitely wrong.
SC
Scarlet 16 days ago
True, but it can also help with streaming.
MA
Maxima 21 days ago
But that's for data loading, right?
SC
Scarlet 26 days ago
I was leaning towards B) CREATE PIPE.
FE
Felix 1 month ago
I agree, A makes sense.
VA
Val 1 month ago
It lets you access data without moving it.
MA
Maxima 1 month ago
Why do you think that?
VA
Val 2 months ago
I think it's A) CREATE EXTERNAL TABLE.
JO
Joanna 2 months ago
A) is the best choice for this question.
ME
Melodie 2 months ago
C) CREATE TABLE is definitely not right.
ER
Erasmo 2 months ago
D) CREATE FILE FORMAT seems unrelated.
JU
Jutta 2 months ago
I feel confident about A) too.
BR
Brinda 2 months ago
B) is more about data loading, not querying.
MO
Monroe 3 months ago
A) makes sense for querying without ingestion.
PE
Percy 3 months ago
Really? I thought it was B) CREATE PIPE.
FE
Felix 3 months ago
I think it's A) CREATE EXTERNAL TABLE.
DE
Delila 3 months ago
Seems too easy, but I guess it makes sense!
EL
Eladia 3 months ago
I thought it was B) CREATE PIPE?
EM
Emmett 3 months ago
Wait, are we sure about that?
AL
Alease 4 months ago
Totally agree with that!
ET
Ettie 4 months ago
A) CREATE EXTERNAL TABLE is the right one!
VO
Von 4 months ago
I’m leaning towards A) too, but I vaguely recall something about file formats being relevant in some context.
TI
Tiera 4 months ago
I feel like I might be mixing up the commands. Wasn't there something about pipes that could also relate to querying?
JU
Justa 4 months ago
I remember practicing a similar question, and I think external tables were definitely involved. A) seems like the best choice here.
AL
Alita 4 months ago
I think it's A) CREATE EXTERNAL TABLE, but I'm not entirely sure if that's the right command for querying without ingesting.
0/2000 characters

Save Cancel