A data analysis team has noticed that their Databricks SQL queries are running too slowly when connected to their always-on SQL endpoint. They claim that this issue is present when many members of the team are running small queries simultaneously. They ask the data engineering team for help. The data engineering team notices that each of the team’s queries uses the same SQL endpoint.

Which of the following approaches can the data engineering team use to improve the latency of the team’s queries?

A data analyst is working with the following table my_table:

customer_name dollars_spent

Hex Sprockets [125.34, 100.15, 9003.99]

Dented Fenders [16.99, 200.85, 33.49, 88.17]

The analyst wants to divide each value in the dollars_spent array by 100 to get the spend in terms of hundreds of dollars using the following code block:

SELECT

customer_name,

_______

FROM my_table;

Which line of code can be used to fill in the blank so that the above code block successfully completes the task?

A BI analyst is building an analytical data model in Databricks using Delta Lake tables. The source system contains transactional sales data that changes frequently. The analyst chooses to apply the Data Vault 2.0 methodology to manage historical changes while ensuring scalability and auditability across multiple business domains.

Which component is used to capture the many-to-many relationship between hubs in a Data Vault v2 model?

A data analyst has two data sources that are providing similar but complementary information. The analyst wants to combine these sources of data into a single, comprehensive dataset for ongoing use for their team in a variety of different projects.

Which term is used to describe this type of work?

A data analyst has been asked to use the below table sales_table to get the percentage rank of products within region by the sales:

The result of the query should look like this:

Which of the following queries will accomplish this task?

A)

B)

C)

D)

A data analyst is working on a DataFrame named dates_df and needs to add a new column, date, derived from the timestamp field.

Which code fragment should be used to extract the date from a timestamp?

Which of the following SQL keywords can be used to convert a table from a long format to a wide format?

A data engineering team has created a Structured Streaming pipeline that processes data in micro-batches and populates gold-level tables. The microbatches are triggered every minute.

A data analyst has created a dashboard based on this gold-level data. The project stakeholders want to see the results in the dashboard updated within one minute or less of new data becoming available within the gold-level tables.

Which of the following cautions should the data analyst share prior to setting up the dashboard to complete this task?

A data scientist wants to tune a set of hyperparameters for a machine learning model. They have wrapped a Spark ML model in the objective function objective_function, and they have defined the search space search_space.

As a result, they have the following code block:

num_evals = 100

trials = SparkTrials()

best_hyperparam = fmin(

fn=objective_function,

space=search_space,

algo=tpe.suggest,

max_evals=num_evals,

trials=trials

)

Which of the following changes do they need to make to the above code block in order to accomplish the task?

What is used as a compute resource for Databricks SQL?

A data analyst creates a Databricks SQL Query where the result set has the following schema:

region STRING

number_of_customer INT

When the analyst clicks on the " Add visualization " button on the SQL Editor page, which of the following types of visualizations will be selected by default?

A Data Analyst is working on sensor_df; this DataFrame contains two columns: record_datetime timestamp and record array.

Which code fragment returns a DataFrame that splits the record column into separate columns and has one array item per row?

A data analyst needs to create an empty managed table table_name in database database_name with a specific schema. The table needs to be recreated and empty, regardless of whether or not the table already exists.

Which command can the analyst use to complete the task?

A data team has been given a series of projects by a consultant that need to be implemented in the Databricks Lakehouse Platform.

Which of the following projects should be completed in Databricks SQL?

What is an advantage of using a Delta Lake-based data lakehouse over classic enterprise data warehouse solutions?

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?

After running DESCRIBE EXTENDED accounts.customers;, the following was returned:

Now, a data analyst runs the following command:

DROP accounts.customers;

Which of the following describes the result of running this command?

A managed table and an unmanaged external table were both created in Databricks SQL, and data was ingested into each table. Later, both tables were dropped.

What is the status of data for each of those tables?

A data analyst wants to generate insights from large, complex datasets. The analyst needs to quickly understand the meaning of various data columns, ask questions in natural language, and receive AI-driven recommendations for optimizing data queries and workflows.

Which Databricks component is primarily responsible for enabling these capabilities?

A data scientist has asked a data analyst to create histograms for every continuous variable in a data set. The data analyst needs to identify which columns are continuous in the data set.

What describes a continuous variable?

Which of the following layers of the medallion architecture is most commonly used by data analysts?

Which data lakehouse feature results in improved data quality over a traditional data lake?

What describes the variance of a set of values?

A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.

Which of the following relational objects should the data engineer create?

A data analyst filters rows where the tags array includes the value ' sql ' using this query:

SELECT *

FROM main.analytics.articles

WHERE tags = ' sql ' ;

This query returns no results.

How should the analyst query to filter for rows where the tags array contains ' sql ' ?

A data analyst wants the following output:

Which statement will produce this output?

A)

B)

C)

D)

A data engineer is maintaining a data pipeline. Upon data ingestion, the data engineer notices that the source data is starting to have a lower level of quality. The data engineer would like to automate the process of monitoring the quality level.

Which of the following tools can the data engineer use to solve this problem?

Which of the following statements describes descriptive statistics?

A distributed team of data analysts share computing resources on an interactive cluster with autoscaling configured. In order to better manage costs and query throughput, the workspace administrator is hoping to evaluate whether cluster upscaling is caused by many concurrent users or resource-intensive queries.

In which location can one review the timeline for cluster resizing events?

In which of the following situations should a data analyst use higher-order functions?

In a healthcare provider organization using Delta Lake to store electronic health records, a data analyst needs to analyze a snapshot of the patient_records table from two weeks ago before some recent data corrections were applied.

What approach should the Data Engineer take to allow the analyst to query that specific prior version?

A data analyst needs to share a Databricks SQL dashboard with stakeholders that are not permitted to have accounts in the Databricks deployment. The stakeholders need to be notified every time the dashboard is refreshed.

Which approach can the data analyst use to accomplish this task with minimal effort/

Which of the following describes the relationship between Gold tables and Silver tables?

Which of the following is a benefit of the Databricks Lakehouse Platform embracing open source technologies?

A data analyst is processing a complex aggregation on a table with zero null values and the query returns the following result:

Which query did the analyst execute in order to get this result?

A)

B)

C)

D)