View Count: 0
Duration: 48 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 16 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 37 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 36 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
How many types of dimension are possible in SSAS? 
Options:
  1. Four
  2. Five
  3. Six
  4. Seven
View Answer/Explanation:
c
Explanation:

Question No: 2 of 10
Define dimension usage in SSAS Cube? 
Options:
  1. To maintain cube data size
  2. To know the relationships between dimensions and fact
  3. To build business logic
  4. None
View Answer/Explanation:
b
Explanation:

Question No: 3 of 10
Define role play dimensions? 
Options:
  1. One dimension used multiple times in the cube
  2. One dimension used in different cubes
  3. Shared across cubes
  4. None
View Answer/Explanation:
a
Explanation:

Question No: 4 of 10
In which scenario, you would like to go for materializing dimension? 
Options:
  1. To increase spee
  2. To decrease memory size
  3. Both
  4. None
View Answer/Explanation:
a
Explanation:

Question No: 5 of 10
You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. You get the Duplicate Key error when you operate the Analysis Services Database. You should alter the Error Configuration attribute in order to make processing run normally. Which is the correct answer? 
Options:
  1. You should alter the Dynamic Management View (DMV)
  2. You should alter the Local Group
  3. You should alter the dimension
  4. You should alter the Transactions Log
View Answer/Explanation:
c
Explanation:

Question No: 6 of 10
When you include a many-to-many dimension, the following rules apply? 
Options:
  1. You must add the intermediary measure group
  2. You must add the entire many-to-many dimension
  3. You must add the entirety of all dimensions common to the two measure groups involved in the many-to-many relationship
  4. All of the mentioned
View Answer/Explanation:
d
Explanation:
Reference dimensions are materialized and added as regular dimensions

Question No: 7 of 10
What are the different types of Hierarchies? 
Options:
  1. Natural Hierarchy
  2. Unnatural Hierarchy
  3. Balanced Hierarchy
  4. Unbalanced Hierarchy
View Answer/Explanation:
a c d
Explanation:

Question No: 8 of 10
How to disable the attribute Hierarchy? 
Options:
  1. Attribute Hierarchy Enabled: False
  2. Attribute Hierarchy: False
  3. Attribute Hierarchy Enabled: True
  4. None of these
View Answer/Explanation:
a
Explanation:

Question No: 9 of 10
Which type of property determines whether data for parent members should be displayed? 
Options:
  1. Members with Data Property
  2. Naming Template Property
  3. All the above
  4. None of these
View Answer/Explanation:
a
Explanation:

Question No: 10 of 10
The attribute which identifies the parent of a dimension member is called________? 
Options:
  1. Parent Key Attribute
  2. Member Key Attribute
  3. None of these
View Answer/Explanation:
a
Explanation:

  1