Snowflake SnowPro Advanced Administrator - SnowPro Advanced Administrator ADA-C01 Exam
Page: 1 / 13
Total 65 questions
Question #1 (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 #2 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?
A. 
B. 
C. 
D. 
B.
C.
D.
Answer: C
Question #3 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
Which authentication methods are available when connecting to Snowflake using the SQL API? (Choose two.)
A. OAuth
B. Key pair
C. Username and password
D. External browser
E. Single Sign-On (SSO) with an external Identity Provider (IdP)
Answer: AC
Question #4 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
The following SQL command was executed:
Which role(s) can alter or drop table XYZ?
Which role(s) can alter or drop table XYZ?
A. Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
B. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
C. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
D. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.
Answer: C
Question #5 (Topic: Topic 1, Snowflake Security, RBAC, and User Administration
)
The following commands were executed:
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;
Grant role PROD_ANALYST to user A;
Grant role PROD_SUPERVISOR to user B;
What authority does each user have on the WORKING schema?
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;
Grant role PROD_ANALYST to user A;
Grant role PROD_SUPERVISOR to user B;
What authority does each user have on the WORKING schema?
A. Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.
B. Tables created by either user A or user B will be visible to both users.
C. All existing tables in schema PROD.WORKING will be visible to both users.
D. Both user A and user B can create tables in the PROD.WORKING schema.
Answer: D
