Interview Questions

1. Analysis Services provides how many core services?

Options:

a. 2

b. 3

c. 4

d. 1

Reveal Answer

2. What is Analysis Services?

Options:

a. It is the multidimensional database engine

b. It is the single dimensional database engine

c. None of these

Reveal Answer

3. By default, in a ________ schema, all attributes are directly related to the key attributes?

Options:

a. Relational

b. Snowflake

c. Star

d. None of the mentioned

Reveal Answer

4. What is Data mining?

Options:

a. Analysis to find the trends and patterns in data

b. For storing and retrieving large amount of data for analysis

c. None of these

Reveal Answer

5. Define some tools in SSAS?

Options:

a. SSDT (SQL Server Data Tools)

b. SSMS (SQL Server Management Studio)

c. All the above

d. None of these

Reveal Answer

6. UDM Stands for_____?

Options:

a. Unified Dimension Model

b. Unified Dim Model

c. None of these

Reveal Answer

7. Each fact table does not relate to at least one dimension table?

Options:

a. True

b. False

Reveal Answer

8. Each dimension table must be related to other dimension or fact table?

Options:

a. True

b. False

Reveal Answer

9. Analysis can be dome through __________?

Options:

a. MDX (Multidimensional query language)

b. Reporting SSRS

c. EXCEL Pivot

d. None of these

Reveal Answer

Interview Questions and Answer

1. Analysis Services provides how many core services?

2. What is Analysis Services?

3. By default, in a ________ schema, all attributes are directly related to the key attributes?

4. What is Data mining?

5. Define some tools in SSAS?

6. UDM Stands for_____?

7. Each fact table does not relate to at least one dimension table?

8. Each dimension table must be related to other dimension or fact table?

9. Analysis can be dome through __________?

Packages

Resources

About

Other links