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?

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?