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

Questions 21–25

1. 21foundation · easy

   Which scenario would most likely require fuzzy matching for deduplication?

   • AA dataset where customer names are spelled inconsistently, e.g., 'Smyth' vs 'Smith'
   • BA dataset with no duplicate records at all
   • CA dataset where duplicates are exact copies of the same row
   • DA dataset where all records have a unique numeric ID
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   What is label encoding?

   • AAssigning a unique integer to each category of a categorical variable
   • BCreating binary columns for each category
   • CConverting categories to uppercase strings
   • DReplacing categories with their frequency counts
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   What does it mean to reshape data from wide format to long format?

   • AConverting multiple columns into key-value pairs, increasing the number of rows
   • BMerging two tables on a key
   • CSorting the data by a column
   • DConverting rows into columns, decreasing the number of rows
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   What is the purpose of normalizing numeric values (e.g., scaling to 0-1) in a dataset?

   • ATo make all columns have the same data type
   • BTo remove all outliers from the dataset
   • CTo bring all values to a common scale without distorting differences in ranges
   • DTo convert all values to integers for easier storage
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   What is the purpose of data validation rules?

   • ATo encrypt sensitive data in transit
   • BTo automatically correct all data errors without human review
   • CTo increase the speed of data loading
   • DTo ensure data meets required standards before analysis
   Reveal Solution Discussion Select an answer first