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

You work as a database administrator at ABC.com. Your duties include managing a SQL Server 2008 database server named ABC-DB02 that is configured to host the SQL Server 2008 Reporting Services (SSRS). The SSRS contains a table that will be used by ABC.com employees when they open documents. The CIO informs you that the table has to open a document as soon as it is selected. How can this be achieved?

You work as a database administrator at ABC.com. Your duties include managing a SQL Server 2008 database server named ABC-DB01 that is configured to host the SQL Server 2008 Analysis Services (SSAS) role. You receive instructions from the CIO provide him with data concerning the use of temporary files on ABC-DB01. How can you retrieve the information when it is in use?

You work as a database administrator at ABC.com. Your duties include managing a SQL Server 2008 database server named ABC-DB01, which hosts the SQL Server 2008 Analysis Services (SSAS). You receive an instruction from the CIO to configure the Analysis Services query log. You now need to determine which utility is required to accomplish this task. How can this be achieved?

You work as a database administrator for ABC.com. The network contains a SQL Server 2008 database server named ABC-DB05, which hosts the SQL Server Analysis Services (SSAS) role. You receive an instruction from the CIO to enhance the performance of queries on ABC-DB05. To accomplish this task you decide to make use of the Dynamic Management View (DMV). Which command should you use to assist you?

You work as a database administrator at ABC.com. The ABC.com network contains a server named ABC- DB05, which hosts the SQL Server Analysis Services (SSAS) role that contains a cube. You receive instructions from the CIO to add a function to the cube. At present a considerate amount of time is used when new functions are published. How can you reduce the amount of time it takes to publish the functions?

You work as a database administrator at ABC.com. Your duties include managing a SQL Server 2008 Integrated Services (SSIS) instance, which contains a number of data flows. You receive an instruction from the CIO to manage information that is passed through the data flow paths. It is imperative that the data flow logic is not affected. You then decide to make use of the Business Intelligence Development Studio. Which utility will assist you in accomplishing this task?

You work as a database administrator for ABC.com. The ABC.com network contains a SQL Server 2008 Integration Services (SSIS) Data Flow. You configure the data flow to transfer data to a SQL Server 2008 database named ABC_Data. You have been tasked with configuring the information located in the data flow to refresh the information in ABC_Data. How can this be accomplished?

You work as a database administrator at ABC.com. You are responsible for managing a SQL Server 2008 database server named ABC-DB05, which hosts the SQL Server 2008 Integration Services (SSIS) and has a Data Flow task. The CIO has informed you to make sure that the package logs errors to a Microsoft Word document. You then decide to add an Error output to the source component. Which component should you use?

You work as a database administrator for ABC.com. The ABC.com network contains a SQL Server 2008 database server named ABC-DB05, which hosts the SQL Server 2008 Analysis Services (SSAS). The CIO has instructed you to deploy a data mining structure for the network. He has also informed you that the mining structure must include the Microsoft Clustering mining model from Scalable K-Means to Non-scalable K-Means. Which of the following actions should you take?

You work as a database administrator for ABC.com. The ABC.com network contains a SQL Server 2008 database server named ABC-DB01, which hosts the SQL Server Reporting Services (SSRS) role. ABC.com currently makes use of Kerberos for authentication. You receive various complaints from management regarding the safety of information in the domain. You have been instructed to make the necessary modifications that will assist the current authentication. Which of the following actions should you take?