Databricks Certified Data Analyst Associate Dumps Questions – Effective Way to Get Certified

1. Query History provides Databricks SQL users with a lot of benefits. A data analyst has been asked to share all of these benefits with their team as part of a training exercise. One of the benefit statements the analyst provided to their team is incorrect.

Which statement about Query History is incorrect?

2. A data analysis team is working with the table_bronze SQL table as a source for one of its most complex projects. A stakeholder of the project notices that some of the downstream data is duplicative. The analysis team identifies table_bronze as the source of the duplication.

Which of the following queries can be used to deduplicate the data from table_bronze and write it to a new table table_silver?

A) CREATE TABLE table_silver AS SELECT DISTINCT *

FROM table_bronze;

B) CREATE TABLE table_silver AS

INSERT *

FROM table_bronze;

C) CREATE TABLE table_silver AS

MERGE DEDUPLICATE *

FROM table_bronze;

D) INSERT INTO TABLE table_silver

SELECT * FROM table_bronze;

E) INSERT OVERWRITE TABLE table_silver

SELECT * FROM table_bronze;

3. A data scientist has asked a data analyst to create histograms for every continuous variable in a data set. The data analyst needs to identify which columns are continuous in the data set.

What describes a continuous variable?

4. An analyst writes a query that contains a query parameter. They then add an area chart visualization to the query. While adding the area chart visualization to a dashboard, the analyst chooses "Dashboard Parameter" for the query parameter associated with the area chart.

Which of the following statements is true?

5. A data analyst has been asked to provide a list of options on how to share a dashboard with a client. It is a security requirement that the client does not gain access to any other information, resources, or artifacts in the database.

Which of the following approaches cannot be used to share the dashboard and meet the security requirement?

A. Download the Dashboard as a PDF and share it with the client.

B. Set a refresh schedule for the dashboard and enter the client's email address in the "Subscribers" box.

C. Take a screenshot of the dashboard and share it with the client.

D. Generate a Personal Access Token that is good for 1 day and share it with the client.

E. Download a PNG file of the visualizations in the dashboard and share them with the client.

6. 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?

7. Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?

8. A data analyst wants the following output:

Which statement will produce this output?

9. 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)

10. A stakeholder has provided a data analyst with a lookup dataset in the form of a 50-row CSV file. The data analyst needs to upload this dataset for use as a table in Databricks SQL.

Which approach should the data analyst use to quickly upload the file into a table for use in Databricks SOL?

11. A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.

Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?

12. A data engineer is working with a nested array column products in table transactions. They want to expand the table so each unique item in products for each row has its own row where the transaction_id column is duplicated as necessary.

They are using the following incomplete command:





Which of the following lines of code can they use to fill in the blank in the above code block so that it successfully completes the task?

13. What describes the variance of a set of values?

14. Which statement describes descriptive statistics?

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





Which query did the analyst execute in order to get this result?

A)





B)





C)





D)

16. The stakeholders.customers table has 15 columns and 3,000 rows of dat a. The following command is run:





After running SELECT * FROM stakeholders.eur_customers, 15 rows are returned. After the command executes completely, the user logs out of Databricks.

After logging back in two days later, what is the status of the stakeholders.eur_customers view?

17. Delta Lake stores table data as a series of data files, but it also stores a lot of other information.

Which of the following is stored alongside data files when using Delta Lake?

18. What is a benefit of using Databricks SQL for business intelligence (Bl) analytics projects instead of using third-party Bl tools?

19. 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?

20. A data analyst has created a user-defined function using the following line of code:

CREATE FUNCTION price (spend DOUBLE, units DOUBLE)

RETURNS DOUBLE

RETURN spend / units;

Which of the following code blocks can be used to apply this function to the customer_spend and customer_units columns of the table customer_summary to create column customer_price?