ADA-C01 Question 289
Single answerRecover dropped dashboardsA Snowflake administrator receives an urgent request from the analytics team: a Snowsight dashboard used by executives was accidentally deleted earlier that morning. The team needs the dashboard restored with minimal data loss. Which action should the administrator take to recover the dropped dashboard?
- A
Use the dashboard's Time Travel history in Snowsight to restore the deleted dashboard from the point just before it was dropped.
- B
Run an UNDROP DASHBOARD command from a worksheet while using a role with OWNERSHIP on the schema that contained the dashboard.
- C
Open Snowsight, navigate to the folder or collection that previously contained the dashboard, and restore it from the Recently Deleted area if it is still within the retention period.
- D
Query ACCOUNT_USAGE.DASHBOARDS and recreate the dashboard automatically by executing the stored dashboard definition returned by the view.
Show answer and explanation
Correct answer: C
Explanation
For dropped Snowsight dashboards, recovery is performed through the Snowsight user interface rather than with SQL commands such as UNDROP. Dashboards are not database objects managed through SQL DDL recovery semantics, so standard Time Travel and UNDROP patterns do not apply. The administrator should go to the relevant Snowsight area and restore the dashboard from Recently Deleted, assuming it is still within the retention period. This reflects Snowflake best practice: use SQL recovery features for supported database objects, and use Snowsight content-management features for Snowsight artifacts such as dashboards. Refer to Snowflake documentation on Snowsight dashboards and content recovery/deleted items behavior for the supported restore workflow.
- A. Incorrect.
Incorrect. Time Travel applies to supported Snowflake data objects such as tables, schemas, and databases, but it does not provide a user-driven Time Travel restore mechanism for Snowsight dashboards. A common misconception is assuming all Snowflake UI assets behave like database objects with SQL-based recovery semantics.
- B. Incorrect.
Incorrect. There is no supported UNDROP DASHBOARD SQL command in Snowflake. Dashboards are Snowsight objects, not SQL objects that can be restored with standard UNDROP commands. Candidates may choose this because UNDROP is valid for databases, schemas, tables, stages, and some other object types, but not dashboards.
- C. Correct.
Correct. Dropped Snowsight dashboards can be recovered through the Snowsight interface from the Recently Deleted area, provided they are still within the applicable retention window. This is the practical recovery path for accidentally deleted dashboards and is the option that aligns with how Snowsight content recovery works.
- D. Incorrect.
Incorrect. ACCOUNT_USAGE views are for metadata and monitoring, not for automatically reconstructing deleted Snowsight dashboards. Even if metadata about dashboard usage or ownership exists, Snowflake does not provide a supported mechanism to regenerate a dashboard by executing a definition from ACCOUNT_USAGE. This distractor targets the misconception that all UI artifacts are fully reproducible from account metadata.