Implementing Analytics Solutions Using Microsoft Fabric — Question 177

You plan to use Fabric to store data.

You need to create a data store that supports the following:

• Writing data by using T-SQL
• Multi-table transactions
• Dynamic data masking

Which type of data store should you create?

Answer options

• A. KQL database
• B. lakehouse
• C. warehouse
• D. semantic model

Correct answer: C

Explanation

The correct answer is C, 'warehouse', as it is designed for multi-table transactions and supports T-SQL for writing data along with dynamic data masking capabilities. Options A and B do not inherently offer support for multi-table transactions in the same way, and option D refers to a modeling approach rather than a data storage solution.