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

Questions 1–5

1. 1expert · hard

   A marketing analyst merges two customer lists from different CRM exports into a single table. The 'customer_name' column has inconsistent formatting (e.g., 'John Smith' vs 'smith, john') and the 'email' column is the only reliable unique identifier. After merging, the analyst suspects some customers appear twice with slightly different email spellings (e.g., 'john.smith@email.com' vs 'johnsmith@email.com'). What is the most appropriate deduplication strategy?

   • AUse fuzzy matching on customer_name only, since email is unreliable.
   • BUse exact matching on the email column and remove all duplicate email addresses.
   • CNormalize emails by removing periods and standardizing the domain, then use exact matching on the normalized value.
   • DManually review all rows where the customer_name is similar, regardless of email.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which Snowflake function removes leading and trailing spaces from a string?

   • ALENGTH
   • BSUBSTR
   • CREPLACE
   • DTRIM
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Why is it important to convert a column from string to numeric before performing arithmetic operations?

   • ABecause numeric columns are always more efficient than string columns
   • BBecause string columns cannot be used in WHERE clauses
   • CBecause arithmetic operations on strings may produce unexpected results or errors
   • DBecause strings cannot be stored in Snowflake tables
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is one-hot encoding used for?

   • AReplacing missing values with the mode
   • BConverting numeric variables into categorical bins
   • CConverting categorical variables into binary columns for each category
   • DScaling numeric values to a 0-1 range
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which of the following is an example of feature engineering?

   • ARenaming a column from 'cust_id' to 'customer_id'
   • BSorting the dataset by date
   • CRemoving duplicate rows from a dataset
   • DCreating a new column 'age' from a 'birthdate' column
   Reveal Solution Discussion Select an answer first