BenchMark Quizzes by MDFT Pro

Choose the Correct Data Store Type

You work for MDFT Pro, a well-known training agency. You need to create a data store in Fabric that supports writing data using T-SQL, multi-table transactions, and dynamic data masking.

Which type of data store should you create?

Choose the correct answer from the options below.

Explanations for each answer:

Warehouse is correct.
Semantic Model is incorrect. A semantic model is used for creating business intelligence reports and analytics, not for storing and managing data with T-SQL operations.
KQL Database is incorrect. A KQL database is designed for log and time-series data analysis using Kusto Query Language, not for T-SQL operations or multi-table transactions.
Lakehouse is incorrect. A lakehouse combines data lake and data warehouse capabilities but is primarily optimized for big data analytics and doesn't fully support all T-SQL features like dynamic data masking.

Learn more about Fabric Warehouses:

Fabric Warehouses

Exam Preparation Quiz

Choose the Correct Data Store Type