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

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

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

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

QUESTION 46
Why would you set the “Ignore multiple outputs for filters” property in a calculation view?

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

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

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

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

QUESTION 51
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 could be the reason?

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

QUESTION 53
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 answers to this question.

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

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

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

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

QUESTION 58
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 schema within the same local database.Which of the following items do you need?Note: There are 2 correct answers to this question.

QUESTION 59
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 to a calculation view and try to build it.What do you observe in the SAP HANA database container?

QUESTION 60
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 deployment of the table function fails.Which of the following could be a valid reason?

QUESTION 61
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, the input parameters of calculation view B are not proposed as source parameters.What might be the reason for this?

QUESTION 62
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?

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

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

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