NEW QUESTION 37
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

NEW QUESTION 38
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

NEW QUESTION 39
What is the minimum Snowflake edition that has column-level security enabled?

NEW QUESTION 40
Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

NEW QUESTION 41
What is the minimum Snowflake edition that provides data sharing?

NEW QUESTION 42
What type of query benefits the MOST from search optimization?

NEW QUESTION 43
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

NEW QUESTION 44
How often are the Account and Table master keys automatically rotated by Snowflake?

NEW QUESTION 45
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?

NEW QUESTION 46
What is the recommended compressed file size range for continuous data loads using Snowpipe?

NEW QUESTION 47
What is the recommended file sizing for data loading using Snowpipe?

NEW QUESTION 48
Which command is used to unload data from a Snowflake table into a file in a stage?

NEW QUESTION 49
The Snowflake Cloud Data Platform is described as having which of the following architectures?

NEW QUESTION 50
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

NEW QUESTION 51
Which services does the Snowflake Cloud Services layer manage? (Choose two.)

NEW QUESTION 52
Which command can be used to load data files into a Snowflake stage?

NEW QUESTION 53
What Snowflake role must be granted for a user to create and manage accounts?

NEW QUESTION 54
What is a best practice after creating a custom role?

NEW QUESTION 55
A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

NEW QUESTION 56
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

NEW QUESTION 57
Which formats are supported for unloading data from Snowflake? Choose 2 answers

NEW QUESTION 58
A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?

NEW QUESTION 59
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

NEW QUESTION 60
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?