Databricks Certified Data Analyst Associate — Question 33

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?

Answer options

• A. Violin Chart
• B. Line Chart
• C. Bar Chart
• D. Histogram
• E. There is no default. The user must choose a visualization type.

Correct answer: C

Explanation

The default visualization type for a result set with categorical data (region) and numerical data (number_of_customer) in Databricks SQL is a Bar Chart, which effectively displays comparisons between different categories. The other options are either not suitable for this type of data or do not serve as defaults in this context.