Get started Bring yourself up to speed with our introductory content.

Quiz: BI in SQL Server 2008 R2

Are you a SQL Server 2008 R2 guru? Take the quiz to test your know-how on R2's new and improved BI capabilities.

Take this quiz and test your knowledge on the new BI features for SQL Server 2008 R2, including PowerPivot, Master Data Services, Parallel Data Warehouse and more.

1. The PowerPivot feature for SQL Server 2008 R2 was originally known by what codename? *

2. Reusable report sections that can be leveraged across multiple reports in Report Builder 3.0 are known as *

3. The new edition of SQL Server 2008 R2 designed to support massive data warehouses is called: *

4. IT can monitor and manage PowerPivot for SharePoint environments is known as: *

5. True or false? PowerPivot is only compatible with Microsoft Excel 2010 and SharePoint 2010. *

6. Master data management features are designed to help: *

7. From within PowerPivot, IT professionals can monitor: *

8. SQL Server data sources that have been designated as "master data" are also known as: *

9. From the Master Data Manager console for MDS, authorized users can: *

10. True or false? Power Pivot, Reporting Services (SSRS), Analysis Services (SSAS) and SharePoint 2010 can all integrate with Master Data Services in SQL Server 2008 R2. *

Online Surveys powered by SurveyGizmo
Online Survey Software

Dig Deeper on Microsoft SQL Server 2008 R2

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.