Answer: Dynamic Data Masking, Secure views

The question asks for two Snowflake features to restrict unauthorized access to PII. Dynamic Data Masking (A) is optimal as it masks sensitive data in query results based on user roles, preventing unauthorized users from seeing actual PII values. Secure Views (C) are recommended because they restrict underlying data access and prevent users from viewing the view definition, enhancing security for PII. Transient tables (B) are for temporary data storage and do not inherently restrict access. Multi-Factor Authentication (D) is for user authentication, not direct data access control. Data encryption (E) protects data at rest but does not restrict access; it ensures confidentiality if accessed, which is less suitable for the specific requirement of restricting unauthorized access.

Author: LeetQuiz Editorial Team