killtest题库网提供最新的70-448题库下载！

考试代号：70-448

  认证名称：TS:MS SQL Server 2008.Business Intelligence Dev and Maintenan

  版本号：V2.33

  考题数量：87道

  更新日期：2010-7-13

1.Youare developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQLServer 2008 database. You needto ensure that the data flow updates theexisting records in the SQL Server database byusingdata from the rows in your data flow. Which data flow component should you use?

A.SQLServer Destination

B.OLE DB Destination

C.OLE DB Command Transformation

D.Data ConversionTransformation

Answer:C

2.Youdesign a SQL Server 2008 IntegrationServices (SSIS) package that contains several data flows. You needto monitor the data that passes through each path in thedata flowby using the Business Intelligence Development Studio. You also need toensure that data flow logic is retained. What should you do?

A.Use the DataViewer tool.

B.Use the Data Profiling task.

C.Use theAudit transformation.

D.Use breakpoints in the Script component.

Answer:A

3.You aredevelopingaSQLServer2008Integration Services (SSIS)dataflowthat extracts datafromtwosources. Each source database is located on a different server. Each source is based on a SELECT statement that uses an ORDER BY clause. The data flow is as shown in the following diagram. When the paths from the two sources are connected to a Merge Join component, the following errormessage is displayed:

"Data FlowTask: The input is not sorted. The 'input "Merge Join Left Input" (80)' must be sorted." You needto ensure that data from each query is included in each row in the data flow. You want toachieve this goal by using minimum amount of execution time. What should you do?

A.Adda Sort transformation for each data flow.

B.Addan OLE DB Command transformation for each data flow.

C.Update the sorting properties in each source component.

D.Replace the Merge Join transformationwith a UnionAll transformation.

Answer:C

4.Youare designing a SQL Server 2008 IntegrationServices (SSIS) packagE.The package includes aDat

a Flow task that copies several million rows. Thedata flow requires a match against a reference table tha

t contains 10,000 rows. Each rowin the reference table will be used during the dataflow.

You needto ensure that the data flow executes in the minimum amount of time. Which data flow compon

ent should you select?

A.a Fuzzy Lookup transformation

B.a Lookup transformation along with the Full cacheoption

C.a Lookup transformation alongwith the No cacheoption

D.a Lookup transformation alongwith the Partial cache option

Answer:B

5.Youdesign a SQL Server 2008 IntegrationServices (SSIS) data flow that inserts data from a sourcequery toa destinationtable.You need to insert only those rows that do not already exist in the destination tablE.What are twopossibleways to achieve this goal? (Each correct answer presents a complete solution. C

hoose two.)

A.Use the Merge transformation.

B.Use theLookup transformation.

C.Use the UnionAll transformation.

D.Use the Merge Join transformation.

E.Use the Fuzzy Lookup transformation.

F.Use the Fuzzy Grouping transformation.

Answer:BD

6.You modify a SQL Server 2008Integration Services (SSIS) packagE.The packageextracts data from atext file and loads this datato a SQL Server 2008table as shown in the following two exhibits. You need to update the package to extract data from multiple text files of the same directory. Which three actions should you perform? (Each correct answer presents part of the solution. Choosethree.)

A.Adda variable to the package.

B.Adda variable to the data flow task.

C.Add a Foreach Loop container tothe package.

D.Add a For Loop container to the package.

E.Addan expression tothe Flat File Source component.

F.Addan expression tothe Flat File connection manager.

Answer:ACF

7.You implement a SQL Server 2008Integration Services (SSIS) package. The package contains the following components: A Foreach Loop container for the Collection property as shown in the following exhibit. (Click the Exhibit button.) A Foreach Loop container for the Variable Mappings property as shown in the following exhibit. (Click theExhibit button.) A Stringvariable named FileName. A Stringvariable namedDirectoryPath. You needto update the package so that the DirectoryPath variable returns the directory path for the filepath stored in the FileName variable.Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A.Set the RaiseChangedEvent property of the User::FileNamevariable to True.

B.Set the EvaluateAsExpression property of the User::DirectoryPath variable toTrue

C.Add a Script task to the OnPostExecute event handler of the ForeachLoop container.

D.Set the Expression property of the User::DirectoryPath variable to the following expression. SUBSTRI

NG( @[User::FileName], 1, LEN( @[User::FileName] ) FINDSTRING( REVERSE(@[User::FileName] ), "\

\", 1 ))

E.Set the Expression property of the User::FileName variable to the following expression. SUBSTRING(

@[User::FileName], 1, LEN( @[User::FileName] ) FINDSTRING( REVERSE(@[User::FileName] ), "\\", 1

))

Answer:BD

8.You implement a SQL Server 2008Integration Services (SSIS) package. The package contains the following components: Adata flow task contained in a For Loop containerA Flat File destination component that uses a Flat File connection managerAn OnError event handler When an error occurs in the package,

you plan to write diagnostic information from an expression that includes the version of the package to atext file. You needto ensure that the required information is written to the text file. What should you do?

A.Use the VersionGUID variable.

B.Use the ExecutionGUID variable.

C.Use the SourceID variable.

D.Use the TaskID variable.

Answer:A

Killtest题库网提供更多的关于微软认证的题库，你可以根据自己的需要进行下载！