You have a tabular model hosted in SQL Server Analysis Services (SSAS).
You need to add new rows to an existing table. The solution must load only the new rows to
the table.
Which processing mode should you use?
A.
Process Data
B.
Process Full
C.
Process Add
D.
Process Clear
E.
Process Default
C
https://msdn.microsoft.com/en-us/library/ms174774.aspx
I believe it is the E (Process Default)
The correct answer is A. Process Add for tabular refers to processing Partitions. Pythons link refers to Cubes. Tabular link
https://msdn.microsoft.com/en-us/library/hh758414(v=sql.110).aspx
Looks like A should be answer
In question: The solution must load only the new rows to the table.
So let’s forget about processing a cube or partition. We will process only the table. According to https://msdn.microsoft.com/en-us/library/hh758414(v=sql.110).aspx
only Process Data or Process Default will be correct.
ProcessDefault checks the state of model and depending on this issues another Process Option (for example after structure change ProcessFull will be issued, after change in data Process Data will be issued).
As we should here only process the new rows, I would say “A” – Process Data is correct
A
I think E is correct as there might be calculated columns that need rebuilding once the new rows are added, process data will not process these.
C. We only want to add new rows. Options A and E will also process updated data I gather, so we do not want to use these.
https://www.mssqltips.com/sqlservertip/2997/using-processadd-to-add-rows-to-a-dimension-in-sql-server-analysis-services-ssas/
ProcessAdd for a dimension in SSAS (SQL Server Analysis Services). Doing a ProcessAdd for a partition is pretty easy, but there is not much documentation to do a ProcessAdd for a dimension. The SSAS documentation says that you cannot do it using the UI, but you can do it with XMLA
If it is coorect I also for C
The solution must load ONLY the new rows to the table.
Question is under tabular model not multidimensional model, under tabular model, Process Data doing is Loading data into a table without rebuilding hierarchies or relationships or recalculating calculated columns and measures.
https://msdn.microsoft.com/en-us/library/hh758414.aspx
I agree with Ralph
I agree with Ralph too