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.

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.

View Answer

Answer: D