
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer working on a lakehouse project, you are tasked with optimizing the partitioning strategy for a large dataset containing customer transaction data, initially partitioned by date. The goal is to enhance query performance while considering cost efficiency and scalability. The dataset includes transactions from various customer segments (premium, regular, loyalty), across different transaction types (online, in-store, mobile), and product categories (electronics, clothing, groceries). Given these requirements, which of the following partitioning strategies would BEST meet the project's needs? Choose one option.
A
Sub-partition the data solely by customer segment to target marketing analysis more efficiently.
B
Sub-partition the data solely by transaction type to streamline transaction processing reports.
C
Sub-partition the data solely by product category to improve inventory management queries.
D
Implement a combined sub-partitioning strategy using both customer segment and transaction type to optimize for a broader range of query scenarios.