SSAS 2008 Practice Test
10 Questions
| Total Attempts: 362
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?
- A.
Fact
- B.
Data mining
- C.
Regular
- D.
Referenced
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 QuestionYou 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 QuestionA 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...
Questions: 30 | Attempts: 64218 | Last updated: Apr 26, 2022
-
Sample QuestionWhat is the best way to design the layout for your slides?
- Academic Technology Quizzes
- Apple Quizzes
- Automation Quizzes
- Dell Quizzes
- Educational Technology Quizzes
- Gadget Quizzes
- Hcl Quizzes
- Hvac Quizzes
- Hydraulics Quizzes
- Ibm Quizzes
- Information Technology Quizzes
- Microphone Quizzes
- Multimedia Quizzes
- Samsung Quizzes
- Technology Pre Assessment Quizzes
Back to top