Which command will allow users to query data from files in cloud storage without ingesting the data?
Suggested Answer: A
Get Premium COF-C03 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
===========
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.