This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Which is the default distribution used for a table in Synapse Analytics?
HASH.
Round-Robin.
Replicated Table.
Which Index Type offers the highest compression?
Columnstore.
Rowstore.
Heap.
How do column statistics improve query performance?
By keeping track of which columns are being queried.
By keeping track of how much data exists between ranges in columns.
By caching column values for queries.
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?