070-448 試験問題を無料オンラインアクセス

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database.
You change the DataDir property of the instance to a new folder.
You need to ensure that the instance uses the new folder in the minimum amount of downtime.
What should you do?

• A.Restart the Analysis Services service.
• B.Synchronize the database.
• C.Process the database.
• D.Delete the files in the original folder, and then restart the Analysis Services service.

You are developing a SQL Server 2008 Reporting Services (SSRS) report that will be run by managers
only. Each manager's EmpID will be passed into the report at runtime.
The managers want to be able to see a graphical display of sales grouped by product. Each store's data
should be displayed on a separate page.
You need to enable this functionality. What should you use?

• A.Matrix
• B.List
• C.Table
• D.Image

You maintain a SQL Server 2008 Integration Services (SSIS) instancE.The instance stores packages in
a SQL Server 2008 instance.
You need to deploy the package of an instance of SSIS to another SSIS instance that stores its packages in
a shared directory.
What should you do?

• A.Execute the dtexec command.
• B.Execute the dtutil command.
• C.Execute the dtexecui command.
• D.Execute the dtswizard command.

You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database
that is used by the members of the Engineering group.
You configure a new role named Engineering and Design by using the following allowed permission set:
{[Employees].[Department].[Engineering and Design]}
You assign the Engineering group to the Engineering and Design role.
You need to ensure that users in the Engineering and Design role can view data only for their department.
What should you do?

• A.Select the Enable Visual Totals check box for the Engineering and Design role.
• B.Add the User ID = [Engineering and Design]; parameter to the connection string.
• C.Add the Roles = [Engineering and Design]; parameter to the connection string.
• D.Add your account temporarily to the Engineering and Design role.

You maintain a SQL Server 2008 Reporting Services (SSRS) instance.
A developer accidentally deploys 1000 reports to the SSRS instance.
You need to restore the SSRS instance to its original state.
Which database should you restore?

• A.The Report Server Temporary database
• B.The MSDB database
• C.The Report Server database
• D.The master database