Question 51
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Question 52
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?
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?
Question 53
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
Question 54
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?
Question 55
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
