To use an SQL Server 2012 database in an Microsoft Excel 2013 PivotTable,it is generally useful to:
A)create a view in SQL Server 2012 to organize the data.
B)store the needed data in an Excel worksheet.
C)store the needed data in a Word document.
D)store the needed data in a PowerPoint slide show.
E)store the needed data in a Visio diagram.

Question

Quizplus · Accepted Answer

Creating a view in SQL Server 2012 can help organize the data in a way that is optimal for use in a PivotTable. Storing the data in an Excel worksheet or any other format would require unnecessary additional steps and could potentially result in errors or problems with data manipulation. Therefore, creating a view is the best choice.

To Use an SQL Server 2012 Database in an Microsoft