Appian ACD201 Exam - Topic 2 Question 3 Discussion

Actual exam question for Appian's ACD201 exam

Question #: 3
Topic #: 2

You need to relate two entities, Employee and Skill, in the data structure. You want to adhere to Appian best practices.

Employees can have multiple skills, and a single skill can relate to multiple employees.

What type of relationship do these entities represent, and what is the minimum number of tables required to implement the design?

AMany-to-many; 3 tables

BMany-to-many; 2 tables

COne-to-many; 2 tables

Show Suggested Answer

Suggested Answer: A

The relationship between Employee and Skill is many-to-many - an employee can have multiple skills, and each skill can belong to multiple employees.

To model this properly and according to Appian best practices, you need 3 tables:

by Rebbecca at Oct 03, 2025, 06:09 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Val

2 months ago

Wait, how can it be 2 tables for many-to-many? Seems off.

upvoted 0 times

...

Galen

2 months ago

I think it's just 2 tables, right?

upvoted 0 times

...

Herminia

2 months ago

Definitely a many-to-many relationship!

upvoted 0 times

...

Elena

3 months ago

Yup, 3 tables is the way to go!

upvoted 0 times

...

Micheline

3 months ago

I agree, 3 tables makes sense for this setup.

upvoted 0 times

...

Reynalda

3 months ago

I’m a bit confused; I thought many-to-many relationships typically needed just two tables, but now I’m second-guessing myself.

upvoted 0 times

...

Macy

3 months ago

I feel like it might actually require three tables because we need a junction table to link employees and skills.

upvoted 0 times

...

Tammara

4 months ago

I remember practicing a similar question, and I think it was two tables for a many-to-many relationship, but I could be wrong.

upvoted 0 times

...

Janna

4 months ago

I think this is a many-to-many relationship since employees can have multiple skills and vice versa. But I'm not sure about the number of tables needed.

upvoted 0 times

...

Kimi

4 months ago

I'm pretty confident this is a many-to-many relationship, so I'll select option A. The minimum number of tables required is 3 to properly implement the design.

upvoted 0 times

...

Tresa

4 months ago

I'm a bit confused on the minimum number of tables required. I'll need to review the best practices for implementing many-to-many relationships in Appian.

upvoted 0 times

...

Ngoc

4 months ago

Okay, the key is that employees can have multiple skills and a single skill can relate to multiple employees. That sounds like a many-to-many relationship to me.

upvoted 0 times

...

Rachael

4 months ago

Hmm, I'm not sure if we need 3 tables or just 2. I'll have to think this through carefully.

upvoted 0 times

...

Carylon

5 months ago

I think this is a many-to-many relationship, so I'll go with option A.

upvoted 0 times

...