You are managing a SQL Server Analysis Services (SSAS) tabular database.
The database must meet the following requirements:
The processing must load data into partitions or tables.
The processing must not rebuild hierarchies or relationships.
The processing must not recalculate calculated columns.
You need to implement a processing strategy for the database to meet the requirements.
Which processing mode should you use?
A.
Process Clear
B.
Process Data
C.
Process Add
D.
Process Full
E.
Process Default
I think B (Process Data) is correct.
Process Add is available for partitions only. And Process Data also does not recalculate calculated columns and rebuilt hierarchies.
Yes, B is Correct.
Process Data – Load data into a partition or a table without rebuilding hierarchies or relationships or recalculating calculated columns and measures.
https://msdn.microsoft.com/en-us/library/hh758414.aspx
Then C might be correct the requirement is
The processing must load data into partitions or tables.
The processing must <> rebuild hierarchies or relationships.
The processing must <> recalculate calculated columns.
The processing must NOT rebuild hierarchies or relationships.
The processing must NOT recalculate calculated columns.
Pete, but your desrciption describe the definition for answer B not C!?
B is correct.
B is correct!
https://msdn.microsoft.com/en-us/library/gg492096.aspx
Yes. Process data is correct answer.
B
But the question states that you need “a processing strategy for the database to meet the requirements” and on database level there is no such thing as Process data…? So that would mean it would be a manual task all the time. Does that make sense at all??
https://msdn.microsoft.com/en-us/library/gg492096.aspx
There is no “Process Add” options at the database level either. I think the correct answer is “Process Data” i.e. (B)
https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/tabular-model-partitions-ssas-tabular
Process Data- Load data into a partition or a table without rebuilding hierarchies or relationships or recalculating calculated columns and measures.
Ans B