BenchMark Quizzes by MDFT Pro

Choose Storage For Multi-Engine Access

You work as a Data Platform Architect for Mark at MDFT Pro, a well-known training agency. MDFT Pro operates a Fabric workspace that handles various types of student and course data. Mark has assigned you the task of storing semi-structured data from student activity logs, course feedback forms, and learning management system events. The data architecture team at MDFT Pro needs to be able to read this data using multiple query engines: T-SQL for reporting dashboards, KQL for real-time analytics, and Apache Spark for machine learning workloads. However, all write operations will be performed exclusively using Spark to maintain consistency in the data ingestion pipeline. You need to choose the appropriate storage solution that supports this multi-engine access pattern.

What should you use to store the data?

Choose the correct answer from the options below.

Explanations for each answer:

A lakehouse is correct. A lakehouse supports reading data through multiple engines including T-SQL (via SQL analytics endpoint), KQL (via shortcuts or queries), and Apache Spark, while also supporting Spark-based writes. It's designed specifically for semi-structured data and multi-engine access patterns.
An eventhouse is incorrect. An eventhouse is optimized for real-time analytics and KQL queries on streaming data, but it doesn't provide native T-SQL access or support Spark-based writes as the primary write mechanism.
A datamart is incorrect. A datamart is designed for structured relational data and business intelligence workloads, but it doesn't support Apache Spark for writing data or KQL for querying, making it unsuitable for this requirement.
A warehouse is incorrect. While a warehouse supports T-SQL queries, it doesn't support KQL queries or Apache Spark as the write mechanism. Warehouses are optimized for structured data and SQL-based operations.

Learn more about Fabric lakehouses:

Fabric Lakehouse Overview

Practice Exam

Choose Storage For Multi-Engine Access

Discuss this question on social media: