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: *

Which of the following commands will return the number of null values in the member_id column?

• A.SELECT count(member_id) FROM my_table;
• B.SELECT count(member_id) - count_null(member_id) FROM my_table;
• C.SELECT count_if(member_id IS NULL) FROM my_table;
• D.SELECT null(member_id) FROM my_table;
• E.SELECT count_null(member_id) FROM my_table;

Comment: *

Name: *

Email: *

Verification: *

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.Data Explorer
• B.Databricks Filesystem
• C.Jobs
• D.Repos
• E.Dashboards

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Both teams would autoscale their work as data size evolves
• B.Both teams would use the same source of truth for their work
• C.Both teams would reorganize to report to the same department
• D.Both teams would be able to collaborate on projects in real-time
• E.Both teams would respond more quickly to ad-hoc requests

Comment: *

Name: *

Email: *

Verification: *

A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version, they are unable to restore the data because the data files have been deleted.
Which of the following explains why the data files are no longer present?

• A.The VACUUM command was run on the table
• B.The TIME TRAVEL command was run on the table
• C.The DELETE HISTORY command was run on the table
• D.The OPTIMIZE command was nun on the table
• E.The HISTORY command was run on the table

Comment: *

Name: *

Email: *

Verification: *