hiexam
microsoft · AZ-305 · Q834 · hot_area · azure_data_pipeline, data_warehouse, serving_layer

HOTSPOT - You are designing a data pipeline that will integrate large amounts of data from multiple on-premises Micros…

HOTSPOT - 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. //IMG//
Correct region(s)

Answer hidden

Unlock AZ-305

First 5 questions of every exam are free. Unlock the rest.

Includes
  • · All — questions
  • · Verified answers + AI explanations
  • · Spaced-repetition mistake notebook
  • · Phone, tablet, laptop sync

One-time payment. Doesn't auto-renew. · Already paid? Sign in