Transform Data for Analysis SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   What does the ELSE clause in a CASE expression do?

   • ASpecifies the value to return when no condition is true
   • BDefines an additional condition to evaluate
   • CTerminates the CASE expression
   • DConverts the result to a different data type
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which Snowflake SQL function extracts the year from a DATE or TIMESTAMP value?

   • AYEAR()
   • BTO_CHAR()
   • CEXTRACT()
   • DDATE_PART()
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which SQL technique is commonly used in Snowflake to remove duplicate rows from a dataset?

   • ALIMIT
   • BORDER BY
   • CSELECT DISTINCT
   • DGROUP BY
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   In Snowflake, what is a Common Table Expression (CTE)?

   • AA temporary result set defined within a query using the WITH clause
   • BA function that aggregates data
   • CA type of view that is stored in the database
   • DA permanent table that stores query results
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A business intelligence team frequently runs a query that joins `customers` and `orders`, calculates a `customer_lifetime_value` using SUM, and categorizes customers into 'High', 'Medium', or 'Low' value tiers. They want to encapsulate this logic so analysts can query it without rewriting the join and CASE logic each time. What should they create?

   • AA stored procedure that runs the query and returns results
   • BA UDF that returns a table
   • CA materialized table created with CREATE TABLE AS SELECT
   • DA view that encapsulates the join, aggregation, and CASE logic
   Reveal Solution Discussion Select an answer first