Finding the right Azure tool for the right purpose

Now that we have a more detailed generic picture of the components that make a modern data warehouse, let's examine the available Azure services. We will try to identify the ones that are suitable for your requirements. All the following services are classified as Platform-as-a-Service (PaaS) components. And, as a consultant will always tell you, it depends.

While going through your engineered requirements, you should have a picture in mind of where you want to go. You will know about the data volume, data formats and sources, your transformations, the presentation strategy, and all the questions from the first section of this chapter (see Asking in the right direction).

The answers to the questions about volume, for example, together with data formats, will play a vital role in you selecting your storage component. They will point you to the DBs service that you will choose to implement your presentation layer in. There...