Databricks Certified Data Analyst Associate · Free Practice Question Medium
Question 14
When sharing Databricks SQL dashboards, there are two primary settings: 'Run as viewer' and 'Run as owner'. What are the pros and cons of each setting in the context of sharing dashboards?
-
A
'Run as viewer' allows full customization of queries for each viewer (pro), but can be more resource-intensive (con). 'Run as owner' simplifies query management (pro), but doesn't account for individual user access levels (con).
-
B
'Run as viewer' and 'Run as owner' both provide the same level of data visibility (pro), but may have limitations in customizing query execution (con).
-
C
Both settings allow for easy sharing of dashboards (pro), but can lead to complexities in managing user permissions and data access (con).
-
D
'Run as owner' offers greater customization of dashboard settings (pro), but requires viewers to have advanced knowledge of SQL (con). 'Run as viewer' simplifies the user experience (pro), but may lead to inconsistent data reporting (con).
-
E
'Run as viewer' enhances data security by adhering to individual viewer's permissions (pro), but may limit data visibility (con). 'Run as owner' ensures consistent data visibility across users (pro), but might pose security risks if the owner has broader data access (con).
Reveal correct answer
Correct answer: E
Explanation
Each sharing setting in Databricks dashboards has its benefits and drawbacks. The 'Run as viewer' setting respects the individual access permissions of each viewer, providing a secure way to share data. However, this can limit the visibility of data based on those permissions. On the other hand, 'Run as owner' ensures that all viewers see the same data, which is useful for consistency, but this could expose sensitive information if the dashboard owner has access to a broader range of data than the viewers.
References:
Share Databricks SQL dashboards - Azure Databricks | Microsoft Learn.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
