Databricks Data Analyst Exam Latest Update Graded A+

Databricks Data Analyst Exam Latest Update Graded A+ Identify Databricks SQL dashboards as a place to display the results of multiple queries at once. Identify Databricks SQL dashboards as a place to display the results of multiple queries at once. Describe the key audience and side audience for Databricks The key audience include data analysts, data scientists and business intelligence professionals. Side audiences include data engineers and data admins. Describe that a variety of users can view and run Databricks SQL dashboards as stakeholders Stakeholders are users granted access but not edit permissions to a dashboard. This is for stakeholders that need to view and interact with the data on dashboards to gain insights. They can view and interact with data, share the dashboards, receive notifications and drill down into data points. Describe the benefits of using Databricks SQL for in-Lakehouse platform data processing 4 main benefits: -Allows users to query and analyse data stored in data lakes and data warehouses using SQL -Built on top of the Databricks Lakehouse platform, provides a unified platform for data engineering, data science, and analytics -Provides a high-performance query engine that is optimized for big data workloads -Provides a range of tools and features for data processing, including data visualization, data transformation, and machine learning Describe how to complete a basic Databricks SQL query 1. Open SQL editor 2. Select a SQL warehouse 3. Type in your query 4. Click Run 5. If you want to save the query, click Save Where should you write and run SQL code? In Databricks SQL queries Identify the information displayed in the schema browser from the Query Editor page In the schema browser you can view available data objects. You find a list of available databases, tables, columns and data types. You can also use it to explore the structure of your data. Describe how to complete a basic Databricks SQL dashboard 1. Execute your SQL queries 2. Click on the Dashboard icon in the sidebar 3. Click on new dashboard to create a new dashboard. Name your dashboard. 4. Press add tile to add a new tile. Select the visualisation, specify the query and data source and customise the appearance. 5. Add as many tiles as you want. 6. Save your dashboard Describe how dashboards can be configured to automatically refresh 1. Open the dashboard you want to automatically refresh 2. Click the Schedule button in the top right corner 3. Select an interval for refreshing 4. Select the SQL warehouse to use for the refresh 5. Optionally, subscribe users or destinations to be updated when the dashboard updates 6. Click save to save the schedule Describe the purpose of Databricks SQL endpoints/warehouses. -They provide general compute resources for SQL queries, visualizations, and dashboards. -SQL endpoints provide a way to separate the compute resources used for SQL workloads from other workloads in the Databricks workspace. -Databricks SQL supports three types of SQL endpoints: Serverless, Pro, and Classic. Identify Serverless Databricks SQL endpoint/warehouses as a quick-starting option -A quick-starting option for running SQL queries and visualizations in Databricks. -Designed to be easy to set up and use, and provide a cost-effective way to run queries and exploratory analysis -Serverless endpoints are optimized for