4. The query the report uses looks something like this: Alter Stored Procedure spv Report (@Fund varchar(100), @AsOfDate datetime) As Begin Create Table #Results (Reportline varchar(100), Amount decimal(28,12)) Insert into #Results Select ReportLine, Sum(Amount) From FactGL AS GL Join AuxReportLineMatrix ARLM on GL AccountKey - ARLM.AccountKey Where Fund @FundKey and PostingDate @AsOFDate Group by ReportLine Insert into #Results Select ReportLine, Sum(Amount) From FactCommitment As CMT Where Fund FundKey and PostingDate @ASOFDate Group by ReportLine Insert into #Results Select ReportLine, Sum(Amount) From FactMemo As Mem Join AuxReportLineMatrix ARLM on MEM.AccountKey=ARLM.AccountKey Where Fund @FundKey and PostingDate a AsOFDate Group by ReportLine Update #Results set Amount Amount".12 From #Results R Join AuxReportLineMatrixFx ARLM on R. ReportLine ARLM.ReportLine Where ARLM.CurrencyCode='disc Delete from #Results where Amount = 0 Select from #Results End How do you find out where the Other Assets is comes from in the database tables? 5. If you found that this query is the only part of the procedure that returns or changes the Other Assets line. Insert into #Results Select ReportLine, Sum(Amount) From FactGL. As GL Join AuxReportLineMatrix ARLM on GL.AccountKey-ARLM.AccountKey Where Fund FundKey and PostingDate= @AsOFDate Group by ReportLine How do you get more detail on what makes up the query? 6. If in looking at more detail you find these values, and you suspect that you should eliminate reversals how would you do it? Report Line Amount Reversed Entry No Other Assets 100,000 0 1 Other Assets-70,000 1 2 Other Assets 70,000 1 3 Other Assets-70,000 1 4 Insert into #Results Select ReportLine, Sum(Amount) From FactGL. As GL. Join AuxReportLineMatrix ARLM on GL.AccountKey-ARLM.AccountKey Where Fund FundKey and PostingDate @ASOFDate Group by ReportLine 7. Software Development Lifecycle: A. What are the steps of the SDLC? B. In the scenario we just discussed what phases of the SDLC did you just do? C. What steps in the SDLC do you need to complete in order to complete this request and explain how you would do it? D. How would a support role follow all the SDLC steps to change a client's report?