You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A server named ABC-SSAS1 runs SQL Server Analysis Services (SSAS).
You are in the process of designing a monitoring strategy for the ABC-SSAS1. You want to
monitor custom trace events and detailed event durations for queries executed on the
server.
You connect to ABC-SSAS1 using SQL Server Management Studio.
Which two of the following actions should you perform next? (Choose two)
A.
Create a script that queries the DISCOVER_TRACES DMV (Dynamic Management View)
using MDX (Multidimensional Expressions).
B.
Modify the configuration of the trace to save the data in a table in a SQL Server database.
C.
Run the script.
D.
Create a script using XMLA to log the extended events of the trace.
E.
Connect to ABC-SSAS1 using SQL Server Profiler and run the script.
Explanation:
Could be CD also..
D, C