SSAS 2008 Practice Test

10 Questions | By Stephanie044 | Updated: Mar 21, 2022 | Attempts: 384

Questions

Settings

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