What is the minimum Snowflake edition required to create a materialized view?
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
Which command is used to unload data from a Snowflake table into a file in a stage?
What is the default File Format used in the COPY command if one is not specified?
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
When is the result set cache no longer available? (Select TWO)
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
What SQL command would be used to view all roles that were granted to user.1?
Which data type can be used to store geospatial data in Snowflake?
What are the default Time Travel and Fail-safe retention periods for transient tables?
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
True or False: Fail-safe can be disabled within a Snowflake account.
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?
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?