New Release Databricks-Certified-Data-Analyst-Associate Data Analyst Questions

In Databricks, aviewis a saved SQL query definition that references existing tables or other views. Once created, a view remains persisted in themetastore(such as Unity Catalog or Hive Metastore) until it is explicitly dropped.

Key points:

Views donot store datathemselves but reference data from underlying tables.

Logging out or being inactive doesnotdelete or alter views.

Unless a user or admin explicitlydropsthe view or the underlying data/table is deleted, the view continues to function as expected.

Therefore, after logging back in—even days later—a user can still run SELECT * FROM stakeholders.eur_customers, and it will return the same data (provided the underlying table hasn’t changed).

A Sankey diagram is a type of visualization that shows the flow of data between different nodes or categories. It is often used to represent the movement of users through a website, as it can show the paths they take, the sources they come from, the pages they visit, and the outcomes they achieve. A Sankey diagram consists of links and nodes, where the links represent the volume or weight of the flow, and the nodes represent the stages or steps of the flow. The width of the links is proportional to the amount of flow, and the color of the links can indicate different attributes or segments of the flow. A Sankey diagram can help identify the most common or popular user journeys, the bottlenecks or drop-offs in the flow, and the opportunities for improvement or optimization. References: The answer can be verified from Databricks documentation which provides examples and instructions on how to create Sankey diagrams using Databricks SQL Analytics and Databricks Visualizations. Reference links: Databricks SQL Analytics - Sankey Diagram, Databricks Visualizations - Sankey Diagram

Databricks SQL allows you to create multiple visualizations from a single query result. These visualizations can be customized independently and each can be added to a dashboard. This feature is explicitly supported and recommended in Databricks’ documentation on dashboards and visualization workflows, enabling flexible reporting without duplicating queries.

In the Databricks Lakehouse Platform,business analystsprimarily utilize Databricks SQL as their main service. Databricks SQL provides an environment tailored for executing SQL queries, creating visualizations, and developing dashboards, which aligns with the typical responsibilities of business analysts who focus on interpreting data to inform business decisions. While data scientists and data engineers also interact with the Databricks platform, their primary tools and services differ; data scientists often engage with machine learning frameworks and notebooks, whereas data engineers focus on data pipelines and ETL processes. Platform architects are involved in designing and overseeing the infrastructure and architecture of the platform. Therefore, among the roles listed, business analysts are the primary users of Databricks SQL.​