Databricks Updated Databricks-Certified-Data-Analyst-Associate Exam Questions and Answers by kenzo

Databricks provides a user-friendly interface that allows data analysts to quickly upload small datasets, such as a 50-row CSV file, and create tables within Databricks SQL. The steps are as follows:​

Access the Data Upload Interface:

In the Databricks workspace, navigate to the sidebar and click on New > Add or upload data.​

Select Create or modify a table.​

Upload the CSV File:

Click on the browse button or drag and drop the CSV file directly onto the designated area.​

The interface supports uploading up to 10 files simultaneously, with a total size limit of 2 GB.​

Configure Table Settings:

After uploading, a preview of the data is displayed.​

Specify the table name, select the appropriate schema, and configure any additional settings as needed.​

Create the Table:

Once all configurations are set, click on the Create Table button to finalize the process.​

This method is efficient for quickly importing small datasets without the need for additional tools or complex configurations. Options B, C, and D involve more complex or manual processes that are unnecessary for this task.​

Markdown-based text boxes are useful as labels on a dashboard. They allow the data analyst to add text to a dashboard using the %md magic command in a notebook cell and then select the dashboard icon in the cell actions menu. The text can be formatted using markdown syntax and can include headings, lists, links, images, and more. The text boxes can be resized and moved around on the dashboard using the float layout option. References: Dashboards in notebooks, How to add text to a dashboard in Databricks

 Last-mile ETL is the term used to describe the additional processing of data that is done by data analysts or data scientists after the data has been ingested, transformed, and stored in the lakehouse by data engineers. Last-mile ETL typically involves tasks such as data cleansing, data enrichment, data aggregation, data filtering, or data sampling that are specific to the analysis or machine learning use case. Last-mile ETL can be done using Databricks SQL, Databricks notebooks, or Databricks Machine Learning. References: Databricks - Last-mile ETL, Databricks - Data Analysis with Databricks SQL

The correct answer is A because MERGE INTO is the Databricks SQL command used to combine source rows with a target table based on a match condition. The condition checks whether supplier_id already exists. If a row does not match, WHEN NOT MATCHED THEN INSERT * inserts it. If a row already matches, no WHEN MATCHED action is provided, so the existing row remains unchanged. This prevents duplicate supplier rows.

Official documentation extract used: Databricks shows the pattern MERGE INTO target USING source ON target.key = source.key WHEN NOT MATCHED THEN INSERT *.