Free ADA-C02 Questions for Snowflake SnowPro Advanced Administrator ADA-C02 ADA-C02 Exam as PDF & Practice Test Engine

What information is required from the Identity Provider (IdP) to enable federated authentication in Snowflake? (Choose two.)

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

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.)

What steps are required to set up OKTAAPI token integration in Snowflake?

A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema:
Table Name: VWH_META
Column 1: SNAPSHOT_TIME TIMESTAMP_NTZ
Column 2: CONFIG VARIANT
Which commands should be executed to persist the warehouse data at the time of execution in JSON format in the table VWH_META?

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

For Snowflake network policies, what will occur when the account level and user level network policies are both defined?