What does the RECURSIVE parameter do in the FLATTEN function?

It recursively flattens nested arrays and objects

It includes rows with null values

It controls whether to flatten arrays or objects

It flattens only the top level of the data

What does FLATTEN do when applied to an object in Snowflake?

It converts the object to a JSON string

It returns the object as a single row

It produces one row per key-value pair

It returns the object as a single column

What is a known performance implication of using SECURE VIEWS in Snowflake?

They may have slower query performance due to additional security checks

They always improve query performance compared to standard views

They require manual refreshing to maintain performance

They consume additional storage space for data caching

In a Snowflake SQL query, what is the effect of specifying RECURSIVE => TRUE in the FLATTEN function?

It returns the input as a single row with all nested elements concatenated into one string.

It expands nested arrays and objects recursively, producing rows for every level of nesting.

It reverses the order of array elements before flattening them.

It flattens only the top-level array elements, ignoring nested arrays.

An HR team needs to query an employee table to find all direct and indirect reports for a given manager. The employee table has columns for employee_id and manager_id. The team wants to create a reusable object that can be queried with a simple SELECT statement. Which approach should the team use?

Create a recursive view that uses a UNION ALL to traverse the employee-manager hierarchy.

Create a secure view that uses a window function to calculate the hierarchy level.

Create a materialized view that pre-computes the entire hierarchy.

Create a standard view that joins the employee table to itself once.

Snowflake SnowPro Advanced:Data Analyst

Domain 3Objective 3

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

Part of the Data Transformation and Data Modeling domain, which accounts for 23% of the SNOWPRO-ADVANCED-DATA-ANALYST exam.

116questions here

24free pages

47concepts

23%of the exam

47 Concepts in This Objective

Create and manage views
Use secure views
Use materialized views
Work with recursive views
Parse semi-structured data
Query semi-structured data
Use the FLATTEN function
Use the LATERAL flatten technique
Handle nested data structures
Convert between structured and semi-structured data
Use the GET_PATH and similar functions
Use the ARRAY and OBJECT functions
Use the PARSE_JSON and TO_JSON functions
Use the AS_OF and AT timestamp functions
Use the SAMPLE clause
Use the RESULT_SCAN function
Use the TABLE function
Use the GET_PATH function with arrays
Use the FLATTEN function with arrays
Use the FLATTEN function with objects
Use the FLATTEN function with nested structures
Use the FLATTEN function with multiple paths
Use the FLATTEN function with lateral joins
Use the FLATTEN function with the OUTER parameter
Use the FLATTEN function with the MODE parameter
Use the FLATTEN function with the INPUT parameter
Use the FLATTEN function with the PATH parameter
Use the FLATTEN function with the SEQ parameter
Use the FLATTEN function with the KEY parameter
Use the FLATTEN function with the VALUE parameter
Use the FLATTEN function with the THIS parameter
Use the FLATTEN function with the RECURSIVE parameter
Use the FLATTEN function with the OUTER and RECURSIVE parameters
Use the FLATTEN function with the MODE and RECURSIVE parameters
Use the FLATTEN function with the INPUT and PATH parameters
Use the FLATTEN function with the SEQ and KEY parameters
Use the FLATTEN function with the VALUE and THIS parameters
Use the FLATTEN function with the OUTER and MODE parameters
Use the FLATTEN function with the RECURSIVE and OUTER parameters
Use the FLATTEN function with the RECURSIVE and MODE parameters
Use the FLATTEN function with the RECURSIVE, OUTER, and MODE parameters
Use the FLATTEN function with the RECURSIVE, OUTER, MODE, and INPUT parameters
Use the FLATTEN function with the RECURSIVE, OUTER, MODE, INPUT, and PATH parameters
Use the FLATTEN function with the RECURSIVE, OUTER, MODE, INPUT, PATH, and SEQ parameters
Use the FLATTEN function with the RECURSIVE, OUTER, MODE, INPUT, PATH, SEQ, and KEY parameters
Use the FLATTEN function with the RECURSIVE, OUTER, MODE, INPUT, PATH, SEQ, KEY, and VALUE parameters
Use the FLATTEN function with the RECURSIVE, OUTER, MODE, INPUT, PATH, SEQ, KEY, VALUE, and THIS parameters

Questions 71–75

71foundation · easy
What does the RECURSIVE parameter do in the FLATTEN function?
Select an answer first
72foundation · easy
What does FLATTEN do when applied to an object in Snowflake?
Select an answer first
73foundation · easy
What is a known performance implication of using SECURE VIEWS in Snowflake?
Select an answer first
74foundation · easy
In a Snowflake SQL query, what is the effect of specifying RECURSIVE => TRUE in the FLATTEN function?
Select an answer first
75application · medium
An HR team needs to query an employee table to find all direct and indirect reports for a given manager. The employee table has columns for employee_id and manager_id. The team wants to create a reusable object that can be queried with a simple SELECT statement. Which approach should the team use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SNOWPRO-ADVANCED-DATA-ANALYST

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “SNOWPRO-ADVANCED-DATA-ANALYST” is a trademark of its owner, used for identification only.