Question No. 1

A data organization has a team of engineers developing data pipelines following the medallion architecture using Delta Live Tables. While the data analysis team working on a project is using gold-layer tables from these pipelines, they need to perform some additional processing of these tables prior to performing their analysis.

Which of the following terms is used to describe this type of work?

AData blending

BLast-mile

CData testing

DLast-mile ETL

EData enhancement

Show Answer

Correct Answer: D

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.Reference:Databricks - Last-mile ETL,Databricks - Data Analysis with Databricks SQL

Question No. 2

A data analyst has created a Query in Databricks SQL, and now they want to create two data visualizations from that Query and add both of those data visualizations to the same Databricks SQL Dashboard.

Which of the following steps will they need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

AThey will need to alter the Query to return two separate sets of results.

BThey will need to add two separate visualizations to the dashboard based on the same Query.

CThey will need to create two separate dashboards.

DThey will need to decide on a single data visualization to add to the dashboard.

EThey will need to copy the Query and create one data visualization per query.

Show Answer

Correct Answer: B

A data analyst can create multiple visualizations from the same query in Databricks SQL by clicking the + button next to the Results tab and selecting Visualization. Each visualization can have a different type, name, and configuration. To add a visualization to a dashboard, the data analyst can click the vertical ellipsis button beneath the visualization, select + Add to Dashboard, and choose an existing or new dashboard. The data analyst can repeat this process for each visualization they want to add to the same dashboard.Reference:Visualization in Databricks SQL,Visualize queries and create a dashboard in Databricks SQL

Question No. 3

Delta Lake stores table data as a series of data files, but it also stores a lot of other information.

Which of the following is stored alongside data files when using Delta Lake?

ANone of these

BTable metadata, data summary visualizations, and owner account information

CTable metadata

DData summary visualizations

EOwner account information

Show Answer

Correct Answer: C

Delta Lake stores table data as a series of data files in a specified location, but it also stores table metadata in a transaction log. The table metadata includes the schema, partitioning information, table properties, and other configuration details. The table metadata is stored alongside the data files and is updated atomically with every write operation. The table metadata can be accessed using the DESCRIBE DETAIL command or the DeltaTable class in Scala, Python, or Java. The table metadata can also be enriched with custom tags or user-defined commit messages using the TBLPROPERTIES or userMetadata options.Reference:

Enrich Delta Lake tables with custom metadata

Delta Lake Table metadata - Stack Overflow

Metadata - The Internals of Delta Lake

Question No. 4

Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?

AUse Workflows to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with

BUse Delta Live Tables to establish a cluster for Fivetran to interact with

CUse Partner Connect's automated workflow to establish a cluster for Fivetran to interact with

DUse Partner Connect's automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with

EUse Workflows to establish a cluster for Fivetran to interact with

Show Answer

Correct Answer: C

Partner Connect is a feature that allows you to easily connect your Databricks workspace to Fivetran and other ingestion partners using an automated workflow. You can select a SQL warehouse or a cluster as the destination for your data replication, and the connection details are sent to Fivetran. You can then choose from over 200 data sources that Fivetran supports and start ingesting data into Delta Lake.Reference:Connect to Fivetran using Partner Connect,Use Databricks with Fivetran

Question No. 5

A data analyst has created a user-defined function using the following line of code:

CREATE FUNCTION price(spend DOUBLE, units DOUBLE)

RETURNS DOUBLE

RETURN spend / units;

Which of the following code blocks can be used to apply this function to the customer_spend and customer_units columns of the table customer_summary to create column customer_price?

ASELECT PRICE customer_spend, customer_units AS customer_price FROM customer_summary

BSELECT price FROM customer_summary

CSELECT function(price(customer_spend, customer_units)) AS customer_price FROM customer_summary

DSELECT double(price(customer_spend, customer_units)) AS customer_price FROM customer_summary

ESELECT price(customer_spend, customer_units) AS customer_price FROM customer_summary

Show Answer

Correct Answer: E

A user-defined function (UDF) is a function defined by a user, allowing custom logic to be reused in the user environment1.To apply a UDF to a table, the syntax isSELECT udf_name(column_name) AS alias FROM table_name2. Therefore, option E is the correct way to use the UDFpriceto create a new columncustomer_pricebased on the existing columnscustomer_spendandcustomer_unitsfrom the tablecustomer_summary.Reference:

What are user-defined functions (UDFs)?

User-defined scalar functions - SQL

V

Free Databricks Databricks-Certified-Data-Analyst-Associate Exam Actual Questions

The questions for Databricks-Certified-Data-Analyst-Associate were last updated On Jan 15, 2025