You have an Excel workbook that contains a table named Sales. You add Sales to the Power Pivot model. You need to set a column named TransactionID as the row identifier for the Sales table. What…

The correct answer is A. From Power Pivot, modify the Table Behavior setting. https://msdn.microsoft.com/en-us/library/hh560542(v=sql.110).aspx Opening the Table Behavior dialog box In the Data View of your PowerPivot Window, click the PowerPivot Window: Advanced Tab. Click the table tab at the bottom of the window to select the table for which you are…

Model data by using Microsoft Excel

Question

You have an Excel workbook that contains a table named Sales. You add Sales to the Power Pivot model. You need to set a column named TransactionID as the row identifier for the Sales table. What should you do?

Options

AFrom Power Pivot, modify the Table Behavior setting.
BFrom Query Editor, add an index column.
CFrom Query Editor, modify the Data Type.
DFrom Power Pivot, modify the Default Field Set.

How the community answered

(55 responses)

A
75% (41)
B
15% (8)
C
7% (4)
D
4% (2)

Explanation

https://msdn.microsoft.com/en-us/library/hh560542(v=sql.110).aspx Opening the Table Behavior dialog box In the Data View of your PowerPivot Window, click the PowerPivot Window: Advanced Tab. Click the table tab at the bottom of the window to select the table for which you are configuring In Reporting Properties, click Table Behavior. Set the Row Identifier, and then proceed to specify other properties in this dialog. https://ksdconsultancy.blog/2015/10/08/set-table-behaviour-in-powerpivot/

Topics

#Power Pivot#table behavior#row identifier#data model

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice