MENU
An Architect is integrating an application that needs to read and write data to Snowflake without installing any additional software on the application server.
How can this requirement be met?
Suggested Answer: B
Get Premium ARA-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
Cloning a table with a masking policy can cause the cloning operation to fail because the masking policy is not automatically cloned with the table. This is due to the fact that the masking policy is considered a separate object with its own set of privileges1.
Snowflake Documentation on Cloning Considerations1.
35 comments · newest first
SH
Shaquana
11 months ago
I’m surprised there’s no mention of direct JDBC connections here!
MA
Margot
11 months ago
ODBC driver? Nah, that's not going to work without extra software.
BE
Bettina
11 months ago
Wait, can you really use the Snowpipe REST API for this? Sounds off.
ER
Erick
11 months ago
Definitely agree with that! Super easy to integrate.
LA
Laticia
11 months ago
I think the Snowflake SQL REST API is the way to go!
BR
Breana
12 months ago
I’m leaning towards the Snowflake SQL REST API too, but I wonder if there are any limitations I should be aware of.
PH
Phil
12 months ago
I practiced a question similar to this, and I feel like the ODBC driver requires installation, so it might not fit the requirement.
CR
Crista
12 months ago
I'm not entirely sure, but I remember something about Snowpipe being useful for loading data. Maybe that's an option?
TA
Tarra
1 year ago
I think the Snowflake SQL REST API could be the right choice since it allows for direct interaction without needing extra software.
TA
Tammara
1 year ago
The Snowpipe REST API could be a good option too. It's designed for integrating applications with Snowflake, so that might be worth looking into.
LE
Leonor
1 year ago
I'm leaning towards the Snowflake SQL REST API. That seems like the most straightforward way to integrate the application without any additional software.
VI
Vincenza
1 year ago
I'm a bit confused by the question. Can we use the Snowflake client tools, or does it have to be a pure API-based solution?
JA
Jani
1 year ago
Hmm, this seems like a tricky one. I'll need to think through the different options carefully.
LI
Linn
1 year ago
Okay, I think I've got this. The key is to find a way to integrate the application without installing any additional software on the server.
SI
Silvana
1 year ago
The high latency on the HA connection is definitely a red flag. That could be causing the constant failover state changes.
PH
Phil
1 year ago
Hmm, B) the Snowpipe REST API does seem like the most straightforward option. Maybe the other choices involve installing something sneaky, like a unicorn or a singing telegram.
WI
William
1 year ago
C) Use the Snowflake SQL REST API.
LA
Lavonda
1 year ago
B) Use the Snowpipe REST API.
MI
Mickie
1 year ago
A) Use SnowSQL.
LO
Lourdes
1 year ago
I was leaning towards C) the Snowflake SQL REST API, but now I'm not so sure. This is a tricky one!
PA
Page
1 year ago
User3: I'm not sure, maybe we should consider B) Use the Snowpipe REST API as well.
LI
Lili
1 year ago
User2: I agree, SnowSQL seems like the best option for this requirement.
SA
Sage
1 year ago
User1: I think A) Use SnowSQL is the way to go.
TH
Theresia
1 year ago
D) The Snowflake ODBC driver could work, but I'm not sure if that counts as 'without installing any additional software'.
MI
Micaela
1 year ago
D) The Snowflake ODBC driver could work, but I'm not sure if that counts as 'without installing any additional software'.
JO
Joanne
1 year ago
C) Use the Snowflake SQL REST API.
BE
Beula
1 year ago
B) Use the Snowpipe REST API.
HO
Hobert
1 year ago
A) Use SnowSQL.
CH
Cherry
1 year ago
C) Use the Snowflake SQL REST API.
SA
Salena
1 year ago
B) Use the Snowpipe REST API.
JO
Johnathon
1 year ago
A) Use SnowSQL.
ET
Ethan
1 year ago
B) Using the Snowpipe REST API sounds like the way to go. Seems simple and doesn't require any additional software on the application server.
VE
Veronika
2 years ago
I'm not sure, but I think C) Use the Snowflake SQL REST API could also work for this requirement.
ER
Ernestine
2 years ago
I agree with Tashia, SnowSQL allows for reading and writing data to Snowflake without additional software.
TA
Tashia
2 years ago
I think the answer is A) Use SnowSQL.