10 Questions
What is the primary function of Microsoft SQL Server Analysis Services (SSAS)?
Analyze and make sense of information spread across multiple databases
Which services are included in Microsoft SQL Server related to business intelligence and data warehousing?
Integration Services, Reporting Services, and Analysis Services
What are the two flavors of Analysis Services provided by Microsoft SQL Server?
Multidimensional and Tabular
When did Microsoft release OLAP Services as part of SQL Server 7?
1998
What technology did Microsoft acquire in 1996 to begin its foray into the OLAP Server business?
OLAP software technology from Canada-based Panorama Software
What is DAX primarily used for?
Defining custom calculations for Calculated Columns and Measures
Which language is DAX an evolution of?
Multidimensional Expression (MDX)
Where is DAX used as a query language?
Analysis Services tabular model
What is the main purpose of DAX in Power BI?
Conditional formatting expressions and dynamic properties
Which technology uses the same Analysis Services engine as Tabular models?
Power Pivot for Excel
Test your knowledge of Microsoft SQL Server Analysis Services (SSAS) with this quiz. Challenge yourself with questions about OLAP, data mining, business intelligence, and data warehousing to assess your proficiency in using SSAS for analyzing and interpreting data.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free