Appian ACD200 Exam - Topic 4 Question 59 Discussion

Actual exam question for Appian's ACD200 exam

Question #: 59
Topic #: 4

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.)

ACreate a constant and update it as per the business requirement.

BCreate a stored procedure and update it as per the business requirement.

CCreate an expression rule and update it as per the business requirement.

DCreate these entries in a table and reference them through a query entity rule as per the business requirement.

Show Suggested Answer

Suggested Answer: D

by Eun at Oct 18, 2025, 07:27 AM

Limited Time Offer

25%

Off

Get Premium ACD200 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Virgie

5 days ago

It allows flexibility for future changes.

upvoted 0 times

...

Nohemi

11 days ago

I'm surprised this isn't a straightforward answer!

upvoted 0 times

...

Dewitt

16 days ago

Wait, why not just use a constant? Seems simpler.

upvoted 0 times

...

Renato

21 days ago

B could work, but it feels a bit overkill.

upvoted 0 times

...

Vicky

26 days ago

D is the way to go. Ain't nobody got time to be updating code every time the business changes their mind.

upvoted 0 times

...

Anisha

1 month ago

D is the best choice. Gotta love that flexibility!

upvoted 0 times

...

Hollis

1 month ago

D all the way! Who wants to update code when you can just update a table? Easy peasy.

upvoted 0 times

...

Alica

1 month ago

D is the correct answer. Storing the options in a table is the most maintainable solution.

upvoted 0 times

...

Eloisa

2 months ago

I'd go with D. Updating a table is much easier than changing code or stored procedures.

upvoted 0 times

...

Jin

2 months ago

Definitely D. Storing the options in a table is the most flexible approach.

upvoted 0 times

...

Creating a constant and updating it as per the business requirement (option A) seems like the easiest approach, but I'm worried about the impact on the transactional database tables. I'll need to think this through carefully.

upvoted 0 times

...

Lorenza

2 months ago

D is the way to go. Storing the gender options in a table makes it easy to update as per business requirements.

upvoted 0 times

...

Adrianna

2 months ago

A seems too rigid for future changes.

upvoted 0 times

...

Lashawnda

2 months ago

Why D?

upvoted 0 times

...

Virgie

3 months ago

I think option D is the best.

upvoted 0 times

...

Zana

3 months ago

I think D is the best choice. Flexibility is key!

upvoted 0 times

...

Adria

3 months ago

I think option D is the way to go. Storing the gender labels in a table and referencing them through a query entity rule seems like the most flexible and maintainable solution.

upvoted 0 times

...

Oretha

3 months ago

I'm a bit confused about the difference between a stored procedure and an expression rule. Can someone clarify which one would be more appropriate here?

upvoted 0 times

...

Charlette

4 months ago

Okay, let me see. I'm leaning towards option D, creating a table to store the gender labels and reference them through a query entity rule. That way, we can easily update the labels without impacting the database.

upvoted 0 times

...

Talia

4 months ago

Hmm, this seems like a tricky one. I'll need to think carefully about the implications for the transactional database tables.

upvoted 0 times

...

Shayne

4 months ago

I vaguely recall that expression rules are more for calculations, so I don't think option C is right.

upvoted 0 times

...

Dulce

4 months ago

I feel like creating a constant might not be flexible enough for future changes. Wasn't there a practice question about this?

upvoted 0 times

...

Laura

4 months ago

I'm not entirely sure, but I remember something about stored procedures being useful for dynamic data. Maybe option B?

upvoted 0 times

...

Louvenia

5 months ago

I think option D makes the most sense since it allows for easy updates without affecting the database structure directly.

upvoted 0 times

...