Databricks Certified Data Analyst Associate Exam Questions Instant Access

Question 1

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

Answer : C

Question 2

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?

Adates_df.withColumn('date', f.unix_timestamp('timestamp')).show()

Bdates_df.withColumn('date', f.to_date('timestamp')).show()

Cdates_df.withColumn('date', f.date_format('timestamp', 'yyyy-MM-dd')).show()

Ddates_df.withColumn('date', f.from_unixtime('timestamp')).show()

Answer : B

Question 3

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

ATRANSFORM

BPIVOT

CSUM

DCONVERT

EWHERE

Answer : B

Question 4

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 5

Data engineers and data analysts are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL. The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables.

Which of the following changes will need to be made to the pipeline when migrating to Delta Live Tables?

AThe pipeline can have different notebook sources in SQL and Python.

BThe pipeline will need to be written entirely in SQL.

CThe pipeline will need to use a batch source in place of a streaming source.

DThe pipeline will need to be written entirely in Python.

Answer : A

Question 6

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

AOpen-source formats

BSchema enforcement

CACID transactions

DGeneric optimizations

Answer : A

Question 7

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?

ALast-mile ETL

BAd-hoc improvements

CData testing

DData blending

Answer : D