Exam MCD - Level 1 All QuestionsBrowse all questions from this exam
Question 64

Refer to the exhibits.

A web client sends a new order record {`oid`: `100`, `custId`: `[email protected]`, `status`: `NEW ORDER` } in the payload of a POST request to the Mule application.

What value must be used in the Input Parameters field of the Database Insert operation to properly pass the order record values to the SQL statement?

A.

B.

C.

D.

    Correct Answer:

    The correct value for the Input Parameters field in the Database Insert operation must match the variable names defined in the SQL statement's query and the keys in the JSON payload to pass the order record values properly. The provided SQL query text in the exhibit expects parameters named oid, custId, and status, as seen from the notation :oid, :custId, and :status. Given the payload structure, the correct value for the Input Parameters field should map each of these expected parameters to the corresponding fields from the payload. Therefore, the correct answer is A, where the mappings are provided as: '#[ {oid: payload.oid, custId: payload.custId, status: payload.status} ]'. This ensures that the values from the payload are correctly passed to the SQL statement.

Discussion
alexstam

correct its A

nfortunengcobo

A is correct

ExamDev

A is correct