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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake COF-C03 Exam - Topic 4 Question 6 Discussion

Which command will allow users to query data from files in cloud storage without ingesting the data?
A) CREATE EXTERNAL TABLE
B) CREATE PIPE
C) CREATE TABLE
D) CREATE FILE FORMAT

Snowflake COF-C03 Exam - Topic 4 Question 6 Discussion

Actual exam question for Snowflake's COF-C03 exam
Question #: 6
Topic #: 4
[All COF-C03 Questions]

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

Show Suggested Answer Hide Answer
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

===========

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

Limited Time Offer

25%

Off

Get Premium COF-C03 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Val
2 days ago
I think it's A) CREATE EXTERNAL TABLE.
upvoted 0 times
...
Joanna
7 days ago
A) is the best choice for this question.
upvoted 0 times
...
Melodie
12 days ago
C) CREATE TABLE is definitely not right.
upvoted 0 times
...
Erasmo
17 days ago
D) CREATE FILE FORMAT seems unrelated.
upvoted 0 times
...
Jutta
22 days ago
I feel confident about A) too.
upvoted 0 times
...
Brinda
27 days ago
B) is more about data loading, not querying.
upvoted 0 times
...
Monroe
1 month ago
A) makes sense for querying without ingestion.
upvoted 0 times
...
Percy
1 month ago
Really? I thought it was B) CREATE PIPE.
upvoted 0 times
...
Felix
1 month ago
I think it's A) CREATE EXTERNAL TABLE.
upvoted 0 times
...
Delila
2 months ago
Seems too easy, but I guess it makes sense!
upvoted 0 times
...
Eladia
2 months ago
I thought it was B) CREATE PIPE?
upvoted 0 times
...
Emmett
2 months ago
Wait, are we sure about that?
upvoted 0 times
...
Alease
2 months ago
Totally agree with that!
upvoted 0 times
...
Ettie
2 months ago
A) CREATE EXTERNAL TABLE is the right one!
upvoted 0 times
...
Von
2 months ago
I’m leaning towards A) too, but I vaguely recall something about file formats being relevant in some context.
upvoted 0 times
...
Tiera
3 months ago
I feel like I might be mixing up the commands. Wasn't there something about pipes that could also relate to querying?
upvoted 0 times
...
Justa
3 months ago
I remember practicing a similar question, and I think external tables were definitely involved. A) seems like the best choice here.
upvoted 0 times
...
Alita
3 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.
upvoted 0 times
...

Save Cancel