| |
|
|
|
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
|
|
|
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
|
|
|
|