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).
You are in the process of creating a project, which will contain a parent-child hierarchy for the
dimension, using SSAS. The project contains a child key feature named Tar and the parent key
feature is named Maintenance. You are appointed as the root member, and need to make sure
that the project contains the top user.
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 Integration Services
(SSIS) Data Flow.
The Data Flow inserts the data from a source query into a result table. You receive an instruction
from the CIO to add the rows that are contained in the result table.
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 that is configured to host the SQL Server 2008
Reporting Services (SSRS) instance.
During routine maintenance you discover that a ABC.com user named Amy Walsh unintentionally
published numerous reports to the SSRS instance. You need to determine a way to recover the
status of the sample prior to reports being published on it.
Which of the following actions should you take?

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 Integration Services

(SSIS).
The SSIS makes use of Business Intelligence Development Studio. The network has a package
Data Flow component. You receive instructions from the CIO to attach a sample of the component
to the package.
Whilst attempting to accomplish this you discover that the toolbox option does not contain the
component. To ensure productivity you need to add the component to the toolbox.
Which of the following actions should you take?

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 2008 Integration
Services (SSIS).
A default connection manager is used to connect to a component. You receive an instruction from
the CIO to create an XML configuration file, which will be used to provide the necessary
authentication information to accomplish your tasks.
Whilst attempting to login you are presented with an error message stating that you are unable to
make a connection to the package.
Which of the following actions should you take in order for the packet to operate?

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) role as well as a recovery instance.
The role contains the reports of the various divisions. To retrieve the information ABC.com users
make use of stored procedures.
How can you ensure that the reports will function?

You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server
2008 database server named ABC-DB01. ABC-DB01 is configured to host the SQL Server 2008
Reporting Services (SSRS).
You receive an instruction from the CIO to provide ABC.com users with the necessary permissions
to a private folder that will allow them to deploy the reports, as well as control the information. You
want to accomplish this task by adding a role to ABC-DB01.
Identify the role that you should add?

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 Integration
Services (SSIS).
The SSIS runs a number of packages. You receive an instruction from the CIO that all services on
ABC-DB05 should run as normal as possible.
Which of the following actions should you take? (Choose all that apply.)

You work as a database administrator at ABC.com. You are assigned to manage a server named
ABC-DB01. Your duties include managing a SQL Server 2008 Integration Services (SSIS)
instance.
The SQL instance was tested in a local development environment. You receive an instruction from
the CIO to deploy the instance to ABC-DB01. The CIO informs you that the level of security must
be configured for users when they run the package.
Which of the following actions should you take?

You work as a Developer for ABC.com. The company has a SQL Server 2008 computer. You are
designing a Microsoft SQL Server 2008 Reporting Services (SSRS) accounting report. You want
every alternate row of the output in the report table to have a green background. You need to use
the appropriate expression for the BackgroundColor property of the table. Which of the following
expressions should you choose to accomplish the task?