Which view shows the column lineage within an account?
Answer(s): A
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?
Answer(s): D
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?
Answer(s): C
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?
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?
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.)
Answer(s): A,E
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?
Answer(s): B
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.)
Answer(s): B,D
Snowflake supports multi-factor authentication using authenticator applications and passkeys, both of which provide secure second-factor authentication mechanisms.
Post your Comments and Discuss Snowflake SnowPro Core COF-C03 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the SnowPro Core COF-C03 content, but please register or login to continue.