ExamGecko
Search Search Login
Home Home / Snowflake / DSA-C02
Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

To return the contents of a DataFrame as a Pandas DataFrame, Which of the following method can be used in SnowPark API?
Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. What does the aggregate method shown in below code do? g = df.groupby(df.index.str.len()) g.aggregate({'A':len, 'B':np.sum})
Which one is not the feature engineering techniques used in ML data science world?
You are training a binary classification model to support admission approval decisions for a college degree program. How can you evaluate if the model is fair, and doesn't discriminate based on ethnicity?
Which metric is not used for evaluating classification models?
Which type of Python UDFs let you define Python functions that receive batches of input rows as Pandas DataFrames and return batches of results as Pandas arrays or Series?
Which of the following is a Python-based web application framework for visualizing data and analyzing results in a more efficient and flexible way?
Which Python method can be used to Remove duplicates by Data scientist?
Which of the learning methodology applies conditional probability of all the variables with respec-tive the dependent variable?
Mark the incorrect statement regarding usage of Snowflake Stream & Tasks?

Question 57 - DSA-C02 discussion

Report
Export

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

A.
External functions return a value. The returned value can be a compound value, such as a VARIANT that contains JSON.
Answers
A.
External functions return a value. The returned value can be a compound value, such as a VARIANT that contains JSON.
B.
External functions can be overloaded.
Answers
B.
External functions can be overloaded.
C.
An external function can appear in any clause of a SQL statement in which other types of UDF can appear.
Answers
C.
An external function can appear in any clause of a SQL statement in which other types of UDF can appear.
D.
External functions can accept Model parameters.
Answers
D.
External functions can accept Model parameters.
Suggested answer: A, B, C, D

Explanation:

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

Show Answer
asked 23/09/2024
ABDOUL RAZAK TIENDREBEOGO
26 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms