Model, query, and explore data in Azure Synapse

Question 1

function used to read the data that are stored in files in a data lake

Answer 1

OPENROWSET

Question 1

difference between dedicated SQL pool and serverless SQL pool

Answer 1

serverless used to perform SQL queries on files; dedicated defines a relational database in which data can be stored and queried

Question 2

external database object that encapsulates the connection info to a file location in a data lake store

Answer 2

DATA SOURCE

Question 3

how to analyze parquet file using Spark

Answer 3

load the parquet file directly into a Spark dataframe (no need to first load data into a serverless SQL pool)

Question 4

HASH vs ROUND_ROBIN

Answer 4

HASH provides good read performance for a large table by distributing records across compute nodes based on the hash key

ROUND_ROBIN distributes data evenly, but does not optimize queries on commonly used distribution key fields