Da Notes - 70-019 - I

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 ]

Import data

· DTS import wizard
· DTS designer - not as friendly
· BULK Import (text flies only)
· Replication - complex and limited to databases supported
· DTS custom program - very complex but may be better when many tables must be imported

INSERT SELECT

· Selecting data from an existing SQL Server table to be added to another table; SELECT INTO creates a new table, and INSERT SELECT requires an existing table
Installation Options
· OLAP server 
· OLAP Manager 
· Client Components (client components and other related files). Required to run the OLAP Manager and the OLAP server 
· Sample applications

Installation Parameters

· -r causes Setup.exe to automatically generate a silent response file (.iss) 
· -s performs a silent unattended installation using the response file created with -r 
· -f1<path\ResponseFile> defines alternate location and name of the response file (.iss file) 
· -f2<path\LogFile> defines alternate location and name of the log file 

Integrity

· Domain = columns
· Entity = rows
· Referential = between tables
· User defined = specific business rules