SnowPro Advanced Administrator
Last Update Nov 25, 2024
Total Questions : 72
To help you prepare for the ADA-C01 Snowflake exam, we are offering free ADA-C01 Snowflake exam questions. All you need to do is sign up, provide your details, and prepare with the free ADA-C01 practice questions. Once you have done that, you will have access to the entire pool of SnowPro Advanced Administrator ADA-C01 test questions which will help you better prepare for the exam. Additionally, you can also find a range of SnowPro Advanced Administrator resources online to help you better understand the topics covered on the exam, such as SnowPro Advanced Administrator ADA-C01 video tutorials, blogs, study guides, and more. Additionally, you can also practice with realistic Snowflake ADA-C01 exam simulations and get feedback on your progress. Finally, you can also share your progress with friends and family and get encouragement and support from them.
A user with the proper role issues the following commands when setting up and activating network policies:
CREATE OR REPLACE NETWORK POLICY foo_policy
ALLOWED_IP_LIST = ( '1.1.1.0/24', '2.2.2.0/24' , '3.3. 3. 0/24' )
BLOCKED IP LIST = ( '1.1.1.1')
COMMENT = 'Account level policy';
ALTER ACCOUNT SET NETWORK_POLICY=FOO_POLICY;
CREATE OR REPLACE NETWORK POLICY bar_policy
ALLOWED_IP_LIST = ('3.3.3.0/24')
BLOCKED IP LIST = ('3.3.3.10')
COMMENT = 'user level policy';
ALTER USER userl SET NETWORK_POLICY=BAR_POLICY;
Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?
If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?
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?
TESTED 25 Nov 2024
