Databricks Data Analyst exam

Identify Databricks SQL dashboards as a place to display the results of multiple queries at once. - answer-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 - answer-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 - answer-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 - answer-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 - answer-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? - answer-In Databricks SQL queries Identify the information displayed in the schema browser from the Query Editor page - answer-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 - answer-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 - answer-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. - answer--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 - answer--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 lower-cost, lower-performance workloads compared to Classic and Pro Describe the trade-off between cluster size and cost for Databricks SQLendpoints/warehouses. - answer-Larger clusters can handle more concurrent queries and larger workloads, but also cost more to run Identify Partner Connect as a tool for implementing simple integrations with a number of other data products - answer--provides a simpler alternative to manual partner connections by provisioning the required Azure Databricks resources on your behalf, then passing resource details to the partner -allows you to create trial accounts with select Azure Databricks technology partners -designed to make it easy to connect your Databricks workspace to partner solutions, without requiring you to manually configure and manage complex integrations Describe how to connect Databricks SQL to ingestion tools like Fivetran - answer-1. Click Partner Connect 2. Click Fivetran (or the partner you want) 3. Enter your info, then click Connect to Fivetran/Partner 4. A new tab opens in your browser with the partner website. Complete the log in. 5. Follow the instructions to set up a connector, then set up an destination for the data 6. In DB, create an endpoint, and a warehouse and table to receive the ingested data 7. Configure the destination in Fivetran, and Fivetran will then start ingesting your data What should you do if you have an existing partner account? - answer-Follow the steps to connect to the partner solution manually in the appropriate connection guide. This is because the connection experience in Partner Connect is optimized for new partner accounts. What is small-file upload? - answer-A solution for importing small text files like lookup tables and quick data integrations! Import from object storage using Databricks SQL - answer-You can import data from object storage using Databricks SQL by creating an external table that references the data in object storage. You need to enter a path to the data in the storage with a link. When can you ingest directories of files? - answer-When the files are the same type and have the same schema. DB reads all the files and combines them in a single table Describe how to connect Databricks SQL to visualization tools like Tableau, Power BI, and Looker - answer-1. Navigate to the Clusters tab. Click create clusters or select an existing one 2. In the Advanced Options section, select the JDBC/ODBC tab 3. Follow the instructions to download the JDBC or ODBC driver for your visualisation tool. Configur