To use an SQL Server 2014 database in an Microsoft Excel 2013 PivotTable,it is generally useful to ________.
A)create a view in SQL Server 2014 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 Visio diagram

Question

Quizplus · Accepted Answer

Creating a view in SQL Server 2014 to organize the data allows Excel to easily and efficiently access the database for use in a PivotTable. Storing the data in an Excel worksheet is not always practical or efficient, and storing it in a Word document or Visio diagram would not allow for easy analysis in a PivotTable.

To Use an SQL Server 2014 Database in an Microsoft