ADA-C01 Question 283
Single answerShare worksheets and dashboardsA Snowflake administrator needs to let a finance manager review a Snowsight dashboard and one supporting worksheet that were created by a data analyst. The finance manager already has a Snowflake user account, but should not be able to edit the worksheet or dashboard. The administrator also wants to avoid granting broad object ownership or moving the underlying SQL assets to a different role. Which action should the administrator take to meet these requirements?
- A
Use Snowsight sharing to grant the finance manager access to the specific worksheet and dashboard with view-only permissions.
- B
Transfer OWNERSHIP of the worksheet and dashboard to the finance manager's role so the manager can open them in Snowsight.
- C
Create a secure data share for the finance manager and add the worksheet and dashboard to the share.
- D
Grant the finance manager's role USAGE on the analyst's warehouse; this will automatically allow viewing the worksheet and dashboard in Snowsight.
Show answer and explanation
Correct answer: A
Explanation
The best answer is to use Snowsight's built-in sharing capability for worksheets and dashboards. This is the least-privilege approach for internal collaboration on saved Snowsight content. It allows another Snowflake user to access the shared worksheet or dashboard without changing ownership. Administrators should also remember that sharing the Snowsight object itself does not replace required privileges on the underlying database objects or warehouse access needed to run queries or refresh dashboard results. In Snowflake best practices, object ownership should be transferred only when administrative control truly needs to change, and secure data sharing should not be confused with Snowsight content sharing because they address different types of assets.
- A. Correct.
Correct. In Snowsight, worksheets and dashboards can be shared directly with other Snowflake users so they can view the content without becoming the owner. This is the appropriate way to let another internal user review saved Snowsight content while preserving the original creator's ownership and avoiding unnecessary privilege escalation. The recipient still needs appropriate access to the underlying data and compute resources used when interacting with the content.
- B. Incorrect.
Incorrect. Transferring OWNERSHIP is excessive and changes control of the object rather than simply granting access. The scenario explicitly says the administrator wants to avoid broad ownership changes and does not want the finance manager to edit the assets. Ownership transfer would also create administrative side effects and is not the intended mechanism for routine dashboard or worksheet sharing.
- C. Incorrect.
Incorrect. Secure data sharing is for sharing database objects such as tables, views, and secure views across accounts or listings, not for sharing Snowsight interface objects like worksheets and dashboards. A candidate might choose this because it sounds like a generic sharing feature, but it does not apply to Snowsight content objects.
- D. Incorrect.
Incorrect. Warehouse USAGE allows a role to use a warehouse for query execution, but it does not grant access to another user's saved worksheet or dashboard in Snowsight. This option reflects a common misconception that compute privileges also control visibility of Snowsight content. Content sharing and object/data privileges are separate concerns.