How can a user improve the performance of a single large complex query in Snowflake?
A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
What can a Snowflake user do with the information included in the details section of a Query Profile?
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.