What is a characteristic of Snowflake's transaction locking and concurrency modeling?

• A. Queries executed within a given transaction see that transaction's uncommitted changes.
• B. Transaction locking in Snowflake is enforced exclusively at the row and table levels.
• C. A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.
• D. If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.

A Snowflake organization MYORG consists of two Snowflake accounts:
Account Name Snowflake Region Snowflake Edition
ACCOUNT1 AWS_EU_WEST_2 ENTERPRISE
ACCOUNT2 AZURE_WESTEUROPE STANDARD
The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled.
Management wants to have the PROD_DB database replicated to ACCOUNT2.
Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?

• A. USE ROLE ORGADMIN;
  SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('MYORG.ACCOUNT1','ENABLE_ACCOUNT_DATABASE_REPLICATION','TRUE');
  USE ROLE ACCOUNTADMIN;
  ALTER DATABASE PROD_DB ENABLE REPLICATION TO ACCOUNTS MYORG.ACCOUNT2 IGNORE EDITION CHECK;
• B. No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.
• C. It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.
• D. USE ROLE ORGADMIN;
  SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('MYORG.ACCOUNT1','ENABLE_ACCOUNT_DATABASE_REPLICATION','TRUE');
  SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('MYORG.ACCOUNT2','ENABLE_ACCOUNT_DATABASE_REPLICATION','TRUE');
  USE ROLE ACCOUNTADMIN;
  ALTER DATABASE PROD_DB ENABLE REPLICATION TO ACCOUNTS MYORG.ACCOUNT2;

A user with the proper role issues the following commands when setting up and activating network policies:
CREATE OR REPLACE NETWORK POLICY foo_policy
ALLOWED_IP_LIST = ('1.1.1.0/24', '2.2.2.0/24', '3.3.3.0/24')
BLOCKED_IP_LIST = ('1.1.1.1')
COMMENT = 'Account level policy';
ALTER ACCOUNT SET NETWORK_POLICY=foo_policy;
CREATE OR REPLACE NETWORK POLICY bar_policy
ALLOWED_IP_LIST = ('3.3.3.0/24')
BLOCKED_IP_LIST = ('3.3.3.10')
COMMENT = 'user level policy';
ALTER USER user1 SET NETWORK_POLICY=BAR_POLICY;
Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?

• A. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.
• B. No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.
• C. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.
• D. No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.

What are characteristics of data replication in Snowflake? (Choose three.)

• A. The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.
• B. Users can have unlimited primary databases and they can be replicated to an unlimited number of accounts if all accounts are within the same organization.
• C. Replication can only occur within the same cloud provider.
• D. Users must be granted REPLICATIONADMIN privileges in order to enable replication.
• E. To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.
• F. Databases created from shares can be replicated.