Learn with Snowflake : ADA-C02 training material for 100% pass

What Snowflake capabilities are commonly used in rollback scenarios? (Choose two.)

• A. CREATE TABLE prd_table_bkp as SELECT * from table(result_scan('problematic_query_id'));
• B. ALTER TABLE prd_table SWAP WITH prd_table_bkp;
• C. Contact Snowflake Support to retrieve Fail-safe data.
• D. SELECT SYSTEM$CANCEL_QUERY('problematic_query_id');
• E. CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT => 'problematic_query_id');

Explanation: Only visible for Exam4Labs members. You can sign-up / login (it's free).

For Snowflake network policies, what will occur when the account level and user level network policies are both defined?

• A. The account_level policy will override the user_level policy.
• B. A network policy error will be generated with no definitions provided.
• C. The user_level policy will override the account_level policy.
• D. The user_level network policies will not be supported.

Explanation: Only visible for Exam4Labs members. You can sign-up / login (it's free).

A team of developers created a new schema for a new project. The developers are assigned the role DEV_TEAM which was set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE DEV_TEAM;
GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;
GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;
Each team member's access is set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE JDOE_PROFILE;
CREATE USER JDOE LOGIN_NAME = 'JDOE' DEFAULT ROLE='JDOE_PROFILE';
GRANT ROLE JDOE_PROFILE TO USER JDOE;
GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;
New tables created by any of the developers are not accessible by the team as a whole.
How can an Administrator address this problem?

• A. Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.
• B. Set up future grants on the newly-created schemas.
• C. Assign ownership privilege to DEV_TEAM on the newly-created schema.
• D. Set up the new schema as a managed-access schema.

Explanation: Only visible for Exam4Labs members. You can sign-up / login (it's free).

Which Snowflake objects can be managed using SCIM integration? (Choose two.)

• A. Stages
• B. Roles
• C. Warehouses
• D. Shares
• E. Users

Explanation: Only visible for Exam4Labs members. You can sign-up / login (it's free).

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

Explanation: Only visible for Exam4Labs members. You can sign-up / login (it's free).