Databricks SQL: Helpful questions and answers — Part 03

Part 1 | Part 2

Here are some popular questions and answers related to Databricks SQL. Some are Spark SQL related, and some are specific to the Databricks SQL environment.

These can be a reference for those interested in taking the Databricks Certified Data Analyst Associate exam.

Photo by Rohit Farmer on Unsplash

A data analyst is worried that their data’s mean value is affected by a few outliers. Which of the following data visualizations is best to show if this is the case?

- Boxplot
- Funnel
- Map - markers
- Counter

A data analyst needs to visualize the number of recorded cases of COVID-19 within Europe. Which of the following data visualizations is best suited to accomplish this?

- Stacked bar chart
- Map - choropleth
- Map - markers
- The counter

Which of the following visualization types is best suited to depict the results of this query?

SELECT order_date 
    FROM sales 
    WHERE order_date >= to_date('2020-01-01') 
    AND order_date <= to_date('2021-01-01');

- Funnel
- Stacked bar chart
- Bar chart
- Boxplot

Which of the following data visualizations displays a single number by default?

- Bar chart
- Counter
- Map - markers
- Funnel

Which of the following automations are available in Databricks SQL?

- Query refresh schedules
- Dashboard refresh schedules
- Alerts
- All of the above

Which of the following steps is optional when sharing the most recent results of a dashboard?

- Selecting a refresh interval
- Selecting a SQL warehouse to use to refresh the dashboard
- Set subscribers to be notified of dashboard results
- Set the dashboard refresh schedule to Enabled if it isn’t already.

Where will an alert be sent if no destination is specified for an alert?

- The email address of the workspace administrator
- The email addresses of any subscribed stakeholders
- The email address of the creator of the alert
- Nowhere; An error will be thrown when creating the alert.

What level of permissions is the owner of a query granted on their SQL query?

- Can View
- Can Run
- Can Edit
- Can Manage

Good Luck.

[embed]Join Medium with my referral link - Ganesh Chandrasekaran As a Medium member, a portion of your membership fee goes to writers you read, and you get full access to every story…ganeshchandrasekaran.com

[embed]Get an email whenever Ganesh Chandrasekaran publishes. Edit descriptionganeshchandrasekaran.com