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 Reporting
Services (SSRS).

You are in the process of creating a SSRS report that contains a table, as well as a matrix.
Information is currently returned by the dataset via a stored procedure. You need to determine
whether the information will be returned in the table. Whilst retrieving your information the matrix
needs to be operational.
How can this be achieved?

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 Reporting
Services (SSRS).
The CIO has informed you that users in the Marketing division must be granted the Read Only
permissions for the folders located in the Sales division. You then decide to assign all the
Marketing division users to a security role that was created by a former administrator.
What should you do to ensure that they are able to peruse the report definitions?

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 server database named ABC-DB05. ABC-DB05 contains a Data Mining organization, which
makes use of the Business Intelligence Development Studio (BIDS) and contains several tabs.
You receive an instruction from the CIO to perform minor modifications to the Chart tab.
Which of the following options describes two consequences of this action? (Choose two)

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?