Databricks Certified Data Analyst Associate Exam Practice Test Instant Access

Question 1

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?

AOption A

BOption B

COption C

DOption D

Answer : B

Question 2

A stakeholder has provided a data analyst with a lookup dataset in the form of a 50-row CSV file. The data analyst needs to upload this dataset for use as a table in Databricks SQL.

Which approach should the data analyst use to quickly upload the file into a table for use in Databricks SOL?

ACreate a table by uploading the file using the Create page within Databricks SQL

BCreate a table via a connection between Databricks and the desktop facilitated by Partner Connect.

CCreate a table by uploading the file to cloud storage and then importing the data to Databricks.

DCreate a table by manually copying and pasting the data values into cloud storage and then importing the data to Databricks.
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.

Answer : A

Question 3

What is used as a compute resource for Databricks SQL?

ASingle-node clusters

BDownstream BI tools integrated with Databricks SQL

CSQL warehouses

DStandard clusters

Answer : C

Question 4

Which statement about subqueries is correct?

ASubqueries are not available in Databricks SQL

BSubqueries can be used like other user-defined functions to transform data into different data types.

CSubqueries can retrieve data without requiring the creation of a table or view.

DSubqueries can be used like other built-in functions to transform data into different data types.
In Databricks SQL, a subquery is a nested query within a larger SQL query that allows for the retrieval of data without the necessity of creating a table or view. This is particularly useful for simplifying complex queries by breaking them down into more manageable parts. Subqueries can be employed in various clauses such as SELECT, FROM, and WHERE to perform operations like filtering, transforming, and aggregating data on-the-fly. This flexibility enhances query efficiency and readability without the overhead of persisting intermediate results as separate tables or views.

Answer : C

Question 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
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

Answer : E

Question 6

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/

ABy granting the stakeholders' email addresses permissions to the dashboard

BBy adding the stakeholders' email addresses to the refresh schedule subscribers list

CBy granting the stakeholders' email addresses to the SQL Warehouse (formerly known as endpoint) subscribers list

DBy downloading the dashboard as a PDF and emailing it to the stakeholders each time it is refreshed
To share a Databricks SQL dashboard with stakeholders who do not have accounts in the Databricks deployment and ensure they are notified upon each refresh, the data analyst can add the stakeholders' email addresses to the dashboard's refresh schedule subscribers list. This approach allows the stakeholders to receive email notifications containing the latest dashboard updates without requiring them to have direct access to the Databricks workspace. This method is efficient and minimizes effort, as it automates the notification process and ensures stakeholders remain informed of the most recent data insights.

Answer : B

Question 7

What does Partner Connect do when connecting Power Bl and Tableau?

ACreates a Personal Access Token. downloads and installs an ODBC driver, and downloads a configuration file for connection by Power Bl or Tableau to a SQL Warehouse (formerly known as a SQL Endpoint).

BCreates a Personal Access Token for authentication into Databricks SQL and emails it to you.

CDownloads a configuration file for connection by Power Bl or Tableau to a SQL Warehouse (formerly known as a SQL Endpoint).

DDownloads and installs an ODBC driver.
When connecting Power BI and Tableau through Databricks Partner Connect, the system automates several steps to streamline the integration process:
Personal Access Token Creation: Partner Connect generates a Databricks personal access token, which is essential for authenticating and establishing a secure connection between Databricks and the BI tools.
ODBC Driver Installation: The appropriate ODBC driver is downloaded and installed. This driver facilitates communication between the BI tools and Databricks, ensuring compatibility and optimal performance.
Configuration File Download: A configuration file tailored for the selected BI tool (Power BI or Tableau) is provided. This file contains the necessary connection details, simplifying the setup process within the BI tool.
By automating these steps, Partner Connect ensures a seamless and efficient integration, reducing manual configuration efforts and potential errors.

Answer : A