Which three actions should you perform in sequence?

DRAG DROP
You administer a SQL Server Analysis Services (SSAS) instance.
You need to capture a continuous log of detailed event and subevent durations and custom
trace events from queries executed in the SSAS instance.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

DRAG DROP
You administer a SQL Server Analysis Services (SSAS) instance.
You need to capture a continuous log of detailed event and subevent durations and custom
trace events from queries executed in the SSAS instance.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

Answer: See the explanation

Explanation:
Box 1: Write an XMLA script to log the extended events of the trace.
Box 2: Launch SQL Server Management Studio and connect to the instance.
Box 3: Execute the script.

Note:
* Auditing an instance of SQL Server or a SQL Server database involves tracking and
logging events that occur on the system. The SQL Server Audit object collects a single
instance of server- or database-level actions and groups of actions to monitor. The audit is at
the SQL Server instance level. You can have multiple audits per SQL Server instance. The
Server Audit Specification object belongs to an audit. You can create one server audit
specification per audit, because both are created at the SQL Server instance scope.
* Trace events can be started and captured using SQL Server Profiler, , or can be started
from an XMLA command as SQL Server Extended Events and later analyzed.
* Extended Event tracing is enabled using a similar XMLA create object script.

Analysis Services Trace Events



Leave a Reply 8

Your email address will not be published. Required fields are marked *


Fabio J.

Fabio J.

Launch SQL Server Managment Studio and connect to the instance.

Write an XMLA script to log the Extended Events of the trace.

Execute the script.

Smorc

Smorc

Box2: catalog.execution_component_phases – catalog.executions view

SZ

SZ

based on scenario it should capture the control flow task so it has to be catalog.executables
The answer is correct

Smorc

Smorc

Well ok, i did not take this into consideration – but how can you compare durations, when there is no information about start or endtime in the catalog.executables view? Would appreciate if you could explain this.

RAUL

RAUL

If you read the 31 question explanation you will see that both answers are wrong.
Catalog.executions is the right answer in both questions.

c

c

Agree with Fabio

d

d

agree, executions

Ansuman

Ansuman

catalog.execution_component_phases with
catalog.executions will give the whole flow of data