QUESTION NO: 1

You're the administrator of your company network. And SQL Server 2008 has been deployed on
your computer. Now you use SQL Server 2008 to create a SQL Server 2008 Analysis Services

(SSAS) solution and then you design a Business Intelligence (BI) solution. There's a dimension named DEClients in the solution. And the dimension is used to stand for clients who buy products in your company. The solution gives a list of top 8 Clients according to the sales amount. End users of the solution use filters in Microsoft Excel worksheet to analyze datA. Now you're assigned a task to make sure that when the filters are applied, the list must be updated. So which named set expression should you use to achieve this?
A. CREATE SESSION SET CURRENTCUBE.[Top 10 Clients] AS TOPCOUNT([ DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])

B. CREATE HIDDEN SET CURRENTCUBE.[Top 10 Clients] AS TOPCOUNT([ DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])

C. CREATE DYNAMIC SET CURRENTCUBE.[Top 10 Clients] AS TOPCOUNT([ DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])

D. CREATE SET CURRENTCUBE.[Top 10 Clients] ASTOPCOUNT([
DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])

Answer: C

QUESTION NO: 2

You're the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution. There is a SQL Server 2008 Analysis Services (SSAS) cube which contains 110 million Fact rows and 750 dimension attributes. The cube reads data from a remote data source and increases several measure groups by 1 million rows everyday. You intend to deploy this SQL Server 2008 Analysis Services (SSAS) cube. You want to increase the total number of users by 180 percent for the cube. During cube processing, you have to capture the baseline performance on the overall system. So what should you do?
A. You should use the sp_monitor system stored procedure to monitor cube processing events.

B. You should use the sp_trace_setfilter system stored procedure to monitor cube processing events.

C. You should configure the data collector to collect Query Activity statistics during cube processing.

D. You should configure the data collector to collect Performance Counters statistics during cube processing.

2

Answer: D

QUESTION NO: 3

You're the administrator of your company network. And you are in charge of a Microsoft SQL

Server 2005 Reporting Services (SSRS) instance which is deployed as a single server and configured to use Native mode. Besides this, the instance also has another feature: A custom data extension developed by using Microsoft .NET Framework 2.0. Now you intend to upgrade the instance to SQL Server 2008 Reporting Services without loss of functionality. So what should you do to achieve this?
A. You should uninstall Internet Information Services (IIS). MCITP Certification

B. You should upgrade the data extension to .NET Framework 3.5.

C. You should edit the RSWebapplication.config file to refer to the upgraded SSRS endpoint location.

D. You should install a new instance of SSRS. Migrate the existing configuration files and database to the new instance.

Answer: D

Configuring TS Gateway Settings

The TS Gateway settings deusing TS RemoteApp programs on the terminal server, as shown in Exercise 3.9. There are three TS Gateway settings that are con
Automatically Detect TS Gateway Server Settings.
Use the TS Gateway Server Settings.
Do Not Use a TS Gateway Server. MCITP Test

EXERCISE 3.9

TS RemoteApp TS Gateway Global Deployment Settings
Follow these steps to con

1. Click Start
2. In the Actions pane, click TS Gateway Settings.
3. On the TS Gateway tab, there are three server settings.

Automatically Detect TS Gateway Server Settings. If this is selected, the client tries to use Group Policy settings to determine the behavior of the client connec- tion to the TS Gateway server.

Use These TS Gateway Server Settings. This selection will allow you to conthe TS Gateway server name and logon method. The server name must match the SSL certi

Do Not Use a TS Gateway Server. Use this selection if the client is not accessing the TS servers from the Internet.

Configuring RDP Settings

Using these RDP selections will specify settings users will get when connecting to a Remote- App, such as device and resource redirection and some display settings. Exercise 3.10 shows the available user RDP selections. MCITP Certification