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

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

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

QUESTION 50
Why would you create SQL in calculation views?

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
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 output of your query?

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

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

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

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

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

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

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

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

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

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

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

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

QUESTION 65
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. Afterward, you perform the following build operations:Build the dimension calculation view as a single object.Build the entire SAP HANA database module.What is the outcome of the build operations?

QUESTION 66
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 you check if pruning occurs?Note:
There are 2 correct answers to this question.

QUESTION 67
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 calculation views to a PROD environment, which sequence of steps is required in the DEV environment?

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

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

QUESTION 70
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 name appears only once in the results?