Home / DE Associate practice test / Governance and Security / Question

Databricks Data Engineer Associate · free practice question

A data engineer needs to let a team read and write data files at a specific cloud storage path that is registered in Unity Catalog as an external location. The…

Exam-style question on Governance and Security from the free DE Associate practice test, with the answer and a full explanation below.

Updated November 10, 2026

Governance and Security

A data engineer needs to let a team read and write data files at a specific cloud storage path that is registered in Unity Catalog as an external location. The engineer wants to grant the least privilege that still allows both reading and writing files at that governed path. Which grant should the engineer apply?

  1. AGrant CREATE EXTERNAL LOCATION on the storage credential, because holding that privilege on the underlying credential is what lets a team read and write the actual data files at the external location's registered path.
  2. BGrant MODIFY on the external location object, because MODIFY is the file-level write privilege for an external location and it transitively includes the ability to read all of the files that are stored at that path.
  3. CGrant READ FILES on the external location, which is enough for both operations because on an external location the read privilege also authorizes writing new files back into the same governed cloud storage path.
  4. DGrant ALL PRIVILEGES on the storage credential to the team, because file read and write access on any path is controlled at the storage-credential level rather than on the external location securable object itself.
  5. EGrant WRITE FILES on the external location, which itself requires READ FILES; because WRITE FILES depends on READ FILES, granting WRITE FILES gives the team both read and write access to files at the governed path.
Answer & explanation

Correct answer: E

WHY E: WRITE FILES on the external location requires READ FILES, so granting WRITE FILES yields both read and write on the path with the least privilege. WHY NOT A: CREATE EXTERNAL LOCATION governs who can create external locations, not who can read or write files at an existing one. WHY NOT B: External locations use READ FILES and WRITE FILES, not MODIFY, which is a table-level privilege. WHY NOT C: READ FILES authorizes reading only; it does not permit writing new files to the path. WHY NOT D: File access is granted on the external location securable, and ALL PRIVILEGES on the storage credential is both wrong and excessive.

Take the full DE Associate practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Data Engineer Associate practice test. Take it and get a section-by-section score.

Start the free test →