nerdexam
SnowflakeSnowflake

COF-C02 · Question #552

COF-C02 Question #552: Real Exam Question with Answer & Explanation

The correct answer is D: SHOW NETWORK POLICIES. To list all network policies available in an account, the correct command is SHOW NETWORK POLICIES. Network policies in Snowflake are used to define and enforce rules for how users can connect to Snowflake, including IP whitelisting and other connection requirements. The SHOW NET

Account Access and Security

Question

Which command can be used to list all network policies available in an account?

Options

  • ADESCRIBE SESSION POLICY
  • BDESCRIBE NETWORK POLICY
  • CSHOW SESSION POLICIES
  • DSHOW NETWORK POLICIES

Explanation

To list all network policies available in an account, the correct command is SHOW NETWORK POLICIES. Network policies in Snowflake are used to define and enforce rules for how users can connect to Snowflake, including IP whitelisting and other connection requirements. The SHOW NETWORK POLICIES command provides a list of all network policies defined within the account, along with their details. The DESCRIBE SESSION POLICY and DESCRIBE NETWORK POLICY commands do not exist in Snowflake SQL syntax. The SHOW SESSION POLICIES command is also incorrect, as it does not pertain to the correct naming convention used by Snowflake for network policy management. Using SHOW NETWORK POLICIES without any additional parameters will display all network policies in the account, which is useful for administrators to review and manage the security configurations pertaining to network access.

Topics

#Network Policies#Security#SHOW commands#Account Administration

Community Discussion

No community discussion yet for this question.

Full COF-C02 PracticeBrowse All COF-C02 Questions