Microsoft-TS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance Set 6

You manage a Microsoft SQL Server Analysis Services (SSAS) database for your company. Users are reporting that SSAS performance has recently degraded. You run a SQL Profiler trace on MDX queries that are being executed on a SSAS instance. Trace analysis shows that a MDX query executed by a new user is consuming more than the required resources. You review the MDX query and identify that the MDX query contains a complex IIF function to return a result set. Which advice should you give to the new user to improve query performance?

You want to deploy a custom assembly in SQL Server 2008 Report Services (SSRS) for use in the reports you are generating for your organization. What must you do to deploy a custom assembly?

You create several reports for the ABC.com with SQL Server Report Services (SSRS) 2008. The sales manager wants to look at the QtrSales report from last year to review sales figures from the previous year. The QtrSales report has been modified several times and the data source has changed. How should you retrieve the information from last year's QtrSales report using the least amount of administrative effort?

You work as a Database Administrator for ABC.com. The company has a SQL Server 2008 computer. You manage SQL Server 2008 Reporting Services (SSRS) for the company, which has a database named Production. You want to implement a database recovery operation for the Production database. Which of the following utilities should you use to accomplish the task?

You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. The business model of the company uses SSIS. There are 30 packages that use the same configuration and are stored in an XML file as a variable. You want to track the changes that affect a package that uses one variable. You also want to modify the package to provide automatic notification through email whenever there are changes to the variable. What should you do? Each correct answer represents a part of the solution. Choose all that apply.

You are an employee at ABC.com. The company has a SQL Server 2008 computer. The SQL Server 2008 Reporting Services instance is being administered in the company. You want to view the basic information about the report server. To which of the following roles should you be assigned to accomplish the task?

You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. You manage a SQL Server 2008 Integration Services (SSIS) package for the company. You want to perform operations like mining text, cleaning data, and running data mining prediction queries. Which of the following SQL Server Integration Services transformations should you choose to accomplish the task?

You work as an administrator for ABC.com. The company has a SQL Server 2008 computer. You are assigned a task to create and maintain Microsoft SQL Server 2008 Integration Services (SSIS) packages with the help of SSIS Designer. While you were developing the packages, it failed. Which of the following tabs of the SSIS Designer should you look to identify what happened?

You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. You are designing a SQL Server 2008 Integration Services (SSIS) package. The package uses at least one sequence container in one transaction. A Data Flow task and a Control Flow task are controlled by each transaction. Each Data Flow task has a success constraint that is followed by the Control Flow task. The following requirements should be included in the package:

You work as an administrator for ABC.com. The company has a SQL Server 2008 computer. You manage a Microsoft SQL Server 2008 Analysis Services (SSAS) instance. You deploy a data mining structure, which includes the Clustering mining model of Microsoft. You want to change the mining model properties from Scalable K-Means to Non-scalable K-Means. Which of the following parameters of the mining model should you change to accomplish the task?