Online Access Free C_HANAIMP_16 Practice Test

What does a graph neighborhood search reveal?

• A.Edges that contain the same attributes
• B.Shortest path between vertices
• C.Vertices that contain the same attributes
• D.Vertices that are closely connected

What do you use in the definition of a dynamic SQL analytic privilege?

• A.A table function that returns a list of allowed values.
• B.A scalar function that returns a list of the allowed values for each attribute.
• C.An organization hierarchy that provides role-based access to data.
• D.A procedure that returns the data access condition as an SQL expression.

In a calculation view, what is the purpose of a variable?

• A.To provide a run-time attribute filter based on a user input
• B.To pass values between procedures and calculation views
• C.To break up complex SQL into smaller steps
• D.To provide a dynamic value in a calculated column

You have a cube calculation view that consumes a dimension view. You suspect some dimension columns have been renamed in the cube calculation view. Which function of SAP Web IDE for SAP HANA do you use to check where the output columns originate from?

• A.Auto-map byname
• B.Database Explorer
• C.Where used
• D.Show lineage

You are querying a calculation view based on the union node, as shown in the graphic. When would the value of the Empty Union Behavior property take effect?
Note: There are 2 correct answers to this question.

• A.When the query requests PRODUCT_GROUP
• B.When the query requests only the PRODUCT_ID
• C.When Source A has no records
• D.When the query requests PRODUCT_GROUP and PRODUCT_ID