Microsoft Exam Questions

You need to ensure that the model has the most recent data while minimizing the processing time

You are developing a tabular Business Intelligence Semantic Model (BISMJ database based
on a SQL Server database.
In the data source, the FactlnternetSales table is partitioned by month. Data from the current
month has been updated and new data has been inserted in the FactlnternetSales table, in
the DimProduct table, and in the DimCustomer table.
In the model, the FactlnternetSales table is also partitioned by month.
You need to ensure that the model has the most recent data while minimizing the processing
time.
What should you do?

A.
Process the latest FactlnternetSales model table partition, the DimProduct table, and the
DimCustomer table with the Process Clear processing option. Then process the database
with the Process Data processing option.

B.
Process the latest FactlnternetSales model table partition, the DimProduct table, and the
DimCustomer table with the Process Clear processing option. Then process the database
with the Process Full processing option.

C.
Process the latest FactlnternetSales model table partition, the DimProduct table, and the
DimCustomer table with the Process Defrag processing option. Then process the database
with the Process Recalc processing option.

D.
Process the latest FactlnternetSales model table partition, the DimProduct table, and the
DimCustomer table with the Process Data processing option. Then process the database
with the Process Defrag processing option.

E.
Process the latest FactlnternetSales model table partition, the DimProduct table, and the
DimCustomer table with the Process Data processing option. Then process the database
with the Process Recalc processing option.