Guide (New 2024) Actual Databricks Databricks-Certified-Data-Analyst-Associate Exam Questions [Q15-Q39]

QUESTION 15
A data analyst needs to use the Databricks Lakehouse Platform to quickly create SQL queries and data visualizations. It is a requirement that the compute resources in the platform can be made serverless, and it is expected that data visualizations can be placed within a dashboard.
Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?

Delta Lake

Databricks Notebooks

Tableau

Databricks Machine Learning

Databricks SQL

QUESTION 16
Which of the following statements about adding visual appeal to visualizations in the Visualization Editor is incorrect?

Visualization scale can be changed.

Data Labels can be formatted.

Colors can be changed.

Borders can be added.

Tooltips can be formatted.

QUESTION 17
A data analyst created and is the owner of the managed table my_ table. They now want to change ownership of the table to a single other user using Data Explorer.
Which of the following approaches can the analyst use to complete the task?

Edit the Owner field in the table page by removing their own account

Edit the Owner field in the table page by selecting All Users

Edit the Owner field in the table page by selecting the new owner’s account

Edit the Owner field in the table page by selecting the Admins group

Edit the Owner field in the table page by removing all access

QUESTION 18
A data analyst wants to create a dashboard with three main sections: Development, Testing, and Production. They want all three sections on the same dashboard, but they want to clearly designate the sections using text on the dashboard.
Which of the following tools can the data analyst use to designate the Development, Testing, and Production sections using text?

Separate endpoints for each section

Separate queries for each section

Markdown-based text boxes

Direct text written into the dashboard in editing mode

Separate color palettes for each section

QUESTION 19
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?

Violin Chart

Line Chart

IBar Chart

Histogram

There is no default. The user must choose a visualization type.

QUESTION 20
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)

Option A

Option B

Option C

Option D

QUESTION 21
A data analyst has recently joined a new team that uses Databricks SQL, but the analyst has never used Databricks before. The analyst wants to know where in Databricks SQL they can write and execute SQL queries.
On which of the following pages can the analyst write and execute SQL queries?

Data page

Dashboards page

Queries page

Alerts page

SQL Editor page

QUESTION 22
A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist.
Which of the following commands can the analyst use to complete the task without producing an error?

DROP DATABASE database_name;

DROP TABLE database_name.table_name;

DELETE TABLE database_name.table_name;

DELETE TABLE table_name FROM database_name;

DROP TABLE table_name FROM database_name;

QUESTION 23
A data engineer is working with a nested array column products in table transactions. They want to expand the table so each unique item in products for each row has its own row where the transaction_id column is duplicated as necessary.
They are using the following incomplete command:

Which of the following lines of code can they use to fill in the blank in the above code block so that it successfully completes the task?

array distinct(produces)

explode(produces)

reduce(produces)

array(produces)

flatten(produces)

QUESTION 24
A data analysis team is working with the table_bronze SQL table as a source for one of its most complex projects. A stakeholder of the project notices that some of the downstream data is duplicative. The analysis team identifies table_bronze as the source of the duplication.
Which of the following queries can be used to deduplicate the data from table_bronze and write it to a new table table_silver?
A)
CREATE TABLE table_silver AS
SELECT DISTINCT *
FROM table_bronze;
B)
CREATE TABLE table_silver AS
INSERT *
FROM table_bronze;
C)
CREATE TABLE table_silver AS
MERGE DEDUPLICATE *
FROM table_bronze;
D)
INSERT INTO TABLE table_silver
SELECT * FROM table_bronze;
E)
INSERT OVERWRITE TABLE table_silver
SELECT * FROM table_bronze;

Option A

Option B

Option C

Option D

Option E

QUESTION 25
A data analyst has been asked to configure an alert for a query that returns the income in the accounts_receivable table for a date range. The date range is configurable using a Date query parameter.
The Alert does not work.
Which of the following describes why the Alert does not work?

Alerts don’t work with queries that access tables.

Queries that return results based on dates cannot be used with Alerts.

The wrong query parameter is being used. Alerts only work with Date and Time query parameters.

Queries that use query parameters cannot be used with Alerts.

The wrong query parameter is being used. Alerts only work with drogdown list query parameters, not dates.

QUESTION 26
How can a data analyst determine if query results were pulled from the cache?

Go to the Query History tab and click on the text of the query. The slideout shows if the results came from the cache.

Go to the Alerts tab and check the Cache Status alert.

Go to the Queries tab and click on Cache Status. The status will be green if the results from the last run came from the cache.

Go to the SQL Warehouse (formerly SQL Endpoints) tab and click on Cache. The Cache file will show the contents of the cache.

Go to the Data tab and click Last Query. The details of the query will show if the results came from the cache.

QUESTION 27
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?

None of these

Table metadata, data summary visualizations, and owner account information

Table metadata

Data summary visualizations

Owner account information

QUESTION 28
A business analyst has been asked to create a data entity/object called sales_by_employee. It should always stay up-to-date when new data are added to the sales table. The new entity should have the columns sales_person, which will be the name of the employee from the employees table, and sales, which will be all sales for that particular sales person. Both the sales table and the employees table have an employee_id column that is used to identify the sales person.
Which of the following code blocks will accomplish this task?

QUESTION 29
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?

Data blending

Last-mile

Data testing

Last-mile ETL

Data enhancement

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

When custom logic needs to be applied to simple, unnested data

When custom logic needs to be converted to Python-native code

When custom logic needs to be applied at scale to array data objects

When built-in functions are taking too long to perform tasks

When built-in functions need to run through the Catalyst Optimizer

QUESTION 31
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?

Running SELECT * FROM delta. `dbfs:/stakeholders/customers` results in an error.

Running SELECT * FROM accounts.customers will return all rows in the table.

All files with the .customers extension are deleted.

The accounts.customers table is removed from the metastore, and the underlying data files are deleted.

The accounts.customers table is removed from the metastore, but the underlying data files are untouched.

QUESTION 32
A data analyst is working with gold-layer tables to complete an ad-hoc project. A stakeholder has provided the analyst with an additional dataset that can be used to augment the gold-layer tables already in use.
Which of the following terms is used to describe this data augmentation?

Data testing

Ad-hoc improvements

Last-mile

Last-mile ETL

Data enhancement

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

Which of the following queries did the analyst run to obtain the above result?