Get Databricks Databricks-Certified-Data-Analyst-Associate Dumps Questions Study Exam Guide Jul 11, 2024 [Q27-Q48]

QUESTION 27
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?

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

Use Workflows to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with

Use Delta Live Tables to establish a cluster for Fivetran to interact with

Use Partner Connect’s automated workflow to establish a cluster for Fivetran to interact with

Use Partner Connect’s automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with

Use Workflows to establish a cluster for Fivetran to interact with

QUESTION 29
The stakeholders.customers table has 15 columns and 3,000 rows of data. 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?

The view remains available and SELECT * FROM stakeholders.eur_customers will execute correctly.

The view has been dropped.

The view is not available in the metastore, but the underlying data can be accessed with SELECT * FROM delta. `stakeholders.eur_customers`.

The view remains available but attempting to SELECT from it results in an empty result set because data in views are automatically deleted after logging out.

The view has been converted into a table.

QUESTION 30
Which of the following approaches can be used to ingest data directly from cloud-based object storage?

It is not possible to directly ingest data from cloud-based object storage

Create an external table while specifying the object storage path to LOCATION

Create an external table while specifying the DBFS storage path to FROM

Create an external table while specifying the DBFS storage path to PATH

Create an external table while specifying the object storage path to FROM

QUESTION 31
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?

Separate endpoints for each section

Separate queries for each section

Markdown-based text boxes

Direct text written into the dashboard in editing mode

Separate color palettes for each section

QUESTION 32
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?

QUESTION 33
Which of the following is a benefit of Databricks SQL using ANSI SQL as its standard SQL dialect?

It has increased customization capabilities

It is easy to migrate existing SQL queries to Databricks SQL

It allows for the use of Photon’s computation optimizations

It is more performant than other SQL dialects

It is more compatible with Spark’s interpreters

QUESTION 34
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?

Delta Lake

Databricks Notebooks

Tableau

Databricks Machine Learning

Databricks SQL

QUESTION 35
A data analyst has been asked to produce a visualization that shows the flow of users through a website.
Which of the following is used for visualizing this type of flow?

Heatmap

IChoropleth

Word Cloud

Pivot Table

Sankey

QUESTION 36
Which of the following should data analysts consider when working with personally identifiable information (PII) data?

Organization-specific best practices for Pll data

Legal requirements for the area in which the data was collected

None of these considerations

Legal requirements for the area in which the analysis is being performed

All of these considerations

QUESTION 37
A data analyst is working with gold-layer tables to complete an ad-hoc project. A stakeholder has provided the analyst with an additional dataset that can be used to augment the gold-layer tables already in use.
Which of the following terms is used to describe this data augmentation?

Data testing

Ad-hoc improvements

Last-mile

Last-mile ETL

Data enhancement

QUESTION 38
Which of the following statements about adding visual appeal to visualizations in the Visualization Editor is incorrect?

Visualization scale can be changed.

Data Labels can be formatted.

Colors can be changed.

Borders can be added.

Tooltips can be formatted.

QUESTION 39
Which of the following layers of the medallion architecture is most commonly used by data analysts?

None of these layers are used by data analysts

Gold

All of these layers are used equally by data analysts

Silver

Bronze

QUESTION 40
A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist.
Which of the following commands can the analyst use to complete the task without producing an error?

DROP DATABASE database_name;

DELETE TABLE database_name.table_name;

DROP TABLE database_name.table_name;

DELETE TABLE table_name FROM database_name;

DROP TABLE table_name FROM database_name;

QUESTION 41
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?

array distinct(produces)

explode(produces)

reduce(produces)

array(produces)

flatten(produces)

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

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

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

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

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

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

QUESTION 43
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?

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

Set a refresh schedule for the dashboard and enter the client’s email address in the “Subscribers” box.

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

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

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

QUESTION 44
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?

Violin Chart

Line Chart

IBar Chart

Histogram

There is no default. The user must choose a visualization type.

QUESTION 45
A data analyst has been asked to use the below table sales_table to get the percentage rank of products within region by the sales:

The result of the query should look like this:

Which of the following queries will accomplish this task?
A)

B)

C)