What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A is configured to automatically perform transaction log backups, database integrity checks, and other maintenance tasks on a regular basis. Another administrator uses the SQL Server Surface Area Configuration tool to reconfigure AIOTestKing A. You notice that AIOTestKing A no longer performs the automated maintenance tasks. You need to ensure that the maintenance tasks on AIOTestKing A are completed automatically. What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report that supports drilldown. You need to modify the report so that the detailed data is hidden when the report is initially rendered. What should you do?
What should you do?
You are troubleshooting an ASP.NET Web application. System administrators have recently expanded your web farm from one to two servers. Users are periodically reporting an error message about invalid view state.
You need to fix the problem.
What should you do?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A is a member of a Microsoft Active Directory domain. You do not have any rights or privileges to perform domain administration. However, you have been granted membership in the local Administrators group on AIOTestKing A. You perform most of the management of AIOTestKing A from your administrative workstation. However, for security reasons, you want to track all attempts for interactive logons and network connections to AIOTestKing A. What should you do?
Which Multidimensional Expressions (MDX) query should you use?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report is based on the multidimensional data from a Microsoft SQL Server 2005 Analysis Services (SSAS) cube. You need to use the Report Wizard to create a Matrix report by using the [Change Count] measure in the Details field. Which Multidimensional Expressions (MDX) query should you use?
What should you do?
You are creating a Windows Communication Foundation (WCF) service that implements operations in a
RESTful manner.
You need to add a delete operation.
You implement the delete method as follows.
string void DeleteItems(string id);
You need to configure WCF to call this method when the client calls the service with the HTTP DELETE
operation. What should you do?
Which service or services should you disable?
You are a database administrator for AIOTestKing.com. You are configuring a new SQL Server 2005 computer named AIOTestKing A. AIOTestKing A will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to AIOTestKing A will be made by using AIOTestKing As DNS name. You need to disable any unnecessary services on AIOTestKing A.
Which service or services should you disable? (Choose all that apply.)
Which expression should you use?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report.
You create a report parameter named DisplayCol that contains the following properties:
Data Type: Integer Prompt: Display Column Available Values: Non-queried with the following Label/Value pairs:
oYes/1 oNo/0
Default Values: Null
The report parameter is used to control the visibility of the column.
You need to use the appropriate expression in the Hidden property for the column.
Which expression should you use?
Which approach should you recommend?
You are designing a data access service backed by Microsoft SQL Server. Other developers will use your service as a third-party service.
You have the following requirements:
To reduce maintenance cost, you must write the minimal amount of code required for fulfilling the goals.
The service must function with Microsoft and non-Microsoft technologies.
The service must implement the WS-Security standards.
You need to design the service to meet the requirements.
Which approach should you recommend?
What should you do?
You are a database administrator for AIOTestKing.com. You receive alerts reporting that several transactions on your SQL Server 2005 database have terminated due to a deadlock error. You need to find out the causes of the deadlocks. What should you do?