Free Access GAQM.Databricks-Certified-Data-Engineer-Associate.v2025-10-18.q113 Practice Test (Page 23)

Question 106

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?

Question 107

A data engineer has three tables in a Delta Live Tables (DLT) pipeline. They have configured the pipeline to drop invalid records at each table. They notice that some data is being dropped due to quality concerns at some point in the DLT pipeline. They would like to determine at which table in their pipeline the data is being dropped.
Which of the following approaches can the data engineer take to identify the table that is dropping the records?

A.They can set up separate expectations for each table when developing their DLT pipeline.

B.They cannot determine which table is dropping the records.

C.They can set up DLT to notify them via email when records are dropped.

D.They can navigate to the DLT pipeline page, click on each table, and view the data quality statistics.

E.They can navigate to the DLT pipeline page, click on the "Error" button, and review the present errors.

Question 108

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?

A.GRANT USAGE ON DATABASE customers TO team;

B.GRANT ALL PRIVILEGES ON DATABASE customers TO team;

C.GRANT ALL PRIVILEGES ON DATABASE team TO customers;

D.GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;

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

Question 109

A data engineer is designing a data pipeline. The source system generates files in a shared directory that is also used by other processes. As a result, the files should be kept as is and will accumulate in the directory. The data engineer needs to identify which files are new since the previous run in the pipeline, and set up the pipeline to only ingest those new files with each run.
Which of the following tools can the data engineer use to solve this problem?

A.Unity Catalog

B.Data Explorer

C.Databricks SQL

D.Delta Lake

E.Auto Loader

Question 110

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to an ELT job. The ELT job has its Databricks SQL query that returns the number of input records containing unexpected NULL values. The data engineer wants their entire team to be notified via a messaging webhook whenever this value reaches 100.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of NULL values reaches 100?

A.They can set up an Alert with a custom template.

B.They can set up an Alert with a new email alert destination.

C.They can set up an Alert with a new webhook alert destination.

D.They can set up an Alert with one-time notifications.

E.They can set up an Alert without notifications.

Other Version: 873GAQM.Databricks-Certified-Data-Engineer-Associate.v2024-11-27.q107

Latest Upload: 206CuramSoftware.CS0-003.v2025-10-18.q211; 180GAQM.Databricks-Certified-Data-Engineer-Associate.v2025-10-18.q113; 132SAP.C-C4HCX-2405.v2025-10-17.q85; 180Huawei.H12-831_V1.0.v2025-10-16.q126; 142SAP.C-THR70-2411.v2025-10-16.q55; 153ISTQB.ISTQB-CTAL-TA.v2025-10-15.q36; 167SAP.C-S4CFI-2408.v2025-10-15.q86; 159Oracle.1z1-076.v2025-10-15.q59; 184HP.HPE7-A08.v2025-10-15.q85; 251Docker.DCA.v2025-10-15.q113

Question 106

Question 107

Question 108

Question 109

Question 110

Download PDF File