What is a characteristic of Snowflake's transaction locking and concurrency modeling?
A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.
If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.
Transaction locking in Snowflake is enforced exclusively at the row and table levels.
Queries executed within a given transaction see that transaction's uncommitted changes.
MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day. Which queries will allow the user to view the historical data that was in the table before this query was executed? (Select THREE).
SELECT * FROM my table WITH TIME_TRAVEL (OFFSET => -60*30);
SELECT * FROM my_table AT (TIMESTAMP => '2021-01-01 07:00:00' :: timestamp);
SELECT * FROM TIME_TRAVEL ('MY_TABLE', 2021-01-01 07:00:00);
SELECT * FROM my table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';
SELECT * FROM my_table AT (OFFSET => -60*30);
SELECT * FROM my_table BEFORE (STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');
What are benefits of creating and maintaining resource monitors in Snowflake? (Select THREE).
The cost of running a resource monitor is only 10% of a credit, per day of operation.
Multiple resource monitors can be applied to a single virtual warehouse.
Resource monitors add no additional load to virtual warehouse compute.
Multiple triggers can be configured across various virtual warehouse thresholds.
Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.
Resource monitors can be applied to more than one virtual warehouse.
What access control policy will be put into place when future grants are assigned to both database and schema objects?
Database privileges will take precedence over schema privileges.
Schema privileges will take precedence over database privileges.
An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.
An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.
When does auto-suspend occur for a multi-cluster virtual warehouse?
When there has been no activity on any cluster for the specified period of time.
After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.
When the minimum number of clusters is running and there is no activity for the specified period of time.
Auto-suspend does not apply for multi-cluster warehouses.
A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening. Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?
Alter the user and set MINS TO BYPASS MFA to a value that will disable MFA long enough for the user to log in.
Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.
Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.
A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database. For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?
To save costs on warehouse shutdowns and startups for different queries
To save costs by running the warehouse as little as possible
To keep the data cache warm to support good performance of similar queries
To keep the query result cache warm for good performance on repeated queries
What are benefits of using Snowflake organizations? (Select TWO).
Administrators can change Snowflake account editions on-demand based on need.
Administrators can monitor and understand usage across all accounts in the organization.
Administrators can simplify data movement across all accounts within the organization.
User administration is simplified across all accounts within the organization.
Administrators have the ability to create accounts in any available cloud provider or region.
In which scenario will use of an external table simplify a data pipeline?
When accessing a Snowflake table from a relational database
When accessing a Snowflake table from an external database within the same region
When continuously writing data from a Snowflake table to external storage
When accessing a Snowflake table that references data files located in cloud storage
What Snowflake capabilities are commonly used in rollback scenarios? (Select TWO).
SELECT SYSTEM$CANCEL_QUERY('problematic_query_id');
CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT => 'problematic_query_id');
CREATE TABLE prd_table_bkp AS SELECT * FROM TABLE(RESULT_SCAN('problematic_query_id'));
ALTER TABLE prd_table SWAP WITH prd_table_bkp;
Contact Snowflake Support to retrieve Fail-safe data.