Which two actions should you perform?
You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) instance.
You need to perform the following tasks:
Permit data sources to use the No credentials option.
Access Report Manager by using Secure Sockets Layer (SSL).
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
Which two actions should you perform?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. All company servers run Windows Server 2003 and are part of an Active Directory domain. Company policy states that all servers are shut down each night. A SQL Server Agent backup job is configured to run on AIOTestKing A each morning at 09:00.
On the mornings when AIOTestKing A has not been turned on by 09:00, the job fails to start, and you must manually start it. You need to ensure that AIOTestKing A is backed up automatically each morning. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
What should you do?
You are managing a Microsoft SQL Server 2005 Reporting Services (SSRS) solution. The current reporting solution consists of a single computer that hosts both the Web server components and the database server components of SSRS. This computer is dedicated to the sales department. The company security policy requires a separate SSRS solution for the payroll department. There is no budget for any new hardware. You need to isolate the security models of each department without using separate Web servers or database servers. What should you do?
What should you do?
You are the database administrator for AIOTestKing.com. The company uses a SQL Server 2005 database to track online sales. Employees who run the In-Stock report experience slow performance. This performance problem is caused by the contention between the In-Stock report and high volume of data entry to the tables that are accessed in this report. The company wants the In-Stock report returned immediately even though other employees might be changing the data within their data-entry transactions. Any changes made in other transactions while the report is running must be visible to the employees who are running the In-Stock report. You need to design a solution to achieve this goal.
What should you do?
What should you do?
You are creating a Microsoft SQL Server 2005 Reporting Services (SSRS) report. You deploy a new report by using Business Intelligence Development Studio (BIDS) from a test environment. Previously deployed reports display errors indicating unavailable production servers. You need to modify the SSRS project by using BIDS to allow the previously deployed data sources to work properly. What should you do?
What are two possible ways to achieve this goal?
You are a database administrator for AIOTestKing.com. You create a maintenance plan that includes shrinking your SQL Server 2005 databases and reorganizing your indexes once a week. You test the plan and discover that the database does not shrink as expected. You need to troubleshoot why the database is not shrinking. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)
Which role should you assign to the group?
You are administering a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. You need to assign a group of users a predefined security role that permits them to read all the report definitions. Which role should you assign to the group?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A hosts a database named DB1. DB1 serves as the backend database for an application that tracks issues that help desk technicians receive and the associated trouble tickets. When installed, the help desk application loaded several stored procedures and views that are used for data manipulation and reporting purposes. DB1 contains more than 50 tables. The bulk of the data is stored within the Employees, Issues, Assets, and AssetTracker tables. An application developer inadvertently deletes the AssetTracker table in DB1. The AssetTracker table is referenced by several views and functions in the database. You need to ensure that users are not able to remove critical tables such as this that are referenced by views or functions. What should you do?
What changes should you expect in both the profit chart and the lift chart?
You are analyzing a data mining structure by using Business Intelligence Development Studio (BIDS). You change the settings on the Data Mining Accuracy Chart tab. What changes should you expect in both the profit chart and the lift chart?
Which two actions should you perform?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer. Your company’s database auditing department must receive an e-mail message when the SQL Server service and the SQL Server Agent service are started, stopped, or paused. They also need to receive an e-mail message when the EXECUTE AS option is used with stored procedures and other commands. You need to ensure that the auditing department receives the e-mail messages that they need. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)