Salesforce-MuleSoft-Developer-I Salesforce Certified MuleSoft Developer (Mule-Dev-201) Questions and Answers

MuleSoft Documentation Reference : https://docs.mulesoft.com/db-connector/1.9/database-connector-select

You can define your own DataWeave functionsusing the fun declaration in the header of a DataWeave script. Sample is as below. ----------------------------------------

%dw 2.0

output application/json

fun toUpper(aString) = upper(aString)

---

toUpper("hello")

MuleSoft Doc Ref : https://docs.mulesoft.com/mule-runtime/4.1/dataweave-functions

Correct answer is Save the payload from the Database SELECT operation to a variable

Response from HTTP requestwill override the payload and hence response of database SELECT can be lost. Best way to preserve is to assign payload of first operation to variable using TransformMessage.

APIKIt Creates a separate flow for each HTTP method. Hence 4 private flows would be generated.

MuleSoft Documentation Referrence :https://docs.mulesoft.com/mule-runtime/4.3/build-application-from-api

Correct answer is Creates and manages discoverable assets to be consumedby line of business developers.

C4E does not get directly involved in projects.

POM.xml contains info about the project and configurationn details used by Maven to build the project

Correct answer is MAJOR

MAJOR version when you make incompatible API changes, MINOR version when you add functionality in a backwards compatible manner, and PATCH version when you make backwards compatible bug fixes.

For details refer to this documentation : https://semver.org/

Correct answer is Mule runtime

DataWeave is the MuleSoft expression language for accessing and transforming data that travels through a Mule app. DataWeave is tightly integrated with the Mule runtime engine, which runs the scripts and expressions in your Mule app.

Mule Doc Reference : https://docs.mulesoft.com/mule-runtime/4.3/dataweave

Lets revise few concepts RAML which can help us to find the answer of this question.

URI Parameters

Lets have a look at below example.

/foos:

/{id}:

/name/{name}:

Here, the braces { } around property names define URI parameters. They represent placeholders in each URI anddo not reference root-level RAML file properties as we saw above in the baseUri declaration. The added lines represent the resources /foos/{id} and /foos/name/{name}.

Query Parameters

Now we'll define a way to query the foos collection using query parameters. Note that query parameters are defined using the same syntax that we used above for data types:

/foos:

get:

description:ListallFoosmatching query criteria,ifprovided;

otherwise list allFoos

queryParameters:

name?:string

ownerName?:string

Based on the above information , below is the only option which defines storeid as uri parameter and department as query parameter.

/{storeId}:

get:

queryParameter:

department:

Allowed methods is an optional configuration. If nothing is specified then all HTTP methods are supported.

Rest all are mandatory.

*Batch scope has filter criteria which says paylod mod 2 = 0 whch means only 2, 4 and 6 will be in batch scope.

* So payload for each of these will be incremented by 10.

* Aggregator has batch size defined as 2. So it will process in batch of two records.

* Hence option 3 is correct answer.

[20,40]

[60]

Behavior with aggregator configured with fixed size

In this scenario, the batch step sends the processed records to an aggregator, which starts processing the records and buffering them until the configuredaggregator’s size is reached. After that, the aggregator sends the aggregated records to the stepping queue.

Diagram Description automatically generated

The batch job builds record blocks of the configured block size and sends them to their corresponding batch step for processing. Each batch stepreceives one or more record blocks and starts processing them in parallel. After the batch step processes a record, the batch step sends the record to the aggregator for further processing. The aggregator continues processing records until the number of aggregated records reaches the configured aggregator’s size.

https://docs.mulesoft.com/mule-runtime/4.3/batch-processing-concept

Scatter-Gather Router

The Scatter-Gather component is arouting event processor that processes a Mule event through different parallel processing routes that contain different event processors. Each route receives a reference to the Mule event and executes a sequence of one or more event processors. Each of these routes uses a separate thread to execute the event processors, and the resulting Mule event can be either the same Mule event without modifications or a new Mule event with its own payload, attributes, and variables. The Scatter-Gather component then combines the Mule events returned by each processing route into a new Mule event that is passed to the next event processor only after every route completes successfully.

