Databricks Certified Data Analyst Associate Exam Questions Instant Access

Question 1

A data analyst has produced a visualization. A stakeholder has viewed the visualization and is complaining that the visualization is difficult to interpret. After looking at the visualization, the analyst determines that the scale of the y-axis must be changed.

Where are the controls for changing the scale of the y-axis in Databricks SQL?

AQuery Editor Y Axis

BDashboard Editor Axes Y Axis

CVisualization Editor Y Axis

DSettings User Settings Scaling

Answer : C

The correct answer is C because axis settings are configured in the visualization editor, specifically under the Y-axis settings. The Query Editor is for writing SQL, not configuring chart axes. User Settings do not control individual chart scales. Dashboard editing may contain visualizations, but the specific control is in the visualization editor's Y Axis configuration.

Question 2

Which statement describes descriptive statistics?

AA branch of statistics that uses a variety of data analysis techniques to infer properties of an underlying distribution of probability.

BA branch of statistics that uses summary statistics to categorically describe and summarize data.

CA branch of statistics that uses summary statistics to quantitatively describe and summarize data.

DA branch of statistics that uses quantitative variables that must take on a finite or countably infinite set of values.

Answer : C

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

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 5

A Data Analyst is working on employees_df and needs to add a new column where a 10% tax is calculated on the salary. Additionally, the DataFrame contains the column age, which is not needed.

Which code fragment adds the tax column and removes the age column?

Aemployees_df = employees_df.withColumn('tax', employees_df.salary * 10).dropField('age')

Bemployees_df = employees_df.withColumn('tax', employees_df.salary * 0.1).drop('age')

Cemployees_df = employees_df.withColumn('tax', lit(0.1) * col('salary')).dropField('age')

Demployees_df = employees_df.withColumn('tax', employees_df.salary * 10).drop('age')

Answer : B

Option B is correct after correcting the uploaded typo withcolumn to withColumn. A 10% tax is calculated by multiplying salary by 0.1, not by 10. The age column should be removed using .drop('age'). Options A and D multiply salary by 10, which calculates 1000%, not 10%. Options A and C also use dropField, which is not the correct DataFrame method for removing a top-level column. Official Databricks PySpark documentation states that withColumn adds or replaces a column and that drop(*cols) returns a new DataFrame without the specified columns.

Question 6

In which of the following scenarios should a data engineer select a Task in the Depends On field of a new Databricks Job Task?

AWhen another task needs to be replaced by the new task.

BWhen another task needs to fail before the new task begins.

CWhen another task has the same dependency libraries as the new task.

DWhen another task needs to use as little compute resources as possible.

EWhen another task needs to successfully complete before the new task begins.

Answer : E

Question 7

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

Which step will the data analyst need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

ACopy the Query and create one data visualization per query.

BAdd two separate visualizations to the dashboard based on the same Query.

CDecide on a single data visualization to add to the dashboard.

DAlter the Query to return two separate sets of results.

Answer : B