exam questions

Exam MCIA - Level 1 All Questions

View all questions & answers for the MCIA - Level 1 exam

Exam MCIA - Level 1 topic 1 question 90 discussion

Actual exam question from Mulesoft's MCIA - Level 1
Question #: 90
Topic #: 1
[All MCIA - Level 1 Questions]

An external web UI application currently accepts occasional HTTP requests from client web browsers to change (insert, update, or delete) inventory pricing information in an inventory system's database. Each inventory pricing change must be transformed and then synchronized with multiple customer experience systems in near real-time (in under 10 seconds). New customer experience systems are expected to be added in the future.

The database is used heavily and limits the number of SELECT queries that can be made to the database to 10 requests per hour per user.

What is the most scalable, idiomatic (used for its intended purpose), decoupled. reusable, and maintainable integration mechanism available to synchronize each inventory pricing change with the various customer experience systems in near real-time?

  • A. Write a Mule application with a Database On Table Row event source configured for the inventory pricing database, with the watermark attribute set to an appropriate database column
    In the same now, use a Scatter-Gather to call each customer experience system's REST API with transformed inventory-pricing records
  • B. Add a trigger to the inventory-pricing database table so that for each change to the inventory pricing database, a stored procedure is called that makes a REST call to a Mule application
    Write the Mule application to publish each Mule event as a message to an Anypoint MQ exchange
    Write other Mule applications to subscribe to the Anypoint MQ exchange, transform each received message, and then update the Mule application's corresponding customer experience system(s)
  • C. Replace the external web UI application with a Mule application to accept HTTP requests from client web browsers
    In the same Mule application, use a Batch Job scope to test if the database request will succeed, aggregate pricing changes within a short time window, and then update both the inventory pricing database and each customer experience system using a Parallel For Each scope
  • D. Write a Mule application with a Database On Table Row event source configured for the inventory pricing database, with the ID attribute set to an appropriate database column
    In the same flow, use a Batch Job scope to publish transformed Inventory-pricing records to an Anypoint MQ queue
    Write other Mule applications to subscribe to the Anypoint MQ queue, transform each received message, and then update the Mule application's corresponding customer experience system(s)
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Alandt
6 months, 1 week ago
Selected Answer: B
I made the official Mulesoft practice exam and the correct answer was B. Add a trigger....
upvoted 1 times
...
gilofernandes
1 year, 1 month ago
Selected Answer: B
A and D are using Database On Table Row event which causes a lot of SELECT's to the database. Option C is not scalable and decoupled: for each new customer a new entry in parallel For each must be added. So option B is correct one for me.
upvoted 3 times
...
prapasup
1 year, 2 months ago
Selected Answer: A
A makes more sense in terms of synchronizing three systems using scatter-gather
upvoted 2 times
...
lwong1
1 year, 9 months ago
Database On Table Row event source selects from the database table at a regular frequency. For this I believe it's option C, although is replacing the "external" web UI
upvoted 2 times
...
lzrvs
1 year, 11 months ago
Selected Answer: D
The batch scope part does not make much sense to be honest, especially if we are talking about relatively low volume. Nevertheless, it will serve the purpose. The subscription to a queue exchange will ensure decoupling, fault tolerance and future scalability.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago