Snowflake SnowPro Advanced Administrator ADA-C02 - SnowPro Advanced Administrator ADA-C02 Exam
Page: 3 / 13
Total 62 questions
Question #11 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.
An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Choose two.)
An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Choose two.)
A. OPERATE
B. MODIFY
C. MONITOR
D. USAGE
E. OWNERSHIP
Answer: CD
Question #12 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening.
Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?
Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?
A. Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.
B. Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.
C. Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
D. Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.
Answer: A
Question #13 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
What SCIM integration types are supported in Snowflake? (Choose three.)
A. Amazon Web Services (AWS)
B. Google Cloud Platform (GCP)
C. Okta
D. Custom
E. Azure Active Directory (Azure AD)
F. Duo Security Provisioning Connector
Answer: CDE
Question #14 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?
A. Any role with GRANT USAGE on SECURITY INTEGRATION
B. ACCOUNTADMIN and SYSADMIN
C. ACCOUNTADMIN and SECURITYADMIN
D. ACCOUNTADMIN only
Answer: C
Question #15 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?
A. The account_level policy will override the user_level policy.
B. The user_level policy will override the account_level policy.
C. The user_level network policies will not be supported.
D. A network policy error will be generated with no definitions provided.
Answer: B
