Da Notes - 70-019 - V

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 ]

Views

· Allows you to partition data by rows and / or columns. You can assign user permissions to views. This allows you to group data by specific rows, columns and tables.
 

VIRTUAL CUBES

· Similar to a database view
· a combination of one or multiple cubes in one real cube 
· requires little physical disk space 
· can also be based on a single cube to expose only selected subsets of its measures and dimensions 
· stores definitions, and not the data of their component cubes 
· Limited security function by restricting some users' view of the underlying cubes 
· Must process the virtual cube after creation to establish the internal links to its dimensions and measures in the underlying cube or cubes.

VIRTUAL CUBE WIZARD

· Setup a virtual cube. 

VIRTUAL DIMENSION

· Fact table columns CANNOT be used to create virtual dimensions. 
· Logical dimension based on a physical dimension property. 
· Allows you to analyze cube data based on member properties of dimension level members in a cube 
· Can be added to a cube when the dimension member property is in the cube 
· Does not increase cube size because aggregation data is not stored in the cube.
· Calculated in memory as needed. Does not affect cube processing time 

Usage Based Optimization Wizard

· Help you reduce the number of aggregations and processing time.
· Optimize OLAP cubes design based on user queries.