Question 6 - Appian ACD201 Real Exam Questions [March 2026 Update]

Q: 6

DRAG DROP You need to create a new database schema using a connected data source system. What should you do? Note: To answer, move all steps from the Options list to the Answer List area and arrange them in the correct order.

Drag & Drop

Enable JavaScript to use the Drag & Drop feature.

Copy the credentials and connection URL.
Create separate schemas for each application or suite of applications that you want to secure using the AppianProcess.createNewSchema() stored procedure.
Create a MariaDB Data Source connected system for each schema using the credentials
Put users in the Database Editors group to allow them to make changes in the new database schema through phpMyAdmin. Put users in the Database Viewers group to give them read-only permissions in phpMyAdmin.

Correct Answer:

Answer Area Bucket 1: B. Create separate schemas for each application or suite of applications that you want to secure using the AppianProcess.createNewSchema() stored procedure. Bucket 2: A. Copy the credentials and connection URL. Bucket 3: C. Create a MariaDB Data Source connected system for each schema using the credentials Bucket 4: D. Put users in the Database Editors group to allow them to make changes in the new database schema through phpMyAdmin. Put users in the Database Viewers group to give them read-only permissions in phpMyAdmin.

Explanation

The process follows the standard workflow for provisioning new schemas in the Appian Cloud database. First, the schema must be generated using the AppianProcess.createNewSchema() stored procedure executed within phpMyAdmin (Step 1). This procedure automatically generates a dedicated user and password, which must be copied immediately (Step 2). These credentials are then used to configure a MariaDB Data Source connected system object, allowing Appian to interface with the new schema (Step 3). Finally, users are assigned to the Database Editors or Viewers groups to grant them specific access rights to manage or view the newly created schema via the phpMyAdmin interface (Step 4).

References

Appian Documentation - Appian Cloud Database Administration:

Section: "To create a new schema"

Relevance: This section explicitly lists the steps in the exact order: 1) Create separate schemas using the stored procedure, 2) Copy credentials, 3) Create the MariaDB Data Source connected system, and 4) Configure user groups (Database Editors/Viewers) for access.

Link: https://docs.appian.com/suite/help/25.3/appian-cloud-database-administration.html

Appian Community - Data Migration to New Schema:

Section: "Recommended Steps" -> "Create new schema and the Data Source Connected System"

Relevance: Confirms the order of calling the stored procedure first, noting down credentials, and then creating the Connected System object.

Link: https://community.appian.com/success/w/guide/3224/data-migration-to-new-schema

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE