What should you do?
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package contains a Data Flow task with a Fuzzy Grouping transformation that creates data. The output of the Fuzzy Grouping transformation is incorrect. You need to view the output data of the Fuzzy Grouping transformation to debug the package. What should you do?
Which two indexes should you use?
You are a database administrator for AIOTestKing.com The company uses a SQL Server 2005 database that contains a table named Production.Product. There are more than 40 columns in the table. The most common queries are shown in the following Transact-SQL statements.
–QUERY 1 SELECT [Name], [ProductLine], [ListPrice], [Class], [Style] FROM [Production].[Product] WHERE [ProductLine] = ‘T’
–QUERY 2 SELECT * FROM [Production].[Product] ORDER BY [Name]
You need to choose the best indexes to support the most common queries to the Production.Product table while minimizing the space required for the indexes. Which two indexes should you use? (Each correct answer presents part of the solution. Choose two.)
Which DMX WHERE clause should you use?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report uses a dataset that is based on a Data Mining Extensions (DMX) prediction query. The query forecasts the probability of purchases for buyers when specific inputs are given. Users want to select the values at runtime that might be used to forecast the probability of a purchase. You need to implement two report parameters named @buyer and @probability that will be used to control the DMX query at report runtime. Which DMX WHERE clause should you use?
What is the most likely cause of the problem?
You are a database administrator for AIOTestKing.com. You run SQL Server Profiler by using the SP:Recompile event class. You notice a large number of recompiles occurring.
You need to identify the possible cause of the large number of recompiles. What is the most likely cause of the problem?
Which three tasks should you perform?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The execution of the report must trigger an event for Notification Services by using a custom assembly. You need to write a custom code function named RSNotify that will parse the data from a field named ProductValue and execute the custom assembly within the report. 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. The company uses a SQL Server 2005 computer that runs Reporting Services. Reporting Services is used to produce hundreds of reports each day. You discover that the ReportServerTempDB database is growing. You need to minimize the size of the ReportServerTempDB database. What should you do?
Which three tasks should you perform?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report has three columns in a table. The columns are named MachineName, MachineMfr, and MachineModel. The report navigation options must allow users to click on a row from the MachineName column and drill through to another report, and then pass the contents of the MachineName column as a parameter named MachineName. You need to configure the report navigation options to satisfy the user 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. Your company has 10 SQL Server 2005 computers in a distributed environment. The SQL Server computers each subscribe to a transactional replication publication. Company policy defines service level agreements (SLAs) for maximum replication latency. You need to verify that the SLAs are being met. What should you do?
Which expression should you use?
You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) accounting report.
Every other line of output in the report table must have a green background. You need to use the appropriate expression for the BackgroundColor property of the table. Which expression should you use?
What should you do?
You are the database administrator of a SQL Server 2005 computer named AIOTestKing A.
The following query is run frequently.
All tables referenced in the query are read-intensive with very few inserts and updates.
You cannot change existing objects in the database. You can add new objects to the database. You need to optimize the performance of the query. What should you do?