QuestionQ6

VerifiedMonitor and optimize an analytics solution

You have a Fabric workspace that includes a semantic model called Model1.

You need to dynamically run and monitor Model1's refresh progress.

What should you use?

Explanation

SQL Server Management Studio can connect to a Fabric semantic model through the XMLA endpoint, issue TMSL refresh commands, and query Dynamic Management Views (DMVs). DMVs return Analysis Services server-state information such as active commands and executing jobs, which supports monitoring an in-progress refresh.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!