Configure Authentication and Access Control ARA-C01 Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   What is the purpose of a mapping table in row-level security?

   • ATo improve query performance.
   • BTo define column-level masking rules.
   • CTo store encrypted versions of the data.
   • DTo define which users or roles can access which rows.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which Snowflake authentication method is most appropriate for a user who needs to log in using their corporate credentials managed by an external identity provider?

   • ASnowflake-native authentication
   • BOAuth authentication
   • CKey-pair authentication
   • DSAML federated authentication
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   What is the purpose of a network policy in Snowflake?

   • ATo restrict access to Snowflake based on IP addresses.
   • BTo control user authentication methods.
   • CTo manage session timeouts.
   • DTo encrypt data in transit.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A multinational company has a 'SALES' table with a 'REGION' column. The requirement is that users can only see rows for their own region. The architect has created a mapping table 'REGION_MAP' that associates each user with a region. What is the most appropriate way to enforce this?

   • ACreate a secure view on the SALES table that joins with REGION_MAP and filters by CURRENT_USER().
   • BCreate a separate table for each region and grant access to the appropriate users.
   • CGrant SELECT on the SALES table only to users in the same region.
   • DCreate a masking policy on the REGION column to hide the region value from unauthorized users.
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   What is the recommended practice for rotating key pairs used for Snowflake authentication?

   • AKeep the same key pair indefinitely to avoid disruption.
   • BUse the same key pair for all users.
   • CShare the private key with the Snowflake administrator.
   • DGenerate a new key pair and update the user's public key in Snowflake.
   Reveal Solution Discussion Select an answer first