Category C-HANAIMP-18

NO.45 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?

NO.46 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?

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

NO.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?

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

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

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

NO.52 Why would you implement active / active read-enabled mode?

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

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

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

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

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

NO.58 Why would you create a multistore table?

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

NO.60 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.

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

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