In which type of node can you create calculated columns? (There are 2 correct answers.) Rank node Union node Join node Projection node. You want to build a hierarchy on a time-based data structure. What type of hierarchy do you use? Parent-child hierarchy Level hierarchy Ragged hierarchy Unbalanced hierarchy. Which are features of a calculated column? (There are 2 correct answers.) It is a column in the result set Its calculations are persisted It is created in the output area It is created in the semantics node. You want to show a male and female option to users. What feature do you use? (There are 3 correct answers.) Domain fix values Value help Variables Expressions Input parameters. You are creating a currency conversion. What options do you have for the
Target Currency field? (There are 3 correct answers.) Select a fixed currency Select a column Use the Derived from Table option Use an input parameter Select a table type. What can you use as data sources for a decision table? (There are 2 correct answers.) Table types Scalar functions CDS views Calculation views. Where do you create a variable? In the context menu of a package In the semantics node In the output area of a join node In the scenario area of an aggregate node. You have logs from a website. How do you show the total number of website
visitors that used a mobile phone? (There are 2 correct answers.) Create a restricted column Create an action Create a filter expression Create a rank column. Which can a level hierarchy do? Have time-dependency Be used for a bill of materials structure Enable drill-down in a value help list Show variable deepness in the data. What can a variable be used for? Currency conversion Calculated column expression Call decision table in SQLScript Filtering. You are working with a currency measure. What is decimal shift used for? Increase the accuracy of the currency conversion To undo the decimal adjustment for ABAP For currencies with more than two decimal places Avoid rounding errors during the conversion. What variable type do you use if you want to allow the user to choose dates
from 2011 to 2014? Single value Interval Range Multiple entries. What do you create to find the number of unique items sold per shop? A calculation view with a restricted column in an aggregation node A calculation view with a counter in a projection node A calculation view with a counter in an aggregation node An analytic view with a calculated column in an star join node. What artifacts do you use in the output area of a decision table node? (There
are 2 correct answers.) Input parameters Restrictions Actions Conditions. What can you use to limit the number of records produced by a calculation
view? (There are 3 correct answers.) SAP client restrictions Domain fix values Filter expressions Restricted columns Generated columns. You created a calculated column in an analytic view for a table containing
the number of units ordered, the price per unit, and the number of units in
stock. You get the wrong results in your results. What could be the problem? You mistyped the calculated column expression You chose the SQL expression syntax You did NOT enable calculate before aggregation You did NOT enable the currency conversion. Where can you create a filter expression? In an aggregation node In a data foundation node In a projection node In the semantics node. The company’s board members want to run simulations on the year-end
financial data. What do you use to build this for them? A parent-child hierarchy A variable An expression A decision table. Which tables do you need for currency conversion? DD07* TCUR* BICS* SHINE*. You build a financial report for the company’s board members that allows
them to choose if they want the report to be in euros or dollars. What do
you use? An input parameter from an aggregation node A variable from the semantics node A variable from a projection node An input parameter from the semantics node. What type of input parameters do you use to choose the data from a field in
the current table? Direct Derived from table Value help Column.
