CERTIFIED-DATA-ANALYST-ASSOCIATE Question #17: Real Exam Question with Answer & Explanation

Question

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?

Options

• AViolin Chart
• BLine Chart
• CBar Chart
• DHistogram
• EThere is no default. The user must choose a visualization type.

Explanation

Databricks SQL defaults to a Bar Chart when you click "Add visualization" on a result set containing one categorical (STRING) column and one numeric (INT) column, because this combination naturally maps to a bar chart - categories on the x-axis, counts/values on the y-axis. A Violin Chart (A) requires a continuous distribution dataset, not categorical + count data. A Line Chart (B) requires a time-series or ordered numeric x-axis, not a STRING region column. A Histogram (D) requires a single numeric column to bin, not a categorical + numeric pair. Option E is wrong because Databricks does have a default - it intelligently infers the best chart type from your schema. Memory tip: Think "category + number = bar" - whenever Databricks sees a string column paired with a numeric column, it assumes you want to compare values across categories, which is the textbook use case for a bar chart.

No community discussion yet for this question.