| Exam Name: | Databricks Certified Data Engineer Associate Exam | ||
| Exam Code: | Databricks-Certified-Data-Engineer-Associate Dumps | ||
| Vendor: | Databricks | Certification: | Databricks Certification |
| Questions: | 176 Q&A's | Shared By: | aila |
A data engineer has joined an existing project and they see the following query in the project repository:
CREATE STREAMING LIVE TABLE loyal_customers AS
SELECT customer_id -
FROM STREAM(LIVE.customers)
WHERE loyalty_level = ' high ' ;
Which of the following describes why the STREAM function is included in the query?
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?
Which of the following describes a scenario in which a data engineer will want to use a single-node cluster?
A data engineer manages multiple external tables linked to various data sources. The data engineer wants to manage these external tables efficiently and ensure that only the necessary permissions are granted to users for accessing specific external tables.
How should the data engineer manage access to these external tables?