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

Questions 61–65

1. 61foundation · easy

   Which FLATTEN parameter, when set to TRUE, causes the function to flatten all nested levels of a semi-structured input rather than only the first level?

   • AMODE
   • BINPUT
   • CRECURSIVE
   • DOUTER
   Reveal Solution Discussion Select an answer first
2. 62foundation · easy

   In a Snowflake query, you use FLATTEN to expand an array of objects. Which column in the FLATTEN output would you reference to access the value of the current object in the array?

   • AKEY
   • BINDEX
   • CTHIS
   • DVALUE
   Reveal Solution Discussion Select an answer first
4. 63foundation · easy

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

   • AAT
   • BBEFORE
   • CTIMESTAMP
   • DSAMPLE
   Reveal Solution Discussion Select an answer first
5. 64foundation · easy

   What does the SAMPLE clause do in a Snowflake query?

   • AIt returns the first N rows of a table
   • BIt returns rows in a specific order
   • CIt returns a random sample of rows from a table
   • DIt returns rows that match a specific condition
   Reveal Solution Discussion Select an answer first
6. 65foundation · easy

   Which statement correctly describes the KEY column returned by the FLATTEN function in Snowflake?

   • AIt always contains the index of the element in the input array.
   • BIt always contains the key name from the input object.
   • CIt contains the key name if the input is an object, or the index if the input is an array.
   • DIt contains the data type of the flattened element.
   Reveal Solution Discussion Select an answer first