OutSystem Associate Exam Questions and Answers 100% Solved| Latest Update Graded A+
Considering the following Aggregate, where the Orders are fetched with their reviewers
(Employees), which of the following options is correct?
A) The Aggregate returns Orders with Priority and with zero or more Employees
B) The Aggregate returns Orders with Status and at least one Employee
C) The Aggregate returns Orders without Employee and without Status
D) The Aggregate only returns Orders with Priority, Status and Employee A)
Consider the Action called Absolute which returns an absolute value (abs) of a number N
passed as Input Parameter. When does the Action return 0 ?
A) When the input parameter (N) is zero
B) When the input parameter (N) is less than zero
C) When the input parameter (N) is greater than zero
D) Never A)
David bought a bunch of products with a 10% discount. What would be the best way of
calculating the price with the discount?
A) Create a calculated attribute ProductWithDiscount with the expression: OrderItem.TotalPrice
- (OrderItem.TotalPrice * 0.1)
B) This is not possible to do with an Aggregate. Use an SQL instead
C) Create a calculated attribute ProductWithDiscount with the expression: Product.Price -
(Product.Price * 0.1)
D) Use a For Each to cycle through each order item and calculate the price with the discount
C)
The following Screen has two Dropdowns, one to select a Country and one to select a City. The
GetCountries and GetCities Aggregates provide the countries and the cities to be displayed in
the respective dropdowns and are both set to be fetched At Start. Which of the following
,options is not a valid step if we want to just fetch the cities for the country selected in the
respective dropdown?
A) Set the Fetch property of the GetCities Aggregate to Only On Demand
B) Call the GetCities Aggregate in the GetCountries' On After Fetch Event handler
C) Refresh the GetCities Aggregate in the OnChange Action of the Country Dropdown
D) Filter the GetCities Aggregate by the selected country A)
Consider the following Block, where the OnClickAction Action is set as the OnClick Event
handler for a Button inside MyBlock. Taking into account this scenario, select the correct
option.
A) If no Event handler is defined for MyEvent, the trigger Event statement will throw an error at
runtime
B) The Event handler for MyEvent must be defined when instantiating MyBlock
C) The Event handler for MyEvent must be defined in MyBlock properties
D) The Event handler for MyEvent does not need to be defined, as the OnClick Event handler
will handle MyEvent as well D)
When I want to sort the results in an Aggregate ...
A) ... I need to add an input parameter to the Aggregate
B) ... I can do it by selecting the attribute by which I want to sort as long as no filter exists for
that attribute
C) ... I can do it simply by right-clicking that attribute and choosing between ascending or
descending order
D) ... I need to write a Dynamic Sort expression C)
Business concepts that need to be stored and accessed in our applications should be modelled
as...
A) Entities
,B) Entity diagrams
C) Entity relationships
D) Database tables A)
Consider the following Action, which calculates the square root (sqrt) of a positive decimal
number (N). Knowing that the function was called with N = 0, and the debugger is stopped at
the Start node, what will happen when the developer selects the Continue (F9) option
highlighted in the picture?
A) The Action will end, with sqrt = 0
B) The debugger will stop in the N < 0 If node
C) The Action will throw an exception and sqrt will have no value
D) The debugger will stop at the breakpoint in the End node D)
A developer should favour using a Structure instead of the Entity in the output of a SELECT SQL
Query. Do you agree with this statement?
A) Yes, because queries become easier to maintain
B) Yes, because queries will retrieve fewer Attributes and less data
C) No, since it is exactly the same
D) No, it is preferable to use the Entity instead of the Structure A)
Considering the following Aggregate, what will be the attributes of the
GetOrdersShippingState.List.Current record?
A) The two aggregation attributes (ShippingState and Count) plus all the attributes of the
Source Entity
B) Six attributes corresponding to the six visible columns in the Aggregate: ShippingState,
Count, Description, DueDate, CreatedOn and Priority
C) The two aggregation attributes: ShippingState and Count
, D) The two aggregation attributes (ShippingState and Count) plus the columns used to calculate
these aggregations C)
Considering the following Entities, what is required to create a many-to-many relationship
between them?
A) Create a third Entity that contains two attributes of types Order Identifier and Product
Identifier
B) Create an attribute of type Product Identifier in the Order Entity
C) Create an attribute of type Order Identifier in the Product Entity and an attribute of type
Product Identifier in the Order Entity
D) Create a third Entity with a primary key of type Order Identifier and an attribute of type
Product Identifier A)
Consider the following Pagination that is associated with an already implemented Table on a
Screen. There are no errors in Service Studio, but when the user selects a new page (in the
pagination widget) the results do not change on the Table. What is the reason for that
behaviour?
A) The GetMovies Aggregate is not being refreshed in the OnNavigate Action
B) The Max Records property of the Pagination should be set to GetMovies.Count and the
TotalCount to RecordsPerPage
C) The Table is not being refreshed on the OnNavigate Action
D) The Max. Records of the Aggregate should be equal to the total number of movies in the
database A)
Regarding Blocks in OutSystems reactive apps, which of the following options is correct?
A) Blocks can only be instantiated on Screens
B) Blocks can be instantiated on Client Actions on the Screen
C) Blocks can be instantiated on Screens and other Blocks
Considering the following Aggregate, where the Orders are fetched with their reviewers
(Employees), which of the following options is correct?
A) The Aggregate returns Orders with Priority and with zero or more Employees
B) The Aggregate returns Orders with Status and at least one Employee
C) The Aggregate returns Orders without Employee and without Status
D) The Aggregate only returns Orders with Priority, Status and Employee A)
Consider the Action called Absolute which returns an absolute value (abs) of a number N
passed as Input Parameter. When does the Action return 0 ?
A) When the input parameter (N) is zero
B) When the input parameter (N) is less than zero
C) When the input parameter (N) is greater than zero
D) Never A)
David bought a bunch of products with a 10% discount. What would be the best way of
calculating the price with the discount?
A) Create a calculated attribute ProductWithDiscount with the expression: OrderItem.TotalPrice
- (OrderItem.TotalPrice * 0.1)
B) This is not possible to do with an Aggregate. Use an SQL instead
C) Create a calculated attribute ProductWithDiscount with the expression: Product.Price -
(Product.Price * 0.1)
D) Use a For Each to cycle through each order item and calculate the price with the discount
C)
The following Screen has two Dropdowns, one to select a Country and one to select a City. The
GetCountries and GetCities Aggregates provide the countries and the cities to be displayed in
the respective dropdowns and are both set to be fetched At Start. Which of the following
,options is not a valid step if we want to just fetch the cities for the country selected in the
respective dropdown?
A) Set the Fetch property of the GetCities Aggregate to Only On Demand
B) Call the GetCities Aggregate in the GetCountries' On After Fetch Event handler
C) Refresh the GetCities Aggregate in the OnChange Action of the Country Dropdown
D) Filter the GetCities Aggregate by the selected country A)
Consider the following Block, where the OnClickAction Action is set as the OnClick Event
handler for a Button inside MyBlock. Taking into account this scenario, select the correct
option.
A) If no Event handler is defined for MyEvent, the trigger Event statement will throw an error at
runtime
B) The Event handler for MyEvent must be defined when instantiating MyBlock
C) The Event handler for MyEvent must be defined in MyBlock properties
D) The Event handler for MyEvent does not need to be defined, as the OnClick Event handler
will handle MyEvent as well D)
When I want to sort the results in an Aggregate ...
A) ... I need to add an input parameter to the Aggregate
B) ... I can do it by selecting the attribute by which I want to sort as long as no filter exists for
that attribute
C) ... I can do it simply by right-clicking that attribute and choosing between ascending or
descending order
D) ... I need to write a Dynamic Sort expression C)
Business concepts that need to be stored and accessed in our applications should be modelled
as...
A) Entities
,B) Entity diagrams
C) Entity relationships
D) Database tables A)
Consider the following Action, which calculates the square root (sqrt) of a positive decimal
number (N). Knowing that the function was called with N = 0, and the debugger is stopped at
the Start node, what will happen when the developer selects the Continue (F9) option
highlighted in the picture?
A) The Action will end, with sqrt = 0
B) The debugger will stop in the N < 0 If node
C) The Action will throw an exception and sqrt will have no value
D) The debugger will stop at the breakpoint in the End node D)
A developer should favour using a Structure instead of the Entity in the output of a SELECT SQL
Query. Do you agree with this statement?
A) Yes, because queries become easier to maintain
B) Yes, because queries will retrieve fewer Attributes and less data
C) No, since it is exactly the same
D) No, it is preferable to use the Entity instead of the Structure A)
Considering the following Aggregate, what will be the attributes of the
GetOrdersShippingState.List.Current record?
A) The two aggregation attributes (ShippingState and Count) plus all the attributes of the
Source Entity
B) Six attributes corresponding to the six visible columns in the Aggregate: ShippingState,
Count, Description, DueDate, CreatedOn and Priority
C) The two aggregation attributes: ShippingState and Count
, D) The two aggregation attributes (ShippingState and Count) plus the columns used to calculate
these aggregations C)
Considering the following Entities, what is required to create a many-to-many relationship
between them?
A) Create a third Entity that contains two attributes of types Order Identifier and Product
Identifier
B) Create an attribute of type Product Identifier in the Order Entity
C) Create an attribute of type Order Identifier in the Product Entity and an attribute of type
Product Identifier in the Order Entity
D) Create a third Entity with a primary key of type Order Identifier and an attribute of type
Product Identifier A)
Consider the following Pagination that is associated with an already implemented Table on a
Screen. There are no errors in Service Studio, but when the user selects a new page (in the
pagination widget) the results do not change on the Table. What is the reason for that
behaviour?
A) The GetMovies Aggregate is not being refreshed in the OnNavigate Action
B) The Max Records property of the Pagination should be set to GetMovies.Count and the
TotalCount to RecordsPerPage
C) The Table is not being refreshed on the OnNavigate Action
D) The Max. Records of the Aggregate should be equal to the total number of movies in the
database A)
Regarding Blocks in OutSystems reactive apps, which of the following options is correct?
A) Blocks can only be instantiated on Screens
B) Blocks can be instantiated on Client Actions on the Screen
C) Blocks can be instantiated on Screens and other Blocks
