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

9 months ago

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

upvoted 0 times

...

Markus

9 months ago

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

upvoted 0 times

...

Gilma

9 months ago

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

upvoted 0 times

...

Ronna

10 months ago

I think the PUT command is also allowed.

upvoted 0 times

...

Vonda

10 months ago

You can definitely use a GET command!

upvoted 0 times

...

Shonda

10 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

10 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

10 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

11 months ago

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

upvoted 0 times

...

Rosita

11 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

11 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

11 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

11 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

11 months ago

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

upvoted 0 times

...

Shawnna

11 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

11 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

11 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

11 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

...