C_HANAIMP_18 Exam Questions

What do you use a hierarchy function for? Note: There are 3 correct answers.

Why do we support SQL development in SAP HANA data modeling projects?

You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views all belong to the same project. Before deploying your c...

You want to join two tables in a calculation view. Why do you use a non-equi join?

Your calculation view consumes one data source, which includes the following columns: SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE. In the output, you want to see summarized data...

In an XS Advanced project, what is the purpose of the .hdiconfig file?

What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question.

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name. How do you ensure that each customer na...

What does SAP HANA provide to support full stack native application development? Note: There are 2 correct answers to this question.

Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output from the screenshot?

In your calculation view, you want to consume a custom data source defined using SQLScript. In which type of object do you write your code?

You have configured static cache for your calculation view and run a query against it, but the cache results are not being used. What might be the reason for this?

Which options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.

Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.

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

How can you define a variable that presents its value help hierarchically? Note: There are 2 correct answers to this question.

Which of the following techniques can you use to improve the performance of calculation views? Note: There are 2 correct answers to this question.

Which of the following are usually not required In the data model of SAP S/4HANA? Note: There are 2 correct answers to this question.

What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.

What is the SQL keyword used to process input parameters defined in a calculation view?

Which type of join supports a temporal condition in a calculation view?

Which of the following are warm data tier solutions? Note: There are 3 correct answers to this question.

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deploymen...

Why would you implement active / active read-enabled mode?

What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afte...

You have generated a calculation view properties file. What does it contain?

What are the limitations of using a full outer join in a star join node? Note: There are 2 correct answers to this question.

Which calendar types can be selected when creating time-based DIMENSIONS? Note: There are 2 correct answers to this question.

Why would you build a calculation view of type SQL Access only?

You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources. How do yo...

You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns. What is the recommended approach for verifyi...

Why might you use the Keep Flag property in an aggregation node?

What are possible consequences of unfolding? Note: There are 2 correct answers to this question.

Why do we use Git when modeling calculation views? Note: There are 2 correct answers to this question.

A calculation view consumes the data sources shown in the graphic. You want to identify which companies sold products in January AND February. What is the optimal way to do this?

Why do you create calculation views of data category DIMENSION with type TIME?

What is generated when you deploy a CUBE calculation view design-time file? Note: There are 2 correct answers to this question.

When modeling in the SAP Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?