Developing SQL 2016 Data Models (SSAS) Quiz Questions and Answers

CALCULATE statement is used to populate each cell in the cube with aggregated data.

Answer :
  • FALSE

What is the full form of OLAP?

Answer :
  • Online Analytical Processing

What is Microsoft SQL Server Analysis Services used for?

Answer :
  • Both 1 and 2

What is the full form of KPI?

Answer :
  • Key Performance Indicator

What are the types of storage mode?

Answer :
  • All of the above

Which type of data models are used by databases configured for OLAP?

Answer :
  • Multidimensional

Named query in DSV is similar to _______________ in Database.

Answer :
  • View

A cube contains Time and Department dimensions along with Salary, DA measures. How many measures will that cube contain?

Answer :
  • 3

Calculated members can be created with________.

Answer :
  • Both A and B

You use SQL Server Profiler to watch the events generated as a result of a processing operation. You need to find how many records the server has read from the data source when processing a dimension. Which Profiler column do you need to examine?

Answer :
  • IntegerData