Snowflake SnowPro Core Practice Test - Questions Answers, Page 39
List of questions
Question 381

Which function unloads data from a relational table to JSON?
Question 382

Which commands can only be executed using SnowSQL? (Select TWO).
Question 383

What is the relationship between a Query Profile and a virtual warehouse?
Question 384

What is the primary purpose of a directory table in Snowflake?
Question 385

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).
Question 386

Which commands are restricted in owner's rights stored procedures? (Select TWO).
Question 387

Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?
Question 388

Which privilege must be granted by one role to another role, and cannot be revoked?
Question 389

How can performance be optimized for a query that returns a small amount of data from a very large base table?
Question 390

What does the LATERAL modifier for the FLATTEN function do?
Question