nerdexam
Snowflake

ADA-C01 · Question #47

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?

The correct answer is C. CREATE NETWORK POLICY ADMIN_POLICY. Option C creates a network policy that allows only the IP address 192.168.1.100 and blocks all other IP addresses using the CIDR notation 0.0.0.0/01. It then applies the network policy to the user ABC, who has the ACCOUNTADMIN role. This ensures that only this user can access…

Account Management and Security

Question

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?

Options

  • ACREATE NETWORK POLICY ADMIN_POLICY
  • BCREATE NETWORK POLICY ADMIN POLICY
  • CCREATE NETWORK POLICY ADMIN_POLICY
  • DCREATE OR REPLACE NETWORK POLICY ADMIN_POLICY

How the community answered

(45 responses)
  • A
    9% (4)
  • B
    2% (1)
  • C
    84% (38)
  • D
    4% (2)

Explanation

Option C creates a network policy that allows only the IP address 192.168.1.100 and blocks all other IP addresses using the CIDR notation 0.0.0.0/01. It then applies the network policy to the user ABC, who has the ACCOUNTADMIN role. This ensures that only this user can access the Snowflake account from the specified IP address, while blocking their access from anywhere

Topics

#network policy#IP allowlist#access control#DDL syntax

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice