Free Snowflake DSA-C02 Exam Dumps Questions & Answers

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?

• A.  Scaler Python UDFs
• B.  MPP Python UDFs
• C.  Hybrid Python UDFs
• D.  Vectorized Python UDFs

Data Scientist can query, process, and transform data in a which of the following ways using Snowpark Python. [Select 2]

• A.  Query and process data with a DataFrame object.
• B.  Write a user-defined tabular function (UDTF) that processes data and returns data in a set of rows with one or more columns.
• C.  SnowPark currently do not support writing UDTF.
• D.  Transform Data using DataIKY tool with SnowPark API.

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

• A.  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.
• B.  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)
• C.  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.
• D.  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.

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

• A.  snowpark.ml.modeling
• B.  snowflake.sklearn.modeling
• C.  snowflake.ml.modeling
• D.  snowflake.scikit.modeling

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.  The data type of the returned value is the same as the data type of the input values
• C.  NULL values are skipped unless all the records are NULL
• D.  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