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?

You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server
2008 server database named ABC-DB05, which hosts the SQL Server 2008 Analysis Services
(SSAS).
You have created a SSAS project that contains a cube with a dimension named Housing. The
dimension has a property named Cement. The project also contains information about the
ABC.com users employed on the project. You need to determine a way to browse the data in the
dimension.
Which of the following is the action that will accomplish this?

You work as a database administrator for ABC.com. Your duties include managing a SQL Server
2008 database server named ABC-DB05, which hosts the SQL Server 2008 Analysis Services
(SSAS).
The SSAS method contains a dimension and a measure group. The dimension is named Housing,
and the measure group is named Supplies. Housing includes a property named _Month. Items are
configured to connect to the Housing dimension. You receive instructions from the CIO that the
_Month property is contained in the design on Supplies.
How can this be accomplished?

You work as a database administrator at 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 SSAS method contains a dimension named Marketing, which in turn contains a table named
Supplies. Supplies contain two fields named Sand and Stone. A new policy requires data to be
obtained by measures using Marketing. You then decide to create a relationship between the
Marketing dimension and the Stone measuring group.
What should be included in your next step?