Snowflake DSA-C02 Exam - 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?

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

BExternal functions can be overloaded.

CAn external function can appear in any clause of a SQL statement in which other types of UDF can appear.

DExternal functions can accept Model parameters.

Show Suggested 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).

by Reid at Sep 19, 2024, 01:45 AM

Limited Time Offer

25%

Off

Get Premium DSA-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Casie

3 months ago

Wait, can external functions really return compound values? That seems odd!

upvoted 0 times

...

Florencia

3 months ago

D is correct, external functions can take model parameters for sure!

upvoted 0 times

...

Kristofer

3 months ago

C is a bit tricky, I thought there were restrictions.

upvoted 0 times

...

Kimbery

4 months ago

B sounds right, I've overloaded functions in other contexts.

upvoted 0 times

...

Ming

4 months ago

A is definitely true, I've used it before!

upvoted 0 times

...

Christoper

4 months ago

I feel like D might be true since models often have parameters, but I can't remember if external functions specifically accept them.

upvoted 0 times

...

Sueann

4 months ago

I practiced a similar question, and I think C is right because external functions should work like other UDFs in SQL statements.

upvoted 0 times

...

Moon

5 months ago

I'm not entirely sure about the overload thing in B; it seems familiar, but I can't recall if it's specific to external functions.

upvoted 0 times

...

Arlette

5 months ago

I remember that external functions can return complex values like JSON, so I think A is correct.

upvoted 0 times

...

Kanisha

5 months ago

Ah, I remember learning about external functions in Snowflake. I'm pretty confident I can identify the right rules here. I'll make sure to read each option closely before selecting the correct ones.

upvoted 0 times

...

Heike

5 months ago

Okay, let's see. I know external functions can return compound values, and they can be overloaded. But I'm not sure about the other options - I'll have to think through each one carefully.

upvoted 0 times

...

Svetlana

5 months ago

Hmm, I'm a little unsure about the differences between external functions and other types of UDFs. I'll need to review the details on how external functions work in Snowflake.

upvoted 0 times

...

Madelyn

5 months ago

This question seems pretty straightforward. I'm confident I can identify the correct rules for using an external function in Snowflake.

upvoted 0 times

...

Sommer

1 year 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

Coleen

1 year ago

C) An external function can appear in any clause of a SQL statement in which other types of UDF can appear.

upvoted 0 times

...

Sherell

1 year ago

B) External functions can be overloaded.

upvoted 0 times

...

Cherelle

1 year 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

...

Yuki

1 year 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

Charlette

1 year ago

C) An external function can appear in any clause of a SQL statement in which other types of UDF can appear.

upvoted 0 times

...

Rupert

1 year ago

B) External functions can be overloaded.

upvoted 0 times

...

Pauline

1 year 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

...

Gussie

1 year 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

1 year ago

I agree with Erick. External functions can return a value, be overloaded, and accept Model parameters.

upvoted 0 times

...

Domingo

1 year 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

1 year ago

D) External functions can accept Model parameters.

upvoted 0 times

...

Jovita

1 year ago

C) An external function can appear in any clause of a SQL statement in which other types of UDF can appear.

upvoted 0 times

...

Jovita

1 year ago

B) External functions can be overloaded.

upvoted 0 times

...

Jovita

1 year 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 year 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

1 year ago

Yes, those rules are important to keep in mind when using external functions.

upvoted 0 times

...

Justine

1 year ago

I agree, A, C, and D are the correct rules to follow.

upvoted 0 times

...

Erick

1 year ago

I think the correct rules are A, B, and D.

upvoted 0 times

...

Samira

1 year ago

B is definitely a rule too. I remember reading about that in the Snowflake docs.

upvoted 0 times

...