You are designing a data pipeline that will integrate large amounts of data from multiple...

You are designing a data pipeline that will integrate large amounts of data from multiple on-premises Microsoft SQL Server databases into an analytics platform in Azure. The pipeline will include the following actions:

• Database updates will be exported periodically into a staging area in Azure Blob storage.

• Data from the blob storage will be cleansed and transformed by using a highly parallelized load process.

• The transformed data will be loaded to a data warehouse.

• Each batch of updates will be used to refresh an online analytical processing (OLAP) model in a managed serving layer.

• The managed serving layer will be used by thousands of end users.

You need to implement the data warehouse and serving layers.

What should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.