Free Snowflake ADA-C01 Exam Dumps Questions & Answers

When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?

• A.CURRENT_ROLE
• B.CURRENT_CLIENT
• C.CURRENT ACCOUNT
• D.CURRENT_USER

Which statement allows this user to access this Snowflake account from a specific IP address (192.168.1.100) while blocking their access from anywhere else?

• A.CREATE NETWORK POLICY ADMIN_POLICY
  ALLOWED_IP_LIST = ('192.168.1.100');
  ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';
  User ABC is the only user with an ACCOUNTADMIN role.
• B.CREATE NETWORK POLICY ADMIN_POLICY
  ALLOWED IP LIST = ('192.168.1.100')
  BLOCKED_IP_LIST = ('0.0.0.0/0');
  ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';
• C.CREATE NETWORK POLICY ADMIN POLICY
  ALLOWED_IP_LIST = ('192.168.1.100');
  ALTER ROLE ACCOUNTADMIN SET NETWORK_POLICY = 'ADMIN_POLICY';
• D.CREATE OR REPLACE NETWORK POLICY ADMIN_POLICY
  ALLOWED_IP_LIST = ('192.168. 1. 100/0') ;
  ALTER USER ABC SET NETWORK_POLICY = 'ADMIN_POLICY';

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 EAST
  Command: ALTER DATABASE PROD_AWS_WEST REFRESH;
• B.Location : AWS_WEST
  Command : ALTER DATABASE PROD AWS WEST REFRESH;
• C.Location : AWS_EAST
  Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;
• D.Location : AWS_WEST
  Command : REFRESH DATABASE PROD_AWS WEST REFRESH;

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

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

A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows:
USE ROLE SECURITYADMIN;
CREATE ROLE ROLE_MANAGED_ACCESS;
GRANT ROLE ROLE_MANAGED_ACCESS TO ROLE SYSADMIN;
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE ROLE_MANAGED_ACCESS;
GRANT ALL privileges ON DATABASE WORK TO ROLE ROLE_MANAGED_ACCESS;
USE ROLE ROLE_MANAGED_ACCESS;
CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITH MANAGED ACCESS;
USE ROLE SECURITYADMIN;
GRANT SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA MANAGED ACCESS to ROLE_MANAGED_ACCESS; The Administrator now wants to disable the managed access on the schema.
How can this be accomplished?

• A.REVOKE SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA_MANAGED_ACCESS FROM ROLE_MANAGED_ACCESS; ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;
• B.USE ROLE ROLE MANAGED_ACCESS;
  DROP SCHEMA WORK. SCHEMA_MANAGED_ACCESS;
  CREATE SCHEMA SCHEMA_MANAGED_ACCESS;
  Then recreate all needed objects.
• C.ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;
• D.USE ROLE ROLE_MANAGED_ACCESS;
  DROP SCHEMA WORK. SCHEMA MANAGED_ACCESS;
  CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITHOUT MANAGED ACCESS;
  Then recreate all needed objects.