ACD100 Certification Exam Questions with AI Explanations

QUESTION: 11

You need to update the table structure in the database, and then update the related CDT in Appian to publish the data store entity.
Column names in the database and the CDT are implemented using different naming conventions.
Which statement is appropriate in this scenario?

You can update the CDT columns in Appian Designer, or update the CDT-related XSD and create a new version from that.
You must update the CDT columns in Appian Designer.
You don't need to make any manual changes. Appian automatically updates the CDT according to database chances.
You must update the CDT-related XSD and create a new version from that.

Answer(s): D

Reveal Solution Next Question

QUESTION: 12

During User Acceptance Testing (UAT), a tester operating in the test environment asks you to change a data point in one of the tables.
In the development environment, you navigate to the database and adjust the data point that the tester described.
What is the issue with the steps taken?

According to Appian best practices, changes should not be made directly in a database.
The change to the database was made in the wrong environment.
As an associate, you should not be communicating or coordinating directly with testers.
The change was made without formally seeking approval from DevOps.

Answer(s): A

Reveal Solution Next Question

QUESTION: 13

Review the following table.
Given the following options are in mySQL, which option correctly alters the last row on the table?

INSERT price = 0.9 -
INTO product -
WHERE product_id = 3;
MODIFY product -
UPDATE price = 0.9 -
WHERE product_id = 3;
SET product -
(price) VALUES (0.9)
WHERE product_id = 3;
UPDATE product -
SET price = 0.9 -
WHERE product_id = 3;

Answer(s): D

Reveal Solution Next Question

QUESTION: 14

What is a Foreign Key?

The key that cannot be used in any other table.
The key that joins two tables together.
The key that uniquely identifies a record.
The key that uniquely identifies a record when joined with another column.

Answer(s): B

Reveal Solution Next Question

QUESTION: 15

You need to edit data in a table. You ate currently using the following statement:
INSERT INTO product (productId, productName) VALUES (3, "App1e"); What is the issue?

You should be using an UPDATE statement.
You forgot the WHERE clause in your statement.
You should be using a CREATE statement.
You should be using an EDIT statement.

Answer(s): A

Explanation:

CREATE TABLE table_name (
column1 datatype,
column2 datatype,
....
);

Reveal Solution Next Question

Appian Certified Associate Developer ACD100 Dumps in PDF

Free Appian ACD100 Real Questions (page: 17)

QUESTION: 11

QUESTION: 12

QUESTION: 13

QUESTION: 14

QUESTION: 15

Explanation: