Instructor's Method - 6/15/2021

Question 1

PolyBase

Answer 1

One technology to help load data from data lake to dedicated SQL pool

Question 2

Different distribution methods

Answer 2

Round Robin - data is (almost) equally divided amongst different distributions

Hash Distributed - data will be co-located based on Hash column

Question 3

Round Robin

Answer 3

Don’t have to define/analyze in which distributions should I store the data

But reading data is slow

Question 4

Hash Distribution

Answer 4

Dedicated SQL pool will look into value of hash column, perform the hash, and then store it into distribution

Writing will be slower. Because Dedicated SQL pool has to apply logic (hash) to decide in which distribution to store

Question 5

Best Practice

Answer 5

Make sure you have at least 60 distinct values in hash column

Column that you choose should spread the data “as equally as possible”

Choose a column that will mostly be used in WHERE, JOINS, GROUP BY, etc.

Question 6

CTAS

Answer 6

Create Table as SELECT

Question 7

Concurrency slots

Answer 7

A set of resources

Question 8

Resource Classes

Answer 8

Defines # slots allocated

Question 9

Resource Classes

Answer 9

Defines # slots allocated to use

Question 10

Data warehousing unit

Answer 10

Decides # concurrency slots you are going to get

The performance level

Question 11

Synapse Pipelines

Answer 11

Shares code base with Azure Data Factory