Spring Sale Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple75

Pass the Databricks Certification Databricks-Certified-Data-Engineer-Associate Questions and answers with Dumpstech

Exam Databricks-Certified-Data-Engineer-Associate Premium Access

View all detail and faqs for the Databricks-Certified-Data-Engineer-Associate exam

Go to Exam

Practice at least 50% of the questions to maximize your chances of passing.

Viewing page 3 out of 6 pages

Viewing questions 21-30 out of questions

Questions # 21:

A data organization leader is upset about the data analysis team’s reports being different from the data engineering team’s reports. The leader believes the siloed nature of their organization’s data engineering and data analysis architectures is to blame.

Which of the following describes how a data lakehouse could alleviate this issue?

Options:

Both teams would autoscale their work as data size evolves

Both teams would use the same source of truth for their work

Both teams would reorganize to report to the same department

Both teams would be able to collaborate on projects in real-time

Both teams would respond more quickly to ad-hoc requests

Questions # 22:

A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF).

Which of the following code blocks creates this SQL UDF?

Questions # 23:

A Databricks single-task workflow fails at the last task due to an error in a notebook. The data engineer fixes the mistake in the notebook. What should the data engineer do to rerun the workflow?

Options:

Repair the task

Rerun the pipeline

Restart the Cluster

Switch the cluster

Questions # 24:

A data engineer wants to schedule their Databricks SQL dashboard to refresh every hour, but they only want the associated SQL endpoint to be running when it is necessary. The dashboard has multiple queries on multiple datasets associated with it. The data that feeds the dashboard is automatically processed using a Databricks Job.

Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?

Options:

They can turn on the Auto Stop feature for the SQL endpoint.

They can ensure the dashboard's SQL endpoint is not one of the included query's SQL endpoint.

They can reduce the cluster size of the SQL endpoint.

They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.

They can set up the dashboard's SQL endpoint to be serverless.

Questions # 25:

Which of the following describes the relationship between Gold tables and Silver tables?

Options:

Gold tables are more likely to contain aggregations than Silver tables.

Gold tables are more likely to contain valuable data than Silver tables.

Gold tables are more likely to contain a less refined view of data than Silver tables.

Gold tables are more likely to contain more data than Silver tables.

Gold tables are more likely to contain truthful data than Silver tables.

Questions # 26:

A data engineer is reviewing the documentation on audit logs in Databricks for compliance purposes and needs to understand the format in which audit logs output events.

How are events formatted in Databricks audit logs?

Options:

In Databricks, audit logs output events in a plain text format.

In Databricks, audit logs output events in a JSON format.

In Databricks, audit logs output events in an XML format.

In Databricks, audit logs output events in a CSV format.

Questions # 27:

Which SQL code snippet will correctly demonstrate a Data Definition Language (DDL) operation used to create a table?

Options:

DROP TABLE employees;

INSERT INTO employees (id, name) VALUES (1, 'Alice');

CRFATF tabif employees ( id INT, name suing

ALTFR TABIF employees add column salary DECTMA(10,2);

Questions # 28:

A new data engineering team team. has been assigned to an ELT project. The new data engineering team will need full privileges on the database customers to fully manage the project.

Which of the following commands can be used to grant full permissions on the database to the new data engineering team?

Options:

GRANT USAGE ON DATABASE customers TO team;

GRANT ALL PRIVILEGES ON DATABASE team TO customers;

GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;

GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;

GRANT ALL PRIVILEGES ON DATABASE customers TO team;

Questions # 29:

A single Job runs two notebooks as two separate tasks. A data engineer has noticed that one of the notebooks is running slowly in the Job’s current run. The data engineer asks a tech lead for help in identifying why this might be the case.

Which of the following approaches can the tech lead use to identify why the notebook is running slowly as part of the Job?

Options:

They can navigate to the Runs tab in the Jobs UI to immediately review the processing notebook.

They can navigate to the Tasks tab in the Jobs UI and click on the active run to review the processing notebook.

They can navigate to the Runs tab in the Jobs UI and click on the active run to review the processing notebook.

There is no way to determine why a Job task is running slowly.

They can navigate to the Tasks tab in the Jobs UI to immediately review the processing notebook.

Questions # 30:

A Data Engineer is building a simple data pipeline using Delta Live Tables (DLT) in Databricksto ingest customer data. The raw customer data is stored in a cloud storage location in JSON format. The task is to create a DLT pipeline that reads the rawJSON data and writes it into a Delta table for further processing.

Which code snippet will correctly ingest the raw JSON data and create a Delta table using DLT?

Question # 30

Options:

Option A

Option B

Option C

Option D

Viewing page 3 out of 6 pages

Viewing questions 21-30 out of questions