Free SnowPro Advanced: Data Scientist Certification Exam DSA-C02 Exam Practice Test

Which ones are the key actions in the data collection phase of Machine learning included?

• Label
• Ingest and Aggregate
• Probability
• Measure

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 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. C.
• 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 one is not the types of Feature Engineering Transformation?

• Scaling
• Encoding
• Aggregation
• Normalization

Which of the following is a common evaluation metric for binary classification?

• Accuracy
• F1 score
• Mean squared error (MSE)
• Area under the ROC curve (AUC)

Which of the Following is not type of Windows function in Snowflake?

• Rank-related functions.
• Window frame functions.
• Aggregation window functions.
• Association functions.

To return the contents of a DataFrame as a Pandas DataFrame, Which of the following method can be used in SnowPark API?

• REPLACE_TO_PANDAS
• SNOWPARK_TO_PANDAS
• CONVERT_TO_PANDAS
• TO_PANDAS

Secure Data Sharing do not let you share which of the following selected objects in a database in your account with other Snowflake accounts?

• Sequences
• Tables
• External tables
• Secure UDFs

Which of the following cross validation versions may not be suitable for very large datasets with hundreds of thousands of samples?

• k-fold cross-validation
• Leave-one-out cross-validation
• Holdout method
• All of the above

Which one is incorrect understanding about Providers of Direct share?

• A data provider is any Snowflake account that creates shares and makes them available to other Snowflake accounts to consume.
• As a data provider, you share a database with one or more Snowflake accounts.
• You can create as many shares as you want, and add as many accounts to a share as you want.
• If you want to provide a share to many accounts, you can do the same via Direct Share.

What is the formula for measuring skewness in a dataset?

• MEAN - MEDIAN
• MODE - MEDIAN
• (3(MEAN - MEDIAN))/ STANDARD DEVIATION
• (MEAN - MODE)/ STANDARD DEVIATION