(Oct-2024) MCD-Level-1 Exam Dumps Contains FREE Real Quesions from the Actual Exam
Free Test Engine Verified By MuleSoft Certified Developer Certified Experts
NEW QUESTION # 86
Refer to the exhibit.
How should be the where clause written for the configured input parameters in such a way that it achieves below SQL query?
- A. WHERE city := city AND state := state
- B. WHERE city = attributes.city AND state = attributes.state
- C. WHERE city := ${city} AND state := ${state}
- D. WHERE city = :city AND state = :state
Answer: D
Explanation:
Correct syntax to use where clause is WHERE city = :city AND state = :state This question validates knowledge on using dynamic queries 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 complex queries 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). Although some 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 configuration screen, 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 <db:sql> configuration looks like this:
* <set-variable variableName="table" value="PLANET"/>
* <db:select config-ref="dbConfig">
* <db:sql>#["SELECT * FROM $(vars.table) WHERE name = :name"]</db:sql>
* <db:input-parameters>
* #[{'name' : payload}]
* </db:input-parameters>
* </db:select>
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
NEW QUESTION # 87
Explanation:
Correct answer is {customerID}.
- A. fun toUpper(userName) -> upper(userName)
- B. var toUpper(userName) -> upper(userName)
- C. fun toUpper(userName) = upper(userName)
- D. var toUpper(userName) = upper(userName)
Answer: C
Explanation:
Reference:
A function named toUpper needs to be defined that accepts a string named userName and returns the string in uppercase.
What is the correct DW code to define the toUpper function?
NEW QUESTION # 88
What happens to the attributes of a Mule event in a flow after an outbound HTTP Request is made?
- A. Attributes do not change
- B. Previous attributes are passed unchanged
- C. New attributes may be added from the HTTP response headers, but no headers are ever removed
- D. Attributes are replaced with new attributes from the HTTP Request response (which might be null)
Answer: D
Explanation:
Attributes are replaced with new attributes from the HTTP Request response.
Attributes include everything apart from Payload/body. For ex: Headers, query parameters, URI parameters.
So, when outbound HTTP request is made, new attributes need to pass the outbound HTTP request and old attributes are replaced.
I have created below diagram to make it easy for you to understand:
NEW QUESTION # 89
Refer to the exhibits. The main flow contains an HTTP Request in the middle of the flow. The HTTP Listeners and HTTP Request use default configurations.
A web client submits a request to the main flow's HTTP Listener that includes query parameters for the pedigree of the piano.
What values are accessible to the Logger component at the end of the main flow?
- A. payload
- B. payload
pedigree query params - C. payload
pedigree query params producer var - D. payload
producer var
Answer: D
NEW QUESTION # 90
Refer to the exhibit.
How many private flows does APIKIT generate from the RAML specification?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION # 91
An app team is developing a mobile banking app. It took them two months to create their own APIs to access transaction information from a central database. The app team later found out that another team had already built an API that accesses the transaction information they need.
According to MuleSoft, what organization structure could have saved the app team two months of development time?
- A. Center for Enablement
- B. MuleSoft Support Center
- C. Center of Excellence
- D. Central API Review Board
Answer: A
NEW QUESTION # 92
A
web client submits a request to http://localhost:8081?accountType=personal. The query parameter is captured using a Set Variable transformer to a variable named accountType.
What is the correct DataWeave expression to log accountType?
- A. Account Type: #[message.inboundProperties.accountType]
- B. Account Type: #[vars.accountType]
- C. Account Type: # [attributes.accountType]
- D. Account Type: #[flowVars.accountType]
Answer: B
Explanation:
vars: Keyword for accessing a variable, for example, through a DataWeave expression in a Mule component, such as the Logger, or from an Input or Output parameter of an operation. If the name of your variable is myVar, you can access it like this: vars.myVar Hence correct answer is Account Type: #[vars.accountType]
NEW QUESTION # 93
Refer to the exhibit. The main flow contains an HTTP Request in the middle of the flow. The HTTP Listeners and HTTP request use default configurations.
What values are accessible to the Logger at the end of the flow after a web client submit request to
http://local:801/order?color=red?
- A. payload
- B. payload quantity var color query param
- C. payload color query param
- D. payload quantity var
Answer: D
NEW QUESTION # 94
What are the latest specification of RAML available?
- A. 0
- B. 1.2
- C. 1
- D. 0.8
Answer: C
Explanation:
The current version of the RAML specification is 1.0
You can check RAML version in RAML definition by referring to first comment. See highlighted part in below image.
NEW QUESTION # 95
A company has an API to manage purchase orders, with each record identified by a unique purchase order ID. The API was built with RAML according to MuleSoft best practices.
What URI should a web client use to request order P05555?
- A. /orders?order=P05555
- B. /orders/P05555
- C. /orders/order=P05555
- D. /orders/{P05555}
Answer: B
NEW QUESTION # 96
What of the below is not a feature of API Notebooks?
- A. API documentation
- B. Perform authenticated live calls on a real server
- C. Creates a client for an API
- D. Creates a mock service for an API
Answer: D
Explanation:
Correct answer is Creates a mock service for an API
API Notebook is an open source, shareable web application for API documentation, interactive API tutorial and example generatation, and a client for your API endpoints. Using API Notebook, you can make requests and quickly transform the responses into readable format. However it cannot be used to mock service for an API.
MuleSoft Doc Ref : https://docs.mulesoft.com/api-manager/1.x/api-notebook-concept
NEW QUESTION # 97
A Mule application configured with Autodiscovery implements an API.
Where is governance enforced for policies defined for this Mule application?
- A. In Runtime Manager
- B. In API manager
- C. In the Mule application
- D. Runtime Manager
Answer: B
Explanation:
Correct answer is API manager
NEW QUESTION # 98
Refer to the exhibits. A web client sends a POST request to the HTTP Listener and the Validation component in the Try scope throws an error.
What response message is returned to the web client?
- A. ''ERROR2"
- B. Validation Error
- C. "END"
- D. "ERROR1"
Answer: A
Explanation:
NEW QUESTION # 99
A Mule application contains an ActiveMQ JMS dependency. The Mule application was developed in Anypoint Studio and runs successfully in Anypoint Studio.
The Mule application must now be exported from Anypoint Studio and shared with another developer.
What export options create the smallest JAR file that can be imported into the other developer's Anypoint Studio and run successfully?
- A. Option D
- B. Option B
- C. Option A
- D. Option C
Answer: A
NEW QUESTION # 100
An app team is developing a mobile banking app. It took them two months to create their own APIs to access transaction information from a central database. The app team later found out that another team had already built an API that accesses the transaction information they need.
According to MuleSoft, what organization structure could have saved the app team two months of development time?
- A. Center for Enablement
- B. MuleSoft Support Center
- C. Center of Excellence
- D. Central API Review Board
Answer: A
Explanation:
Reference:
Center for Enablement is correct answer .It is a cross-functional team typically staffed with members from central IT, line-of-business departments, and digital innovation teams charged with productizing, publishing, and harvesting reusable assets and best practices. In this case , app team would have checked first with Center for Enablement before developing their own API's. Hence could have avoided re-work
NEW QUESTION # 101
Where are values of query parameters stored in the Mule event by the HTTP Listener?
- A. Attributes
- B. Payload
- C. Variables
- D. Inbound Properties
Answer: A
Explanation:
Correct answer is Attributes.
Query parameters , URI parameters and headers are some of examples which are part of attributes.
Diagram Description automatically generated
Bottom of Form
Top of Form
NEW QUESTION # 102
Refer to the exhibits The Mule application does NOT define any global error handlers.
A web client sends a POST request to the Multi application with this input payload The File Write operation throws a FILECONNECTIVITY error What response message is returned to the web client?
- A. "OTHER ERROR"
- B. "FILECONNECTIVITY"
- C. "File written"
- D. "ORDER NOT_CREATED"
Answer: D
NEW QUESTION # 103
Refer to the exhibits.
A Mule application has an HTTP Request that is configured with hardcoded values. To change this, the Mule application is configured to use a properties file named config.yaml.
what valid expression can the HTTP Request host value be set to so that it is no longer hardcoded?
- A. ${training.host}
- B. #[training.host]
- C. #[training:host]
- D. ${training:host}
Answer: A
NEW QUESTION # 104
Refer to the exhibits.
What payload and variable are logged at the end of the main flow?
- A. [[Req5, Req10, Req15, Req20], 5]
- B. [Req5Req10,Req15Req20, 5]
- C. [[5, 10, 15, 20], 5]
- D. [[5, 10, 15, 20], 1]
Answer: C
Explanation:
Correct answer is [[5, 10, 15, 20], 5]
Key thing to note here is that any changes made to payload in for each loop are not available outside for each scope where as variable value updated in for each loop is visible out side for each loop too.
NEW QUESTION # 105
......
Use Real MuleSoft Achieve the MCD-Level-1 Dumps - 100% Exam Passing Guarantee: https://www.prep4surereview.com/MCD-Level-1-latest-braindumps.html
