Download PrepIQ Entellitrak Certified Developer Program Ultimate Exam and more Exams Technology in PDF only on Docsity!
Developer Program Ultimate Exam
Question 1. Which component of Entellitrak’s architecture is primarily responsible for rendering the user interface? A) Java EE backend services B) HTML, CSS, and JavaScript/jQuery C) Database engine D) Eclipse IDE plug-in Answer: B Explanation: The front-end of Entellitrak uses HTML, CSS, and JavaScript/jQuery to present forms and screens to the user. Question 2. In the data-first methodology, what is the first artifact developers should create? A) Java custom operations B) UI form layouts C) Data Objects (DOs) and their fields D) Security roles Answer: C Explanation: Data-first emphasizes defining the data model (DOs, fields, relationships) before building UI or logic. Question 3. Which deployment model allows Entellitrak to run on a customer’s own servers while still using cloud-based services for updates? A) On-premises only B) Cloud-only C) Hybrid D) Virtual private cloud Answer: C Explanation: A hybrid deployment combines on-premises infrastructure with cloud services for things like updates or analytics. Question 4. What is the purpose of the Entellitrak Developer Interface? A) To edit HTML templates directly B) To manage code versions in Git
Developer Program Ultimate Exam
C) To configure Data Objects, forms, and business rules without writing code D) To monitor server performance metrics Answer: C Explanation: The Developer Interface provides a low-code environment for configuring DOs, forms, and rules. Question 5. Which Eclipse plug-in feature assists developers in writing server-side Java for Entellitrak? A) Automatic UI layout generation B) Code completion for the eTK API C) Real-time database replication D) Integrated security scanner Answer: B Explanation: The plug-in offers code assistance and templates for the Entellitrak Java API. Question 6. When creating a parent/child Data Object relationship, which key must be defined on the child object? A) Primary key only B) Foreign key referencing the parent’s primary key C) Unique index on a text field D) Composite key of two lookup fields Answer: B Explanation: The child object stores a foreign key that points to the parent’s primary key to maintain the hierarchy. Question 7. Which field type should be used when a value must be selected from a predefined list of codes? A) Text B) Date C) Lookup (Reference Data Object) D) Calculated Answer: C
Developer Program Ultimate Exam
A) Tab B) Section C) Container D) Grid Answer: B Explanation: Sections allow logical grouping and can be configured to be collapsible. Question 12. Which property would you set to make a field mandatory on the Add form but optional on Edit? A) Required = true (global) B) Read-only = false C) Required = true with a conditional rule based on form mode D) Default value = blank Answer: C Explanation: Conditional rules can evaluate the form mode (add vs edit) to enforce required status dynamically. Question 13. Which client-side event fires after the form has been fully rendered and all fields are populated? A) onload B) onchange C) onblur D) onfocus Answer: A Explanation: The onload event occurs once the form finishes loading, making it ideal for initializing UI logic. Question 14. When configuring a Query-Based List (QBL), which language is used to define the underlying data query? A) JavaScript B) EntelliSQL C) Groovy
Developer Program Ultimate Exam
D) XML
Answer: B Explanation: EntelliSQL is Entellitrak’s SQL dialect used for QBL definitions. Question 15. To enable bulk deletion of selected rows in a List View, which List View option must be activated? A) Enable Inline Editing B) Enable Bulk Actions C) Show Record Count D) Enable Export to CSV Answer: B Explanation: Bulk Actions provide a menu for operations such as delete, export, or custom actions on multiple rows. Question 16. Which component of Entellitrak defines the top-level navigation structure visible to end users? A) Form Designer B) Site Structure (Sites, Menus, Sub-menus) C) Data Object schema D) Scheduled Jobs Answer: B Explanation: Sites, Menus, and Sub-menus build the primary navigation hierarchy. Question 17. Which server-side construct is used to run custom business logic before a record is saved? A) Pre-save Java rule (or Groovy) B) Post-save UI script C) Onload client script D) List View filter Answer: A Explanation: Pre-save rules execute on the server just before persisting a record, allowing validation or modification.
Developer Program Ultimate Exam
A) Server-side pre-save rule B) Client-side onchange script C) Scheduled job D) Database trigger Answer: B Explanation: Client-side onchange scripts can recalculate values instantly as the user types. Question 22. Which method safely performs an asynchronous call to a custom server-side operation? A) window.location.href = … B) $.ajax() with the eTK endpoint URL C) document.write() D) setTimeout() with a GET request Answer: B Explanation: $.ajax() is the standard jQuery method to invoke server-side services asynchronously. Question 23. When writing EntelliSQL for a List View, which clause should be used to limit the number of rows returned for performance? A) ORDER BY B) GROUP BY C) LIMIT (or FETCH FIRST) D) HAVING Answer: C Explanation: LIMIT (or FETCH FIRST) restricts result set size, improving query performance. Question 24. Which SQL construct is most appropriate for retrieving the total number of cases per status category? A) SELECT * FROM Cases B) SELECT status, COUNT(*) FROM Cases GROUP BY status C. SELECT status FROM Cases WHERE status = ‘Open’
Developer Program Ultimate Exam
D) SELECT DISTINCT status FROM Cases Answer: B Explanation: GROUP BY with COUNT aggregates rows per status. Question 25. In Entellitrak, how are Data Objects physically stored in the database? A) As XML documents in a single table B) Each DO maps to its own relational table C) All DOs share one universal table D) As JSON blobs in a NoSQL store Answer: B Explanation: Every Data Object has a corresponding relational table that holds its fields. Question 26. Which technique helps identify a slow-running EntelliSQL query used in a List View? A. Enabling JavaScript console logging B. Using the System Log Viewer’s SQL profiling tab C. Adding a “debug” field to the form D. Restarting the application server Answer: B Explanation: The System Log Viewer can display execution times for EntelliSQL statements. Question 27. Which security element allows a developer to restrict access to a specific field based on the current user’s role? A) Site navigation menu B) Field-level permission in the Role definition C) List View filter D) Client-side JavaScript hide/show Answer: B Explanation: Field-level permissions are part of role configuration and are enforced server-side.
Developer Program Ultimate Exam
B) Reporting Data Object (RDO) C) Reference Data Object D) Temporary Data Object Answer: B Explanation: RDOs are optimized for reporting and can be denormalized for performance. Question 32. When designing a scheduled job that exports daily case data to a CSV file, which Entellitrak component must be configured? A) List View bulk export B) Java class implementing the ScheduledJob interface and a schedule entry in the admin console C) Client-side JavaScript timer D) Database trigger on the case table Answer: B Explanation: Scheduled jobs are Java classes registered with the platform’s scheduler. Question 33. Which module provides out-of-the-box support for attaching files to case records? A) Document Management module B) Data Archiving module C) Workflow Engine D) Security module Answer: A Explanation: The Document Management module handles file storage and retrieval. Question 34. Where can developers view stack traces for exceptions thrown by custom Java code? A) Browser console B) System Log Viewer (Error level) C) List View “Error” column D) Eclipse console only
Developer Program Ultimate Exam
Answer: B Explanation: The System Log captures server-side exceptions with full stack traces. Question 35. In an Agile development cycle on Entellitrak, which practice helps ensure rapid feedback on UI changes? A) Deploying to production after every commit B) Using the “Preview” mode in the Developer Interface for instant form rendering C) Skipping unit tests to speed up delivery D) Hard-coding values in Java classes Answer: B Explanation: Preview mode allows immediate visual verification of UI adjustments without a full deployment. Question 36. When deciding between configuration and customization, which scenario most strongly suggests writing custom Java code? A) Adding a new dropdown value to a lookup table B) Changing the label of a field on a form C) Implementing complex multi-system integration with SOAP calls D. Reordering sections on a form Answer: C Explanation: Complex external integrations typically require custom server-side code. Question 37. Which naming convention is recommended for custom Java classes to avoid conflicts during platform upgrades? A) Use generic names like “Helper” B) Prefix with the customer’s short code and a descriptive suffix (e.g., “ABC_CaseExportJob”) C) Use all lowercase letters only D) Include the date in the class name Answer: B
Developer Program Ultimate Exam
A) Visible on Add only B) Read-only on Edit C) Auto-increment numeric ID D) Default value based on a formula Answer: C Explanation: Auto-increment IDs are generated by the database; they are not a configurable field property. Question 42. When a List View uses a JOIN between two Data Objects, what must be ensured for optimal performance? A) Both tables have the same column names B) Indexed foreign key columns are used in the ON clause C) The JOIN is performed in client-side JavaScript D) The query returns all columns (*) Answer: B Explanation: Indexing the join columns allows the database engine to execute the join efficiently. Question 43. Which EntelliSQL clause is used to exclude rows that do not meet a certain condition after grouping? A) WHERE B) HAVING C) ORDER BY D) LIMIT Answer: B Explanation: HAVING filters groups based on aggregate conditions. Question 44. In a custom Java rule, how can you retrieve the current logged-in user’s ID? A) etkUser.getCurrentUserId() B) etkSecurity.getCurrentUser().getId() C) etkData.getUserId() D) etkContext.getUserId()
Developer Program Ultimate Exam
Answer: B Explanation: etkSecurity provides access to the current user’s security context. Question 45. Which UI component would you use to allow users to switch between “Summary” and “Details” views on the same form? A) Tab B) Section C) Container with conditional visibility D) Dropdown field Answer: A Explanation: Tabs can hold separate layouts and let users toggle between them. Question 46. To make a field invisible for users with the “Viewer” role but visible for “Editor”, you would configure: A) Client-side jQuery hide() based on role B) Field-level permission in the role definition C) A List View filter D) A custom scheduled job that updates the field’s visibility flag Answer: B Explanation: Field permissions are evaluated server-side according to role assignments. Question 47. Which of the following best describes a “Calculated” field? A) A field whose value is entered manually by the user B) A field that derives its value from an expression evaluated on the server or client C) A field that stores a file reference D) A field that only appears in reports Answer: B Explanation: Calculated fields compute values automatically based on other data.
Developer Program Ultimate Exam
B) Add an onchange client script that re-queries the dependent field’s data source C) Use a server-side post-save rule D) Configure the dependent field as “Read-Only” Answer: B Explanation: An onchange script can trigger a refresh of related fields based on the new lookup value. Question 52. To limit a List View to only show records the current user created, which filter expression would you use? A) creator = ‘admin’ B) created_by = etkSecurity.getCurrentUserId() C) owner = ‘*’ D) status = ‘Open’ Answer: B Explanation: Using the current user’s ID ensures the list is personalized. Question 53. Which of the following is NOT a valid use of a Scheduled Job? A) Daily export of case data to an external FTP server B) Real-time validation of a field as the user types C) Nightly cleanup of temporary files D) Weekly generation of summary reports Answer: B Explanation: Real-time UI validation should be done client-side, not as a background job. Question 54. When a custom Java operation needs to call another custom operation, which pattern is recommended? A) Directly instantiate the second class with new B) Use the eTK API’s OperationExecutor to invoke the other operation by name C) Call a static method on the second class D) Execute a SQL stored procedure that runs the second operation Answer: B
Developer Program Ultimate Exam
Explanation: OperationExecutor ensures proper context, security, and transaction handling. Question 55. Which Entellitrak feature provides out-of-the-box audit trails for data changes? A) System Log Viewer B) Data Object versioning (history) C) List View “Change Log” column D) Document Management module Answer: B Explanation: Data Object history records create, update, and delete actions for audit purposes. Question 56. Which of the following is a best practice for handling large result sets in a List View? A) Return all rows and let the browser paginate B) Use server-side pagination with the “LIMIT” clause and enable List View paging C) Disable paging to improve performance D) Store the entire result set in a client-side JavaScript array Answer: B Explanation: Server-side pagination reduces memory usage and speeds up rendering. Question 57. To enforce that a case cannot be submitted unless a related document is attached, you would implement: A) A client-side validation script on the Submit button B) A pre-save server-side rule that checks for the document’s existence C) A List View filter that hides the Submit button D) A database trigger on the document table Answer: B Explanation: Server-side pre-save rules guarantee enforcement regardless of client manipulation.
Developer Program Ultimate Exam
B) Hidden field updated by a server-side rule C) Dropdown list populated via SQL D) Button that the user must click to refresh the total Answer: A Explanation: A calculated field combined with client-side onchange events provides immediate updates. Question 62. In Entellitrak, what does the “Reference Data Object” type primarily provide? A) Workflow automation B) Centralized lookup values for consistency across the application C) File storage capabilities D) Real-time data streaming Answer: B Explanation: Reference Data Objects serve as lookup tables for dropdowns and validation. Question 63. Which of the following is NOT a supported relationship cardinality in Entellitrak’s data model? A) One-to-One B) One-to-Many C) Many-to-Many D) Many-to-Zero Answer: D Explanation: “Many-to-Zero” is not a defined cardinality; relationships are defined as one-to-one, one-to-many, or many-to-many. Question 64. To enable a user to export the current List View to Excel, which configuration must be set? A) Enable “Export to CSV” in List View options (Excel export uses the same engine) B) Add a custom Java button that writes an XLS file C) Turn on “Bulk Actions” and select “Export”
Developer Program Ultimate Exam
D) No configuration – export is always available Answer: A Explanation: The List View’s Export option supports CSV/Excel formats when enabled. Question 65. Which of the following statements about Entellitrak’s “Soft Delete” is true? A) Soft-deleted records are removed from the database immediately. B) Soft-deleted records can be restored by an admin. C) Soft-deleted records are invisible to all users, including admins. D) Soft-delete only works on Reference Data Objects. Answer: B Explanation: Soft-deleted records remain in the database and can be restored if needed. Question 66. When creating a custom Java operation that must run under a specific user’s security context, which method should you use? A) etkSecurity.runAsUser(userId, () -> operationLogic()) B) etkData.getDataAs(userId, objectName, id) C) etkContext.setCurrentUser(userId) D) No special handling – operations always run as the system user Answer: A Explanation: runAsUser executes code with the permissions of the specified user. Question 67. Which of the following is the correct way to reference a field value in an EntelliSQL SELECT clause? A) SELECT fieldName FROM DataObject B) SELECT DO.fieldName FROM DataObject DO C) SELECT "fieldName" FROM DataObject D) SELECT #fieldName FROM DataObject Answer: B Explanation: Using an alias (e.g., DO) clarifies the table and field reference.
