MDFT Academy Quizzes

Configure OneLake Security Permissions

You work for MDFT Academy, a well-known training agency that uses Microsoft Fabric for data analytics. You need to configure OneLake security for users shown in the following table.

Name	Required access
MARK	Read all the Spark data.
CLAIRE	Read all the SQL endpoint data.

The solution must follow the principle of least privilege. Which permission should you assign to CLAIRE?

Choose the correct answer from the options below.

Explanations for each answer:

Read is incorrect. The Read permission only grants access to metadata and item properties, but not to actual data content. This is insufficient for reading SQL endpoint data.
ReadAll is incorrect. The ReadAll permission does not grant access to SQL endpoint data. It only provides access to OneLake data and metadata, but not SQL endpoint data.
ReadData is correct.
Write is incorrect. The Write permission grants full write access to data, which exceeds the requirement of only reading SQL endpoint data and violates the principle of least privilege.

Exam Preparation Quiz

Configure OneLake Security Permissions