Work with Views and Semi-Structured Data SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 22)

Questions 106–110

1. 106foundation · easy

   Which FLATTEN parameter controls whether the function returns rows for empty arrays and objects?

   • AOUTER
   • BMODE
   • CRECURSIVE
   • DINPUT
   Reveal Solution Discussion Select an answer first
2. 107foundation · easy

   A VARIANT column contains both arrays and objects at different positions. Which MODE value should be used with FLATTEN to expand every element of the arrays AND every key-value pair of the objects in a single call?

   • AALL
   • BARRAY
   • COBJECT
   • DBOTH
   Reveal Solution Discussion Select an answer first
4. 108foundation · easy

   Which clause is used to query data before a specific timestamp in Snowflake?

   • ASAMPLE
   • BBEFORE
   • CAT
   • DTIMESTAMP
   Reveal Solution Discussion Select an answer first
5. 109expert · hard

   A data analyst runs a query that uses FLATTEN to extract data from a VARIANT column. The query succeeds, but the analyst needs to reference the results of this query in a subsequent query without re-running the FLATTEN logic. The analyst wants to use the RESULT_SCAN function. Which statement is correct?

   • AThe analyst can use RESULT_SCAN without a query ID, and it will automatically reference the last query.
   • BThe analyst can use RESULT_SCAN only if the first query was a SELECT statement.
   • CThe analyst must use RESULT_SCAN in the same session and it will reference the last query by default.
   • DThe analyst must capture the query ID from the first query and use it in RESULT_SCAN.
   Reveal Solution Discussion Select an answer first
6. 110foundation · easy

   Which of the following is a common use case for the FLATTEN function?

   • AParsing a JSON string into a VARIANT
   • BUnnesting an array of objects into individual rows
   • CCreating a secure view
   • DConverting a VARIANT to a JSON string
   Reveal Solution Discussion Select an answer first