Microsoft 70-448 Exam Syllabus Topics:

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

Question #1
You create a data mining model by using SQL Server 2008 Analysis Services (SSAS).
You create a mining structure by using the following Data Mining Extensions (DMX) code.
CREATE MINING STRUCTURE [Bike Buyer](
[Customer Key] LONG KEY,
[Age] LONG DISCRETIZED(Automatic, 10),
[Bike Buyer] LONG DISCRETE,
[Commute Distance] TEXT DISCRETE,
[Yearly Income] DOUBLE CONTINUOUS
)
You need to create a mining model that can be processed by using this mining structure. You also need to
ensure that the model uses the Microsoft Decision Trees algorithm.
Which DMX statement should you use?

A. ALTER MINING STRUCTURE [Bike Buyer] ADD MINING MODEL [Decision Tree] ( [Customer Key],
[Age],
[Bike Buyer] PREDICT,
[Commute Distance],
[Yearly Income]
)?USING Microsoft_Decision_Trees
WITH DRILLTHROUGH
B. INSERT INTO [Decision Tree] ( [Customer Key], [Age], [Bike Buyer], [Commute Distance], [Yearly Income] ) OPENQUERY([Bike Buyer], ?'Select [Customer Key], [Age], [Bike Buyer] , [Commute Distance],[Yearly Income]' )
C. SELECT * INTO [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Bike Buyer]
D. CREATE MINING MODEL [Decision Tree] ( [Customer Key] LONG KEY, [Age] LONG DISCRETIZED(Automatic, 10), [Bike Buyer] LONG DISCRETE, [Commute Distance] TEXT DISCRETE, [Yearly Income] DOUBLE CONTINUOUS )?USING Microsoft_Decision_Trees

Question #2
You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a Product dimension.
The dimension contains the Category and Subcategory attributes.
The attributes have a Rigid relationship typE.The data source for the Product dimension changes the
relationship between the Category and Subcategory values.
You need to execute an XML for Analysis (XMLA) command to process the dimension to successfully
reflect the changE.What should you do?

A. Use the ProcessAdd command.
B. Use the ProcessIndexes command.
C. Use the ProcessUpdate command.
D. Use the ProcessClear and the ProcessDefault commands.

Question #3
You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts data from two sources: a Mircosoft Excel sources and ADO.net. The ADO.net source is based on a SELECT statement that uses an ORDER BY clause.
The data flow is as shown in the following exhibit. (Click the Exhibit button.)
When the paths from the two sources are connected to the Merge Join component, the following error
message is displayed:
Data Flow Task: the input is not sorted. The `input "Merge Join Left Input"(48)' must be sorted.
You need to ensure that data from each query is included in each row in the data flow.
What should you do? (Each correct answer presents part of the solution. Choose two.)

A. Replace the Merge Join transformation with a Union All transformation.
B. Update the sorting properties in the ADO.net source component.
C. Add a Sort transformation for the Excel source.
D. Add an OLE DB Command transformation for each data flow.

Question #4
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 MeasureExpression property of the Amount measure to [DimCustomer].[Amount]*[Ownership].
B. Set the MeasureExpression property of the Amount measure to [Amount]*[Ownership].
C. Set the FormatString property of the Amount measure to [DimCustomer].[Amount]*[Ownership].
D. Set the FormatString property of the Amount measure to [Amount]*[Ownership].

Question #5
Note: This question is part of a series of questions that use the same of similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You maintain the SQL Server 2008 Integration Services (SSIS) instance for a healthcare device manufacturing company.
You develop a package named Memberinformation.dtsx with Windows authentication. You deploy it to SQL Server.
You need to validate Memberinformation.dtsx packages without package execution.
Which command syntax should you use?

A. dtexec /f " Z:\ Memberinformation.dtsx " /conf "
Z: \Memberinformationconfig,cfg "
B. dtutil /SQL Memberinformation /COPY DTS;c:\SSISpackages\Memberinformation
C. dtexec /f "c: \ Memberinformation .dtsx" /1 " DTS.LogProviderTextFile;Y:\Loginformation.txt"
D. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /COPY SQL; Memberinformation.dtsx
E. dtexec /sq Memberinformation /ser productionServer / va
F. dtutil /FILE c:\SSISpackages\Memberinformation.dtsx /COPY FILE;W: \ProdSSISpackages\ Memberinformation_Prod.dtsx
G. dtutil /FILE c:\ SSISpackages|Memberinformation.dstx /DestServer DBPROD /COPY SQL; Memberinformation.dtsx
H. dtexec /sq Memberinformation / verify (a400e860-38d5-11c5-11ce-ae62-08002b2b79ef)

Solutions: