Killtest题库

专业IT认证题库学习资料,助您通过IT认证考试!

« killtest题库网提供最新的000-976题库下载!killtest题库网提供最新的70-515题库下载! »

最新最全的70-448题库免费下载!(killtest题库网提供)

MCTS 70-448考试题库由我们专业IT认证讲师及产品专家精心打造,包括了当前最新的全真试题。题库的覆盖率在96%以上,确保考生能一次性通过考试。并且网站上的题库随着微软认证厂商对考题做出的动态变化而及时更新,确保题库始终是最新最全的,最终保证考生的能PASS

考试代号:70-448

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

版本号:V8.02

考题数量:81

更新日期:2010-11-26

 

   部分题库参考如下:

1. 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. SQL Server Destination

B. OLE DB Destination

C. OLE DB Command Transformation

D. Data Conversion Transformation

Answer: C

2. You design a SQL Server 2008 Integration Services (SSIS) package that contains several data flows.

You need to monitor the data that passes through each path in the data flow by using the Business Intelligence Development Studio. You also need to ensure that data flow logic is retained.

What should you do?

A. Use the Data Viewer tool.

B. Use the Data Profiling task.

C. Use the Audit transformation.

D. Use breakpoints in the Script component.

Answer: A

3. 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. You need to

ensure that the data flow executes in the minimum amount of time.

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

Answer: B

4. You design a SQL Server 2008 Integration Services (SSIS) data flow that inserts data from a source

query to a destination table.

You need to insert only those rows that do not already exist in the destination table. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

A. Use the Merge transformation.

B. Use the Lookup transformation.

C. Use the Union All transformation.

D. Use the Merge Join transformation.

E. Use the Fuzzy Lookup transformation.

F. Use the Fuzzy Grouping transformation.

Answer: BD

5. You implement a SQL Server 2008 Integration Services (SSIS) package.

The package contains the following components:

¡¤A data flow task contained in a For Loop containe

¡¤A Flat File destination componentthat uses a Flat File connection manager

¡¤An OnError event handle When an error occurs in the package, you plan to write diagnostic information from an expression that includes the version of the package to a text file.

You need to 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题库网可下载更多最新最全的题库,同时,想要了解最新的考试动态信息,也可到网站咨询!

 

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

日历

最近发表

Powered By Z-Blog 1.8 Arwen Build 81206

Copyright xxxx-xxxx Your WebSite. Some Rights Reserved.