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?

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.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Alex

Alex

Yes. E, process data and process recalc

Rams

Rams

Yes, E is the correct answer. Process defrag option not available for Database.
Process Defrag -Defragments the auxiliary table indexes.

Process Recalc -Updates and recalculates hierarchies, relationships, and calculated columns.
https://msdn.microsoft.com/en-us/library/hh758414.aspx

Fabio J.

Fabio J.

I Agree.

nohup

nohup

E
Any time after you do a Process Clear or Process Data, you must issue a Process Recalc. Also, after you merge partitions in script, you must perform a Process Recalc. Your model may be unqueryable if you skip the Process Recalc. Process Recalc is always the last thing you do, and you can batch up as many processing operations as you want before issuing that last Process Recalc.

You do not need to Process Recalc if you do a Process Add, Process Full, or Process Default.

Youri

Youri

E is Correct