Online Access Free C_HANAIMP_15 Practice Test

Why do you use the query debug mode in a calculation view?

• A.To observe the generated SQL for each node
• B.To check which database engines will be involved by each node
• C.To measure the overall run-time of the query
• D.To check if SAP HANA can parallelize the entire query

You are building a cube calculation view with an aggregation node that calculates total sales, based on the data shown in the graphic.
The price may vary based on SHIRT_ID and PROMO_LEVEL only. The calculation is Total Sales = PRICE * QUANTITY.
How do you ensure accurate results, regardless of the column in the query output?

• A.Set the Transparent Filter property for STATE
• B.Set the Dynamic Partition flag for SHIRT_ID and PROMO_LEVEL
• C.Set the Keep Flag property for both SHIRT_ID and PROMO_LEVEL
• D.Set STATE as an aggregated column.

You join two tables using a referential join and set the cardinality to 1..n. What type of join is executed at runtime if your query does NOT request columns from the right table?

• A.Left outer join
• B.Right outer join
• C.Inner join
• D.Full outer join

Refering to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation View?

• A.SELECT Privileges and Analytics Privileges on both views
• B.A SELECT privilege on the CUBE and an analytic Privilege (Country = United States) on the DIMENSION Calculation View
• C.A SELECT Privilege and an Analytic Privileges
• D.Analytic Privileges and SELECT Privileges on the CUBE Calculation View

How can you define a variable that presents its value help hierarchically? 2 correctas

• A.Create a parent-child hierarchy and assign it to the variable
  Ensure the variables reference column is the parent attribute of the hierarch
• B.Create a level hierarchy and assign it to the variable
  Ensure the variables reference column is the leaf level of the hierarchy
• C.Create a parent-child hierarchy and assign it to the variable
  Ensure the variables reference column is the child attribute of the hierarchy
• D.Create a level hierarchy and assign it to the variable
  Ensure the variables references column is the top level of the hierarchy