分类：
2010-11-27 10:45:54
MCTS 考试题库由我们专业IT认证讲师及产品专家精心打造，包括了当前最新的全真试题。题库的覆盖率在96%以上，确保考生能一次性通过考试。并且网站上的题库随着微软认证厂商对考题做出的动态变化而及时更新，确保题库始终是最新最全的，最终保证考生的能PASS！
以下是题库的部分真题，和大家分享如下：
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
登录可下载更多最新最全的题库，同时，想要了解最新的考试动态信息，也可到网站咨询！
