Question

which option is suitable to calculate the effect of different interest rates on an investment:-
1.scenario manager
2.subtotal
3.consolidation of data
4.none of the above

Plz logical or absolutely correct answers only

Answer 1

The (3) CONSOLIDATION OF DATA option is suitable to calculate the effect of different interest rates on an investment.

• Data is generated from many disparate sources and in many different formats. Data consolidation is the process that combines all of that data wherever it may live, removes any redundancies, and cleans up any errors before it gets stored in one location, like a data warehouse or data lake.
• This "consolidation" — beyond the scope of this post — is often performed on a regular schedule and is used to incorporate changes to data being replicated in order to ensure the "latest" version of data is reflected in the data warehouse.

Answer 2

Council addition of dataA

E