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?

ACREATE EXTERNAL TABLE

BCREATE PIPE

CCREATE TABLE

DCREATE FILE FORMAT

Show Suggested 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:

Submit Cancel

Delila

2 days ago

Seems too easy, but I guess it makes sense!

upvoted 0 times

...

Eladia

7 days ago

I thought it was B) CREATE PIPE?

upvoted 0 times

...

Emmett

13 days ago

Wait, are we sure about that?

upvoted 0 times

...

Alease

18 days ago

Totally agree with that!

upvoted 0 times

...

Ettie

23 days ago

A) CREATE EXTERNAL TABLE is the right one!

upvoted 0 times

...

Von

28 days ago

I’m leaning towards A) too, but I vaguely recall something about file formats being relevant in some context.

upvoted 0 times

...

Tiera

1 month 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

1 month 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

1 month 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

...