Online Access Free Databricks-Certified-Data-Analyst-Associate Practice Test

In which of the following situations will the mean value and median value of variable be meaningfully different?

• A.When the variable contains no outliers
• B.When the variable is of the categorical type
• C.When the variable contains a lot of extreme outliers
• D.When the variable contains no missing values
• E.When the variable is of the boolean type

A data analyst has created a Query in Databricks SQL, and now they want to create two data visualizations from that Query and add both of those data visualizations to the same Databricks SQL Dashboard.
Which of the following steps will they need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

• A.They will need to decide on a single data visualization to add to the dashboard.
• B.They will need to copy the Query and create one data visualization per query.
• C.They will need to add two separate visualizations to the dashboard based on the same Query.
• D.They will need to create two separate dashboards.
• E.They will need to alter the Query to return two separate sets of results.

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?

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

Which of the following statements about a refresh schedule is incorrect?

• A.Refresh schedules can be configured in the Query Editor.
• B.A query being refreshed on a schedule does not use a SQL Warehouse (formerly known as SQL Endpoint).
• C.You must have workspace administrator privileges to configure a refresh schedule
• D.A query can be refreshed anywhere from 1 minute lo 2 weeks
• E.A refresh schedule is not the same as an alert.

Which of the following describes how Databricks SQL should be used in relation to other business intelligence (BI) tools like Tableau, Power BI, and looker?

• A.As a complete replacement with additional functionality
• B.As a complementary tool for quick in-platform Bl work
• C.As a substitute with less functionality
• D.As a complementary tool for professional-grade presentations
• E.As an exact substitute with the same level of functionality