MENU
An external API frequently invokes an Employees System API to fetch employee data from a MySQL database. The architect must design a caching strategy to query the database only when there Is an update to the Employees table or else return a cached response in order to minimize the number of redundant transactions being handled by the database.
Suggested Answer: A
Get Premium Salesforce Certified MuleSoft Platform Integration Architect (Mule-Arch-202) Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
37 comments · newest first
IL
Ilda
11 months ago
D is the way to go, consistent and reliable!
BI
Billy
11 months ago
Wait, using a scheduler every hour? That feels off.
CH
Chery
11 months ago
C seems inefficient, why not just invalidate on updates?
ST
Stephanie
11 months ago
I think B is better, less manual work involved.
HE
Herminia
12 months ago
Option A sounds solid, hardcoding new data can be risky though.
FE
Felicidad
12 months ago
I’m leaning towards option D since it combines a fixed schedule with an expiration interval, but I’m not entirely confident about the frequency setting.
YO
Yolande
1 year ago
I practiced a similar question where we had to decide on cache invalidation methods. I feel like option B might be too basic for this scenario.
MA
Mayra
1 year ago
I think option A sounds familiar because it mentions hardcoding the new data, but that seems risky for updates.
DO
Domingo
1 year ago
I remember we discussed caching strategies in class, but I'm not sure if using a Scheduler is the best approach here.
ZI
Zita
1 year ago
This is a tricky one. I'm not super familiar with the caching strategies mentioned, so I'll have to think it through carefully. I'm drawn to option C since it uses a Scheduler to invalidate the cache on a fixed frequency. That seems like a simple and reliable approach. But I'm also wondering if the 1-hour expiration in option D might be better. Hmm, I'll have to weigh the pros and cons of each.
WI
Winfred
1 year ago
Hmm, I'm a bit unsure about this one. The question mentions minimizing redundant database transactions, so I'm wondering if option A or D might be better since they set the expiration interval to 1 hour. That could help reduce the number of cache invalidations. But I'm not totally sure which one is the best approach.
LU
Lucille
1 year ago
This seems like a pretty straightforward caching problem. I think option B is the way to go - using an On Table Row operation to invalidate the cache whenever the Employees table is updated. The default expiration interval should be fine, no need to complicate things.
MI
Miss
1 year ago
Okay, let me think this through. The key here is to invalidate the cache whenever the Employees table is updated, right? So I think options B, C, and D all have the right idea there. The difference is in the expiration interval. I'm leaning towards option D since the 1-hour expiration seems like a good balance between keeping the cache fresh and not hitting the database too often.
LE
Leslee
1 year ago
I've got a good feeling about this one. The key is to understand the different validation checks and where they're performed. I think I can narrow it down to the right answer.
CA
Casey
1 year ago
I'll look for an option that suggests ongoing monitoring of drug therapy across multiple patients, not just one individual.
AL
Aleta
1 year ago
Hmm, I feel like it could also be the manifest tag, but that doesn't sound quite right for themes.
RO
Ronny
1 year ago
Hmm, I'm a bit confused about the difference between CE, PE, and P devices. I'll have to think this through carefully.
AL
Alayna
2 years ago
This question is a real head-scratcher. I'm just hoping I don't end up 'caching' my career if I get it wrong!
RO
Rodolfo
2 years ago
I think option A sounds like the best approach to minimize redundant transactions and keep the data fresh.
CH
Chaya
2 years ago
C) Use a Scheduler with a fixed frequency set to every hour to trigger an invalidate cache flow. Use an object-store-caching-strategy and the default expiration interval.
DA
Daren
2 years ago
A) Use an On Table Row operation configured with the Employees table, call invalidate cache, and hardcode the new Employees data to cache. Use an object-store-caching-strategy and set the expiration interval to 1 hour.
YO
Yong
2 years ago
Hmm, this question is a real brain-teaser. I'm going to go with option D - it seems the most robust and reliable solution.
TA
Tanja
2 years ago
C is a nice compromise, but I'd rather not rely on a scheduled job to invalidate the cache. Seems like a potential point of failure.
SH
Shawn
2 years ago
A is a bit overkill, don't you think? Hardcoding the data feels like a hack, and 1 hour is too long for a cache expiration.
JA
Janna
2 years ago
A is a bit overkill, don't you think? Hardcoding the data feels like a hack, and 1 hour is too long for a cache expiration.
TH
Thurman
2 years ago
Use a Scheduler with a fixed frequency set to every hour, triggering an invalidate cache flow. Use an object-store-caching-strategy and set the expiration interval to 1 hour.
KA
Kattie
2 years ago
C) Use a Scheduler with a fixed frequency set to every hour to trigger an invalidate cache flow. Use an object-store-caching-strategy and the default expiration interval.
RO
Roxanne
2 years ago
B) Use an On Table Row operation configured with the Employees table and call invalidate cache. Use an object-store-caching-strategy and the default expiration interval.
KA
Katie
2 years ago
C) Use a Scheduler with a fixed frequency set to every hour to trigger an invalidate cache flow. Use an object-store-caching-strategy and the default expiration interval.
JO
Joanne
2 years ago
B) Use an On Table Row operation configured with the Employees table and call invalidate cache. Use an object-store-caching-strategy and the default expiration interval.
MA
Marylin
2 years ago
B) Use an On Table Row operation configured with the Employees table and call invalidate cache. Use an object-store-caching-strategy and the default expiration interval.
GA
Gabriele
2 years ago
D is the best choice here. Scheduled invalidation with a 1-hour expiration interval ensures the cache is up-to-date without unnecessary database queries.
DE
Deeanna
2 years ago
I agree, D seems like the most efficient option for minimizing redundant transactions.
MA
Margret
2 years ago
D is the best choice here. Scheduled invalidation with a 1-hour expiration interval ensures the cache is up-to-date without unnecessary database queries.
AN
Annmarie
2 years ago
Option B seems like the way to go. Keep it simple and let the default expiration interval handle the caching.
IZ
Izetta
2 years ago
B: Agreed, simplicity is key in this scenario.
LI
Lili
2 years ago
A: Option B seems like the way to go. Keep it simple and let the default expiration interval handle the caching.