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

In a calculation view, why would you choose the DEPRECATED setting? Note: There are 2 correct answers to this question.A . To ensure it is not exposed to reporting tools for consumption B. To indicate that it should not be used as a data source to other calculation views C....

July 13, 2023 No Comments READ MORE +

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.

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.A . To prevent passing columns in stacked calculation views B. To ensure specific columns are NOT exposed to the reporting tool C. To remove a...

July 13, 2023 No Comments READ MORE +

Which calendar types can be selected when creating time-based DIMENSIONS?

Which calendar types can be selected when creating time-based DIMENSIONS? Note: There are 2 correct answers to this question.A . Fiscal B. Julian C. Gregorian D. FactoryView AnswerAnswer: A,C

July 13, 2023 No Comments READ MORE +

In a database module, what is the purpose of the .hdiconfig file?

In a database module, what is the purpose of the .hdiconfig file?A . To specify an external schema in which calculation views will get their data B. To specify which HDI plug-ins are available C. To specify in which space the container should be deployed D. To specify the namespace...

July 12, 2023 No Comments READ MORE +

Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud?

Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud? Note: There are 2 correct answers to this question.A . Pre-calculated aggregates B. Indexes C. Stored procedures D. Table partitionsView AnswerAnswer: A,B

July 11, 2023 No Comments READ MORE +

What options do you have to handle orphan nodes in your hierarchy?

What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.A . Define an expression to determine a parent. B. Generate additional root nodes. C. Assign them to a level below the root. D. Assign them to a node at...

July 11, 2023 No Comments READ MORE +

Which of the following conditions must be met?

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 question.A . The hierarchy must be exposed by a calculation view of type CUBE with star join. B....

July 10, 2023 No Comments READ MORE +

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?

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?A . 7 months B. 3 months C. 2 weeks D. 1...

July 9, 2023 No Comments READ MORE +

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

Why would you choose an HDI-shared service plan instead of a schema service plan? Note: There are 3 correct answers to this question.A . You want to use SAP Business Application Studio. B. You want to use containers to isolate objects. C. You want to develop calculation views. D. You...

July 8, 2023 No Comments READ MORE +

What is the optimal way to do this?

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?A . Use a union node. B. Use an intersect node. C. Use an aggregation node. D. Use a minus...

July 7, 2023 No Comments READ MORE +