Exam MCIA - Level 1 topic 1 question 44 discussion

Actual exam question from Mulesoft's MCIA - Level 1

Question #: 44
Topic #: 1

A Mule application uses the Database connector.
What condition can the Mule application automatically adjust to or recover from without needing to restart or redeploy the Mule application?

A. One of the stored procedures being called by the Mule application has been renamed
B. The database server has been updated and hence the database driver library/JAR needs a minor version upgrade
C. The database server was unavailable for four hours due to a major outage but is now fully operational again
D. The credentials for accessing the database have been updated and the previous credentials are no longer valid

Show Suggested Answer

Suggested Answer: D 🗳️

by awsExpert007 at June 27, 2021, 5:39 a.m.

Comments

Submit Cancel

edogwest

1 month, 2 weeks ago

Selected Answer: C

The Database connector’s connection pool includes a reconnection strategy: if the database host becomes unreachable (network or server outage) the connector keeps retrying at configured intervals. When the database comes back online—even hours later—the connector automatically obtains a new connection and processing continues. No redeploy or restart is required. For the other situations a manual change and redeploy/restart are needed: A – stored-procedure renamed: SQL statements compiled in the flow will keep failing until you update the query. B – driver JAR upgrade: the new library must be packaged and the app redeployed. D – credential change: you must update the connector configuration (properties/secure-properties) and restart the runtime for new credentials to take effect. Hence only scenario C is automatically recoverable.

upvoted 1 times

...

awsuser1

1 year, 5 months ago

Answer is C

upvoted 2 times

...

madgeezer

1 year, 10 months ago

Selected Answer: C

C. The database server was unavailable for four hours due to a major outage but is now fully operational again

upvoted 1 times

...

MuleK

2 years ago

Selected Answer: C

Change in property also causes restarts C. The database server was unavailable for four hours due to a major outage but is now fully operational again

upvoted 1 times

...

alevita

2 years, 4 months ago

C. COuld also be D but it is not clear if the DB credentials are in a property file.

upvoted 1 times

gilofernandes

7 months, 1 week ago

no matter where the DB credentials are stored (property file, runtime manager properties, hardcoded in connector) it is necessary a restart or deploy of the mule app.

upvoted 1 times

...