A retail company has a frequently queried dashboard that aggregates daily sales by product category from a large transactional table. The dashboard queries are slow and the team wants to improve performance without changing the dashboard's SQL. The underlying table is updated several times a day. Which approach should the team take?

Create a materialized view on the aggregation query and let Snowflake maintain it automatically.

Create a secure view on the aggregation query and grant the dashboard users access to it.

Create a recursive view on the aggregation query to handle the hierarchical product categories.

Create a standard view on the aggregation query and cluster the base table on the category column.

In a Snowflake SQL query, the FLATTEN function is used to expand a VARIANT column that contains an array of objects. What does the KEY column in the output of FLATTEN represent when the input is an array?

The data type of the array element

The name of the key for each object in the array

The index of the array element, starting at 0

What is the purpose of using multiple FLATTEN functions in a single query?

To control whether to flatten arrays or objects

To generate sequence numbers for each row

To flatten data from multiple levels of nesting

To include null values in the output

Snowflake SnowPro Advanced:Data Analyst

Domain 3Objective 3

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

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 86–90

86application · medium
A retail company has a frequently queried dashboard that aggregates daily sales by product category from a large transactional table. The dashboard queries are slow and the team wants to improve performance without changing the dashboard's SQL. The underlying table is updated several times a day. Which approach should the team take?
Select an answer first
87foundation · easy
In a Snowflake SQL query, the FLATTEN function is used to expand a VARIANT column that contains an array of objects. What does the KEY column in the output of FLATTEN represent when the input is an array?
Select an answer first
88foundation · easy
When using the FLATTEN function, which parameter specifies the expression that contains the semi-structured data to be flattened?
Select an answer first
89foundation · easy
What is the output of the TO_JSON function in Snowflake?
Select an answer first
90foundation · easy
What is the purpose of using multiple FLATTEN functions in a single query?
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.

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

Questions 86–90

In a Snowflake SQL query, the FLATTEN function is used to expand a VARIANT column that contains an array of objects. What does the KEY column in the output of FLATTEN represent when the input is an array?

When using the FLATTEN function, which parameter specifies the expression that contains the semi-structured data to be flattened?

What is the output of the TO_JSON function in Snowflake?

What is the purpose of using multiple FLATTEN functions in a single query?

Keep studying — Data Transformation and Data Modeling