Appian Exam ACD101 Topic 3 Question 28 Discussion

Actual exam question for Appian's ACD101 exam

Question #: 28
Topic #: 3

You have two Custom Data Types (CDT): ACME_invoice and ACME_invoiceItem that have a flat relationship.

The invoice item table has a field that is a foreign key to the invoice table. You are leveraging the database to automatically generate their primary keys.

How should you structure the process model to add a new invoice and the new invoice items to the system?

A1. Write to Multiple Data Store Entities smart service (Writing to the ACME_invoiceItem table and ACME_invoice table).

B1. Write to Data Store Entity smart service (Writing to the ACME_invoiceItem table).
2. Script Task to update foreign keys.
3. Write to Data Store Entity smart service (Writing to the ACME_invoice table).

C1. Write to Data Store Entity smart service (Writing to the ACME_invoice table).
2. Script Task to update foreign keys.
3. Write to Data Store Entity smart service (Writing to the ACME_invoiceItem table).

Show Suggested Answer

Suggested Answer: C

When dealing with related data types where one has a foreign key to another, you must first create the record in the primary table (ACME_invoice) and then use the generated primary key to create related records in the secondary table (ACME_invoiceItem). This is why you first write to the ACME_invoice table, then update the foreign keys in a Script Task, and finally write to the ACME_invoiceItem table.

Appian Documentation: Relational Databases

by Patrick at Dec 07, 2024, 06:58 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Catarina

3 months ago

I prefer option C because it first writes to the invoice table before the invoice item table.

upvoted 0 times

...

Magnolia

3 months ago

I disagree, I believe option B is better as it ensures the foreign keys are updated correctly.

upvoted 0 times

...

Delmy

4 months ago

Forget the options, I'm just going to write a script that does it all in one line. That's the real solution!

upvoted 0 times

...

Susana

4 months ago

Haha, the question says the database is generating the primary keys. Why are we worrying about that?

upvoted 0 times

Alton

3 months ago

C) 1. Write to Data Store Entity smart service (Writing to the ACME_invoice table). 2. Script Task to update foreign keys. 3. Write to Data Store Entity smart service (Writing to the ACME_invoiceItem table).

upvoted 0 times

...

Luann

3 months ago

B) 1. Write to Data Store Entity smart service (Writing to the ACME_invoiceItem table). 2. Script Task to update foreign keys. 3. Write to Data Store Entity smart service (Writing to the ACME_invoice table).

upvoted 0 times

...

Option A seems like the most straightforward approach. Why add unnecessary complexity with extra steps?

upvoted 0 times

...