Multiple Choice
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.
Correct Answer:

Verified
Correct Answer:
Verified
Q4: Operational databases store historical data.
Q37: What are Business Intelligence (BI)systems?
Q41: Compare the characteristics of an operational database
Q45: A data warehouse database differs from an
Q49: The structured storage equivalent of an RDBMS
Q51: RFM analysis analyzes and ranks customers based
Q52: Business Intelligence (BI)systems do which of the
Q53: What is a slowly changing dimension?
Q61: In RFM analysis,F stands for "how frequently."
Q102: Operational databases contain a fact table.