Snowflake ADA-C01 Practice Test : Free Online Preparation

Question 1
- What are characteristics of Dynamic Data Masking? (Select TWO).
  
  A : A masking policy that is currently set on a table can be dropped.
  
  B : A single masking policy can be applied to columns in different tables.
  
  C : A masking policy can be applied to the VALUE column of an external table.
  
  D : The role that creates the masking policy will always see unmasked data in query results.
  
  E : A single masking policy can be applied to columns with different data types.
  
  Answer: B,E
Question 2
- Select true statement with respect to API Integration..
  
  A : Your Snowflake account can have multiple API integration objects
  
  B : Only Snowflake roles with OWNERSHIP or USAGE privileges on the API integration can use the API integration directly
  
  C : Multiple external functions can use the same API integration object, and thus the same HTTPS proxy service
  
  D : An API integration object is tied to a specific cloud platform account and role within that account.
  
  Answer: A,B,C,D
Question 3
- 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 (),
  FROM TABLE (RESULT_SCAN (LAST_QUERY_ID(1) ) ) ;
  
  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 (),
  OBJECT CONSTRUCT (*)
  FROM TABLE (RESULT_SCAN (LAST_QUERY_ID ()));
  
  D : 1. SHOW WAREHOUSES;
  2. INSERT INTO VWH META
  SELECT CURRENT TIMESTAMP (), *
  FROM TABLE (RESULT_SCAN (SELECT
  LAST QUERY ID(-1)));
  
  Answer: C
Question 4
- What are characteristics of data replication in Snowflake? (Select THREE).
  
  A :
  The ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command must be issued from the primary account.
  
  B : Users must be granted REPLICATIONADMIN privileges in order to enable replication.
  
  C :
  To start replication run the ALTER DATABASE ... REFRESH command on the account where the secondary database resides.
  
  D : Replication can only occur within the same cloud provider.
  
  E : Databases created from shares can be replicated.
  
  F :
  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.
  
  Answer: A,E,F
Question 5
- If the Account Administrator granted global CREATE DATA EXCHANGE LISTING privilege to a role, the role can be used to perform which of the following tasks?
  
  A : Reject listing requests
  
  B : Submit listings for approval/publishing listings
  
  C : Create and view provider profiles
  
  D : Modify listings properties
  
  Answer: A,B,C,D

Free Snowflake ADA-C01 Exam Questions

Try our Free Demo Practice Tests for Comprehensive ADA-C01 Exam Preparation