View Count: 0
Duration: 46 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 10
OLAP stands for? 
Options:
  1. Online analytical processing
  2. Online analysis processing
  3. Online transaction processing
View Answer/Explanation:
a
Explanation:

Question No: 2 of 10
What is Microsoft SQL Server 2005 Analysis Services used for? 
Options:
  1. Delivers online analytical processing (OLAP)
  2. Delivers data mining functionality
  3. Used for extracting and storing data which allows easier reporting
  4. Both a and b
View Answer/Explanation:
d
Explanation:

Question No: 3 of 10
OLAP (Online Analytical Processing) system is used for________? 
Options:
  1. Analyze very large amount of data
  2. Multidimensional data model
  3. Analyze very small amount of data
  4. None of these
View Answer/Explanation:
a b
Explanation:

Question No: 4 of 10
Define some Key elements of Data Warehouse? 
Options:
  1. Fact Tables
  2. Dimension Tables
  3. Dimension
  4. Measures
View Answer/Explanation:
a b c d
Explanation:

Question No: 5 of 10
Which table contains the attributes based on which you need to summarize or analyze the data? 
Options:
  1. Fact Table
  2. Dimension table
  3. Both the above
  4. None of these
View Answer/Explanation:
b
Explanation:

Question No: 6 of 10
Dimension attributes are not completely independent from each other? Is It True or not? 
Options:
  1. TRUE
  2. FALSE
View Answer/Explanation:
a
Explanation:

Question No: 7 of 10
What are the two approaches for designing Dimension Model? 
Options:
  1. Star Schema
  2. Snow Flake Schema
  3. Star Flake Schema
  4. None of these
View Answer/Explanation:
a b
Explanation:

Question No: 8 of 10
What is Star Schema? 
Options:
  1. Each dimension is represented by one dimension table
  2. Each dimension table is linked to a fact table
  3. The dimension may be represented by more than one Dimension table
  4. Not All dimension tables are directly linked to Fact table
View Answer/Explanation:
a b
Explanation:

Question No: 9 of 10
What is Snowflake Schema? 
Options:
  1. Each dimension is represented by one dimension table
  2. Each dimension table is linked to a fact table
  3. Dimension may be represented by more than one Dimension table
  4. Not All dimension tables are directly linked to Fact table
View Answer/Explanation:
c d
Explanation:

Question No: 10 of 10
What do datawarehouses support? 
Options:
  1. OLAP
  2. OLTP
  3. OLAP and OLTP
  4. Operational databases
View Answer/Explanation:
a
Explanation:

  1