Databricks Certified Data Analyst Associate - Databricks-Certified-Data-Analyst-Associate FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A data analyst needs to share a Databricks SQL dashboard with stakeholders that are not permitted to have accounts in the Databricks deployment. The stakeholders need to be notified every time the dashboard is refreshed.
Which approach can the data analyst use to accomplish this task with minimal effort/

A. By granting the stakeholders' email addresses to the SQL Warehouse (formerly known as endpoint) subscribers list B. By adding the stakeholders' email addresses to the refresh schedule subscribers list C. By downloading the dashboard as a PDF and emailing it to the stakeholders each time it is refreshed D. By granting the stakeholders' email addresses permissions to the dashboard

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 2

A data analyst runs the following command:
SELECT age, country
FROM my_table
WHERE age >= 75 AND country = 'canada';
Which of the following tables represents the output of the above command?

A.

B.

C.

D.

E.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 3

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. Data engineer B. Business analyst C. Platform architect D. Data scientist

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

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. Databricks Notebooks B. Tableau C. Databricks Machine Learning D. Databricks SQL E. Delta Lake

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

A data analyst is processing a complex aggregation on a table with zero null values and their query returns the following result:

Which of the following queries did the analyst run to obtain the above result?

A.

B.

C.

D.

E.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

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

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

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

What describes Partner Connect in Databricks?

A. It exposes connection information to third-party tools via Databricks partners. B. it allows multi-directional connection between Databricks and Databricks partners easier. C. it allows for free use of Databricks partner tools through a common API. D. It is a feature that runs Databricks partner tools on a Databricks SQL Warehouse (formerly known as a SQL endpoint).

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).