Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer chokes, but the text of the scenario is the same in each question in this series.
Start of repeated scenario
You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Four workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.
Data Sample:
The data model is shown in the Data Model exhibit.
Data Model:
A . In the workbook query for Workshops, filter [IsLatest] to equal 1.
B . In the workbook query for Workshops, add an index column.
C . In the Power Pivot model, change the data type for Workshop[lD] to General.
D . In the Power Pivot model, change the Table Behavior setting for Workshops.
Answer: D