A security auditor is verifying that a new row-level security policy is working correctly. They want to ensure that users in the `SALES` role can only see rows where the region matches their own. Which approach would provide the most direct verification?

Query the ACCESS_HISTORY to see which rows were accessed by users in the SALES role.

Review the POLICY_REFERENCES view to confirm the policy is attached to the table.

Check the GRANTS_TO_ROLES to ensure the SALES role has the necessary privileges.

Execute a query as a user in the SALES role and compare the results with the expected rows.

A security engineer wants to verify that access control policies are correctly applied to a specific table. Which Snowflake view provides a comprehensive record of all privileges granted on objects?

INFORMATION_SCHEMA.TABLE_PRIVILEGES

ACCOUNT_USAGE.OBJECT_PRIVILEGES

A financial institution must provide a report to auditors showing all access to customer data, including the specific rows and columns accessed, for the past year. They also need to show which queries were executed by which users. Which combination of views would provide the most comprehensive evidence?

ACCESS_HISTORY and QUERY_HISTORY

QUERY_HISTORY and LOGIN_HISTORY

ACCESS_HISTORY and GRANTS_TO_USERS

A healthcare organization needs to prove to an auditor that only authorized personnel have accessed patient records. Which combination of Snowflake features would provide the most comprehensive evidence?

ACCESS_HISTORY and GRANTS_TO_USERS

QUERY_HISTORY and LOGIN_HISTORY

Snowflake SnowPro Advanced:Security Engineer

Domain 3Objective 1

Audit and Monitor Security Policies and Controls SNOWPRO-ADVANCED-SECURITY-ENGINEER Practice Questions (Page 1)

Part of the Security Auditing and Compliance domain, which makes up ~22% of our current practice bank.

21questions here

5free pages

5concepts

Questions 1–5

1expert · medium
A security auditor is verifying that a new row-level security policy is working correctly. They want to ensure that users in the `SALES` role can only see rows where the region matches their own. Which approach would provide the most direct verification?
Select an answer first
2foundation · easy
A security engineer wants to verify that access control policies are correctly applied to a specific table. Which Snowflake view provides a comprehensive record of all privileges granted on objects?
Select an answer first
3expert · medium
A financial institution must provide a report to auditors showing all access to customer data, including the specific rows and columns accessed, for the past year. They also need to show which queries were executed by which users. Which combination of views would provide the most comprehensive evidence?
Select an answer first
4foundation · easy
A security engineer needs to generate a compliance report demonstrating that only authorized users have accessed sensitive data. Which Snowflake view provides the necessary data access information for this report?
Select an answer first
5application · medium
A healthcare organization needs to prove to an auditor that only authorized personnel have accessed patient records. Which combination of Snowflake features would provide the most comprehensive evidence?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SNOWPRO-ADVANCED-SECURITY-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “SNOWPRO-ADVANCED-SECURITY-ENGINEER” is a trademark of its owner, used for identification only.

Audit and Monitor Security Policies and Controls SNOWPRO-ADVANCED-SECURITY-ENGINEER Practice Questions (Page 1)

Questions 1–5

A security auditor is verifying that a new row-level security policy is working correctly. They want to ensure that users in the `SALES` role can only see rows where the region matches their own. Which approach would provide the most direct verification?

A security engineer wants to verify that access control policies are correctly applied to a specific table. Which Snowflake view provides a comprehensive record of all privileges granted on objects?

A security engineer needs to generate a compliance report demonstrating that only authorized users have accessed sensitive data. Which Snowflake view provides the necessary data access information for this report?

A healthcare organization needs to prove to an auditor that only authorized personnel have accessed patient records. Which combination of Snowflake features would provide the most comprehensive evidence?

Keep studying — Security Auditing and Compliance