Free Microsoft Dynamics MB-820 Actual Exam Questions - Question 12 Discussion
HOTSPOT You are writing a procedure to block all inventory items with numbers that do not start with the letter S. You need to complete the procedure. How should you complete the code expressions? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. 
I’m thinking the condition should explicitly check the first character with something like Left(ItemNumber, 1) <> "S" to block non-S items. That feels clearer than relying on Contains or InStr here.
I’d pick the expression that explicitly checks if the first character is not 'S' (uppercase) because inventory codes usually use uppercase letters. Lowercase might not be needed here.
I think option C fits better here since it uses 'S' with a check for the first character not matching. It should cover the uppercase case, which is what inventory numbers probably use. Lowercase might be less likely, so probably no need to overcomplicate with case-insensitive checks. Also, A seems like it’s including items starting with S instead of excluding them, so that’s out. Keeping it simple with C should do the trick without missing the goal of blocking those not starting with S.
I’d go with options excluding items that start with S or s, since blocking should catch both cases. So, filtering out anything not starting with uppercase or lowercase S makes sense here.
Not picking B since it starts with 'S' and question wants non-'S' items blocked.