Question 1

When using Expand Inline parameters in SQL queries, which of the following is not a best practice?

Options :

A : All options are bad practices.

B : Build WHERE column IN (@values) clauses by wrapping all the values in a EncodeSql call: values =

EncodeSql(name1 + "," + name2 + "," + name).

C : Perform manual string encoding using the Replace function.

D : Use EncodeSql to encode the full contents of an SQL parameter. For example: myparameter = EncodeSql("WHERE surname = " + @myVariable1 + " OR name = " + @myVariable2)

Answer: A

Question 2

If you have a screen that is slow to show to the user, what should you do to speed it up?

Options :

A : Replace any complex queries in preparation by aggregates and cycles to process their results.

B : Do all the pre-processing during preparation to speed up operations when calling screen actions

C : Replace all aggregates and queries by server actions that will process the information and return the results.

D : If possible, avoid doing any query results processing during preparation, delaying these tasks to any write operations

Answer: D

Question 3

When should you use the "Commit Transaction" action in OutSystems?

Options :

A : Use it at the beginning of every screen to improve performance

B : Use it to discard changes made during the screen execution

C : Use it to save changes to the database permanently

D : "Commit Transaction" is not a valid action in OutSystems

Answer: C

Question 4

Select the correct statement regarding the differences between a “Submit” and an “Ajax Submit”

Options :

A : Even though the Preparation is executed in both methods, the Ajax Submit request is made through Javascript, avoiding the browser to hang while waiting for an answer

B : The Ajax Submit request is executed asynchronously and allows to refresh only parts of the screen, however the server-side logic doesn’t have access to all contents previously loaded during the Preparation

C : There are no differences between both platform methods, they both implement the HTTP POST method

D : None of the above

Answer: B

Question 5

Your OutSystems application needs to handle user feedback and ratings. How would you design and implement a user-friendly feedback system with considerations for data storage and analysis?

Options :

A : Ignore user feedback for simplicity.

B : Leverage External Database Entities for storing feedback and use Aggregates for analysis.

C : Use only built-in forms for feedback.

Answer: B