MENU
Use of which file function allows a user to share unstructured data from an internal stage with an external reporting tool that does not have access to Snowflake">
Suggested Answer: B
Get Premium COF-C02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
The GET_PRESIGNED_URL function in Snowflake generates a pre-signed URL for a file in an internal stage. This URL can be shared with external tools or users who do not have direct access to Snowflake, allowing them to download the file.
Generate Pre-Signed URL:
SELECT GET_PRESIGNED_URL(@my_stage/file.txt);
Share the URL: The generated URL can be shared with external users or applications, enabling them to access the file directly.
Snowflake Documentation: GET_PRESIGNED_URL
Snowflake Documentation: Working with Stages
34 comments · newest first
HO
Hollis
11 months ago
C seems plausible too, but I lean towards B.
HA
Hayley
11 months ago
Wait, can you really share data like that? Sounds risky!
RU
Rutha
11 months ago
I thought it was A at first, but B makes more sense.
OD
Odette
11 months ago
Agreed, B is the way to go!
CA
Carli
11 months ago
I think it's definitely B, GET_PRESIGNED_URL.
GE
Gerald
12 months ago
I’m leaning towards GET_PRESIGNED_URL too, but I remember there were nuances in the definitions. It’s tricky!
JO
Jose
12 months ago
I feel like BUILD_STAGE_FILE_URL could be the answer, but it sounds a bit off. I need to double-check my notes.
MA
Marti
12 months ago
I remember something about sharing files, but I can't recall the exact function. Was it BUILD_SCOPED_FILE_URL?
BR
Brock
1 year ago
I think it might be GET_PRESIGNED_URL, but I'm not entirely sure. We practiced a similar question in class.
GR
Gracia
1 year ago
Ah, I remember learning about this in class. I believe the answer is B, GET_PRESIGNED_URL. That function creates a temporary, shareable URL for the file.
BE
Belen
1 year ago
I'm a bit confused on the difference between the "BUILD_" and "GET_" functions. Gotta make sure I understand that before I can answer this.
CO
Colette
1 year ago
Okay, let's see. I think the key here is finding a function that can generate a shareable URL for the data, rather than just the file location. Time to review my Snowflake notes!
DU
Dulce
1 year ago
Hmm, this one seems tricky. I'll need to think through the different file functions and how they relate to sharing data with external tools.
LA
Lashaunda
2 years ago
I'm going with B) GET_PRESIGNED_URL. It's the perfect solution to share data without giving away the whole farm.
JO
Josphine
2 years ago
GET_PRESIGNED_URL is definitely the best option for sharing data externally.
VE
Verda
2 years ago
I prefer A) BUILD_SCOPED_FILE_URL. It works well for my needs.
PA
Paola
2 years ago
I think B) GET_PRESIGNED_URL is the way to go too. It's secure and efficient.
SU
Susy
2 years ago
I think D) GET_STAGE_LOCATION might be the answer, as it specifies the stage location for sharing data
JA
Jacquelyne
2 years ago
B) GET_PRESIGNED_URL is the way to go. Gotta love those Snowflake functions that make life easier.
AL
Alease
2 years ago
Haha, I bet the answer is not D) GET_STAGE_LOCATION. That would just give you the location of the stage, not a way to share the data!
JA
Janella
2 years ago
C) BUILD_STAGE_FILE_URL
TH
Theodora
2 years ago
B) GET_PRESIGNED_URL
AL
Alison
2 years ago
A) BUILD_SCOPED_FILE_URL
YV
Yvonne
2 years ago
I'm not sure, but C) BUILD_STAGE_FILE_URL could also work for sharing data from internal stage
MI
Millie
2 years ago
I agree with Ryan, GET_PRESIGNED_URL makes sense for sharing data externally
OC
Ocie
2 years ago
Definitely B) GET_PRESIGNED_URL. That's the way to go to securely share data from Snowflake with external reporting tools.
AJ
Aja
2 years ago
GET_PRESIGNED_URL is the way to go for sharing data securely outside of Snowflake.
MA
Marsha
2 years ago
I agree, GET_PRESIGNED_URL is the best option for securely sharing data with external tools.
RY
Ryan
2 years ago
I think the answer is B) GET_PRESIGNED_URL
TA
Talia
2 years ago
I think the answer is B) GET_PRESIGNED_URL. It allows you to generate a temporary, pre-signed URL that can be shared with external tools to access the data.
MA
Magnolia
2 years ago
I agree, it's definitely B) GET_PRESIGNED_URL.
CH
Chana
2 years ago
I'm pretty sure it's A) BUILD_SCOPED_FILE_URL.
EV
Evan
2 years ago
I think it might be C) BUILD_STAGE_FILE_URL.
MI
Miesha
2 years ago
I believe the answer is B) GET_PRESIGNED_URL.