Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Snowflake ARA-R01 Exam - Topic 2 Question 4 Discussion

Actual exam question for Snowflake's ARA-R01 exam

Question #: 4
Topic #: 2

[All ARA-R01 Questions]

What actions are permitted when using the Snowflake SQL REST API? (Select TWO).

AThe use of a GET command

BThe use of a PUT command

CThe use of a ROLLBACK command

DThe use of a CALL command to a stored procedure which returns a table

ESubmitting multiple SQL statements in a single call

Show Suggested Answer

Suggested Answer: A, D

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.

by Lon at Apr 23, 2024, 09:15 AM

Limited Time Offer

25%

Off

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Dominic

8 months ago

Submitting multiple SQL statements in one call? That sounds risky!

upvoted 0 times

...

Markus

8 months ago

Totally agree, GET and PUT are the way to go!

upvoted 0 times

...

Gilma

8 months ago

Wait, can you really use a ROLLBACK with the REST API?

upvoted 0 times

...

Ronna

8 months ago

I think the PUT command is also allowed.

upvoted 0 times

...

Vonda

8 months ago

You can definitely use a GET command!

upvoted 0 times

...

Shonda

9 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.

upvoted 0 times

...

Willis

9 months ago

I feel like ROLLBACK is not something we can do with the REST API, but I can't recall the specifics.

upvoted 0 times

...

Kattie

9 months ago

I remember practicing a question about REST API commands, and I think CALL commands were mentioned as valid actions.

upvoted 0 times

...

Denae

9 months ago

I think the GET command is definitely allowed, but I'm not sure about the PUT command.

upvoted 0 times

...

Rosita

9 months 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.

upvoted 0 times

...

Sue

9 months 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.

upvoted 0 times

...

Phuong

9 months 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.

upvoted 0 times

...

Novella

9 months ago

Okay, let's see. I know the REST API supports GET and POST commands, but I'm not sure about PUT or ROLLBACK.

upvoted 0 times

...

Mendy

9 months ago

Hmm, this one looks tricky. I'll need to think carefully about the Snowflake SQL REST API capabilities.

upvoted 0 times

...

Shawnna

9 months 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.

upvoted 0 times

...

Angelica

9 months 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.

upvoted 0 times

...

Margret

10 months 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.

upvoted 0 times

...

Belen

10 months 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.

upvoted 0 times

...

Charlena

2 years ago

D and E were confusing. Multiple SQL statements in one call seemed unlikely.

upvoted 0 times

...

Pamella

2 years ago

ROLLBACK caught my attention, but I wasn't sure.

upvoted 0 times

...

Sarina

2 years ago

Yes, GET is definitely one of them. PUT seems logical too for uploading data.

upvoted 0 times

...

Noe

2 years ago

I agree. GET is used for retrieving data, right?

upvoted 0 times

...

Rebbeca

2 years ago

Kind of. I think GET and PUT are definitely in.

upvoted 0 times

...

Shawna

2 years ago

Did anyone find the Snowflake SQL REST API question tricky?

upvoted 0 times

...

Beula

2 years ago

B) The use of a PUT command

upvoted 0 times

...

Paris

2 years ago

A) The use of a GET command

upvoted 0 times

...