SnowPro Core Practice Test practice questions, page 49 of 54, with answer review and explanations.
Question 241
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
Snowflake leverages a Role-Based Access Control (RBAC) model.
Snowflake requires a user to configure an IAM user to connect to the database.
All data in Snowflake is encrypted.
Snowflake can run within a user's own Virtual Private Cloud (VPC).
All data in Snowflake is compressed.
Question 242
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?
4 minutes
10 minutes
14 minutes
24 minutes
Question 243
What can be used to view warehouse usage over time? (Choose two.)
The LOAD HISTORY view
The query history view
The SHOW WAREHOUSES command
The WAREHOUSE_METERING_HISTORY view
The billing and usage tab in the Snowflake web UI
Question 244
What actions will prevent leveraging of the ResultSet cache? (Choose two.)
Removing a column from the query SELECT list
Stopping the virtual warehouse that the query is running against
Clustering of the data used by the query
Executing the RESULTS_SCAN() table function
Changing a column that is not in the cached query
Question 245
Which statement is true about running tasks in Snowflake?
A task can be called using a CALL statement to run a set of predefined SQL commands.
A task allows a user to execute a single SQL statement/command using a predefined schedule.
A task allows a user to execute a set of SQL commands on a predefined schedule.
A task can be executed using a SELECT statement to run a predefined SQL command.