<< Prev Question Next Question >>

Question 25/35

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?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (35q)
Question 1: An Administrator wants to delegate the administration of a c...
Question 2: A Snowflake Administrator is investigating why a query is no...
Question 3: An Administrator needs to create a sample of the table LINEI...
Question 4: What session parameter can be used to test the integrity of ...
Question 5: When adding secure views to a share in Snowflake, which func...
Question 6: How should an Administrator configure a Snowflake account to...
Question 7: A large international company with many operating regions re...
Question 8: A team is provisioning new lower environments from the produ...
Question 9: The following SQL command was executed: Use role SECURITYADM...
Question 10: A company enabled replication between accounts and is ready ...
Question 11: An Administrator has a table named SALES_DATA which needs so...
Question 12: An Administrator needs to implement an access control mechan...
Question 13: In which scenario will use of an external table simplify a d...
Question 14: The following commands were executed: Grant usage on databas...
Question 15: What Snowflake capabilities are commonly used in rollback sc...
Question 16: Which statement allows this user to access this Snowflake ac...
Question 17: A Snowflake Administrator needs to persist all virtual wareh...
Question 18: What access control policy will be put into place when futur...
Question 19: A company has implemented Snowflake replication between two ...
Question 20: When does auto-suspend occur for a multi-cluster virtual war...
Question 21: Which actions are considered breaking changes to data that i...
Question 22: An Administrator receives data from a Snowflake partner. The...
Question 23: A data provider wants to share data from multiple databases ...
Question 24: A virtual warehouse report_wh is configured with AUTO_RESUME...
Question 25: A user with the proper role issues the following commands wh...
Question 26: What are benefits of creating and maintaining resource monit...
Question 27: A company has many users in the role ANALYST who routinely q...
Question 28: In general, the monthly billing for database replication is ...
Question 29: A Snowflake user runs a complex SQL query on a dedicated vir...
Question 30: What are characteristics of data replication in Snowflake? (...
Question 31: What roles or security privileges will allow a consumer acco...
Question 32: Which Snowflake objects can be managed using SCIM integratio...
Question 33: A requirement has been identified to allow members of a corp...
Question 34: A Snowflake account is configured with SCIM provisioning for...
Question 35: A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) tha...