Azure Data Warehouse

Question 1

What is the computing expression for systems utilizing control and storage nodes to scale processing?

Answer 1

MPP - Massively parallel processing

Question 2

What are the 2 types of node within the Azure Data Warehouse

Answer 2

1) Compute

2) Control

Question 3

What is the unit of measure for Data Warehouse processing power and how many control and compute nodes does 200 give you?

Answer 3

200 DWU’s (Data Warehouse Unit) gives you

1 Control node and 2 compute nodes

Question 4

How does the data warehouse process a polybase query.

Answer 4

1) The control node uses the cost base optimization and creates a plan.
2) The control node issues instructions to the compute nodes.
3) The compute nodes uses the data movement service (DMS) to communicate with the hadoop distributed file system (HDFS)