Da Notes - 70-019 - C

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 ]

Calculations

Table size = Row size in bytes * Nbr of rows / 1024 (1 time = K, 2 times = Meg, 3 times = gigabytes)

Create Index

Creates an index on a given table. 
· UNIQUE - Creates a unique index (one in which no two rows are permitted to have the same index value). 
· CLUSTERED - Physical order of rows is the same as the indexed order of the rows. 
· NON-CLUSTERED - physical order of the rows is not the same as their indexed order. 
· PAD_INDEX - Space to leave open on each page (node) in the index. Useful only when FILLFACTOR is specified 
· FILLFACTOR = fillfactor - Percentage of how full SQL Server should make the leaf level of each index page during index creation. 
· IGNORE_DUP_KEY - If specified and an INSERT statement that creates a duplicate key is executed, SQL Server issues a warning message and ignores (does not insert) the duplicate row. Otherwise an error is raised.
· DROP_EXISTING - Specifies the index should be dropped and rebuilt. The index name must be an existing index. This clause enhances performance when recreating a clustered index (with either the same or a different set of keys) on a table that also has nonclustered indexes. The nonclustered indexes are rebuilt once, and only if the keys are different. This clause replaces the execution of a DROP INDEX statement on the old clustered index followed by the execution of a CREATE INDEX statement for the new clustered index (a DBCC REINDEX could also be used).

Cube Wizard

Interface for specifying the fact table, measures, and dimensions when you build your cube.

Custom Applications

Use Microsoft ActiveX Data Objects (ADO), (ADO MD), multidimensional expressions (MDX), or Microsoft English Query to access or manipulate a data source.

Add-in Programs - you can create and register add-in programs that will be called by the OLAP Add-In Manager in response to user activity in the OLAP Manager user interface. They can optionally use Decision Support Objects (DSO) to manage server objects, and multiple add-in programs can be registered.