Fundamentals of Microsoft Fabric

Chapter 18. Fabric Decision Guide: When to Choose What

You’ve come a long way by reading this book so far, and you should be well equipped with a thorough understanding of the individual Microsoft Fabric components.

We like to think about this chapter as a puzzle. You know the feeling when you start building a jigsaw—you are very aware of each piece and what’s displayed on it. Not only that, but there are probably pieces that seem to be the right shape to fit here and there in the jigsaw. But, are these pieces really in the right spot? Or, should you use another one? Consider this chapter the final jigsaw: you know each and every individual piece, and we will now help you put all of these pieces into the right place.

How to Pick the Right Option

Microsoft Fabric is all about the options. As you’ve seen up to this point in the book, the same task can often be completed in multiple ways. And it doesn’t necessarily follow that one way is better than the other. Sometimes, it boils down to the skill set of the individuals in your organization performing the data task, or maybe it’s just a personal preference. Sometimes, however, these decisions might have a larger impact on the entire data platform workload. Therefore, it is of paramount importance to understand the implications of choosing Option A versus Option B to complete Task XYZ in Microsoft Fabric.

In the following sections, we’ll do our best to provide you with guidance on the most common Fabric dilemmas. Please bear in mind ...