Last Update 1 hour ago Total Questions : 60
The SnowPro Advanced: Administrator content is now fully updated, with all current exam questions added 1 hour ago. Deciding to include ADA-C02 practice exam questions in your study plan goes far beyond basic test preparation.
You'll find that our ADA-C02 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these ADA-C02 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any SnowPro Advanced: Administrator practice test comfortably within the allotted time.
MY_TABLE is a table that has not been updated or changed for several days. On 01 January 2021 at 07:01, a user ran a query that updated this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.
Which queries allow the user to view the historical data that was in the table before this query ran?
Choose three
Which steps are needed to configure OKTAAPI token integration in Snowflake?
Under what condition does auto-suspend take place for a multi-cluster virtual warehouse?
Which statement enables a Snowflake Administrator to retrieve the network policy applied to the Snowflake account?
A company has configured Snowflake replication between two Snowflake accounts, both running Snowflake Enterprise Edition. Replication applies to database APP_DB, which contains only one schema, APP_SCHEMA. The company’s Time Travel retention policy is currently 30 days in both accounts. An Administrator must extend the Time Travel retention policy to 60 days on the secondary database only.
How can this requirement be fulfilled?
Which Snowflake capabilities are typically used for rollback scenarios?
Choose two
A Snowflake Administrator needs to retain all virtual warehouse configurations for auditing and backup. A table already exists with this schema:

Which commands should be run to persist the warehouse data at execution time in JSON format in the VWH_META table?
An Administrator has a warehouse that is intended to have a credit quota of 3000 for every calendar year. The Administrator must create a resource monitor that performs these tasks:
At 80% usage, notify the account Administrators.
At 100% usage, suspend the warehouse and notify the account Administrators.
At 120% usage, stop all running executions, suspend the warehouse, and notify the account Administrators.
Which SQL command meets these requirements?
In general, monthly database-replication billing is proportional to which variables?
Choose two
Which roles or security privileges allow a consumer account to request and receive data from the Data Exchange?
Choose two
