Online Access Free Databricks-Certified-Data-Analyst-Associate Exam Questions

What does Partner Connect do when connecting Power Bl and Tableau?

• A.Creates a Personal Access Token for authentication into Databricks SQL and emails it to you.
• B.Creates a Personal Access Token. downloads and installs an ODBC driver, and downloads a configuration file for connection by Power Bl or Tableau to a SQL Warehouse (formerly known as a SQL Endpoint).
• C.Downloads a configuration file for connection by Power Bl or Tableau to a SQL Warehouse (formerly known as a SQL Endpoint).
• D.Downloads and installs an ODBC driver.

A data analyst needs to use the Databricks Lakehouse Platform to quickly create SQL queries and data visualizations. It is a requirement that the compute resources in the platform can be made serverless, and it is expected that data visualizations can be placed within a dashboard.
Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?

• A.Delta Lake
• B.Tableau
• C.Databricks SQL
• D.Databricks Machine Learning
• E.Databricks Notebooks

Data professionals with varying responsibilities use the Databricks Lakehouse Platform Which role in the Databricks Lakehouse Platform use Databricks SQL as their primary service?

• A.Business analyst
• B.Data scientist
• C.Data engineer
• D.Platform architect

A data analyst has been asked to configure an alert for a query that returns the income in the accounts_receivable table for a date range. The date range is configurable using a Date query parameter.
The Alert does not work.
Which of the following describes why the Alert does not work?

• A.The wrong query parameter is being used. Alerts only work with drogdown list query parameters, not dates.
• B.Queries that use query parameters cannot be used with Alerts.
• C.Alerts don't work with queries that access tables.
• D.Queries that return results based on dates cannot be used with Alerts.
• E.The wrong query parameter is being used. Alerts only work with Date and Time query parameters.

Which of the following statements describes descriptive statistics?

• A.A branch of statistics that uses quantitative variables that must take on an uncountable set of values.
• B.A branch of statistics that uses quantitative variables that must take on a finite or countably infinite set of values.
• C.A branch of statistics that uses a variety of data analysis techniques to infer properties of an underlying distribution of probability.
• D.A branch of statistics that uses summary statistics to categorically describe and summarize data.
• E.A branch of statistics that uses summary statistics to quantitatively describe and summarize data.