Mark the correct steps for saving the contents of a DataFrame to a Snowflake table as part of Moving Data from Spark to Snowflake?

Step 1.Use the write() method of the DataFrame to construct a DataFrameWriter. Step 2.Specify SNOWFLAKE_SOURCE_NAME using the format() method. Step 3.Specify the connector options using either the option() or options() method. Step 4.Use the dbtable option to specify the table to which data is written. Step 5.Use the mode() method to specify the save mode for the content. (Correct)

Step 1.Use the PUT() method of the DataFrame to construct a DataFrameWriter. Step 2.Specify SNOWFLAKE_SOURCE_NAME using the NAME() method. Step 3.Use the dbtable option to specify the table to which data is written. Step 4.Specify the connector options using either the option() or options() method. Step 5.Use the save() method to specify the save mode for the content.

Step 1.Use the PUT() method of the DataFrame to construct a DataFrameWriter. Step 2.Specify SNOWFLAKE_SOURCE_NAME using the format() method. Step 3.Specify the connector options using either the option() or options() method. Step 4.Use the dbtable option to specify the table to which data is written. Step 5.Use the save() method to specify the save mode for the content.

Step 1.Use the write() method of the DataFrame to construct a DataFrameWriter. Step 2.Specify SNOWFLAKE_SOURCE_NAME using the format() method. Step 3.Specify the connector options using either the option() or options() method. Step 4.Use the dbtable option to specify the table to which data is written. Step 5.Use the mode() method to specify the save mode for the content. (Correct)

Step 1.Use the writer() method of the DataFrame to construct a DataFrameWriter. Step 2.Specify SNOWFLAKE_SOURCE_NAME using the format() method. Step 3.Use the dbtable option to specify the table to which data is written. Step 4.Specify the connector options using either the option() or options() method. Step 5.Use the save() method to specify the save mode for the content.

Which ones are the known limitations of using External function?

Currently, external functions cannot be shared with data consumers via Secure Data Sharing.

Currently, external functions must be scalar functions. A scalar external function re-turns a single value for each input row.

External functions have more overhead than internal functions (both built-in functions and internal UDFs) and usually execute more slowly

An external function accessed through an AWS API Gateway private endpoint can be accessed only from a Snowflake VPC (Virtual Private Cloud) on AWS and in the same AWS region.

Currently, external functions cannot be shared with data consumers via Secure Data Sharing.

Currently, external functions must be scalar functions. A scalar external function re-turns a single value for each input row.

External functions have more overhead than internal functions (both built-in functions and internal UDFs) and usually execute more slowly

An external function accessed through an AWS API Gateway private endpoint can be accessed only from a Snowflake VPC (Virtual Private Cloud) on AWS and in the same AWS region.

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

Model will overfit the test set

Model will underfit the test set

Model will overfit the training set

How do you handle missing or corrupted data in a dataset?

Replace missing values with mean/median/mode

Assign a unique category to missing values

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

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

External functions can be overloaded.

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

External functions can accept Model parameters.

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

External functions can be overloaded.

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

External functions can accept Model parameters.

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?

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.

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

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

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

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?

Compare disparity between selection rates and performance metrics across ethnicities.

Evaluate each trained model with a validation dataset and use the model with the highest accuracy score.

Remove the ethnicity feature from the training dataset.

Compare disparity between selection rates and performance metrics across ethnicities.

Mark the incorrect statement regarding usage of Snowflake Stream & Tasks?

An standard-only stream tracks row inserts only.

Snowflake automatically resizes and scales the compute resources for serverless tasks.

Snowflake ensures only one instance of a task with a schedule (i.e. a standalone task or the root task in a DAG) is executed at a given time. If a task is still running when the next scheduled execution time occurs, then that scheduled time is skipped.

Streams support repeatable read isolation.

An standard-only stream tracks row inserts only.

Snowflake DSA-C02 Practice Test 2 - Free Online Exam Prep & Questions

Which of the following is a Python-based web application framework for visualizing data and analyzing results in a more efficient and flexible way?

Become a Premium Member for full access

Unlock Premium Member

Snowflake DSA-C02 Practice Test 2

Question

Snowflake DSA-C02 Practice Tests

Practice Tests