ADA-C01 Question 288
Single answerRecover dropped dashboardsA Snowflake administrator is told that a Snowsight dashboard used by finance was accidentally deleted earlier in the day by one of the analysts. The dashboard was built directly in Snowsight and is needed immediately for month-end reporting. The administrator has ACCOUNTADMIN privileges and wants the fastest supported way to restore the dashboard with its previous definition. What should the administrator do?
- A
Use Snowsight to open the Worksheets or Dashboards area, locate the deleted dashboard in the Recently Deleted view, and restore it if it is still within the retention window.
- B
Run an UNDROP DASHBOARD command in SQL, because dashboards are schema-level objects that support Time Travel recovery.
- C
Use Time Travel on the underlying tables to recreate the dashboard automatically at the point just before deletion.
- D
Query ACCOUNT_USAGE views to retrieve the dashboard metadata and then run CREATE OR REPLACE DASHBOARD from the returned definition.
Show answer and explanation
Correct answer: A
Explanation
This question tests the distinction between Snowflake SQL objects and Snowsight content objects. A common mistake is assuming that all deleted items in Snowflake can be restored with UNDROP or Time Travel. In practice, Snowsight dashboards are managed through the Snowsight interface and are restored from the Recently Deleted area when still within the applicable retention window. Time Travel and UNDROP are used for supported database objects, not for Snowsight dashboards. Best practice is to understand which assets are governed by SQL object recovery versus Snowsight content recovery, and to act quickly when a dashboard is deleted so it can be restored before the retention period expires.
- A. Correct.
Correct. Snowsight dashboards are restored through the Snowsight user interface, not through SQL object recovery commands. If the dashboard was deleted recently and is still within the supported retention period for deleted Snowsight content, an administrator or authorized user can restore it from the Recently Deleted area. This is the fastest supported recovery method for a dropped Snowsight dashboard.
- B. Incorrect.
Incorrect. There is no SQL command such as UNDROP DASHBOARD for Snowsight dashboards. UNDROP applies to supported database objects such as tables, schemas, and databases, but Snowsight dashboards are not recovered as schema-level SQL objects through Time Travel or UNDROP syntax.
- C. Incorrect.
Incorrect. Time Travel can restore data in supported database objects, but it does not automatically restore Snowsight dashboard definitions. Even if underlying tables are intact or recoverable, the deleted dashboard object itself must be restored separately through the supported Snowsight mechanism.
- D. Incorrect.
Incorrect. ACCOUNT_USAGE views can help with auditing and investigation, but they do not provide a supported way to reconstruct and recreate a deleted Snowsight dashboard definition with a CREATE OR REPLACE DASHBOARD statement. Snowsight dashboards are not recreated from SQL DDL in this manner.