What should you do?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report has a column of data that must be displayed and printed by using a strikethrough text. You need to modify the appropriate property of a text field to represent the proper text formatting. What should you do?
which queries consume the most resources. You want to achieve this goal as quickly as possible. What should yo
You are a database administrator for AIOTestKing.com. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do?
What should you do?
You administer a Microsoft SQL Server 2005 Reporting Services (SSRS) instance. You have remote access to e-mail and HTTP only. A user must create a report based on a Microsoft SQL Server 2005 Analysis Services (SSAS) cube. No report model is currently available for the cube. The user can access the cube through the Microsoft Office Excel application and is a member of the System User role. You need to help the user create a report by using the SSRS Report Builder utility. What should you do?
What should you do?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A has recently been upgraded from two to eight processors. The AIOTestKing A configuration is summarized in the following table.
You need to optimize AIOTestKing A so that longer running queries can run parallel plans.
What should you do?
Which three tasks should you perform?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report uses a dataset that calls a Microsoft SQL Server stored procedure. The stored procedure requires three input parameters that cannot be Null.
The report must meet the following requirements when it runs:
Each of the stored procedure input parameters must be used. All parameter values must be selected from the drop-down lists. Only valid values must be used for input parameters.
You need to set the Report Parameters dialog box configurations to meet the outlined requirements.
Which three tasks should you perform? (Each correct answer presents part of the solution.
Choose three.)
What should you do?
You are a database administrator for AIOTestKing.com. You migrate several SQL Server 2000 Data Transformation Services (DTS) packages to a 64-bit version of SQL Server 2005 Standard Edition. After migrating the packages, you notice that they do not run.
You verify that the packages run on a 32-bit version of SQL Server 2005 Standard Edition. You need to ensure that the packages run. You must minimize the amount of additional development time required. What should you do?
Which report section should you use?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) matrix report. You use the SSRS Report Wizard to create the report. The report is based on a Microsoft SQL Server 2005 Analysis Services (SSAS) dataset. The dataset consists of a single measure named Total Sales, and two dimension attributes named Store Name and Month. You need to drag the Total Sales measure to a report section to display a table with values for Total Sales for each month. Which report section should you use?
What should you do?
You are a database administrator for AIOTestKing.com. You notice that the following Transact-SQL query is performing very slowly.
SELECT VideoTitle, UpcNum, RetailPrice, ReleaseDate FROM Srvideo.VideoTitle WITH (INDEX(0)) WHERE ReleaseDate BETWEEN ‘20050401’ AND ‘20050510’ There is a clustered index on the VideoTitle column. There is a nonclustered index on the ReleaseDate column that includes the UpcNum and RetailPrice columns. When you query the sys.dm_db_index_physical_stats dynamic management function (DMF) or the VideoTitle table, the avg_fragmentation_in_percent is 10 percent. The graphical execution plan for the slow query is shown in the exhibit.
You need to ensure that the query performs quickly. What should you do?
What should you do?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The source of the SSRS report data is a Transact-SQL stored procedure. The procedure does not have any input parameters and returns all records in a set of tables. Three other applications that run on Microsoft SQL Server also use the stored procedure. You need to limit the amount of data that is displayed on the report without affecting any other applications that use the stored procedure. What should you do?
What should you do first?
You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. Backups of all system databases are performed on Saturday nights. Backups of all user databases are performed on Sunday nights. All backups are stored in an off-site facility. AIOTestKing A unexpectedly turns off due to a power outage. When AIOTestKing A is brought back online, the SQL Server service fails to start. You view the SQL Server error log as shown in the exhibit.
You need to return AIOTestKing A to working order as quickly as possible. What should you do first?