Prepare and Clean Datasets SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 8)

Questions 36–40

1. 36foundation · easy

   What is the difference between a join and a concatenation (UNION) in SQL?

   • AA join requires identical column names, while concatenation does not
   • BA join is used for numeric data, while concatenation is used for text data
   • CA join combines columns from different tables based on a key, while a concatenation stacks rows from tables with the same columns
   • DA join stacks rows, while a concatenation combines columns
   Reveal Solution Discussion Select an answer first
2. 37foundation · easy

   Which of the following is an example of a data profiling task?

   • AScheduling a daily data load from an external source
   • BComputing the percentage of null values in each column
   • CSetting up role-based access control for a database
   • DCreating a machine learning model to predict customer churn
   Reveal Solution Discussion Select an answer first
4. 38foundation · easy

   Which function would you use to extract the domain name from an email address like 'user@example.com'?

   • ATRIM
   • BUPPER
   • CREPLACE
   • DSPLIT_PART
   Reveal Solution Discussion Select an answer first
5. 39application · medium

   A customer service team has a 'full_name' column with values like 'Dr. Jane A. Doe, PhD' and 'Mr. John Smith Jr.'. The analyst needs to extract the first name, last name, and title into separate columns for a mailing campaign. What is the most robust approach?

   • ACast the full_name to an ARRAY and select elements by position.
   • BManually split the string at the first and last space characters.
   • CUse a regular expression to parse the name components based on known title and suffix patterns.
   • DUse SPLIT_PART on the space character and take the first and last tokens.
   Reveal Solution Discussion Select an answer first
6. 40application · medium

   A sales analyst has a table with one row per product per month, containing columns: 'product_id', 'month', and 'revenue'. To create a report that shows each product as a row and each month as a column, what should the analyst do?

   • AUse the UNPIVOT function to transform the data.
   • BUse the PIVOT function to transform the month values into columns.
   • CUse a JOIN to combine the data with itself.
   • DUse a GROUP BY clause with a CASE statement for each month.
   Reveal Solution Discussion Select an answer first