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.

This Article Covers

SQL Server 2008 R2

TECHNOLOGIES
Big data analytics
+ Show More

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

This was last published in August 2010

Dig Deeper on Microsoft SQL Server 2008 R2

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close