DSA-C02試験無料問題集（67題）「Snowflake SnowPro Advanced: Data Scientist Certification 認定」

出題：1

Which command manually triggers a single run of a scheduled task (either a standalone task or the root task in a DAG) independent of the schedule defined for the task?

A. RUN TASK

B. CALL TASK

C. EXECUTE TASK

D. RUN ROOT TASK

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

You previously trained a model using a training dataset. You want to detect any data drift in the new data collected since the model was trained.
What should you do?

A. Retrained your training dataset after correcting data outliers & no need to introduce new data.

B. Add the new data to the existing dataset and enable Application Insights for the service where the model is deployed.

C. Create a new version of the dataset using only the new data and retrain the model.

D. Create a new dataset using the new data and a timestamp column and create a data drift monitor that uses the training dataset as a baseline and the new dataset as a target.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

All Snowpark ML modeling and preprocessing classes are in the ________ namespace?

A. snowflake.sklearn.modeling

B. snowflake.scikit.modeling

C. snowflake.ml.modeling

D. snowpark.ml.modeling

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Data Scientist used streams in ELT (extract, load, transform) processes where new data inserted in-to a staging table is tracked by a stream. A set of SQL statements transform and insert the stream contents into a set of production tables. Raw data is coming in the JSON format, but for analysis he needs to transform it into relational columns in the production tables. which of the following Data transformation SQL function he can used to achieve the same?

A. Transpose()

B. lateral flatten()

C. He could not apply Transformation on Stream table data.

D. METADATA$ACTION ()

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

What is the risk with tuning hyper-parameters using a test dataset?

A. Model will overfit the test set

B. Model will perform balanced

C. Model will underfit the test set

D. Model will overfit the training set

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Mark the Incorrect statements regarding MIN / MAX Functions?

A. NULL values are ignored unless all the records are NULL, in which case a NULL value is returned

B. NULL values are skipped unless all the records are NULL

C. For compatibility with other systems, the DISTINCT keyword can be specified as an argument for MIN or MAX, but it does not have any effect

D. The data type of the returned value is the same as the data type of the input values

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

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

A. External functions can accept Model parameters.

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

C. External functions can be overloaded.

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

正解：A,B,C,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

DSA-C02試験無料問題集「Snowflake SnowPro Advanced: Data Scientist Certification 認定」