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

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. OLE DB Command Transformation
• D. SQL Server Destination

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. 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
• B. 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
• C. SELECT * INTO [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Bike Buyer]
• D. 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]' )

You implement a SQL Server 2008 Analysis Services (SSAS) solution. You use data mining extensions
(DMX) to query a data mining model.
You write the following DMX code segment to query a Bike Buyer data mining model in a Decision Tree
data mining structure. (Line numbers are included for reference only.)
01 SELECT
02 [Decision Tree].[Bike Buyer] AS Buyer
03 FROM
04 [Decision Tree] 06 (SELECT 28 AS [Age],
07 '2-5 Miles' AS [Commute Distance],
08 '1' AS [House Owner Flag],
09 1 AS [Number Cars Owned],
10 2 AS [Total Children]) AS t
You need to ensure that the input columns automatically map to the columns in the data mining structure.
Which code fragment should you insert at line 05?

• A. INNER JOIN
• B. NATURAL PREDICTION JOIN
• C. PREDICTION JOIN
• D. OPEN QUERY

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution contains a time
dimension named DimTime that contains a hierarchy named Yr-Qtr-Mth.
You have a measure named Amount from a measure group named Measures.
You need to create a calculated member to display the Amount measure in the previous time period for the
current level of the Yr-Qtr-Mth hierarchy.
Which expression should you use?

• A. ([Measures].[Amount],OPENINGPERIOD( [DimTime].[Yr-Qtr-Mth].FirstSibling.Level))
• B. ([Measures].[Amount],LASTPERIODS( 0,[DimTime].[Yr-Qtr-Mth].PrevMember))
• C. ([Measures].[Amount],[DimTime].[Yr-Qtr-Mth].FirstSibling)
• D. ([Measures].[Amount],[DimTime].[Yr-Qtr-Mth].PrevMember)

You build and deploy a SQL Server 2008 Integration Service (SSIS) package.
During package development, the XML configuration is not specified.
You need to apply the configuration file to the deployed package stored in files system.
Which parameter should you set in the DTEXEC command line utility?

• A. /conf
• B. /CheckF
• C. /L
• D. /Set