WorksheetsDBF ECO Search OS exam
Total questions: 143
Worksheet time: 2hrs 23mins
Name
Class
Date
1.
Which of the following options is an advantage of using the Personal Area instead of the Public Area to debug an OutSystems Application?
a)
Developers can debug the application without affecting the main version of the application
b)
Developers can share with other developers their own breakpoints
c)
Developers can test changes to the data model and logic without affecting other developers
d)
Developers can create their own personal versioning of the module
2.
Consider the following date model containing the Status Static Entity, and the Customer, Order, ShippingDetail, OrderProduct and Product Entities. Why is this date model wrong?
a)
Contains an unnecessary one-to-one relationship
b)
Contains an attribute in the Order Entity that should not be there.
c)
Contains an unnecessary many-to-many relationship
d)
Contains an attribute in the Status Entity that should not be there
3.
Which of the following Expressions is the best to correctly display the Customer Name, of all the Customers, in the Table Records?
a)
GetCustomer(OrderTable.List.Current.Customer.Id).Name
b)
GetOrders.List.Current.Customer.Name
c)
OrderTable.List.Current.Customer.Name
d)
GetCustomer(GetOrders.List.Current.Customer.Id).Name
4.
The GetContacts Aggregate is defined in the Preparation of the Contacts Screen, and fetches all records from the Contact Entity. Select the correct option, taking into consideration the following ContactComboBox properties.
a)
If the user selects an existing Contact, the value of the SpecialContactIdvariable will be -1
b)
If the user selects an existing Contact, the value of both ContactId and
SpecialContactId will be the respective Id.
c)
If the user selects the – All Contacts – option, the value of the ContactId
variable will be -1.
d)
If the user selects an existing Contact, the value of the ContactId will be the respective Id
5.
Consider the following two implementations (A and B) below, where the Assign statement is detailed on the right. The goal is to repeat the RunActionWithNumber statement multiple times based on the value of the Number Input Parameter (e.g. 10). Based on this scenario, select correct option.
a)
Both alternatives are possible, as long as the If and For Each conditions are set to Number >= 0.
b)
Alternative A is possible, as long as the If condition is set to Number >= 0
c)
Alternative B is not possible, since the For Each always requires a List to iterate
d)
Alternative B is possible, since the For Each statement is the only statement that allows to create generic loops.
6.
Considering the following usages of the Feedback_Message Action, select the correct option.
a)
All of them work
b)
Snippet A doesn’t work because the Feedback_Message cannot be used in the Preparation of a Screen
c)
Snippet C doesn’t work because the Feedback_Message cannot be inside a Web Block
d)
Snippet B only works if the button associated to the Screen Action has its method property set to Ajax Submit
7.
How would you change the following Aggregate to return, for each team, the highest number of yards in a year and the average number of touchdowns?
a)
Create a Filter in the Aggregate with Max(Team, Yards), and group the results by Touchdowns
b)
Group the results by Team, and then apply the Max function to Yards and the Average function to Touchdowns
c)
Group the results by Year, apply the Max function to Touchdowns, and the Average function to Yards
d)
Sort the results by Yards and Touchdowns, and then group them by Team
8.
In the following Aggregate, which of the following options is the best way to ignore the Orders that have been Canceled?
a)
Group By OrderStatus.Label and then Add a Group Filter with: OrderStatus.Label <> “Canceled”
b)
Add a Filter with: Order.OrderStatusId <> NullIdentifier()
c)
Add a Filter with: Order.OrderStatusId <> Entities.OrderStatus.Canceled
d)
Add a Filter with: OrderStatus <> “Canceled”
9.
After opening the OSMDb module, the following appears on the Manage Dependencies dialog. Considering this scenario select the correct option.
a)
The OSMDb_Core module has been deleted from the Server
b)
The OSMDb_Core module has one or more references to elements in the OSMDb module
c)
Clicking the OK button is enough to refresh all dependencies
d)
A referenced element has been changed in the OSMDb_Core module
10.
Consider the Replace Data operation commonly used in Screens created from Screen Templates. Which of the following options is false?
a)
The Replace Data operation automatically deletes all widgets that could not be matched to the real data
b)
The data mapping in the Replace Data operation is based on the attribute’s name and data type
c)
Forms and Table/List Records support the Replace Data operation
d)
The Replace Data operation words on Screens not generated by Screen Templates
11.
Consider the following Save Screen Action inside the MovieDetail Screen, defined in a module where the Global Exception Handlers is set to the OnException action.In a scenario where the CreateOrUpdateMovie Entity Action throws an Exception, which Exception Handled will handle the exception?
a)
None of the Exception Handlers flows above
b)
The AllExceptions Handler inside the Save Screen Action
c)
The DBExceptions Handler inside the OnException action
d)
The AllExceptions Handler inside the OnException action
12.
If your Screens are only accessible to authenticated users, what is required to allow a new end-user to access your application?
a)
Create a new user in the Development Environment
b)
Create a new user in the Users application
c)
Create a new Groups in the Users application
d)
Create a new user in Service Center
13.
Regarding the Label Widget, which of the following options is false?
a)
If the Input associated to the Label Widget is mandatory, the Label automatically displays a red asterisk
b)
All Label Widgets must be associated to an input Widget
c)
The Value Property of a Label Widget can be defined using Expressions
d)
When the user clicks on a Label, the focus moves to the Widget associated with that Label
14.
Consider the following Entity Diagram. What is the data type of the Id attribute of the SnippingDetail Entity
a)
ShippingDetail Identifier
b)
Integer
c)
Order Identifier
d)
Long Integer
15.
Considering the following Aggregate, what will be the atrributes of the TopProducts.List.Current record?
a)
Three attributes corresponding to the three computed attributes in the Aggregate (Name, QuantitySum, and TotalPriceSum), plus the columns used to calculate these computed attributes (Product.Name, OrderItem.Quantity, and OrderItem.TotalPrice).
b)
The three computed attributes (Name, QuantitySum and TotalPriceSum) plus the four sources with all its attributes
c)
Seven attributes corresponding to the seven visible columns in the TopProducts Aggregate: Name, QuantitySum, TotalPriceSum, Quantity, Price,TotalPrice, and Label
d)
Three attributes that correspond to the computed attributes in the Aggregate: Name, QuantitySum and TotalPriceSum
16.
Web Blocks can have …
a)
… only Screen Actions. Its initializations is done using the Web Screen’s Preparation
b)
… a Preparation, but no Screen Actions
c)
… a Preparation and Screen Actions, just like a Web Screen
d)
… a Preparation, Screen Actions and Output Parameters
17.
To populate a Form, you need to set its Source Record property with …
a)
… a single Record.
b)
… an in-memory Structure
c)
… a Local Variable. There’s no other way.
d)
… a list that was returned from an Aggregate or SQL.
18.
What will happen once you drop the Web Block, as depicted below?
a)
The Web Block will be rendered, but only if it is inside a Container
b)
The Web Block will be rendered since it is possible to nest Web Blocks
c)
You will get an error since you can’t nest Web Blocks
d)
You will get an error since you can’t place a Web Block inside itself
19.
Regarding Static Entities, what can you do at runtime?
a)
Change the Is_Active attribute of the Records to False.
b)
Only use the Ids of its Records. They only exist in memory and have no representation in the database.
c)
Fetch data. To create or edit records, you need to do it at design time.
d)
Fetch, Create and Update Records.
20.
Regarding Session Variables, which of the following options is correct?
a)
Session Variables can be set to Public and used in other modules.
b)
Session Variables cannot be changed inside a Preparation flow.
c)
Session Variables will not keep the assigned value between consecutive requests from the same end-user.
d)
Session Variables should not be used to store Record and List date types.
21.
Consider the following Screen Action, which was set as the Destination of a “Save” Button. When the user submits the valid Form named ProductForm, what is the final outcome of the Action?
a)
When updating an already existing Product, you will get an Exception.
b)
The CreateOrUpdate Action will commit the user changes in the Form to the database.
c)
There will be no changes to the database, as the CreateOrUpdateProduct Action is not using the data from the Form.
d)
The CreateOrUpdate Action will commit the user changes in the Form to the database, only if the Validation Method of the Save Button is set to Server.
22.
Consider the following SQL Statement used in the Preparation of a Screen. Which of the following options is correct?
a)
The @SearchKeyword is an Input Parameter of the Query of type Text.
b)
The @SearchKeyword is an Input Parameter of the Screen of type Text.
c)
The @SearchKeyword is a Session Variable of type Text.
d)
The @SearchKeyword is a Local Variable of the Screen of type Text.
23.
In the following Aggregat
a)
… if you choose Sort A->Z on the Customer.Name column, a second sort option is added to the Aggregate. In the results, the records with the same Date will appear ordered by Name.
b)
… if you choose Sort A->Z on the Customer.Name column, a second sort option is added to the Aggregate. In the results, the records with the same Name will appear ordered by Date.
c)
… if you choose Sort A->Z on the Customer.Name column, the previous sort option it replaced by this new sort option.
d)
… you can’t sort by the Customer.Name, because you already have the results sorted by an attribute of another Entity.
24.
Regarding the output of an Aggregate, which of the following options is correct?
a)
The Count property value is -1 if the Aggregate does not return records.
b)
The List.Length property can not be used to assess if the Aggregate does not return records.
c)
The List.Length property value is always less than or equal to the Count property value.
d)
The Count and List.Length properties always return the same value.
25.
Regarding Screen Actions in OutSystems, which of the following options is false?
a)
A Screen Action has access to the Screen Widget’s runtime properties.
b)
A Screen Action can have multiple Output Parameters.
c)
A Screen Action can be used to download Binary Data.
d)
A Screen Action can be set as the On Click Destination of a Container.
26.
In Service Studio, how can you avoid duplicate records in a Database Entity?
a)
Using a Database View.
b)
Using a Database Trigger.
c)
Using Database Constraints.
d)
Using Unique Indexes.
27.
In OutSystems Web Applications, when do Client & Server validations prevent a request to the server?
a)
When mandatory fields are not filled in, or data types don’t match the expected input data types.
b)
Only when data types don’t match the expected input data types.
c)
Only when mandatory fields are not filled in.
d)
When built-in and custom client-side validations, defined in a Screen Action, fail.
28.
In OutSystems, the For Each statement …
a)
… allows defining a generic loop based on a boolean condition.
b)
… cannot be used to iterate over an Aggregate output, when inside a Server Action.
c)
… can be used in a Screen to display each item of a List.
d)
… allows iterating through all the elements in a List.
29.
What happen when the user presses a Button, that executes a Screen Action, using the Submit method?
a)
The Screen Action associated with the Button is executed, followed by the Preparation.
b)
The Screen Action associated with the Button is executed and the Preparation is not executed.
c)
The Screen Action associated with the Button is executed. The Preparation would only run if the Button’s Method was set to Ajax Submit.
d)
The Preparation executed, followed by the Screen Action associated with the Button.
30.
Regarding Site Properties, which of the following options is correct?
a)
Site Properties can be set to Public and referenced in other modules.
b)
Site Properties can store value of type <Entity>Identifier.
c)
Site Properties values are reset when the user logs out.
d)
Site Properties will store a different value for each end-user.
31.
The Form’s Valid property …
a)
… must be set explicitly using an Assign.
b)
… is set to True only if the user fills all of the Form’s mandatory input fields.
c)
… is set to False when client-side validations fail.
d)
… is set to False when one of the Form’s input fields fails its validation.
32.
Consider that you are creating a new Screen to display application data. Which of the following options is correct regarding OutSystems applications’ Roles in that Screen?
a)
To ensure that access to the Screen is restricted, the Screen can only have application-specific roles checked.
b)
Checking only application-specific Roles in the Screen ensures that end-users are required to log in before accessing the Screen.
c)
To ensure that access to the Screen is restricted, the Screen should have the Anonymous Role checked.
d)
Checking the Registered Role in the Screen ensures that the Screen can only be accessed by users that are not logged in.
33.
A one-to-many relationship from Entity Publisher to Entity Book is created by …
a)
… adding an attribute to Entity Book of type Foreign Key.
b)
… adding an attribute to Entity Publisher Identifier.
c)
… adding an attribute to Entity Book of type Publisher Identifier.
d)
… adding an attribute to Entity Publisher of type Foreign Key.
34.
Setting the Expose Read Only property of an Entity to Yes will …
a)
… only expose the Get<Entity> Entity Action.
b)
… prevent other modules from modifying the Entity’s data, but only if you also set the Public property to No.
c)
… only allows other modules to query data using Aggregate.… prevent other modules from modifying the Entity’s data, but only if you also set the Public property to No.
d)
… prevent other modules from modifying the Entity’s data, but only if you also set the Public property to No.
35.
The Preparation of a Web Screen
a)
… always runs after the End of a Screen Action.
b)
… can only have one End statement.
c)
… is required in all Web Screens.
d)
… is executed before the Web Screen is rendered for the first time
36.
Consider the Movies Screen that contains a Table Records to display the list of Movies. A List Navigation Web Block is associated to the Table Records, to allow to navigate through the existing sets of records. Which of the following Screen Action flows correctly implements the On Notify behavior of the List Navigation?
a)
A and C implement the correct behavior.
b)
A, B and D implement the correct behavior.
c)
Only D implement the correct behavior.
d)
A and D implement the correct behavior
37.
Consider a Table Records that will display all the records of a Database Entity. Which of the following options is correct?
a)
It is mandatory for each attribute to have its own column. To display the values of the attributes, you must drag the Entity or its attributes to the Table Records.
b)
It is not mandatory to have a column for each attribute. To display the values of the attributes you can use more than one widget.
c)
It’s not mandatory to have a column for each attribute. You can only use Text or Expressions inside a Table Records.
d)
It is mandatory for each attribute to have its own column. Otherwise, displaying the values of the attributes will not work properly
38.
When you instantiate a Web Block inside a Web Screen, which of the following options is correct when the user navigates into the Screen?
a)
The Web Screen’s Preparation runs, and then the Web Block’s Preparation runs.
b)
The Web Screen and Block’s Preparation run at the same time.
c)
The Web Block’s Preparation runs, and then the Web Screen’s Preparation runs.
d)
Web Block can’t have a Preparation, so only the Web Screen’s Preparation runs
39.
Regarding Screen Preparation and Server Actions, which of the following options is false?
a)
Server Actions do not have access to Site Properties.
b)
Screen Preparation has access to the Screen Input Parameters.
c)
Screen Preparation does not have access to Local Variables inside Screen Actions.
d)
Server Action have access to Session Variables.
40.
In OutSystems, when importing a Database Entity from an Excel file …
a)
… you will need to manually specify each attribute’s name, and match them to each column in the Excel file, in Name and Data Type.
b)
… the Entity will be created with the attributes corresponding to the columns in the Excel file, but without any Entity Actions.
c)
… the names in the first row in the Excel file will be used to try automatically map the Entity’s attribute names.
d)
… the first row in the Excel file is used to create the Entity’s attributes, but you need to specify the attribute’s Data Types.
41.
The Trigger Event statement allows …
a)
… a Web Screen to notify its children (Web Blocks) that something relevant occurred.
b)
… a Web Block to notify its parent (Web Screen or Web Block) that something relevant occurred.
c)
… a Web Block to notify its children (Web Blocks) that something relevant occurred.
d)
… a Web Screen to notify its parent (Web Screen or Web Block) that something relevant occurred
42.
In the following scenario, what happens when the CompanyId Input Parameter of the CompanyDetail Screen has the NullIdentifier() value?
a)
The Aggregate in the Preparation returns null.
b)
The Aggregate in the Preparation is skipped.
c)
The Aggregate in the Preparation throws a Database Exception at runtime.
d)
The Aggregate in the Preparation returns an empty List.
43.
Consider the following Aggregate that shows all existing data from the Movie and MovieGender Entities in the Preview area. Which of the following options is correct?
a)
Changing the Join to With or Without, and swapping the Entities order in the Join, will yield the same result.
b)
Changing the Join to With or Without will return all existing Movies.
c)
Changing the Join to Only With will yield the same result.
d)
Changing the Join to Only With, and swapping the Entities order in the Join, will return all existing Movies.
44.
The Container in the following screenshot is set with the backgroud-blue style, but it is being rendered with a red background. What is causing this behavior?
a)
The background-blue style is redefined in the ModuleTheme or the HomeScreen, setting the background color to red.
b)
The primary color defined in the ModuleTheme is red.
c)
The background color setting inside the Styles Editor does not override the theme CSS definition.
d)
The container is inside a Web Block that overrides the background-blue style.
45.
In OutSystems, a Consumed REST API Method …
a)
… can be used in a Run Server Action.
b)
… can be used in an Expression.
c)
… cannot have more than one Input Parameter.
d)
… cannot be used in a Preparation.
46.
In OutSystems, if you need to refresh part of a Web Screen instead of refreshing the entire Web Screen, affter clicking a Button, which of the following options is correct?
a)
You always need to use a Refresh Data and an Ajax Refresh on the Screen associated with the Button.
b)
You need to set the Button method to ‘Ajax Submit’ and use Ajax Refresh to refresh the specified Web Screen part.
c)
You need to encapsulate that part of the Web Screen in a Web Block.
d)
You need to set the Button method to ‘Ajax Submit’ or ‘Submit’, and use Ajax Refresh to refresh the specified Web Screen part.
47.
The Id attribute in the Resource Entity has the Delete Rule property set to Ignore. Which of the following statements is true?
a)
Deleting a record from the ToDo Entity will leave the corresponding record in the Resource Entity.
b)
Deleting a record from the ToDo
c)
Deleting a record from the Resource Entity is only possible after deleting the corresponding record from the ToDo Entity.
d)
Deleting a record from the ToDo Entity is not possible if there is a Resource with the same Id in the Database.
48.
Considering Aggregates and SQL Queries, which of the following options is correct?
a)
A SQL Query needs to always have an Output Structure/ Entity defined.
b)
Hiding columns in an Aggregate influences its output.
c)
Everything that can be written in a SQL Query can also be defined in an Aggregate.
d)
Both SQL Queries and Aggregates support Bulk Inserts in the Database.
49.
Check, Grant and Revoke Role functions …
a)
… must be created manually.
b)
… allow to manipulate user permissions at runtime.
c)
… allow to Check, Grant or Revoke Roles of groups.
d)
… can be used in the Condition of an If Widget.
50.
Consider the following ActionX where the Result Output Parameter and the Counter Local Variable have Integer data type. Both default values are 0. Which of the following options is the correct value for the Result Output Parameter, after the ActionX being computed?
a)
The value of the Result Output Parameter is 5.
b)
The value of the Result Output Parameter is 6.
c)
The value of the Result Output Parameter is 7.
d)
The value of the Result Output Parameter is 3.
51.
Regarding Session Variables in OutSystems, which of the following options is correct?
a)
Session Variables' values never expire and are kept in all requests from the same user
b)
Session Variables allow sharing data between different users.
c)
Session Variables ' values expire after the session timeout.
d)
Session Variables can only be used after the user authenticates
52.
Immediatelly after creating an Entity and its attributes, what is the expected behavior when using Boostrap Data from Excel.
a)
You cannot use the Boostrap Data from Excel . You are required to Publish the module first.
b)
The Boostrap Data from Excel will try to automatically map the Entity attributes with the existing headers, in the first row of the Excel file.
c)
You cannot use Boostrap Data from Excel, because the structue of the Entity is already defined.
d)
The Boostrap Data from Excel only works if all attributes match exactly the headers on the first row of the Excel file . Otherwise you get an error.
53.
Consider a Screen containing a Table Records, with an Aggreagate as data source. To add the sort functionality to all colums in the Table Records, you have to
a)
add the List_SortColumn Web Block after the Table Records and select the Table Records in the ListWidgetId property of the List_SortColumn.
b)
simply drop the List_SortColumn Web Block on each column and change the Aggregate to use the Block’s Output parameter.
c)
add the List_SortColumn Web Block to each column of the Table Records, set the Column property with {Entity}.[Attribute] and the Dynamic Sort is automatically added to the Aggregate.
d)
add the Lis_SortColumn Web Block to each column of the Table Records, set the Column property with {Entity}.[Attribute], and define the Dynamic Sort in the Aggregate.
54.
Consider a Web Screen with a Button that is associated to a Screen Action. An Ajax Refresh statement in that Screen Action allows to refresh part of the Web Screen
a)
if the Button’s Method is set to Submit.
b)
regardless of the Button’s Method.
c)
if the Button’s Method is set to Ajax Submit.
d)
if the Button’s Method is set to Navigate.
55.
In the Preparation of a Web Screen, the Destination statement…
a)
… renders the Current Screen and afterwards the user is redirected to the Destination Screen.
b)
… allows redirecting the user to a different Web Screen, without rendering the current Screen.
c)
… prompts the user before redirecting to the Destination Web Screen.
d)
… cannot be used.
56.
Consider that a user navigates to a Web Screen and then clicks on a Button, set with the Submit Method and the following Screen Actions as the Destination. In this scenario, when does the Preparation run?
a)
When the user accesses the Web Screen and when the user clicks on the Button.
b)
When the user accesses the Web Screen, but not when clicks on the Button.
c)
Only when the user clicks on the Button.
d)
Never.
57.
Consider the following ActionX where the Result Output Parameter and the Counter Local Variable have Integer data type. Both default values are 0. Which of the following options is the correct value for the Result Output Parameter, after the ActionX being computed.
a)
The value of the Result Output Parameter is 5.
b)
The value of the Result Output Parameter is 3.
c)
The value of the Result Output Parameter is 6.
d)
The value of the Result Output Parameter is 4.
58.
What happens when the user makes a request to access a Screen for the first time?
a)
The Preparation is only executed if the user has visited the Screen before.
b)
The Preparation is executed, follow by the page rendering.
c)
The Preparation is only executed if the Screen does not have Input Parameter.
d)
The Screen is rendered and then The Preparation is executed.
59.
Consider that you have a Web Block , named CardBlock, whose content is a Container with the ….. style class applied to it. following options is correct? This Block is instantiated inside the Dashboard Screen that is based on the Dashboard. Considering the following CSS definition, which of the Dashboard. Considering the following CSS definition, which of the following options is correct?
a)
In the Dashboard Screen, the Container inside the Web Block will have a blue background and 16px font size.
b)
In the Dashboard Screen, the Container inside the Web Block will have a red background and 16px font size.
c)
In the Dashboard Screen, the Container inside the Web Block will have a blue background and 14px font size.
d)
In the Dashboard Screen, the Container inside the Web Block will have a red background and 14px font size.
60.
The OutSystems debugger can be used to…
a)
inspect the value of primitive types. Composite types, like Lists, cannot be inspected.
b)
inspect the variables’ state and follow the page lifecycle, step by step.
c)
inspect the logic. It is not possible to inspect the Screen render stage.
d)
inspect the value of the variables, except for Session Variables and Site Properties.
61.
Immediately after creating an Entity and its attributes, what is the expected behavior when using the bootstrap Data from Excel?
a)
you cannot use the Bootstrap Data from Excel. You are required to Publish the module first.
b)
The Bootstrap data from Excel will try to automatically map the Entity attributes with the existing headers, in the first row of the Excel file.
c)
You cannot use the Bootstrap Data from Excel, because the structure of the Entity is already defined.
d)
The Bootstrap Data from Excel only works if all attributes match exactly the headers on the first row of the Excel file. Otherwise you get an error.
62.
Select the correct option regarding Sever Actions
a)
It is not possible to set both Public and Function properties to Yes at the same time.
b)
All Sever Actions must have at least one input or Output Parameter
c)
Setting the Function property to Yes requires the Server Action to have only one Output Parameter.
d)
Setting the Public property to Yes requires the Server Action to have at least one Input or Output Parameter
63.
In OutSystems, User Groups allow you to
a)
assign --- a Role to multiple users at the same time
b)
create new user Sessions for multiple users at the same time
c)
assign the same password to multiple users at the same time
d)
grant the access to the same Screens to multiple users at the same time
64.
Before iterating a non-empty List, the List.Current element contains…
a)
… null.
b)
… the last record of the List.
c)
… the first record of the List.
d)
… an empty record.
65.
Select the correct option regarding Sever Actions
a)
A Server Action can only have one Output Parameter, To indicate if the action worked as expected or not, you should use an Exception
b)
A Server Action can return multiple values in different Output Parameters, but limited to the OutSystems basic types.
c)
A Server Action can return multiple values in different Output Parameters, of any OutSystems data type
d)
A Server Action can only have Output Parameter. When more than one value needs to be returned, a Structure must be used.
66.
Consider that you define an Unique Index over the attributes Name and Email of the Customer Entity…. Of the following records would raise a Database Exception when trying to add it to the Entity?
a)
(John Smith, john@example.com, 555-3333) and (John, john.james@examle.com, 777-99999)
b)
(John, john@example.com, 555-33333) and (John, john@example.com, 777-99999)
c)
(John, john@example.com, 555-33333) and ( John James, john@example.com, 777-99999)
d)
(John, john@example.com, 555-33333) and (John, john.james@example.com, 777-99999)
67.
Considering the following Aggregate, which of the following options is correct?
a)
The Aggregate returns Movies with Genre and with zero or more Comments.
b)
The Aggregate only returns Movies without Genre and at least one Comment.
c)
The Aggregate only returns Movies with Genre and at least one Comment.
d)
The Aggregate only returns Comment without Genre and at least one Movies.
68.
Consider the following Server Action, containing a Switch where the conditions are detailed on the connectors. Which of the following options is correct?
a)
If the value of GenderLetter is “Female”, the Gender output value will be “Female”
b)
If the value of the GenderLetter is “M”, the Gender output value will be “Male”
c)
The Gender output value will be either “Female” or “Male”
d)
None
69.
What is wrong with SQL Query?
a)
An Input Parameter is missing
b)
The Output Structure should have the Product, but not the Product Sales.
c)
The Output Structure should have the Product Sales, but not the Product D. The output of a SQL Query can have either Entities or Structures, not both
d)
None
70.
Regarding Web Blocks in OutSystems, which of the following options is correct?
a)
You can instantiate Web blocks only on Web Screens
b)
you can instantiate Web Blocks on Web Screens and external HTML pages, by adding a special HTML tag
c)
You can instantiate Web Blocks on Web Screens and other Web Blocks
d)
You can instantiate Web Blocks on Screen Actions
71.
Select the correct option regarding the output of an Aggregate
a)
Returns Null when there are no results.
b)
Returns a List that is empty when there are no results
c)
Throws an exception when there are no results
d)
Returns – 1 if there no results.
72.
Regarding Web Blocks, which of the following options is correct?
a)
A Web Block can be nested inside itself
b)
A Web Block can have Out Parameters
c)
A Web Block can only be instantiated inside Web Screens
d)
A Web Block can have its own Preparation
73.
Consider the Replace Data operation commonly used in Screens Created from Screen Templates … The following options is correct?
a)
All widgets in Screens generated by Screen Templates support the Replace Date operation
b)
The Replace data operation does not cause any True Change errors. All mismatches between the sample and user data result in warnings
c)
The widgets associated with data that is not matched between the sample and the user data are automatically deleted from the Screens
d)
The replace Data operation also works for Screens that were not created using screen Templates
74.
A Static Entity is an Entity …
a)
…that can only hold basic data type values, excluding references to other Entities
b)
… whose attribute data types are limited to basic data types or Static Entities’ identifiers
c)
… whose attributes must be always mandatory
d)
… Used to define non-modifiable (constant) values with attributes limited to Id, Label, Order and Is_Active
75.
Which of the following should be implemented using a Site Property?
a)
The number of registered users
b)
The minimum password length
c)
The search filter of a list Screen
d)
The list of Logged in users
76.
Considering the behavior implemented through the following Database Entities and relationships, select the correct option.
a)
Referential integrity is guarantee between Order and Order Line, and Customers with Orders are not deletable
b)
Deleting an order deletes all associated Order Lines and referential integrity is only guaranteed between Orders and Customers
c)
Customers with Orders are not deletable and deleting an Order Line deletes the associated Order
d)
Deleting an Order leaves the associated Order History entries bot some Orders are not deletable.
77.
Regarding consuming a REST API using Service Studio, which of the following options is false?
a)
The OnAfterResponse callback allows to handle and customize possible REST API error. For instance, redefine the error message.
b)
It is possible to define specific OnBeforeResponse or OnAfterResponse callbacks for each method of a REST API.
c)
The OnBeforeResponse callback allows you to manipulate the REST method parameters. For instance, inject an API key.
d)
It is possible to use both OnBeforeResponse or OnAfterResponse callbacks in the same REST API.
78.
In the following Aggregate…
a)
…. you cannot replace the existing sort Order.CustomerId because it is a reference attribute.
b)
…. you cannot add a sort by Customer.Name with Ascending order.
c)
… you can only add a sort by Customer.Name if you remove the existing sort.
d)
…. you can also add a Dynamic Sort to the Aggregate.
79.
Consider the following screenshot that displays a Table Records to the show existing Movies, and the List Navigation to navigate through the different set of results. When the user clicks the Page 2 link, the Table Records updates the set of Movies but the List Navigation doesn’t highlight Page 2. Which of the following options explains the problem?
a)
The On Notify Screen Action tied to the List Navigation is not refreshing the query that retrieves the list of Movies.
b)
The On Notify Screen Action tied to the List Navigation is not refreshing the Table Records that displays the list of Movies.
c)
The Submit method of the List Navigation Web Block is set to Navigate.
d)
The On Notify Screen Action tied to the List Navigation is not refreshing the List Navigation Web Block.
80.
In the following Aggregate, we want to filter the results ton only return contacts that have ‘John’ anywhere in their name. To achieve this result, what is the correct expression to put in the Filter of the Aggregate?
a)
Contact.Name = “John”
b)
Contact.Name = “%John%”
c)
Contact.Name like “ %John%”
d)
Contact.Name like “John”
81.
Consider the Aggregate in the following screenshot. What would be the most computationally efficient way of obtaining the total price (including VAT) per Order?
a)
Create a calculated attribute ProductTotalWithVAT with the expression: Product.WholesalPrice = (1 + Product.VAT/100) * OrderProduct.Quantity. Then. Use a Sum aggregation function over that attribute. Product.WholesalePrice * (1+ Product.VAT/100)*OrderProduct.Quantity
b)
Create a Server Action (marked as a Function) that calculators and return the total price with VAT for that Order, based on the OrderId Input Parameter. The, add a calculated ProductTotalWithVAT to the Aggregate, using that Function.
82.
How would you change the following Aggregate to return, for each team, the highest number of the touchdowns ever scored in a year and the average point score?
a)
Group the results by Year, apply the Max function to Touchdowns, and the Average function to Points.
b)
Group the results by Team, and the apply the max function to Touchdowns and the Average function to Points.
c)
Sort the result by Points and Touchdowns, and the Group them by Team.
d)
None
83.
Consider that you need to change that database of your application, with the respective Data Model in the following image, to include the types of Products. A Product can only have one type. Examples of types are: Books, Music, Movies, Electronics. You have been told by the project manager that the Product Types have not changed since last year. Which of the following is the best way to implement this change?
a)
Add a new Static Entity, ProductType, With 4 records, one for each type of Product. In addition, add an attribute to it of type Product Identifier.
b)
Add a new Static Entity, ProductType, With 4 records, one for each type of Product. In addition, add an attribute to Product of type ProductType Identifier.
c)
Add a new Static Entity, ProductType, to the Product Entity and set 1 for Books, 2 for Music, 3 for Movies, 4 for Electronics.
d)
Add a new Static Entity, ProductType, to Product and set its values to “Book”, “Music”, Movies” and “Electronics”.
84.
Considering the On Change Destination property of the Combo Box Widget, which of the following options is correct?
a)
Web Screens and Screen Actions can be selected in the On Change Destination Property.
b)
Screen Actions can be set as the On Change Destination. When an end – user changes the value of the combo box, a Submit request is made and then the Screen Action is executed.
c)
Screen Actions can be set as the On Change Destination. When an end – user changes the value of the combo box, an Ajax Submit request is made and then the Screen Action is executed.
d)
Web Screens can be set as the On Change Destination. When the end – user changes the value of the combo box, the end-user Navigates to the Wed Screen specified.
85.
What is the correct answer?
a)
Product.Price > 0 and Product.QuantityInStock >= 0
b)
ProductForm.Valid = False
c)
ProductForm.Record.Product.Price >= 0 and ProductForm.Record.Product.QuantityInStock >= 0
d)
ProductForm.Valid = True
86.
To use a Table Records you are absolutely required to…
a)
enclose the Table Records in a named Container
b)
specify a Source Record List with the data to be displayed to the user in the Table Records.
c)
specify a Source Record to be displayed to the user in the Table Records.
d)
have a Preparation on the Screen or Web Block containing the Table Records.
87.
When the user submits data in a Form to the server…
a)
the data in the Form is only available in the Preparation.
b)
the data is stored in the Form's Record implicit variable
c)
the Preparation runs, then the Screen Action runs
d)
a Screen Action runs with the data from the Form as Input parameter.
88.
Select the correct option regarding the Input Widget
a)
All Input widgets must be inside a Form widget
b)
Input Widgets can only be bound to variables of Text data type.
c)
The data typed by the user is saved in the Input widget itself
d)
You always need to have a variable to hold the value typed by the user.
89.
in OutSystems the Expression Widget…
a)
cannot contain JavaScript Code to be embedded in Web Pages
b)
can only contain static content to display to users
c)
cannot be used inside Link Widgets.
d)
can contain logic that is evaluated when performing server-side rendering
90.
Considering the On Change Destination property of the Combo Box Widget, which of the following options is correct?
a)
Web Screens and Screen Actions can be selected in the On Change Destination property.
b)
Screen Actions can be set as the On Change Destination. When an end-user changes the value of the combo box, a Submit request is made and then the Screen Action is executed
c)
Screen Actions can be set as the On Change Destination. When an end-user changes the value of the combo box, an Aar Submit request is made and then the Screen Action is executed
d)
Web Screens can be set as the On Change Destination When the end-user changes the value of the combo box the end-user Navigates to the Web Screen specified
91.
When using Server side validations to avoid stoning invalid data in the Database
a)
you should add an Exception Handler to handle invalid user input
b)
you just need to ensure the Form's Validation property is set to Server
c)
you just need to ensure the Save Button's Validation property is set to Server
d)
you should check the Form’s Valid property to see if it is set to False before storing the data
92.
When a Form is submitted, what are the built-in validations that OutSystems performs?
a)
he Mandatory fields are filed in and the data submitted by the user matches the data type of the variables associated with the Inputs.
b)
If the data submitted by the user matches the data type of the variables associated with the respective Inputs.
c)
be Mandatory fields are filed in
d)
be data submitted by the user matches the data type of the Source Record of the Form
93.
Which of the following is the best method to restrict access to part of a Web Screen for users with a specific MovieAdmin Role.
a)
Untick all the Roles in the Screen except for the MovieAdmin Role.
b)
Enclose that part in an If and use a Container to check if the user has permission
c)
Enclose that part in a Container, and use the Enabled property to hide the contents.
d)
Encapsulate that part in a Web Block and change the Block's Role properties, to only allow the MovieAdmin Role.
94.
What is wrong with this SQL Query?
a)
The output structure should have the Product, but not the Product Sales
b)
The syntax for referencing Database Entity attributes should be [EntityName].{AttributeName}.
c)
An Input Parameter is missing.
d)
The Output Structure should have the Product Sales, but not the Product.
95.
Consider the following Screen Action flow, that performs custom validations over data submitted from the ProductForm. Which condition should be set for the highlighted If statement?
a)
ProductForm.Valid = True.
b)
ProductForm.Record.Product.Price > 0 and ProductForm.Record.Product.QuantityInStock...
c)
Product.Price > 0 and Product.QuantityInStock >= 0.
d)
ProductForm.Valid = False
96.
In a Web Application, a Screen Action ...
a)
... can terminate with End, Destination, Download or Raise Exception Statements.
b)
... cannot have multiple termination statements.
c)
... can have multiple termination statements, but none of them can be a Destination statement.
d)
... must always terminate with an End statements.
97.
Considering Aggregates and SQL Queries, which of the following statements is true?
a)
All SQL Queries can be replaced by an Aggregate.
b)
Aggregates and SQL Queries have different output types.
c)
Everything that can be define in Aggregate can also be written in a SQL Query.
d)
Both SQL Queries and Aggregates are automatically optimized by the platform.
98.
When using a Popup_Editor, consider that you implement a Screen Action in the Popup Screen that requires Source Screen to be refreshed. How would you implement that Screen Action?
a)
You use the Popup_Editor_Close to close the Popup, followed by the Ajax Refresh to refresh the Source Screen.
b)
You use the Popup_Editor_Notify for the Popup Screen to notify the Source Screen, followed by the Popup_Editor_ ... the Popup
c)
You use the Popup_Editor_Notify for the Popup Screen to notify the Source Screen and close the Popup.
d)
You use the Popup_Editor_Notify for the Popup Screen to notify the Source Screen, followed by the Popup_Editor__... the Popup and an Ajax Refresh to refresh the Source Screen.
99.
When the user submits data in a Form to the server...
a)
... a Screen Action runs with the data from the Form as Input parameter.
b)
... the Preparation runs then the Screen Action runs.
c)
... the data is stored in the Form’s Record implicit variable.
d)
... the data in the Form is only available in the Preparation.
100.
Select the correct option regarding Server Actions.
a)
Setting the Function property to Yes requires the Server Action to have only one Output Parameter.
b)
All Server Actions must have at least one Input or Output Parameter.
c)
Setting the Public property to Yes requires the Server Action to have at least one Input or Output Parameter.
d)
It is not possible to set both Public and Function properties to Yes at the same time.
101.
Which of the following should be implemented using a Site Property?
a)
The number of registered users.
b)
The search filter of a list Screen.
c)
The list of logged in users.
d)
The minimum password length.
102.
If we have multiple Exception Handlers in an Action flow and an Exception is raised ...
a)
The execution is always moved to the Global Exception Handler.
b)
The execution is moved to the Exception Handler that is most specific to the Exception.
c)
The execution is moved to all Exception Handlers of the Action.
d)
A Switch statement is needed to select which Exception Handler will continue the execution.
103.
Consider a Web Screen with a Button that is associated to a Screen Action. An Ajax Refresh statement in that Screen Action allows to refresh part of that Web Screen, ...
a)
... if the button has Method Navigate.
b)
... regardless of the Button’s Method.
c)
... if the Button has Method Ajax Submit.
d)
... if the Button has Method Submit.
104.
When a Form is submitted, what are the built-in validations that Outsystems performs?
a)
If the data submitted by the user matches the data type of the variables associated with the respective Inputs.
b)
If the Mandatory fields are filled in and if the data submitted by the user matches the data type of the variables associated Inputs.
c)
If the Mandatory fields are filled in.
d)
If the data submitted by the user matches the data type of the Source Record of the Form.
105.
If you define a Unique Index over the attributes Name and Email of the Client Entity ...
a)
... a database exception will be thrown if you try to insert (John, john@example.com, 555-33333) and (John, john@example.com, 777-99999).
b)
... a database exception will be thrown if you try to insert (John Smith, john@example.com, 555-33333) and (John, john, james@example.com, 777-99999).
c)
... a database exception will be thrown if you try to insert (John, john@example.com, 555-33333) and (John, john, james@example.com, 777-99999).
d)
... a database exception will be thrown if you try to insert (John, john@example.com, 555-33333) and (John James, john@example.com , 777-99999).
106.
Before iterating a non-empty List, the List.Current element contains ...
a)
... the first record of the list.
b)
... null
c)
... the last record of the List.
d)
... an empty record.
107.
A static Entity is an Entity...
a)
... whose attribute data types are limited to basic data types or references to other Static Entities.
b)
... that can only hold basic data type values, excluding references to other Entities.
c)
... used to define none-modifiable (constant) values with attributes limited to Id, Label, Order and Is_Active.
d)
.. whose attributes must be always mandatory.
108.
What happens when the user makes a request to access a Screen for the first time?
a)
The Preparation is executed, followed by the page rendering.
b)
The Preparation is only executed if the user has not visited the Screen before.
c)
The Preparation is only executed of the user has not visited the Screen before.
d)
The Screen is rendered and then the Preparation is executed.
109.
The Outsystems debugger can be used to...
a)
... inspect the variables state and follow the page lifecycle, step by step.
b)
... inspect the value of the variables, except for Session Variables and Site Properties.
c)
... inspect the value of primitive types. Composite types, like Lists, cannot be inspected.
d)
... inspect the logic. It is not possible to inspect the Screen render stage.
110.
The Delete<Entity> Entity action ...
a)
... must receive the SQL statement to delete the record as Input Parameter.
b)
... must receive the Identifier of the record to be deleted as Input Parameter.
c)
... must receive the Record to be deleted as Input Parameter.
d)
... asks for confirmation before deleting the record.
111.
Considering an Entry Point of a module, which option is correct?
a)
You can only have one Entry Pont in each UI Flow.
b)
You can have several Entry Points in the same UI Flow, with the Is Default property set to “Yes”.
c)
You can have several Entry Points in the same UI Flow, as long as each one is connected to a Web Screen, or a Web Block...
d)
You can have several Entry Points in the same UI Flow, as long as each one is connected to a Web Screen.
112.
When you use a ComboBox widget...
a)
... you only need to either define the Variable or the Special Variable property.
b)
... you always need to specify a value in the Special List.
c)
... you must define the Special Variable property, if at least one value is defined in the Special List.
d)
... you always need to set the Variable property, if the Source Entity is specified.
113.
To use a Table Records, you are absolutely required to:
a)
Have a Preparation on the Screen or Web Block containing the Table Records.
b)
Specify a Source Record List with the data to be displayed to the user in the Table Record.
c)
Specify a Source Record to be displayed to the user in the Table Records.
d)
Enclose the Table Records in a named Container.
114.
In a Web app, what cannot be referenced from one Module to another Module?
a)
Session Variables.
b)
Web Blocks
c)
Server Actions.
d)
Static Entities.
115.
Consider the following Server Action, containing a Switch where the conditions are detailed on the connector.
a)
The Gender output value will be either “Female” or “Male”.
b)
The Gender output value is always “Unknown”.
c)
If the value of the GenderLetter is “M”, the Gender output value will be “Male”.
d)
If the value of GenderLetter is “Female”, the Gender output value will be “Female”.
116.
In a Switch statement, which comment is NOT CORRECT?
a)
The first branch that the condition evaluates to True is executed.
b)
If no branch evaluates to True, the Otherwise branch is executed.
c)
The Otherwise branch must exist.
d)
Every branch that evaluates to True is executed.
117.
Which of the following statement about Exception Handlers is true?
a)
An Action flow can only raise exceptions if it has at least one Exception Handlers.
b)
The Preparation cannot have Exception Handlers.
c)
In each Action flow, the most specific Exception Handler will be used to handle the Exception.
d)
It is not possible to have more than one Exception Handler per Action flow
118.
In Outsystems, the email and Phone Number ...
a)
... cannot be used as Session Variables data type.
b)
... can be used as an attribute data type, but not as a Screen input Parameter’s data type.
c)
... are basic data type.
d)
... cannot be used as a Static Entity attribute data type.
119.
Which of the following options is correct, regarding Session Variables in Outsystems?
a)
Session Variables value never expire and are kept in all requests from the same user.
b)
Session Variables can only be used after the user authenticates.
c)
Session Variables allow sharing data between different users.
d)
Session Variables values expire after the session timeout.
120.
Consider a Screen containing a Table Record, with an Aggregate as data source. To add the sort functionality to the Table Records, you have to...
a)
Add the List_SortColumn Web Block to each column of the Table Record, set the Column property with {Entity}.[Attribute], and define a Dynamic Sort in the Aggregate.
b)
Add the List_SortColumn Web Block to each column of the Table Record, set the Column property with {Entity}.{Attribute} and the Dynamic Sort is automatically added to the Aggregate.
c)
Add the List_SortColumn Web Block after the Table Records and select the Table Records in the ListWidgetId property of the List_SortColumn.
d)
Simply drop the List_SortColumn Web Block on each column and change the Aggregate to use the Block’s Output parameter.
121.
What do you need to do to ensure that only authenticated users (with a username and password) can access your application?
a)
Create a new Role in the Users application, change, its name to “Authenticated Users”, and check it on all Screens.
b)
Create a new Role in your application, change its name to “Authenticated Users”, and check it on all Screens.
c)
Uncheck the Anonymous role on all Screens.
d)
Check the Anonymous role on all Screens.
122.
A one-to-one relationship from Entity A to Entity B is created by ...
a)
... changing the Entity B identifier data type to <Entity A> Identifier.
b)
... changing the id attribute of Entity B to not be an auto-number and assigning a value to it programmatically, when creating a new record.
c)
... adding a new attribute to the Entity B with data type <Entity A> Identifier.
d)
... adding a new attribute to the Entity A with data type <Entity B> Identifier.
123.
Consider that you need to change the database of your application, with the respective Data Model in the following image, to include the types of Products. A Product can only have one type. Example of types are books, music, movies, electronics. You are told by the project manager that the Product types don’t change since last year. What is the best way to implement this change?
a)
Add an integer attribute, ProductType, to the Product Entity and set 1 for books, 2 for music, 3 for movies, 4 for electronics.
b)
Add a new Static Entity, ProductType, with 4 record, one of each type of Product. In addition, add an attribute to it of type Product Identifier.
c)
Add a Text attribute Product Type, to Product and set its values to “Books”, “Music”, “Movies”, “Electronics”.
d)
Add a new Static Entity, ProductType, with 4 records, one of each type of Product. In addition, add an attribute to Product of type ... ProductType Identifier.
124.
When using Server Side validations, to avoid storing invalid data (according to the application specification) in the Database...
a)
... you should check the Form’s Valid property to see if it is set to False, before storing the data.
b)
... you should add an Exception Handler to handle invalid user input.
c)
... you just need to ensure the “Save” Button’s Validation property is set to “Server”.
d)
... you just need to ensure the Form’s Validation property is set to “Server”.
125.
Select the correct option regarding Web Blocks.
a)
A Web Block can have its own Preparation.
b)
A Web Block can have Output Parameters.
c)
A Web Block can only be instantiated inside Web Screens.
d)
A Web Block can be nested inside itself
126.
In the Aggregate, we want filter the results to only return contacts that have “John” anywhere in their AccountName. To achieve this result, what is the correct expression to put in the Filter of the Aggregate?
a)
Contact.AccountName = “%john%”.
b)
Contact.AccountName like “%john%”.
c)
Contact.AccountName = “john”.
d)
Contact.AccountName like “john”.
127.
The Countdown Web Block has a StartScreen Action, as defined below. What is expected when you add this Web Block to a Web Screen?
a)
You only need to specify a Screen Action, to run when the Notify event occurs, if the Notify Action is set as mandatory.
b)
You only need to specify a Screen Action, to run when the Notify event occurs, if the Notify Action contains a message.
c)
You must specify a Screen Action to run when the Notify event occurs.
d)
You can optionally specify a Screen Action to run when the Notify event occurs.
128.
In Outsystems the Expression Widget...
a)
... cannot contain JavaScript code to be embedded in Web Pages.
b)
... can contain logic that is evaluated when performing server-side rendering.
c)
... cannot be used inside Link Widgets.
d)
... can only contain static content to display to users.
129.
Regarding Web Blocks in Outsystems, select to statement that is true
a)
You can instantiate Web Blocks on Web Screens and other Web Blocks.
b)
You can instantiate Web Blocks on Web Screens and external HTML pages, by adding a special html tag.
c)
You can instantiate Web Blocks on Screen Actions.
d)
You can instantiate Web Blocks only on Web Screens.
130.
Consider that you want to change your application Header, with new fonts, colors and an icon. What is the best approach to accomplish that in Outsystems?
a)
Change the Common/Header Web Block, by adding a Container with the new icon. Add the new CSS to the Module Theme’s Style Sheet.
b)
Add the new CSS to the Style Sheet of every Web Screens in the application, overriding the Style Sheet of the Common/Header Web Block Replace the Header_Logo with the new icon.
c)
Change the Style Sheet of the Common/Header Web Block, with the new CSS implemented and replace the Header_Logo with the new icon.
d)
Replace the Common/Header Web Block on every Web Screen with a new Web Block containing the new icon and CSS in its Style Sheet.
131.
Select the correct option regarding the Input Widget.
a)
All input widgets must be inside a Form widget.
b)
You don’t need to have a variable. The data typed by the user is saved in the Input widget itself.
c)
It can only be associated to variables of Text data type.
d)
You always need to have a variable to store the value typed by the user.
132.
Select the correct option regarding the output of an Aggregate.
a)
Return -1 if there are no results.
b)
Thrown an Exception when there are no results.
c)
Return Null when there are no results.
d)
Return a List that is empty when there are no results.
133.
Consider that a user navigates into a Web Screen then clicks on a Button, set with the Submit method and the following Screen Action as Destination. In this scenario, when does the Preparation run?
a)
When the user accesses the Web Screen, but not when clicks on the Button.
b)
When the user accesses the Web Screen and when the user clicks on the Button.
c)
Never.
d)
When user clicks on the Button.
134.
When deleting a record from an Entity, it deletes all records of an Entity with foreign key references. In this case, what the Delete Rule in use?
a)
Protect
b)
Delete
c)
Ignore
135.
In OutSystems, User Groups allow you to ...
a)
... create new user Sessions for multiple users at the same time.
b)
... assign the same password to multiple users at the same time.
c)
... grant the access to the same Screens to multiple users at the same time.
d)
... assign and revoke a Role to multiple users at the same time.
136.
Inside the Preparation of Web Screen, the Destination statement...
a)
... cannot be used.
b)
... allows redirecting the user to a different Web Screen, without rendering the current Screen.
c)
... renders the Current Screen and afterwards the users is redirected to the Destination Screen.
d)
... prompts the user before redirecting to the Destination Web Screen.
137.
Immediately after creating an Entity and its attributes, what is the expected behavior when using the Bootstrap Data From Excel?
a)
You cannot use the bootstrap data from Excel. You are required to Publish the module first.
b)
The bootstrap will try to automatically map the Entity attributes with the existing headers, in the first row of the Excel file.
c)
The bootstrap only works all attributes match exactly the headers on the first row of the Excel file. Otherwise you get an error...
d)
You cannot use the bootstrap data from Excel, because the structure of the Entity is already defined.
138.
A Screen Preparation...
a)
... requires at least one Input Parameter to filter the queries to the database.
b)
... does not have Output Parameters.
c)
... cannot execute other Server Actions.
d)
... is mandatory for every Web Screen.
139.
In Outsystems, the output parameters of a Consumed REST API Method cannot be mapped to...
a)
... an Entity.
b)
... an Aggregate.
c)
... a Structure.
d)
... a Basic Type.
140.
Select the correct option regarding Server Action.
a)
A Server Action can only have one Output Parameter. When more than one value needs to be returned, a Structure must be used ...
b)
A Server Action can return multiple values in different Output Parameters, but limited to the OutSystems basic types.
c)
A Server Action can only have one Output Parameter. To indicate if the action worked as expected or not, you should use an Exception.
d)
A Server Action can return multiple values in different Output Parameters, of any Outsystems data type
141.
In the image below, the UserMovieRating Entity is dragged into an Aggregate that already has a Movie Entity. Considering this scenario, which of the following statements is correct?
a)
A With or Without type of John will be created between the Movie and UserMovieRating Entities, if UserMovieRaing.MovieId is non mandatory.
b)
A With type of John will be created between the Movie and UserMovieRating Entities, If UserMovieRating.MovieId is mandatory.
c)
A With type of John will be created between the Movie and UserMovieRating Entities, If UserMovieRating.MovieId is non mandatory.
d)
An Only With type of John will be created between the Movie and UserMovieRating Entities, if UserMovieRating.MovieId is non mandatory.
142.
What is the best method to restrict to a part of a Web Screen for users with a specific MovieAdmin Role?
a)
Enclose that part in an If and use the Condition to check if the user has permission.
b)
Encapsulate that part in Web Block and change the Block’s Role properties, to only allow the MovieAdmin role.
c)
Enclose that part in a Container, and use the Enable property to hide the contents.
d)
Unlock all the Roles in the Screen, except for the MovieAdmin Role.
143.
When you create a new Web Screen, it has a Header, Menu and Footer by default because...
a)
.. all Screens are created that way even in Blank modules.
b)
... all Screens must have a Header, Menu and Footer,
c)
... it is built with a layout Web Block, that has placeholders for those Web Blocks.
d)
... all Screen have three Containers for those Web Blocks
100 %