The Scatter-Gather component executes each route in parallel, not sequentially. Parallel execution of routes can greatly increase the efficiency of your Mule application and may provide more information than sequential processing.

Mule Ref Doc : https://docs.mulesoft.com/mule-runtime/4.3/scatter-gather-concept

Web Services Description Language. WSDL is used to describe SOAP based web services

Process section is must to get compiles. Process section must have one or more processors

Diagram Description automatically generated

Pick First is not valid type. Rest all are valid type of event processor.

Choice : https://docs.mulesoft.com/mule-runtime/4.3/choice-router-concept

Round Robin : https://docs.mulesoft.com/mule-runtime/4.3/round-robin

First Successful : https://docs.mulesoft.com/mule-runtime/4.3/first-successful

In this case as outbound call is made using HTTP: POST /child , all attributes will be replaced by this invocation. Hence query parameter will not be accessible at logger. Hence correct answer is option 2

Correct answer is as below.After all processing routes have finished execution, the Scatter-Gathercomponent creates a new Mule event that combines all resulting Mule events from each route, and then passes the new Mule event to the next component in the flow.

{

"0": {

"attributes": ...,

"payload": "100"

},

"1": {

"attributes": ...,

"payload": "200"

}

}

Bottom of Form

Correct answer is The city is #[payload.City]

Answer can get confused with the option #["The city is" ++ payload.City] But note that this option will not print the space between is and city name. This will print The city isPune

Correct answer is */status as it is the correct way to use wildcards while configuring path value in HTTP listener

Correct answer is Not needed asdw::core module is included by default. We don't need to include it explicitly

Query parameters are a defined set of parameters attached to the end of a url. They are extensions of the URL that are used to help define specific content or actions based on the data being passed. To append query params to the end of a URL, a ‘?’ Is added followed immediately by a query parameter.

To add multiple parameters, an ‘&’ is added in between each.

Hence coming back to question, endpoint would return Patients with name as John and (and is very important here) surname as Bell

As can be seen in error message , SOAP service findFlights expects the SOAP paylaod. This can be set using transform message processor which forms SOAP payload before the Consume operation that contains the destination query parameter

First step in creating Modern API is to create an API specification and get feedback from stakeholders so that any future issues can be identified at early stage thereby reducing overall delivery time

The HTTP 415 Unsupported Media Type client error response codeindicates that the server refuses to accept the request because the payload format is in an unsupported format. The format problem might be due to the request's indicated Content-Type or Content-Encoding , or as a result of inspecting the data directly. Asper RAML input is expected in application/xml.

Hence correct answer is Set a request header with the name Content-Type to a

Correct answer is 0.1 vCores

MuleSoft Doc Ref :https://docs.mulesoft.com/runtime-manager/cloudhub-architecture#cloudhub-workers

CloudHub Workers

Workers are dedicated instances of Mule runtime engine that run your integration applications on CloudHub. The memory capacity and processing power of a worker depends on how you configure it at the application level.

Worker sizes have different compute, memory, and storage capacities. You can scale workers vertically by selecting one of the available worker sizes:

Table Description automatically generated

The List operation returns an array of messages in which: Each message holds the file’s content in its payload. The file’s attributes section carries the file’s metadata (such as name, creation time, and size). The payload is empty if the element is a folder.

This question validates you knowledge on Batch Processing. Before we analyze the question , lets revise a bit about batchfilters.

Batch Filters

You can apply one or more filters as attributes to any number of batch steps.Imagine a batch job whose first batch step checks if a Salesforce contact exists for a record, and a second batch step that updates each existing Salesforce contact with new information. You can apply a filter to the second batch step to ensure it only processes records that didn’t fail during the first batch step.By having batch steps accept only some records for processing, you streamline the batch job sothe Mule runtime engine can focus only on the relevant data for a particular batch step.

A batch step uses two attributes to filter records:

acceptExpression

acceptPolicy

Each batch step can accept one acceptExpression and one acceptPolicy attributes to filter records.

