Free SnowPro Core COF-C03 Exam Braindumps
SnowPro Core COF-C03 Questions 25–32 (page: 5)

Updated On: 9-Apr-2026

Which view shows the column lineage within an account?

  1. ACCESS_HISTORY
  2. ALERT_HISTORY
  3. DATA_QUALITY_MONITORING_USAGE_HISTORY
  4. EXTERNAL_ACCESS_HISTORY

Answer(s): A

Explanation:

This view captures detailed query-level access information, including which columns were read and how data flows between objects, enabling analysis of column-level lineage within the account.



Which view or command provides the MOST detailed storage information for a table?

  1. SHOW TABLES
  2. DESC TABLE
  3. ACCOUNT_USAGE.STORAGE_USAGE
  4. ACCOUNT_USAGE.TABLE_STORAGE_METRICS

Answer(s): D

Explanation:

This view provides granular storage metrics at the table level, including details about active, time travel, and fail-safe storage, offering the most comprehensive insight into table storage usage.



What feature specifies which roles are allowed to see a particular record in a table?

  1. Dynamic Data Masking
  2. Secure Data Sharing
  3. Row access policy
  4. Object tagging

Answer(s): C

Explanation:

A row access policy enforces row-level security by defining conditions that determine which roles can view specific records in a table.



How can a user work with multiple assigned roles without the need to frequently switch roles?

  1. Use secondary roles and primary roles.
  2. Grant the user the ACCOUNTADMIN role.
  3. Grant the user the parent role of the roles that have been assigned.
  4. Create a new role and grant it to the user, then grant the existing roles to the new role.

Answer(s): A

Explanation:

Using secondary roles allows a user to activate multiple roles simultaneously, enabling access to objects granted to those roles without switching between them.



Which feature allows users to audit how sensitive data is being accessed over time?

  1. Column-level security
  2. Row-level security
  3. Tag-based masking policy
  4. Object tagging

Answer(s): D

Explanation:

Object tagging enables classification of sensitive data, and when combined with Snowflake's access tracking capabilities, it allows auditing and monitoring of how tagged sensitive data is accessed over time.



In a managed access schema, which role or privilege can grant permissions on schema objects to other roles? (Choose two.)

  1. The owner of the schema
  2. SYSADMIN
  3. ORGADMIN
  4. USERADMIN
  5. Roles with the MANAGE GRANTS privilege

Answer(s): A,E

Explanation:

In a managed access schema, only the schema owner and roles with the MANAGE GRANTS privilege are authorized to grant privileges on objects within the schema to other roles.



Departments A and B both need to access the same data, but sensitive information needs to be hidden from department B.

How should this be accomplished?

  1. Create and share a report with department B that does not contain the sensitive data.
  2. Set up a masking policy on the sensitive data.
  3. Build separate data marts and reports for each department.
  4. Restrict department B's access to columns with sensitive data.

Answer(s): B

Explanation:

A masking policy dynamically obfuscates sensitive data based on the querying role, allowing both departments to access the same dataset while ensuring sensitive information is hidden from unauthorized users.



Which methods for a second factor of authentication does Snowflake support? (Choose two.)

  1. Email codes
  2. Authenticator applications
  3. Social logins
  4. Passkeys
  5. Security questions

Answer(s): B,D

Explanation:

Snowflake supports multi-factor authentication using authenticator applications and passkeys, both of which provide secure second-factor authentication mechanisms.



Viewing page 5 of 14
Viewing questions 33 - 40 out of 100 questions


Post your Comments and Discuss Snowflake SnowPro Core COF-C03 exam prep with other Community members:

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