SQL Flashcards
1
Q
dedicated SQL pool
A
used for ingesting large amounts of data into its own storage system
2
Q
serverless SQL pool
A
doesn’t hold any data itself, but connect to external data
3
Q
filepath SQL function (serverless SQL pool)
A
returns the folder path and folder name from the storage account that a particular row of data that is returned in a SQL query originated from
4
Q
file types that serverless can process
A
delimited files
analytical file types (parquet and delta)
JSON
5
Q
predict SQL function (dedicated SQL pool)
*only supports ONNX model
A
6
Q
parameters for predict SQL function
A
7
Q
A