Use the acceptExpression attribute to process only records that evaluate to true; if the record evaluates to false, the batch step skips the record and sends it to the next one. In other words, the records with an accept expression that resolves to false are the ones that Mule filters out.

The example below filters out all records where the age is less than 21; the batch step does not process those records.

21]">

...

Mule Ref Doc : Refining Batch StepsProcessing | MuleSoft Documentation

As we are clear with above concepts , now lets understand this solution step by step.

1) Batch Step (Less than 50)

Accept expression for this batch step is less than 50. Hence elements which will go in this batch step are amount value 40 and 2. Hence output of logger in first batch step is

{amount=140}

{amount=102}

2) Batch Step (Greater than 20)

Accept condition for this batch step is greater than 20. Note that input amount values for this batch step are 100 , 140 and102 (last two values have been updated in batch step less than 50)

As all values satisfy this condition out put of second logger is

{step2amount=100}

{step2amount=140}

{step2amount=102}

Hence correct answer to this question is

{amount=140}

{amount=102}

{step2amount=100}

{step2amount=140}

{step2amount=102}

2) Batch Step (Greater than 20)

Accept condition for this batch step is greater than 20. Note that input amount values for this batch step are 100 , 140 and 102 (last two values have been updated inbatch step less than 50)

As all values satisfy this condition out put of second logger is

{step2amount=100}

{step2amount=140}

{step2amount=102}

Hence correct answer to this question is

{amount=140}

{amount=102}

{step2amount=100}

{step2amount=140}

{step2amount=102}

The flow can be described asbelow. 1) First HTTP POST requets is made in which paylaod is set to 1 and it gets returned to our mail flow. 2) Second call is initiated for JMS Publish Consume JMS: num1 which add 1 to the payload which makes it as 2. Note that pubih consume is a synchronous operation. Hence paylaod is returned to main flow. 3) Third call is initiated for JMS Publish JMS: num2 which add 1 to the payload . Note that pubih is asynchronous operation. Hence paylaod is never returned to main flow. So payload in main flow is still 2. 4) Finally Set Payload increments payload by 1 making payload as 3 which is returned by the flow. Hence option 3 is the correct answer.

Correct answer is Nothing needs to be changed in the other APIs or their associated applications

This is the benefit of havingseparate interface layer. As there are no changes to interface , no changes are required on the API's which consumes this API in context

Correct answer is Configure the correct JDBC driver as error message suggests the same

