Câu 4: ACD301: Appian Certified Lead Developer

You are working on a large Appian application that only uses custom data types (CDTs) and data store entities (DSEs). The data model for this application is complex. There are many DSEs, and they are related to each other with a combination of one-to-many and many-to-many relationships. In the many sides of these relationships, there could be upwards of 100 related rows of data from the base DSE. Joining the data is currently done within Appian. When an end user views any read-only interface, data is queried, transformed, and joined from multiple DSEs. All interfaces consistently query the same DSEs. How can you decrease the number of database connections that Appian makes to the data source?

1. A. Create a nested CDT that joins the relevant tables with each other. Update each interface to run the single query instead.
2. B. Create a new view in the database that joins the relevant tables. Create a corresponding DSE and update each interface to query the new DSE. — đáp án hiện tại
3. C. Move the tables to their own schema and create a connected system to that schema. Create the corresponding data store object and DSEs. and update each interface to query the new DSEs.