Study with Snowflake : ADA-C02 Exam Torrent as your best preparation materials

When does auto-suspend occur for a multi-cluster virtual warehouse?

• A. Auto-suspend does not apply for multi-cluster warehouses.
• B. When the minimum number of clusters is running and there is no activity for the specified period of time.
• C. After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.
• D. When there has been no activity on any cluster for the specified period of time.

In general, the monthly billing for database replication is proportional to which variables? (Choose two.)

• A. The frequency of the secondary database refreshes from the primary database
• B. The frequency of changes to the primary database as a result of data loading or DML operations
• C. The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts
• D. The amount of table data in the primary database that changes as a result of data loading or DML operations
• E. The number and size of warehouses defined in the primary account

A company enabled replication between accounts and is ready to replicate data across regions in the same cloud service provider.
The primary database object is : PROD_AWS_EAST. Location : AWS_EAST
The secondary database object is : PROD_AWS_WEST. Location : AWS_WEST
What command and account location is needed to refresh the data?

• A. Location : AWS_WEST
  Command : ALTER DATABASE PROD_AWS_WEST REFRESH;
• B. Location : AWS_EAST
  Command : ALTER DATABASE PROD_AWS_WEST REFRESH;
• C. Location : AWS_WEST
  Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;
• D. Location : AWS_EAST
  Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;

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

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

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');
  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;
• B. 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;
• C. It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.
• D. No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.