Causedby:java.sql.SQLException:Errortrying to load driver:com.mysql.jdbc.Driver:Cannotloadclass'com.mysql.jdbc.Driver':[

Class'com.mysql.jdbc.Driver'hasnopackagemappingforregion'domain/default/app/mule_app'.,

Cannotloadclass'com.mysql.jdbc.Driver':[

Correct answer is below as it follows the correct syntax.

/customers:

/{customerId}:

get:

Correct answer is Request access to the API in Anypoint Exchange. This way we can get clientId and Client secret which we can use to access the API

The APIkit Router is a key message processor that validates requests against the provided definition, enriches messages (for example by adding default values to the messages) and routes requests to a particular flow. Also, the Router raises errors messages if errors occurs while routing, validating or processing the user request.

This is a trick question.

You can callonly flows from DataWeave using lookup function. Note that lookup function does not support calling subflows.

A subflow needs a parent context to inherit behaviors from such as exception handling, which a flow does not need

Hence correct answer is Not possible in Mule 4

option 3 is the correct syntz to access application properties

The correct answer is To avoid duplicate processing of records in a database.

If a watermark column is provided, the values taken from that column are used to filter the contents of the next poll, so that only rows with a greater watermark value are returned. If an ID column is provided, this component automatically verifies that the same row is not picked twice by concurrent polls.

Mule doc reference : https://docs.mulesoft.com/db-connector/1.8/database-documentation#listener

Correct syntax to use where clause is WHERE city = :city AND state = :state

This question validates knowledge on using dynamicqueries in DB select operation.

Configure Dynamic Queries in the Select Operation

When you need to parameterize not only the WHERE clause but also parts of the query itself (for example, queries that compare tables that depend on a condition, or complexqueries for which the project table columns need to vary), you can configure dynamic queries.

In the following example, you configure a dynamic query by using a full expression with a string in which the table depends on a variable $(vars.table). Althoughsome of the query text is dynamic ("SELECT * FROM $(vars.table)), the WHERE clause still defines the WHERE condition using input parameters: in this case, WHERE name = :name.

In your Studio flow, select the Select operation.

In the operation configurationscreen, set the SQL Query Text field to SELECT * FROM $(vars.table) WHERE name = :name.

Set the Input Parameters field to {'name' : payload}.

The following screenshot shows the configuration in Studio:

Graphical user interface, application Description automatically generated

Figure 3. Dynamic query configuration

In the XML editor, the  configuration looks like this:

#["SELECT * FROM $(vars.table) WHERE name = :name"]

#[{'name' : payload}]

You can apply input parameters only to parameters in a WHERE clause. To modify any other part of the query, use the DataWeave interpolation operator.

Mule Ref Doc: Query a Database Examples - Mule 4 | MuleSoft Documentation

To include property. To keep the API definition concise, you can include external content, such as documentation, schemas, and frequently used patterns outside the definition itself. Theparser interprets !include as if the content of the externally-hosted file or a URL were declared in-line.

To use the fragments in RAML you have to include the exact path(copy the path) of that fragment you want to use as shown below

Option 3 is the correct as correct syntax is

examples: !include examples/StudentExample.raml

Correct answer is API manager

Database always return rows as an array.

Array is the correct answer

QUESTIONNO: 111

Refer to the exhibits.

A web client submits a request to below flow. What is the output at the end of the flow?

Diagram Description automatically generated

Graphical user interface, text, application, email Description automatically generated

Graphical user interface, text, application, email Description automatically generated

A. String

B. Object

C. Java

D. XML

Answer: A

String is the correct answer as XML is of an Object type String

QUESTIONNO: 219

A Mule project contains a DataWeave module file WebStore dvA that defines a function named loginUser The module file is located in the projects src/main/resources/libs/dw folder

What is correct DataWeave code to import all of the WebStore.dwl file's functions and then call the loginUser function for the login "cindy.park@example.com"?

A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

Answer: D

To compare, DataWeave syntax is #[payload == "FR"].

In this case only one = is used so it will give syntax error.

Hence the correct answer is A dataweave syntax error

The First Successful router iterates through a list of configured processing routes until one of the routes executessuccessfully. This is sequential execution. In all other options mentioned in the question ,we can achieve parallel execution.

Correct answer isArray.

Flatten turns a set of subarrays (such as [ [1,2,3], [4,5,[6]], [], [null] ]) into a single, flattened array (such as [ 1, 2, 3, 4, 5, [6], null ]).

This example defines three arrays of numbers, creates another array containing those three arrays, and then uses the flatten function to convert the array of arrays into a single array with all values.

Source

%dw 2.0

output application/json

var array1 = [1,2,3]

var array2 = [4,5,6]

var array3 = [7,8,9]

var arrayOfArrays = [array1, array2, array3]

---

flatten(arrayOfArrays)

Output

[ 1,2,3,4,5,6,7,8,9 ]

Gold is not valid category for connector types.

MuleSoft Doc Ref :https://docs.mulesoft.com/mule-runtime/3.7/anypoint-connectors#connector-support-categories

Text Description automatically generated with medium confidence

-----------------------------------------------------------------------------------------------------------------------------------

Here’s specifically what is happening here:

1) Payload is successfully set to “Before”

2) Is null validation is used which will pass the message only if payload is null. In this case as payload is not null, it creates an Error Object. Flow execution stops

#[error.description] = “Validation error”

3)Because no error handler is defined, the Mule default error handler handles the error

4) “Validation error” is the error message returned to the requestor in the body of the HTTP request with HTTP Status Code: 500

Reference diagram:

A picture containing timeline Description automatically generated