ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 730 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 730
Topic #: 1
[All SnowPro Core Questions]

How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

  • A. A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.
  • B. A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
  • C. A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.
  • D. Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by MultiCloudIronMan at July 16, 2023, 10:09 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Rameez1
6 months ago
Selected Answer: B
Multiple UDFs may be called with one statement; A single stored procedure is called with one statement A single SQL statement can call multiple UDFs. A single SQL statement can call only one stored procedure.
upvoted 1 times
...
[Removed]
1 year, 2 months ago
Selected Answer: B
B is correct
upvoted 3 times
...
singhks
1 year, 4 months ago
Selected Answer: B
https://docs.snowflake.com/en/developer-guide/stored-procedures-vs-udfs Multiple UDFs May Be Called With One Statement; a Single Stored Procedure Is Called With One Statement
upvoted 2 times
JG1984
1 year, 3 months ago
It is true that a single executable statement can call multiple UDFs, but it is also possible to call multiple stored procedures in a single executable statement, as long as they are called in separate statements. CALL proc1(); CALL proc2(); so i think it can be option C
upvoted 1 times
...
...
Marcusbraga
1 year, 4 months ago
B : call proc1() call proc2() select udf1(), udf2() from table
upvoted 2 times
...
MultiCloudIronMan
1 year, 5 months ago
Selected Answer: B
https://alexandersks.medium.com/difference-between-stored-procedures-and-udfs-snowflake-9e5b93cdb081
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago