DRAG DROP
You manage a SQL Server Reporting Services (SSRS) instance running in native mode.
You are troubleshooting a performance problem and need to know which reports are
frequently executed. You discover that the report server execution logs are empty, despite
significant report activity.
You need to ensure that the server is configured for report execution logging.
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 expplanation.
Explanation:
Box 1: Open SharePoint Central Administration.
Box 2: In the Application Management Group, click Manage Service Application.
Box 3: Enable the Enable report execution logging option.Note:
To enable execution logging:
1. From SharePoint Central Administration, clickManage service applicationsin
theApplication Managementgroup.
2. Click the name of the Reporting Services service application you want to configure.
3. ClickSystem Settings.
4. SelectEnable Execution Loggingin theLoggingsection.
5. ClickOK.
Reference: Report Server Execution Log and the ExecutionLog3 View
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image01611.jpg a
This is native mode, no Sharepoint:
https://msdn.microsoft.com/en-us/library/ms159110.aspx
“You can turn report execution logging on or off from the Server Properties page in SQL Server Management Studio. The EnableExecutionLogging is and Advanced property.”
https://msdn.microsoft.com/en-us/library/ms159110.aspx
https://msdn.microsoft.com/en-us/library/ms159110.aspx
Configuration Settings for a Native Mode Report Server
Start SQL Server Management Studio with administrative privileges. For example right-click the Management Studio icon and click ‘Run as administrator’.
Connect to the desired report server.
Right-click the server name and click Properties. If the Properties option is disabled, verify you ran SQL Server Management Studio with administrative privileges.
Click the Logging page.
Select Enable report execution Logging.
1-In Sql Server Management Studio, connect to …
2-Open the Server Properties window
3-Enable the Enable report…
exactly – this is not a sharepoint mode 🙂