SnowPro Advanced Administrator ADA-C02

SnowPro Advanced Administrator ADA-C02 practice questions, page 2 of 3, with answer review and explanations.

Question 6

What SCIM integration types are supported in Snowflake? (Choose three.)

  1. Amazon Web Services (AWS)
  2. Google Cloud Platform (GCP)
  3. Okta
  4. Custom
  5. Azure Active Directory (Azure AD)
  6. Duo Security Provisioning Connector

Question 7

What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

  1. Any role with GRANT USAGE on SECURITY INTEGRATION
  2. ACCOUNTADMIN and SYSADMIN
  3. ACCOUNTADMIN and SECURITYADMIN
  4. ACCOUNTADMIN only

Question 8

For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?

  1. The account_level policy will override the user_level policy.
  2. The user_level policy will override the account_level policy.
  3. The user_level network policies will not be supported.
  4. A network policy error will be generated with no definitions provided.

Question 9

What access control policy will be put into place when future grants are assigned to both database and schema objects?

  1. Database, privileges will take precedence over schema privileges.
  2. Schema privileges will take precedence over database privileges.
  3. An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.
  4. An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.

Question 10

The following SQL command was executed: Which role(s) can alter or drop table XYZ?

  1. Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
  2. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
  3. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
  4. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.