C_HANAIMP_18 Exam Questions

What is a restricted measure?

Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?

Why would you create a multistore table?

Which of the following approaches might improve the performance of joins in a CUBE calculation view? Note: There are 2 correct answers to this question.

You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to build the...

Why would you use the Transparent Filter property in a calculation view?

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL Which of the following conditions must be met? Note: There are 2 correct answers to this quest...

Why do you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question.

After importing a project in the workspace of the SAP Web IDE, you execute a build at the HDB module level. The build fails. What could be the reason? Note: There are 2 correct ans...

What are the key steps to implement currency conversion in a calculation view?

In a calculation view, why would you choose the DEPRECATED setting? Note: There are 2 correct answers to this question.

You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, th...

Why would you enable Debug Query mode in a calculation view?

Which are the components of SAP HANA Cloud? Note: There are 3 correct answers to this question.

What are the consequences of NOT executing a delta merge? Note: There are 2 correct answers to this question.

Why should you define calculated column expressions using plain SQL and avoid using column engine language?

You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source...

Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

Which of the following supports data replication?

Which of the following data sources can you include in a graphical calculation view? Note: There are 2 correct answers to this question.

Why would you develop an SQL procedure instead of a function? Note: There are 3 correct answers to this question.

A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node. How many rows are in the outp...

You combine two tables in a join node using multiple columns in each table. Why do you enable the dynamic join option? Note: There are 2 correct answers to this question.

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes. What i...

Which tool generates and executes the SQL for a specific node of your calculation view?

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you. When you preview calculation view A, what data do you see?

Which of the following are capabilities of SAP HANA smart data access? Note: There are 2 correct answers to this question.

Why do you use the Hidden Columns checkbox in the semantics node of your calculation view? Note: There are 2 correct answers to this question.

What can you do with shared hierarchies? Note: There are 2 correct answers to this question.

You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?

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

You set the Null Handling property for an attribute but do not set a default value. What is displayed when null values are found in a column of data type NVARCHAR?

You are building a new calculation view A that uses calculation view B, as shown in the diagram. When you preview the calculation view A, the Account Number is not masked. What cou...

You are building a new calculation view B that uses calculation view A as a data source. In the Semantics node of calculation view A, you define a mask for the first 10 digits of a...

Which is the correct syntax when you refer to an input parameter in a calculation view expression?

In a calculation view, which object type do you assign to a projection node to consume a Predictive Analysis Library (PAL) function?

In SAP HANA Series Data, which of the following methods do you use to convert finer interval readings to a coarser interval?

You deleted the design-time file of a calculation view in your HDB module. What is the recommended way to ensure that the corresponding runtime object is also removed from the data...

How do you embed a decision tree in to your calculation view using a table function? Note: There are 2 correct answers to this question.

Which of the following results are generated when you query this temporal hierarchy using a time- validity period interval of March to May?

Why do you use a hierarchy function node in a calculation view?

When you create a full text index, why do you specify FAST_PREPROCESS OFF?

Why would you create SQL in calculation views?

What can you identify using Performance Analysis mode? Note: There are 2 correct answers to this question.

Which of the following are standard options provided to define analytic privileges? Note: There are 3 correct answers to this question.

You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?

You import a project that includes an SAP HANA database (HDB) module to your workspace. You need to create a calculation view that uses data from a table located in an external sch...

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 fo...

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned. What could be the problem? Note: There are 2 correct a...