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

6 months ago

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

upvoted 0 times

...

Markus

6 months ago

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

upvoted 0 times

...

Gilma

6 months ago

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

upvoted 0 times

...

Ronna

7 months ago

I think the PUT command is also allowed.

upvoted 0 times

...

Vonda

7 months ago

You can definitely use a GET command!

upvoted 0 times

...

Shonda

7 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

7 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

7 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

8 months ago

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

upvoted 0 times

...

Rosita

8 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

8 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

8 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

8 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

8 months ago

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

upvoted 0 times

...

Shawnna

8 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

8 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

8 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

8 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

...