Vendor: Microsoft
Exam Code: 70-448
Exam Name: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

1. You are 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 byusingda
ta 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) data flow that inserts data from a sourcequery toa desti
nationtable.You need to insert only those rows that do not already exist in the destination tablE.What are twopossibl
eways to achieve this goal? (Each correct answer presents a complete solution. Choose 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: B, D

3. You implement a SQL Server 2008Integration Services (SSIS) package. The package contains the following com
ponents: Adata flow task contained in a For Loop containerA Flat File destination component that uses a Flat File co
nnection managerAn OnError event handler When an error occurs in the package, you plan to write diagnostic infor
mation from an expression that includes the version of the package to atext file. You needto ensure that the require
d 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

Related Certifications:  MCTS – Microsoft Certified Technology Specialist (MCTS)

Microsoft new generation certifications are basically designed to focus on primary and technical skills to help individual IT professional to select those credentials which will help them in career building. Microsoft certification program offers certification paths for individuals to target on specific job role, industry or technology to demonstrate their experience and skills.
Moreover, organizations would like to ensure that IT professionals should have extraordinary skills for their projects. New generation microsoft shorter certifications will help you to achieve your certifications tracks in a cost effective way.
This new framework of Microsoft new generation certifications makes it easy for managers to differentiate between candidates fulfilling their specific needs. Credentials logos could help to understand testimonials well offering distinction level needed to make use your certificate as recruiting tool. Microsoft program contains the following new certifications.
Microsoft Certified Technology Specialist (MCTS)
This certification enables you to focus on particular technologies making yourself more professional in terms of depth knowledge and expertise in specific areas. MCTS certified professional should be capable of implementing, building, troubleshooting and debugging specific Microsoft technology.
You may find large number of MCTS certifications list at http://www.microsoft.com/learning/mcp/mcts/default.mspx and more certifications are also coming as soon as new technologies are being introduced.
MCITP (Microsoft Certified IT Professional)
MCITP Certification is introduced to provide IT professionals more credentials along with simple framework to display technical and professional skills.
MCDBA (Microsoft Certified Database Administrator)
MCDBA Certified individuals should get knowledge and skills to lead organizations for successful design, implementation and administration of Microsoft SQL server 2000 databases along having MCDBA certificate. Also MCDST, MCSA and MCSE certificate to continue IT professionals to make use of Microsoft SQL server 2000, Windows XP and MS Server 2003 for hands on experience and get required skills.
MCA (Microsoft Certified Architect)
This certification check the necessary skills needed to affect IT business successfully. The skills included are technical breadth, depth, communication, strategy, politics, process and leadership of an organization.