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

Questions 11–15

1. 11foundation · easy

   Which of the following is an example of a data quality check?

   • ACreating a bar chart of sales by region
   • BVerifying that all email addresses contain an '@' symbol
   • CGranting SELECT privileges to a user
   • DMerging two tables on a common key
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A data engineering team has a nightly pipeline that loads sales data into a Snowflake table. Before the data is used for reporting, the analyst wants to ensure that the 'order_id' is unique, the 'order_date' is not in the future, and the 'total_amount' is greater than zero. What is the best way to implement these checks?

   • AAdd a CHECK constraint to the table to prevent invalid data from being inserted.
   • BCreate a task that runs after the load and raises an alert if any rows violate the rules.
   • CUse a SELECT query to count violations and manually review them each morning.
   • DRely on the source system to ensure data quality before loading.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which Snowflake function converts a string to a date?

   • ATO_CHAR
   • BTO_DATE
   • CCURRENT_DATE
   • DDATE_PART
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which approach is best for dealing with corrupt values in a dataset?

   • AReplacing all corrupt values with zeros
   • BInvestigating the source and correcting or removing the corrupt values
   • CIgnoring the corrupt values and proceeding with analysis
   • DDeleting the entire column containing corrupt values
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   What is the purpose of pivoting a table?

   • ATo remove duplicate rows from the table
   • BTo transform unique values from a column into multiple columns for easier analysis
   • CTo fill missing values with a default
   • DTo change the data type of a column
   Reveal Solution Discussion Select an answer first