You want to display a Gender dropdown, and its choice label may change in the future as per the business requirement.
Given transactional database tables rely on this data for reporting, what is the most appropriate action? (Choose the best answer.)
Suggested Answer: D
Get Premium ACD200 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
26 comments · newest first
EL
Eladia
1 month ago
I like B, but stored procedures can be complex. D is simpler.
LU
Luis
1 month ago
Option A seems too rigid. What if we need more changes?
OR
Oren
2 months ago
I agree, D makes sense. Easy to update later.
AN
Antonio
2 months ago
I think option D is the best. It allows flexibility.
AR
Ardella
2 months ago
B could work, but it feels complicated for this task.
ME
Merrilee
2 months ago
Option A seems too rigid for future changes.
TR
Trinidad
2 months ago
I agree, D allows for easy updates.
DE
Derick
2 months ago
I think option D is the best. Flexibility is key.
AN
Anglea
3 months ago
I feel B could work, but stored procedures can get complicated.
NI
Nicholle
3 months ago
Option A seems simpler, but it’s not scalable.
DE
Deandrea
3 months ago
I agree, D makes it easy to update without code changes.
SH
Sheldon
3 months ago
I think option D is the best. It allows flexibility.
JU
Justa
3 months ago
Totally agree with D! Makes the most sense for reporting.
GL
Glenn
4 months ago
Wait, can we really change gender labels that easily?
DO
Dong
5 months ago
B could work, but it might complicate things.
YU
Yun
5 months ago
A seems too rigid for future changes.
CH
Cherri
5 months ago
I think D is the best option. Flexibility is key!
JO
Jolene
6 months ago
Not sure if a table is the right way to go for this.
LI
Lilli
6 months ago
Wait, can we really change the dropdown label that often?
CA
Cassie
6 months ago
Isn't a stored procedure more efficient though?
LE
Leonie
6 months ago
Totally agree, it allows for easy updates!
SA
Samuel
6 months ago
I think option D is the best choice.
ZA
Zachary
6 months ago
I’m a bit confused about the expression rule. I thought it was more for calculations rather than changing labels. Is that correct?
RH
Rhea
7 months ago
I feel like we discussed something similar in class, and I think using a table for dynamic values is a common approach. So, D might be right.
HO
Hortencia
7 months ago
I'm not entirely sure, but I remember something about stored procedures being a bit rigid for this kind of requirement. Maybe option B isn't the best?
PA
Patti
7 months ago
I think option D makes the most sense since it allows for flexibility in changing the labels without affecting the database structure directly.