Knowledge check

Which ALTER DATABASE statement parameter allows a dedicated SQL pool to scale?

SCALE.

MODIFY

CHANGE.

Which workload management feature influences the order in which a request gets access to resources?

Workload classification.

Workload importance.

Workload isolation.

Which Dynamic Management View enables the view of the active connections against a dedicated SQL pool?

sys.dm_pdw_exec_requests.

sys.dm_pdw_dms_workers.

DBCC PDW_SHOWEXECUTIONPLAN.

You must answer all questions before checking your work.

Feedback