Exam for engine

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

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

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

QUESTION 36
Which solutions form the SAP Business Technology Platform? Note: There are 2 correct answers to this question.

QUESTION 37
You create a user-provided service to access tables in external schemas.In which file type do you assign the user-provided service to your database module?

QUESTION 38
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 39
What is a restricted measure?

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

QUESTION 41
What are some of the typical roles in an SAP HANA Cloud implementation?Note: There are 2 correct answers to this question.

QUESTION 42
Why would an SQL developer work with SQLScript?Note: There are 3 correct answers to this question.

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

QUESTION 44
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 45
A new version of SAP HANA Cloud, SAP HANA database is available from today.If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version?

QUESTION 46
Using the table in the diagram, you need to create a CUBE calculation view.

What is the simplest approach to create the output shown in the screenshot?

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

QUESTION 48
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 by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

QUESTION 49
You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

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

QUESTION 51
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 is the correct approach?

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

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

QUESTION 54
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 deploy the calculation view, the deployment fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

QUESTION 55
Why would you choose an HDI-shared service plan instead of a schema service plan?Note: There are 3 correct answers to this question.

QUESTION 56
Why would you create calculation views of data category DIMENSION with type TIME?

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