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

Questions 36–40

1. 36foundation · easy

   What is the purpose of a password policy in Snowflake?

   • ATo define rules for password complexity, rotation, and reuse.
   • BTo mask sensitive data.
   • CTo restrict IP addresses.
   • DTo control session duration.
   Reveal Solution Discussion Select an answer first
2. 37application · medium

   A company is using Okta for identity management and wants to automate the provisioning of Snowflake users and role assignments. The identity team has created the SCIM integration in Snowflake and configured Okta. However, when a new user is added to an Okta group that maps to a Snowflake role, the user is not automatically assigned the role in Snowflake. What is the most likely cause?

   • AThe Snowflake user was created manually before SCIM was enabled.
   • BThe SCIM integration was created with the 'SYNC_PASSWORD' parameter set to 'true'.
   • CThe Okta group is not mapped to the Snowflake role in the SCIM provisioning settings.
   • DThe SCIM integration is using OAuth instead of SAML for authentication.
   Reveal Solution Discussion Select an answer first
4. 38foundation · easy

   Which of the following settings can be configured in a session policy?

   • ASession idle timeout
   • BPassword minimum length
   • CAllowed IP ranges
   • DMFA enforcement
   Reveal Solution Discussion Select an answer first
5. 39foundation · easy

   Which of the following is a securable object in Snowflake?

   • ARole
   • BUser
   • CDatabase
   • DSession
   Reveal Solution Discussion Select an answer first
6. 40foundation · easy

   What is the typical approach to implement row-level security in Snowflake?

   • AUse session policies to limit session duration.
   • BUse a mapping table and secure views to filter rows based on user roles.
   • CUse dynamic data masking to hide columns.
   • DUse network policies to restrict IP addresses.
   Reveal Solution Discussion Select an answer first