QuestionQ106

VerifiedPrepare data

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?

Explanation

Microsoft Fabric warehouse is the data store type that natively supports T-SQL queries, multi-table transactional operations, and dynamic data masking. Lakehouses support Spark and limited SQL; KQL databases are query-only; semantic models are for analytics/reporting only.

Community Discussion

No comments yet. Be the first to start the discussion!