ACD100 V1

A client asks you to store work location information for their employees. The client mentions that multiple employees may be assigned to multiple work locations.

Which type of database relationship is the client describing?
A . One-to-Many (1:N)
B . Many-to-One (N:1)
C . Many-to-Many (M:N)
D . One-to-One (1:1)

View Answer

Answer: C

Explanation:

https://docs.appian.com/suite/help/23.2/CDT_Relationships.html#many-to-many-relationship Many-to-Many Relationship An example of this would be an application to manage Employees and Projects. Each Project has a team of multiple Employees, but a given Employee might currently be on more than one Project

In the scrum lifecycle of a project, when should the team agree on the requirements for the Definition of Done?
A . Before getting started on the project
B . During the sprint retrospective
C . During the backlog refinement
D . After the sprint planning

View Answer

Answer: A

Explanation:

Before getting started, teams need to make important decisions about how the extended team will work together during the project. These include: Scheduling the key ceremonies on a fixed cadence including: daily scrum, sprint planning, sprint review, backlog refinement, sprint review and the sprint retrospective. Design the development workflow and configure the project management tool (e.g. Jira). Define the deployment pipeline and configuration management process. Agree the Definition of Done (DoD) and Definition of Ready (DoR).

What is a Foreign Key?
A . The key that cannot be used in any other table.
B . The key that joins two tables together.
C . The key that uniquely identifies a record.
D . The key that uniquely identifies a record when joined with another column.

View Answer

Answer: B

Review the following table.

Which option correctly deletes the last row from the table?
A . REMOVE product_id = 3 IN product;
B . DELETE FROM product WHERE product_id = 3;
C . DELETE product_i = 3 FROM product;
D . REMOVE FROM product WHERE product_id = 3;

View Answer

Answer: B

In addition to initiating the process model, what other permission is required to execute the Write to Data Store Entity smart service?
A . Viewer permission to the data store
B . Viewer permission to a constant that points to the data store entity
C . Admin permission to the CDT
D . Editor permission to the record

View Answer

Answer: A

Review the following table.

Given the following options are in mySQL, which option correctly alters the last row on the table?
A . INSERT price = 0.9 –
INTO product –
WHERE product_id = 3;
B . MODIFY product –
UPDATE price = 0.9 –
WHERE product_id = 3;
C . SET product –
(price) VALUES (0.9)
WHERE product_id = 3;
D . UPDATE product –
SET price = 0.9 –
WHERE product_id = 3;

View Answer

Answer: D

In a process model, you want all outgoing flows lo start once all incoming flows have reached the node.

Which gateway is most appropriate to use?
A . NAND
B . OR
C . XOR
D . AND

View Answer

Answer: D

A client requested a feature that is exceptionally specific and uncommon.

You begin by gathering research to help determine how such a feature could be implemented, but no documentation is available.

What should you do next?
A . Create a Support Case.
B . Check The Appian Academy.
C . Review the Appian Playbook.
D . Ask the Appian Community.

View Answer

Answer: A

When setting the assignment of a User Input task, you need the task to be assigned to the person who started the process.

Which option is appropriate to use to accomplish this goal?
A . pp!name
B . pm!creator
C . pp!initiator
D . pm!name

View Answer

Answer: C

When using "a!pagingInfo()" within "a!queryEntity()", which batch size value will return all items?
A . -1
B . 0
C . null
D . 500

View Answer

Answer: A