Which two of the following actions should you perform next?

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)

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:



Leave a Reply 2

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


Andres

Andres

Could be CD also..

Mahmoud Ibrahim

Mahmoud Ibrahim

D, C