Da Notes - 70-019 - L

Personal notes on the MCDBA tests. These notes are from the various resources I used to pass the MCDBA exams including the MCDBA sample exams from Transcender.

Passing Score: 620, Questions: 50,  Time: 150 Min.

Da Notes Index 

[ 70-019 - A ] [ 70-019 - B ] [ 70-019 - C ] [ 70-019 - D ] [ 70-019 - E ] [ 70-019 - F ] [ 70-019 - H ] [ 70-019 - I ] [ 70-019 - L ] [ 70-019 - M ] [ 70-019 - N ] [ 70-019 - O ] [ 70-019 - P ] [ 70-019 - R ] [ 70-019 - S ] [ 70-019 - U ] [ 70-019 - V ] [ 70-019 - W ]

Lineage

Info used to track where each row in a database table came from. Must save DTS package to MS Repository to get lineage options.

Use DTS designer to setup (cannot use the IMPORT or EXPORT wizards) Add 2 lineage columns to destination table. Source table not modified. Info for the lineage columns generated automatically 
MS Repository does not allow passwords

LINKED SERVERS

Difference between remote and linked servers - Linked servers can perform distributed queries as well as remote stored procedures. 

Linked server allows SQL Server to execute commands against OLAP Services using the OLE DB provider for OLAP.