Question 100
A SQL developer needs read-only table metadata from a Microsoft Fabric lakehouse through a supported MCP tool. Initial testing shows: Queries enumerate only authorized schemas without row-data exfiltration. Which limitation should the team still consider?
Explanation
Correct Answer
Schema listings can still reveal sensitive dataset names. Connector tools should expose only approved metadata and authenticate with scoped identities. Register a trusted read-only lakehouse MCP tool in a restricted development context.
Incorrect Answers
The selected read-only metadata operation is not a row-write path; the relevant outstanding risk is disclosure through names and structure.
TLS protects transit but cannot prevent an authorized principal from receiving sensitive dataset names.
Even permitted metadata fields can reveal sensitive business projects; reviewers must still account for dataset-name disclosure.