C-HANAIMP131 무료 덤프문제 온라인 액세스

What is the functionality of an aggregation node in a calculation view?(Choose two)

• A.It calculates the sum, minimum, or maximum values for selected columns
• B.It provides deeper control over which columns are totaled
• C.It provides grouping of filter criteria
• D.It determines the output structure of the calculation view

You want to enable the end user to decide at runtime how to restrict the data in an information model.
Which of the following objects do you use?

• A.Restricted measure
• B.Input parameter
• C.Variable
• D.Filter

You have been asked to create an SAP HANA attribute view using the tables Employee (left table) and Department (right table) shown in the attached diagram.

Your view should contain the columns NAME and D_Name for all employees.
Which of the following join types do you use?

• A.Text join
• B.Referential join
• C.Left outer join
• D.Inner join

You need to create an SAP HANA data model based on a star schema. Which SAP HANA engine is recommended for analytical purposes?

• A.Calculation engine
• B.OLAP engine
• C.Row store engine
• D.Join engine

In a calculation view you define a calculated column and set the Calculate Before Aggregation flag.
Which of the following activities is mandatory to activate the view?

• A.Mark the column as hidden
• B.Add a new aggregation node
• C.Select the aggregation type
• D.Set the column type to Attribute