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?
A.
From Query Editor, modify the Data Type
B.
From Power Pivot, modify the Table Behavior settings
B is the correct answer. See the link:
https://support.office.com/en-us/article/set-table-behavior-properties-for-power-view-reports-c0e8c95e-5bb0-4bd8-a86c-6013301700ca
B is the only correct answer as the question is really stating that you have added the Sales table already to the Power Pivot datamodel. So you need to work from there. Power query is already behind (if it was used).
Can you tell us your test steps? how did u crate the sales table with what columns and what you did
upvoted 1 times
...
...
...
This section is not available anymore. Please use the main Exam Page.70-779 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
SN22
Highly Voted 5 years, 4 months agoOompaLoompa
Most Recent 4 years, 5 months agoWarpCore
4 years, 8 months agoWaltmas
4 years, 11 months agoVermonster
5 years, 3 months agoVermonster
5 years, 3 months agosjonghe
4 years, 7 months agomamarach
4 years, 11 months agoexcelll
5 years, 8 months agoSamewiss
5 years, 7 months agoSamewiss
5 years, 7 months agomohroshdy
5 years, 7 months agoDebjit
4 years, 10 months ago