Implement Masking Policies, Row Access Policies, and Tagging SNOWPRO-ADVANCED-SECURITY-ENGINEER Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   In Snowflake, when does a masking policy take effect?

   • AWhen data is loaded into a table
   • BWhen the table is created
   • CWhen the data is exported to a different system
   • DWhen a user runs a query that references the protected column
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   How do you apply a row access policy to a table?

   • ABy using GRANT ROW ACCESS POLICY ON TABLE
   • BBy using UPDATE TABLE ... SET ROW ACCESS POLICY
   • CBy using ALTER TABLE ... SET ROW ACCESS POLICY
   • DBy using CREATE TABLE ... WITH ROW ACCESS POLICY
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   What is a key advantage of integrating tags with policies?

   • AIt automatically encrypts all tagged data
   • BIt improves query performance by reducing data scanned
   • CIt enables centralized management of data protection across many objects
   • DIt eliminates the need for user context in policies
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   How do you apply an existing masking policy to a column in a table?

   • ABy using UPDATE TABLE ... SET MASKING POLICY
   • BBy using ALTER TABLE ... MODIFY COLUMN ... SET MASKING POLICY
   • CBy using GRANT MASKING POLICY ON TABLE
   • DBy using CREATE TABLE ... WITH MASKING POLICY
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which masking function is appropriate for a VARCHAR column to partially hide characters, such as showing only the last four digits of a phone number?

   • ATO_NUMBER
   • BREGEXP_REPLACE
   • CDATEADD
   • DSHA2
   Reveal Solution Discussion Select an answer first