最新なKinaxis KX3-003問題集（62題）、真実試験の問題を全部にカバー！

質問 1：
Customers sign in to view only their independent demands. The customer's User IDs are in a user group with the name of the customer to which they correspond. You want to create a single worksheet that allows customers to only view their independent demands within RapidResponse.
How would you accomplish this task?
A. Create a Profile Variable called CustomerView where the user group is equal to the Customer Name. In the worksheet visible to the customer, create a worksheet filter with the Order.Customer.Name =
$CustomerView expression.
B. Create a Profile Variable called CustomerView where the data value and user group is equal to the Customer Name. In the worksheet visible to the customer, create a worksheet filter with the Order.Customer.ID = $CustomerView expression.
C. Create a Profile Variable called CustomerView where the data value and user group is equal to the Customer Name. In the worksheet visible to the customer, create a worksheet filter with the Order.Customer.Name = $CustomerView expression.
D. Create a Profile Variable called CustomerView where the data value is equal to the Customer Name. In the worksheet visible to the customer, create a worksheet filter with the Order.Customer.Name =
$CustomerView expression.
正解：B
解説: (Pass4Test メンバーにのみ表示されます)

質問 2：
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 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.
B. 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.
C. 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.
D. 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
解説: (Pass4Test メンバーにのみ表示されます)

質問 3：
You have a worksheet based on the Part table. You want to know the total number of unique customers that have orders for each part.
Which expression accomplishes this task?
A. COUNT IndependentDemands {Order.Customer:By}
B. COUNT IndependentDemands {Order.Customer:Sum}
C. COUNT IndependentDemands {Order.Customer<>''}
D. SUM IndependentDemands{Order.Customer:Sum}
正解：A
解説: (Pass4Test メンバーにのみ表示されます)

質問 4：

You want to define a custom data structure connecting BuyerCode to additional information: Manager, Department, and Floor. A manager might be responsible for more than one department. You expect that users will want to filter this information on combinations of each of those data elements.
Referring to the graphic, which data model structure should you use?
A. IV
B. II
C. III
D. I
正解：B
解説: (Pass4Test メンバーにのみ表示されます)

質問 5：

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 ItemDetail table, make Name plus Site into a reference to the Item table.
D. In the TransactionHeader table, make ID, Owner, and Type into a reference to the TransactionDetail table.
E. In the Item table, make Name plus Site into a reference to the ItemDetail table.
正解：A,B,C
解説: (Pass4Test メンバーにのみ表示されます)

質問 6：

Given the worksheet properties shown in the exhibit, which console output would exist for the following script?
var dataForInsert = [['1','BBy-LCD37','DC-Europe','DCRequest','LCD-3735','DC-Europe','06-01-20',147]]; var wbOrderChng = rapidResponse.workbooks.get({name:'Change Orders',scope:'Private'}, {scenarios:
[scenario], filter: {name: 'All Parts', scope: 'Public'}, siteGroup: {name: site, scope: 'Public'}}); var wsOrderChng = wbOrderChng.worksheets.get('ChangeOrders'); var importResult = wsOrderChng.importData(dataForInsert); rapidResponse.console.writeLine(JSON.stringify(importResult));
A. error 455: "importData failed. Delete modify not permitted"
B. 1 record(s) inserted
C. {"deleted":0,"modified":0,"inserted":1}
D. {"deleted":-1,"modified":-1,"inserted":1}
正解：C
解説: (Pass4Test メンバーにのみ表示されます)