Transform Data Using SQL and Snowpark DEA-C02 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   Which statement is true about Snowpark stored procedures?

   • AThey are created using the CREATE PROCEDURE statement.
   • BThey cannot return a result set.
   • CThey are executed automatically on a schedule.
   • DThey can only be written in SQL.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which SQL construct is used to conditionally return different values based on a series of boolean expressions, similar to an if-else chain?

   • ACASE
   • BJOIN
   • CCOALESCE
   • DUNION
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A data engineer needs to create a stored procedure that performs a multi-step transformation using Snowpark Python. The procedure will be called by a task. Which Snowflake command should the engineer use to create the procedure?

   • ACREATE TASK ... AS CALL ...
   • BCREATE FUNCTION ... LANGUAGE PYTHON ...
   • CCREATE STREAM ... ON TABLE ...
   • DCREATE PROCEDURE ... LANGUAGE PYTHON ...
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which practice is most likely to reduce shuffles in a Snowpark transformation job?

   • AUsing a larger warehouse
   • BAdding more columns to the DataFrame
   • CMinimizing the number of joins and aggregations
   • DUsing a materialized view
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which Snowflake feature is specifically designed to load and transform streaming data continuously?

   • AMaterialized views
   • BSnowpipe
   • CStreams and Tasks
   • DExternal tables
   Reveal Solution Discussion Select an answer first