A data engineer needs to use a Delta table as part of a data pipeline, but they do not know if they have the appropriate permissions.
In which of the following locations can the data engineer review their permissions on the table?

• A.Databricks Filesystem
• B.Jobs
• C.Dashboards
• D.Repos
• E.Data Explorer

Comment: *

Name: *

Email: *

Verification: *

A data engineer is maintaining a data pipeline. Upon data ingestion, the data engineer notices that the source data is starting to have a lower level of quality. The data engineer would like to automate the process of monitoring the quality level.
Which of the following tools can the data engineer use to solve this problem?

• A.Unity Catalog
• B.Data Explorer
• C.Delta Lake
• D.Delta Live Tables
• E.Auto Loader

Comment: *

Name: *

Email: *

Verification: *

A data engineer wants to schedule their Databricks SQL dashboard to refresh once per day, but they only want the associated SQL endpoint to be running when it is necessary.
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?

• A.They can set up the dashboard's SQL endpoint to be serverless.
• B.They can turn on the Auto Stop feature for the SQL endpoint.
• C.They can ensure the dashboard's SQL endpoint is not one of the included query's SQL endpoint.
• D.They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.
• E.They can reduce the cluster size of the SQL endpoint.

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands will return the location of database customer360?

• A.ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};
• B.DROP DATABASE customer360;
• C.DESCRIBE DATABASE customer360;
• D.USE DATABASE customer360;
• E.DESCRIBE LOCATION customer360;

Comment: *

Name: *

Email: *

Verification: *

A data engineer needs to create a table in Databricks using data from a CSV file at location /path/to/csv.
They run the following command:

Which of the following lines of code fills in the above blank to successfully complete the task?

• A.None of these lines of code are needed to successfully complete the task
• B.USING CSV
• C.FROM CSV
• D.USING DELTA
• E.FROM "path/to/csv"

Comment: *

Name: *

Email: *

Verification: *