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?

You work as a database administrator for ABC.com. The ABC.com network contains a SQL
Server 2008 database server, which hosts the SQL Server 2008 Integration Services (SSIS)
package.
The CIO has asked to identify the current XML configuration for the package.
Which of the following is the tool that you should use?

You work as a database administrator at ABC.com. Your duties include managing a SQL Server
2008 database server named ABC-DB05, which hosts the SQL Server 2008 Reporting Services
(SSRS). The service contains a report header and footer.
You receive a complaint from a ABC.com user named Mia Hamm, stating that she is presented
with an error message when she attempts to render a report to a Microsoft Word file. You check
and discover that accurate results are displayed when you preview the document. However, as
soon as you render it, you are unsuccessful.
Which of the following actions should you take?

You work as a database administrator at ABC.com. Your duties include managing a SQL Server
2008 database server named ABC-DB05, which hosts the SQL Server 2008 Reporting Services
(SSRS).
You are in the process of publishing a report to a list of subscribers on ABC-DB05. It is therefore
important that a subscription is created on ABC-DB05. You start by selecting the report prior to
clicking the Subscriptions tab.
What should your next step be?

You work as a database administrator for ABC.com. You are responsible for managing a SQL
Server 2008 database server named ABC-DB05, which hosts the SQL Server 2005 Analysis
Services.
You have created a report using SQL Server 2008 Reporting Services (SSRS). You receive
instructions from the CIO to ensure that all reports created on ABC-DB05 will display the user and
extended features.
How can this be achieved?