What is the purpose of a row-level security policy in Snowflake?

To limit the number of rows returned by a query for performance.

To restrict which rows a user can see in a query result.

To restrict which columns a user can see in a query result.

To encrypt rows in the table at rest.

In the context of Snowflake governance, what does the principle of 'least privilege' primarily aim to achieve?

Grant users only the minimum privileges necessary to perform their job functions.

Grant users the ability to access all data for maximum productivity.

Grant all users the same level of access to simplify administration.

Grant users privileges based on their seniority in the organization.

A company is required by its security policy to encrypt all data in transit between its on-premises BI tool and Snowflake. The BI tool connects to Snowflake using the ODBC driver. What should the security engineer configure to ensure that the connection is encrypted?

Use a private connectivity option like AWS PrivateLink to encrypt the connection.

Enable TLS on the BI tool's connection settings and ensure that the ODBC driver is configured to use TLS.

Enable Snowflake's encryption feature in the account settings to encrypt all client connections.

Use a VPN between the BI tool and Snowflake to encrypt the traffic.

Which Snowflake view provides information about query history for auditing purposes?

INFORMATION_SCHEMA.QUERY_HISTORY

Snowflake SnowPro Advanced:Security Engineer

Domain 1Objective 1

Design and Enforce Data Protection, Privacy, and Governance Across Snowflake SNOWPRO-ADVANCED-SECURITY-ENGINEER Practice Questions (Page 6)

Part of the Data Protection, Privacy, and Governance domain, which makes up ~17% of our current practice bank.

30questions here

6free pages

12concepts

Questions 26–30

26foundation · easy
What is the purpose of a row-level security policy in Snowflake?
Select an answer first
27foundation · easy
In the context of Snowflake governance, what does the principle of 'least privilege' primarily aim to achieve?
Select an answer first
28application · medium
A company is required by its security policy to encrypt all data in transit between its on-premises BI tool and Snowflake. The BI tool connects to Snowflake using the ODBC driver. What should the security engineer configure to ensure that the connection is encrypted?
Select an answer first
29foundation · easy
Which Snowflake object is used to implement row-level security?
Select an answer first
30foundation · easy
Which Snowflake view provides information about query history for auditing purposes?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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.