ADA-C01 Exam: Absolutely Free Online Practice

Question 1
- Which one is not the Usage schema contained by SNOWFLAKE database?
  
  A : ORGANIZATION_USAGE
  
  B : READER_ACCOUNT_USAGE
  
  C : DATA_SHARING_USAGE
  
  D : CONSUMER_ACCOUNT_USAGE
  
  E : ACCOUNT_USAGE
  
  Answer: D
Question 2
- What access control policy will be put into place when future grants are assigned to both database and schema objects?
  
  A : Database privileges will take precedence over schema privileges.
  
  B : Schema privileges will take precedence over database privileges.
  
  C : An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.
  
  D : An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.
  
  Answer: B
Question 3
- For idP Setup in SnowFlake, Customers have option to choose which of the below setup providers type as of today?
  
  A : OKTA setup
  
  B : ADFS setup
  
  C : Custom IdP setup
  
  D : PingFederate setup
  
  E : KeyClock setup
  
  Answer: A,B,C
Question 4
- SQL to view the amount of replication data transferred (in bytes) for your Snowflake account within a specified date range can be queried using which of the Views/Table functions
  
  A : REPLICATION_USAGE_HISTORY table function (in the Snowflake Information Schema).
  
  B : REPLICATION_METERING_HISTORY View view (in Account Usage)
  
  C : REPLICATION_USAGE_HISTORY View view (in Account Usage)
  
  D : REPLICATION_METERING_HISTORY table function (in the Snowflake Information Schema)
  
  Answer: A,C
Question 5
- 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 suspend
  on 120 percent do suspend_immediate;
  alter warehouse WH1 set resource_monitor = RM1;
  
  B : 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;
  
  C : 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;
  
  D : 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;
  
  Answer: B

Free Snowflake ADA-C01 Exam Questions

Absolute Free ADA-C01 Exam Practice for Comprehensive Preparation