Apply Analytic and Window Functions SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 6)

Questions 26–27

1. 26foundation · easy

   Which navigation function returns the value from the row immediately before the current row in the window?

   • ANTH_VALUE()
   • BLAG()
   • CLEAD()
   • DFIRST_VALUE()
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   What is the purpose of the PARTITION BY clause inside an OVER clause?

   • AIt filters rows before the analytic function is applied.
   • BIt limits the number of rows returned by the query.
   • CIt divides the result set into groups to which the analytic function is applied independently.
   • DIt sorts the rows within each window.
   Reveal Solution Discussion Select an answer first