var dataArray = [[line, orderNo, site, orderType, partName, site, dueDate, quantity]]; var dataSettings = {scenarios: [scenario], filter: fAllParts, siteGroup: sgSite} var wbOrderChng = rapidResponse.workbooks.get({name:'Change Orders', scope:'Private'}, dataSettings); var cmdDeleteData= wbOrderChng.commands.get('DeleteData'); var wsOrderChng = wbOrderChng.worksheets.get('ChangeOrders') Which two lines of code would potentially delete records in a table if they appeared after the code shown in the exhibit? (Choose two.) Choose 2 answers

• A. var removeResult = wbOrderChng.remove(wsOrderChng.getData());
• B. var importResult = wsOrderChng.importData(dataArray);
• C. var removeResult = wsOrderChng.remove(dataArray);
• D. var executeResult = cmdDeleteData.execute();

The tables shown in the graphic are from an SQL database. Shaded fields indicate key fields in SQL.
Which three actions should you take to design this data model in RapidResponse? (Choose three.) Choose 3 answers

• A. In the TransactionDetail table, make ItemName plus ItemSite into a reference to the Item table.
• B. In the TransactionDetail table make ID, Owner, and Type into a reference to the TransactionHeader table.
• C. In the Item table, make Name plus Site into a reference to the ItemDetail table.
• D. In the TransactionHeader table, make ID, Owner, and Type into a reference to the TransactionDetail table.
• E. In the ItemDetail table, make Name plus Site into a reference to the Item table.

You have a worksheet based on the IndependentDemand table that includes columns for key fields plus multi-scenario columns for Quantity and EffectiveDemand. You want to highlight the Quantity fields where the value in the comparison scenario is different from the corresponding value in the workbook's baseline scenario. You want your worksheet to be able to highlight differences in several scenarios.
How would you achieve this highlighting?

• A. Define the Quantity column to show Actual value, and define an additional hidden column, Quantity0, as !Quantity#0 using "Calculate using grouped results in the previous row or other results"; then define conditional formatting where the Quantity column is not equal to Quantity0.
• B. Define the Quantity column to show Difference, select the scenario comparison filtering option to show Only records with different comparison values, then define conditional formatting for the Quantity column when the respective value is not equal to 0.
• C. Define the Quantity column to show Actual value; add a hidden multi-scenario column, QuantityDelta, to show Difference; then define conditional formatting for the Quantity column when their QuantityDelta field is not 0.
• D. Add a hidden multi-scenario column, RecordID, as show Differences; then define conditional formatting for the Quantity column where RecordID is not equal to 0.

You are asked to improve the performance of a worksheet based on the WhereConsumedForDemand table.
You notice there is no filter control selected.
Which type of filter will improve performance?

• A. a filter based on the IndependentDemand table
• B. a filter based on the Demand table
• C. a filter based on the Part table
• D. a filter based on the SupplyDemand table