Free COF-C02 Exam Braindumps
SnowPro Core Questions 366–370 (page: 75)

Updated On: 10-Feb-2026

User-level network policies can be created by which of the following roles? (Choose two.)

  1. ROLEADMIN
  2. ACCOUNTADMIN
  3. SYSADMIN
  4. SECURITYADNIN
  5. USERADMIN

Answer(s): B,D



What SQL command would be used to view all roles that were granted to USER1?

  1. show grants to user USER1;
  2. show grants user USER1;
  3. describe user USER1;
  4. show grants on user USER1;

Answer(s): A



Which ACCOUNT_USAGE views are used to evaluate the details of dynamic data masking? (Choose two.)

  1. ROLES
  2. POLICY_REFERENCES
  3. QUERY_HISTORY
  4. RESOURCE_MONITORS
  5. ACCESS_HISTORY
  6. MASKING_POLICIES

Answer(s): B,F



Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

  1. A directory table is a separate database object.
  2. Directory tables store data file metadata.
  3. A directory table will be automatically added to a stage.
  4. Directory tables do not have their own grantable privileges.
  5. Directory table data can not be refreshed manually.

Answer(s): B,D



The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

  1. USERADMIN
  2. PUBLIC
  3. ORGADMIN
  4. SYSADMIN

Answer(s): A



Viewing page 75 of 221
Viewing questions 371 - 375 out of 1300 questions


Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!