Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan

QUESTION NO: 1
You maintain a SQL Server 2008 Analysis Services (SSAS) database.
You plan to refresh data in a partition every two hours.
You need to implement the incremental processing strategy.
Which XML for Analysis (XMLA) command should you use?

A. ProcessFull B. ProcessData C. ProcessAdd D. ProcessIndex

Correct Answer: C

QUESTION NO: 2
You maintain a SQL Server Analysis Services (SSAS) database. The database is configured by using
multiple security roles.
The database is accessed by a Microsoft ASP.NET application that runs on a remote computer. The
application is configured to use Windows Authentication.
You need to ensure that the users of the application can successfully access the SSAS database. You also
need to ensure that security restrictions of the roles are applied.
What should you do?

A. Configure Kerberos authentication. B. Configure Analysis Services for HTTP authentication. C. Set the AnonymousConnectionsEnabled policy to True. D. Set the Security\RequireClientAuthentication property to True.

Correct Answer: A

QUESTION NO: 3
You manage the security in SQL Server 2008 Reporting Services (SSRS). The report server contains a
folder named Management Reports.
All groups can view and modify reports in any folder.
You need to ensure that only the Managers group can view and modify reports in the Management Reports
folder.
What should you do?

A. Create a Managers rolE. Assign the Managers role to the root folder. Remove all groups from the Management Reports folder. B. Create a Managers role. Assign the Managers role to the Management Reports folder. Remove all other groups from the Management Reports folder. C. Remove all groups from the Management Reports folder. Add the Managers group to the folder and assign the Content Manager role. D. Add the Managers group to the root folder and assign the Content Manager rolE. Remove all groups from the Management Reports folder.

Correct Answer: C

QUESTION NO: 4
You develop reports by using SQL Server 2008 Reporting Services (SSRS) Enterprise Edition. You need to use data-driven subscription to distribute reports based on dynamic subscription data. Which role should you use?

A. Browser B. System User C. Content Manager D. Publisher

Correct Answer: C

QUESTION NO: 5
You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as shown in the
following exhibit. (Click the Exhibit button.)
The Ownership column contains decimal values that represent percentage of ownership. The sum of all the
values in the Ownership column for a single DimAccount member is 100%.
You create the following measures:
Ownership
Amount
You need to ensure that when the Amount measure is calculated against the DimCustomer dimension, the
weighted value is calculated based on the Ownership measure.
What should you do?

A. Set the FormatString property of the Amount measure to [Amount]*[Ownership]. B. Set the MeasureExpression property of the Amount measure to [DimCustomer].[Amount]*[Ownership]. C. Set the MeasureExpression property of the Amount measure to [Amount]*[Ownership]. D. Set the FormatString property of the Amount measure to [DimCustomer].[Amount]*[Ownership].

Correct Answer: C

QUESTION NO: 6
You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQL
Server 2008 database.
You need to ensure that the data flow updates the existing records in the SQL Server database by using
data from the rows in your data flow.
Which data flow component should you use?

A. OLE DB Destination B. Data Conversion Transformation C. SQL Server Destination D. OLE DB Command Transformation

Correct Answer: D

QUESTION NO: 7
You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a key performance indicator (KPI) named GPMargin for your solution. You set the Value
expression of the KPI in the following manner.
[Measures].[Amount],[Account].[Accounts].[Operating Expenses] /
[Measures].[Amount],[Account].[Accounts].[Gross Margin]
Your solution has a time dimension named DimTime.
You write the following Multidimensional Expressions (MDX) statement. (Line numbers are included for
reference only.)
01 IIf(
02 & &
03ParallelPeriod
04( [DimTime].[Calendar].[Quarter],1,[DimTime].[Calendar].CurrentMember
05)?), 1, -1 )
You need to set a Trend expression of the KPI to show a difference in the values compared with the
previous quarter.
Which MDX code segment should you insert at line 02?

A. KPIStatus( "GPMargin" ) >?( KPIValue( "GPMargin" ), B. KPIValue( "GPMargin" ) >?( KPIValue( "GPMargin" ), C. KPIGoal( "GPMargin" ) >?( KPIValue( "GPMargin" ), D. KPITrend( "GPMargin" ) >?( KPIValue ( "GPMargin" ),

Correct Answer: B

QUESTION NO: 8
You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instance.
The report contains query parameters that allow users to filter the contents of the report.
The report requires users to enter parameter values before it will run.
The users wish to simplify the process so that the report will run without input.
You need to enable this functionality.
What should you do?

A. Add a default value to all parameters B. Modify the dataset to use the Table query type. C. Move the queries to the stored procedures and use the stored procedures to populate and filter the datasets of the report. D. Remove the filters from the dataset queries and use the parameters to filter the data source.

Correct Answer: A

QUESTION NO: 9
You maintain a SQL Server 2008 Analysis Services (SSAS) database on a default instancE.You plan to
document the Analysis Services performance information.
You need to collect information related to the temporary file usage when the database is processed.
Which object should you use?

A. MSAS 2008: Storage Engine Query B. MSAS 2008: Proc Aggregations C. MSAS 2008: Cache D. MSAS 2008: Memory

Correct Answer: B

QUESTION NO: 10
You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is responsible for the sales of bikes in the Northeast region. You plan to grant the necessary permissions to the sales manager to access the database. You have two roles named Northeast Region and Bikes. The schemas of the two roles are as shown in the following tablE.Role Allowed set
Northeast Region
{[Sales Territory].[Sales Territory Region].&[Northeast]}
Bikes
{[Product].[Product Category].[Product Category].&[Bikes]}
The Visual Totals property is set to True for both roles.
You need to ensure that the sales manager can view only the members in the Product dimension that relate
to the Bikes category in the Northeast region.
What should you do?

A. Add the manager to the Bikes role. B. Add the manager to the Northeast Region role. C. Add the manager to a new role that has the following two components: {[Sales Territory].[Sales Territory Region].AllMembers} as the denied set {[Sales Territory].[Sales Territory Region].&[Northeast]} as the allowed set. {[Product].[Product Category].[Product Category].AllMembers} as the denied set. {[Product].[Product Category].[Product Category].&[Bikes]} as the allowed set. D. Add the manager to a new role that has the following two components: {[Sales Territory].[Sales Territory Region].&[Northeast]} as the allowed set. {[Product].[Product Category].[Product Category].&[Bikes]} as the allowed set.

Correct Answer: D

Microsoft TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan - 70-448 Exam Questions