Online Access Free ADA-C01 Practice Test

A data provider wants to share data from multiple databases with a data consumer account.
How can this be accomplished?

• A.The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.
• B.The data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.
• C.The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share
• D.The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.

A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema:
Table Name : VWH_META
Column 1 : SNAPSHOT_TIME TIMESTAMP_NTZ
Column 2 : CONFIG VARIANT
Which commands should be executed to persist the warehouse data at the time of execution in JSON format in the table VWH META?

• A.1. SHOW WAREHOUSES;
  2. INSERT INTO VWH_META
  SELECT CURRENT_TIMESTAMP (),
  OBJECT CONSTRUCT (*)
  FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ()));
• B.1. SHOW WAREHOUSES;
  2. INSERT INTO VWH META
  SELECT CURRENT TIMESTAMP (), *
  FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ())) ;
• C.1. SHOW WAREHOUSES;
  2. INSERT INTO VWH META
  SELECT CURRENT TIMESTAMP (),
  FROM TABLE (RESULT_SCAN (LAST_QUERY_ID(1) ) ) ;
• D.1. SHOW WAREHOUSES;
  2. INSERT INTO VWH META
  SELECT CURRENT TIMESTAMP (), *
  FROM TABLE (RESULT_SCAN (SELECT
  LAST QUERY ID(-1)));

For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?

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

An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perform the following tasks:
1. At 80% usage notify the account Administrators.
2. At 100% usage suspend the warehouse and notify the account Administrators.
3. At 120% stop all running executions, suspend the warehouse, and notify the account Administrators.
Which SQL command will meet these requirements?

• A.create or replace resource monitor RM1 with credit_quota=3000
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do notify and suspend
  on 120 percent do notify and suspend_immediate;
  alter warehouse WH1 set resource monitor = RM1;
• B.create or replace resource monitor RM1 with credit_quota=3000
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;
• C.create or replace resource monitor RM1 with credit_quota=3000
  frequency = yearly
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;
• D.create or replace resource monitor RM1 with credit_quota=3000
  frequency = yearly
  start_timestamp = '2022-01-01 00:00 CET'
  triggers on 80 percent do notify
  on 100 percent do suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource monitor = RM1;

What is required for stages, without credentials, to limit data exfiltration after a storage integration and associated stages are created?

• A.ALTER ACCOUNT my_account SET
  REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
  ALTER ACCOUNT my_account SET
  REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
  ALTER ACCOUNT my_account SET
  PREVENT_UNLOAD_TO_INLINE_URL = false;
• B.ALTER ACCOUNT my_account SET
  REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
  ALTER ACCOUNT my_account SET
  REQUIRE_STORAGE_INTEGRATION FOR STAGE_OPERATION = true;
  ALTER ACCOUNT my_account SET
  PREVENT_UNLOAD_TO_INLINE_URL = true;
• C.ALTER ACCOUNT my_account SET
  REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
  ALTER ACCOUNT my_account SET
  REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = true;
  ALTER ACCOUNT my_account SET
  PREVENT_UNLOAD_TO_INLINE_URL = false;
• D.ALTER ACCOUNT my_account SET
  REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
  ALTER ACCOUNT my_account SET
  REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
  ALTER ACCOUNT my_account SET
  PREVENT_UNLOAD_TO_INLINE_URL = true;