This Microsoft SQL Server Analysis Services, SSAS, quiz has been compiled to cover different aspects of SSAS, so it will be of great benefit to you if you take it. Click the start button to get started, Good Luck!
Questions and Answers
1.
They are how many types of data mart?
A. 
1
B. 
2
C. 
3
D. 
4
2.
The types of data mart include:
A. 
Dependent
B. 
Independent
C. 
Logical data mart
D. 
All of the above
3.
SQL expression represented as a calculated column is a/an
A. 
Named calculation
B. 
Expressed calculation
C. 
Column calculation
D. 
Row calculation
4.
The fact table consist of how many sections?
A. 
1
B. 
2
C. 
3
D. 
4
5.
There are how many types of dimensions?
A. 
1
B. 
2
C. 
3
D. 
4
6.
The dimension which is sharable across the multiple facts or data model is known as
A. 
Degenerate attribute
B. 
Junk dimension
C. 
Confirm dimension
D. 
None of the above
7.
Fact table is directly linked with all dimension tables in which type of database schema?
A. 
Star
B. 
Snowflake
C. 
Starflake
D. 
None of the above
8.
There are how many types of hierarchies?
A. 
4
B. 
3
C. 
2
D. 
1
9.
The following are the standard storage modes in OLAP applications except:
A. 
MOLAP
B. 
ROLAP
C. 
HOLAP
D. 
JOLAP
10.
The dimension table is joined to an intermediate table, which in turn, is joined to the fact table in which type of relation?
If you're a student and preparing for a computer exam, then look no further than Tthis quiz. his might be a good practice to test your Microsoft word skills, you might get to learn something that you didn't before. Go and...
Questions: 18 | Attempts: 118906 | Last updated: Mar 22, 2022
Sample Question
You place the insertion point in the middle of a paragraph and start typing. But the new text deletes existing text. What's the problem and how do you fix it?
A Basic Microsoft excel quiz! Have you just finished your training in Microsoft Excel and are looking to test out your understanding? The practice test below is set to test how well you can use excel effectively. Give it...
Questions: 20 | Attempts: 115092 | Last updated: Mar 22, 2022
Sample Question
A fast way to add up this column of numbers is to click on the cell below the numbers and then:
Office tools such as MS Word, PowerPoint, Excel, Access, etc are must-have skills for any professional nowadays. Take this Microsoft PowerPoint exam quiz to see how well you know some PowerPoint basics. Content in this quiz was...