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

Questions 6–10

1. 6foundation · easy

   Which type of subquery returns a single value that can be used in a comparison condition?

   • AScalar subquery
   • BCorrelated subquery
   • CInline view
   • DTable subquery
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A customer table has a `phone` column stored as VARCHAR with inconsistent formats, e.g., '(555) 123-4567', '555.123.4567', and '5551234567'. The analyst needs to normalize these to a standard format of 10 digits with no separators for a downstream system. Which expression correctly normalizes the phone numbers?

   • AREGEXP_REPLACE(phone, '[^0-9]', '')
   • BREPLACE(phone, '-', '')
   • CSUBSTR(phone, 1, 10)
   • DTRANSLATE(phone, '()-', '')
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which of the following is a common technique used to transform data for analysis in Snowflake?

   • AUsing SHOW TABLES to list tables in a schema
   • BUsing CREATE DATABASE to organize data into separate databases
   • CUsing ALTER TABLE to add columns without changing data values
   • DUsing SELECT statements with functions and joins to reshape and enrich data
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which Snowflake function can be used to replace NULL values in a column with a specified default value?

   • AISNULL
   • BCAST
   • CCOALESCE
   • DNULLIF
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which SQL function would you use in Snowflake to convert a string value to a numeric data type?

   • ATO_NUMBER
   • BTO_VARCHAR
   • CTO_BOOLEAN
   • DTO_DATE
   Reveal Solution Discussion Select an answer first