Microsoft 070-448 Exam Syllabus Topics:

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

Question 1

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The cube structure is as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the Amount measure can be aggregated for the DimCustomer dimension.
What should you do?

A. Create a regular relationship between DimCustomer and FactTransaction.
B. Create a referenced relationship between DimCustomer and FactCustomerAccount. Set DimAccount as an intermediate dimension.
C. Create a many-to-many relationship between DimCustomer and FactTransaction. Set FactCustomerAccount as an intermediate measure group.
D. Create a many-to-many relationship between DimCustomer and FactCustomerAccount. Set FactTransaction as an intermediate measure group.

Question 2

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. ProcessData
B. ProcessFull
C. ProcessAdd
D. ProcessIndex

Question 3

You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from flat
files and loads this data to a SQL Server 2008 database.
The package contains two Boolean variables named @IsWeekday and @IsHoliday. When the package is
executed on week days, the @IsWeekday variable is set to True. When the package is executed on
holidays, the @IsHoliday variable is set to TruE.You need to implement the following business logic in the
control flow of the package:
When the @IsWeekday variable is set to True, the Perform Weekday Processing Data Flow task is
executed.
When the @IsWeekday variable is set to False, the Perform Weekend Processing Data Flow task is
executed.
When the @IsHoliday variable is set to True, the Perform Holiday Processing Data Flow task is executed.
Which control flow logic should you implement?

A. Option A
B. Option D
C. Option C
D. Option B

Question 4

You are designing a SQL Server 2008 Integration Services (SSIS) package.
The package includes a Data Flow task that copies several million rows. The data flow requires a match
against a reference table that contains 10,000 rows. Each row in the reference table will be used during the
data flow.
Same row are not matching due to a mismatched case type
You need to ensure that the data flow executes to match all rows correctly.
Which data flow component should you select?

A. A Fuzzy Lookup transformation
B. A Lookup transformation along with the Full cache option
C. A Lookup transformation along with the No cache option
D. A Lookup transformation along with the Partial cache option

Question 5

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The solution has the following components:
A dimension named DimTime that contains an attribute named Month
A measure group named FactSales that references the DimTime dimension
You need to ensure that the aggregations designed on FactSales always include the Month attribute.
What should you do?

A. Set the AggregationUsage property appropriately.
B. Set the AttributeHierarchyEnabled property appropriately.
C. Set the Usage property appropriately.
D. Set the IsAggregatable property appropriately.

Solutions: