You work as a database administrator at ABC.com. The ABC.com network contains SQL Server
2008 database server named ABC-DB05, which hosts the SQL Server 2008 Analysis Services
(SSAS) role that contains a cube.
During routine monitoring, you discover that queries are not performing optimally. You are tasked
with the responsibility of improving the query performance. You are in the process of identifying
the poorly performing queries in order to make the necessary changes to the cube to enhance the
performance.
What should you do? (Choose THREE.)
Each answer forms part of the solution.)

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) role.

The SSRS package contains a parameter named @Equipment. You receive an instruction from
the CIO to set the @Equipment parameter value in the report by selecting a particular area. Your
solution to this problem should however stop employees from making any modifications to the
parameter.
How can you ensure that the value of the parameter remains unchanged?

You work as a database administrator at ABC.com. You are responsible for managing a SQL
Server 2008 database server named ABC-DB01. ABC-DB01 is configured to host the SQL Server
2008 Reporting Services (SSRS).
You are in the process of generating a SSRS report that will be accessed by employees when
they work from remote locations. However, these employees will not have access to ABC-DB01
when they work from remote locations. The report will be located in an application. You have been
instructed to make sure that the report is not generated abnormally.
Which of the following actions should you take?

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?