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

Questions 11–15

1. 11foundation · easy

   Which SQL statement is used to create a view in Snowflake?

   • ACREATE SCHEMA
   • BCREATE INDEX
   • CCREATE TABLE
   • DCREATE VIEW
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   In Snowflake, which clause is used to filter groups after aggregation?

   • ALIMIT
   • BHAVING
   • CORDER BY
   • DWHERE
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A data engineer loads JSON event logs into a Snowflake table with a VARIANT column `event_data`. Each event has a nested field `event_data:user.details.email`. Some events have a missing email, stored as JSON null. The analyst needs to extract the email as a VARCHAR, returning a default value 'unknown@example.com' when missing. Which expression accomplishes this?

   • AIFNULL(event_data:user.details.email, 'unknown@example.com')
   • BCOALESCE(event_data:user.details.email::VARCHAR, 'unknown@example.com')
   • CTO_VARCHAR(event_data:user.details.email, 'unknown@example.com')
   • Devent_data:user.details.email::VARCHAR
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which Snowflake feature allows you to calculate a running total without collapsing rows into groups?

   • AHAVING
   • BWindow functions
   • CGROUP BY
   • DDISTINCT
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   What is the primary purpose of data transformation in a Snowflake data analysis workflow?

   • ATo convert raw data into a format that is more suitable for analysis and reporting
   • BTo encrypt data at rest and in transit
   • CTo permanently delete data that is no longer needed for analysis
   • DTo replicate data to another cloud region for disaster recovery
   Reveal Solution Discussion Select an answer first