Snowflake ADA-C01 SnowPro Advanced: Administrator Certification Exam Practice Test Questions

• Question 1

  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?

  • Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.
  • No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.
  • Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.
  • No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.

  Show Answer Answer: B Next

• Question 2

  What are the requirements when creating a new account within an organization in Snowflake? (Select TWO).

  • The account requires at least one ORGADMIN role within one of the organization's accounts.
  • The account name is immutable and cannot be changed.
  • The account name must be specified when the account is created.
  • The account name must be unique among all Snowflake customers.
  • The account name must be unique within the organization.

  Show Answer Answer: C,E Next

• Question 3

  A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Select TWO).

  • OPERATE
  • MODIFY
  • MONITOR
  • USAGE
  • OWNERSHIP

  Show Answer Answer: C,D Next

• Question 4

  An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it intodifferent production tables.How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

  • Create it as an external table, which will not incur Time Travel costs.
  • Create it as a transient table with a retention time of 0 days.
  • Create it as a temporary table with a retention time of 0 days.
  • Create it as a permanent table with a retention time of 0 days.

  Show Answer Answer: B Next

• Question 5

  Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

  • Reset a Snowflake user's password
  • Manage system grants
  • Create new users
  • Create new roles

  Show Answer Answer: B Next