Question 1

A data analyst wants to create a dashboard with three main sections: Development, Testing, and Production. They want all three sections on the same dashboard, but they want to clearly designate the sections using text on the dashboard. Which of the following tools can the data analyst use to designate the Development, Testing, and Production sections using text?

Options :

A : Separate endpoints for each section

B : Separate queries for each section

C : Markdown-based text boxes

D : Direct text written into the dashboard in editing mode

E : Separate color palettes for each section

Answer: C

Question 2

In which of the following situations should a data analyst use higher-order functions?

Options :

A : When custom logic needs to be applied to simple, unnested data

B : When custom logic needs to be converted to Python-native code

C : When custom logic needs to be applied at scale to array data objects

D : When built-in functions are taking too long to perform tasks

E : When built-in functions need to run through the Catalyst Optimizer

Answer: C

Question 3

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?

Options :

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;

Answer: A

Question 4

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?

Options :

A :

B :

C :

D :

E :

Answer: E

Question 5

A business analyst has been asked to create a data entity/object called sales_by_employee. It should always stay up-to-date when new data are added to the sales table. The new entity should have the columns sales_person, which will be the name of the employee from the employees table, and sales, which will be all sales for that particular sales person. Both the sales table and the employees table have an employee_id column that is used to identify the sales person. Which of the following code blocks will accomplish this task?

Options :

A :

B :

C :

D :

E :

Answer: D

Free Databricks-Certified-Data-Analyst-Associate Mock Exam – Practice Online Confidently

Buying Options: