You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com.

In order to execute the Usage-Based Optimization Wizard you should make query logging enable. Which is the correct answer?

You are developing a SQL Server 2008 Reporting Services (SSRS) instance of report model for Company.com.

In the Report Builder tool, the users should need to create their SSRS reports.
The data source they used will include a Microsoft SQL Server 2008 database. Which include 1000 tables?

You should design the report model for users, and allow access to only the 20 tables which they require for reporting. Which is the correct answer?

You are creating a SQL Server 2008 Integration Services (SSIS) package on a SQL Server 2008 database for Company.com.

In order to develop a failure recovery plan that is published for a SQL Server. Which is the correct answer?

You are managing a SQL Server 2008 Reporting Services (SSRS) sample which does not give some same rendering extensions for Company.com.

You should make sure that you could set the server in order to render to Microsoft Word.
Which is the correct answer?

You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com.
The SSIS package must contain six Data Flow tasks and three Control Flow tasks.

You should alter the package .Which is the correct answer?