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?
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.