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

- Free Preparation Discussions

Snowflake Exam DSA-C02 Topic 2 Question 29 Discussion

Actual exam question for Snowflake's DSA-C02 exam
Question #: 29
Topic #: 2
[All DSA-C02 Questions]

Which ones are the correct rules while using a data science model created via External function in Snowflake?

Show Suggested Answer Hide Answer
Suggested Answer: A, B, C, D

From the perspective of a user running a SQL statement, an external function behaves like any other UDF . External functions follow these rules:

External functions return a value.

External functions can accept parameters.

An external function can appear in any clause of a SQL statement in which other types of UDF can appear. For example:

1. select my_external_function_2(column_1, column_2)

2. from table_1;

1. select col1

2. from table_1

3. where my_external_function_3(col2) < 0;

1. create view view1 (col1) as

2. select my_external_function_5(col1)

3. from table9;

An external function can be part of a more complex expression:

1. select upper(zipcode_to_city_external_function(zipcode))

2. from address_table;

The returned value can be a compound value, such as a VARIANT that contains JSON.

External functions can be overloaded; two different functions can have the same name but different signatures (different numbers or data types of input parameters).


Contribute your Thoughts:

Sommer
5 days ago
I'm just glad we don't have to worry about the 'Snowflake Abominable Snowman' rule. That would be a real nightmare to remember!
upvoted 0 times
...
Yuki
8 days ago
Wait, are external functions the ones that let you call Python or R code from SQL? If so, I bet they have some pretty crazy rules!
upvoted 0 times
...
Gussie
22 days ago
I'm not sure about C, but I think A, B, and D make sense for using a data science model in Snowflake.
upvoted 0 times
...
Jesusa
26 days ago
I agree with Erick. External functions can return a value, be overloaded, and accept Model parameters.
upvoted 0 times
...
Domingo
28 days ago
Hmm, I was sure that external functions couldn't accept model parameters. Looks like I need to review that part of the documentation again.
upvoted 0 times
Jovita
20 days ago
B) External functions can be overloaded.
upvoted 0 times
...
Jovita
21 days ago
A) External functions return a value. The returned value can be a compound value, such as a VARIANT that contains JSON.
upvoted 0 times
...
...
Edna
1 months ago
I think A, C, and D are the correct rules. External functions are really powerful, but we need to be careful with how we use them.
upvoted 0 times
Justine
25 days ago
Yes, those rules are important to keep in mind when using external functions.
upvoted 0 times
...
Justine
29 days ago
I agree, A, C, and D are the correct rules to follow.
upvoted 0 times
...
...
Erick
1 months ago
I think the correct rules are A, B, and D.
upvoted 0 times
...
Samira
1 months ago
B is definitely a rule too. I remember reading about that in the Snowflake docs.
upvoted 0 times
...

Save Cancel