MENU
What actions are permitted when using the Snowflake SQL REST API? (Select TWO).
Suggested Answer: A, D
Get Premium ARA-R01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
A. The Snowflake SQL REST API does support the use of a GET command, which can be used to retrieve the status of a previously submitted query or to fetch the results of a query once it has been executed. D. The use of a CALL command to a stored procedure is supported, which can return a result set, including a table. This allows the invocation of stored procedures within Snowflake through the SQL REST API.
26 comments · newest first
DO
Dominic
11 months ago
Submitting multiple SQL statements in one call? That sounds risky!
MA
Markus
11 months ago
Totally agree, GET and PUT are the way to go!
GI
Gilma
11 months ago
Wait, can you really use a ROLLBACK with the REST API?
RO
Ronna
11 months ago
I think the PUT command is also allowed.
VO
Vonda
11 months ago
You can definitely use a GET command!
SH
Shonda
12 months ago
Submitting multiple SQL statements in one call seems tricky; I don't think that's permitted, but I might be mixing it up with another API.
WI
Willis
12 months ago
I feel like ROLLBACK is not something we can do with the REST API, but I can't recall the specifics.
KA
Kattie
12 months ago
I remember practicing a question about REST API commands, and I think CALL commands were mentioned as valid actions.
DE
Denae
1 year ago
I think the GET command is definitely allowed, but I'm not sure about the PUT command.
RO
Rosita
1 year ago
Alright, time to put my Snowflake knowledge to the test. I'll start by eliminating the options that don't seem right, then focus on the two correct answers.
SU
Sue
1 year ago
I'm a bit confused by the wording of this question. I'll need to review the Snowflake documentation to make sure I understand the supported commands.
PH
Phuong
1 year ago
I've used the Snowflake SQL REST API before, so I'm feeling pretty confident about this one. I think the key is to focus on the actions that are explicitly permitted.
NO
Novella
1 year ago
Okay, let's see. I know the REST API supports GET and POST commands, but I'm not sure about PUT or ROLLBACK.
ME
Mendy
1 year ago
Hmm, this one looks tricky. I'll need to think carefully about the Snowflake SQL REST API capabilities.
SH
Shawnna
1 year ago
This seems pretty straightforward. I think I'll go with option C and deploy a change set from the sandbox to production with the updated profiles and field access.
AN
Angelica
1 year ago
Hmm, I'm a little unsure about this one. I know there are some key differences between the two programs, but I can't quite recall the specifics about provider reimbursement. I'll have to think this through carefully.
MA
Margret
1 year ago
I'm pretty sure the answer is A. LACP packets should be sent on initialization and then every hello-interval when LACP is in passive mode.
BE
Belen
1 year ago
Option D is definitely tempting, but skipping the meeting could get me in trouble. I think I'll go with B - that way I can document everything and hopefully de-escalate the situation.
CH
Charlena
2 years ago
D and E were confusing. Multiple SQL statements in one call seemed unlikely.
PA
Pamella
2 years ago
ROLLBACK caught my attention, but I wasn't sure.
SA
Sarina
2 years ago
Yes, GET is definitely one of them. PUT seems logical too for uploading data.
NO
Noe
2 years ago
I agree. GET is used for retrieving data, right?
RE
Rebbeca
2 years ago
Kind of. I think GET and PUT are definitely in.
SH
Shawna
2 years ago
Did anyone find the Snowflake SQL REST API question tricky?
BE
Beula
3 years ago
B) The use of a PUT command
PA
Paris
3 years ago
A) The use of a GET command