Appian Exam Appian Certified Senior Developer Topic 5 Question 47 Discussion

Actual exam question for Appian's Appian Certified Senior Developer exam

Question #: 47
Topic #: 5

[All Appian Certified Senior Developer Questions]

There is a need to relate two entities in the data structure: Employee and Skill.

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

What kind of relationship would these entities have, and what is the minimum number of tables required to implement the design, according to Appian best practices? (Choose the best answer.)

AOne-to-many; 2 tables

BMany-to-many; 2 tables

CMany-to-one; 2 tables

DMany-to-many; 3 tables

Show Suggested Answer

Suggested Answer: C

by Josefa at Jan 15, 2025, 10:02 AM

Limited Time Offer

25%

Off

Get Premium Appian Certified Senior Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Miss

25 days ago

Option B all the way! It's the most efficient way to handle this scenario. Plus, who needs more than 2 tables anyway? One-stop shopping, baby!

upvoted 0 times

Mozell

11 days ago

I think option B is the way to go. Many-to-many relationship with 2 tables is efficient.

upvoted 0 times

...

Meghann

27 days ago

Wow, this is a classic database design question. I'm confident option B is the right answer. Gotta love those many-to-many relationships!

upvoted 0 times

...

Audria

1 months ago

Haha, I bet the exam writer is trying to trick us with these options. But I'm going with B, it's the simplest and most straightforward solution.

upvoted 0 times

Mila

2 days ago

User1: Definitely, keeping it simple with just 2 tables is the way to go.

upvoted 0 times

...

Asha

9 days ago

User2: Yeah, I agree. It's the most efficient way to represent the relationship between employees and skills.

upvoted 0 times

...

Carmen

1 months ago

User1: I think B is the answer too, it makes sense for multiple skills and employees to be connected.

upvoted 0 times

...

Gerardo

2 months ago

I think option D is the best answer. A many-to-many relationship requires 3 tables to properly implement it.

upvoted 0 times

Zana

1 months ago

Yes, you are correct. Option D is the best answer for a many-to-many relationship.

upvoted 0 times

...

Zana

2 months ago

I agree, option D is correct. Many-to-many relationships typically require 3 tables.

upvoted 0 times

...

Dominga

2 months ago

The relationship between Employee and Skill is many-to-many, so option B is the correct answer. We need 2 tables to implement this design according to Appian best practices.

upvoted 0 times

...