You want to use a UNION to combine two information objects in a calculation view. Which steps do you have to perform?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Define the mapping of columns of the information objects B. Define a constant column in the target C. Sort the columns in the output structure D. Connect the information objects to the UNION node. Hybrid Data Management System – Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system?
There are 3 correct answers to this question.
Seleccione una o más de una: A. Linguistic search capabilities B. Built-in support for planning C. Text analysis and search D. Text indexing capabilities E. Traditional disk-based tables. You have defined the following SQLScript procedure:
CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA
Which type of database procedures can be called in this SQLScript procedure?
Please choose the correct answer.
Seleccione una: A. Read-write B. Read only C. Write only D. Read-update. You want to run a report on data with multiple currencies. You want to allow end users to select thetarget currency at runtime. Which options does SAP recommend for defining the currency conversion?
There are 2 correct answers to this question.
Seleccione una o más de una: A. A CE_CONVERSION function in a calculation view B. Currency conversion during data load C. A calculated column in an analytic view D. Measures enabled for conversion in an analytic view. In which of the following situations could a row store table be more suitable than a column store table?
There are 2 correct answers to this question.
Seleccione una o más de una: A. The table contains mainly distinct values per column across rows. B. The table contains text that you want to search. C. The table contains only a small number of records. D. The table contains data that you want to aggregate. In which of the following situations could a row store table be more suitable than a column store table?
There are 2 correct answers to this question.
Seleccione una o más de una: A. The table contains mainly distinct values per column across rows. B. The table contains text that you want to search. C. The table contains data that you want to aggregate. D. The table contains only a small number of records. What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Product-based Profitability B. Service-based profitability C. Costing-based Profitability D. Account-based Profitability. Explain how and when to create calculated columns - Using Graphical Modeling Tools?
There are 3 correct answers to this question
Seleccione una o más de una: A. Time characteristics based calculation columns. B. Calculated columns also support non-measure attributes as part of the calculation. C. The calculation could be an arithmetic or character manipulation D. The calculation will be opened in a read-only mode. E. It is possible to nest so that one calculated column, in turn, is based on other calculated columns. Discuss the conditions required to ensure the Referential Integrity?
There are 2 correct answers to this question.
Seleccione una o más de una: A. There is at least one join in the other table B. There are two joins in the able C. Referential integrity holds true in both the directions D. There are three joins in the table. What are the benefits associated with The SAP HANA real-time Operational analytics?
There are 2 correct answers to this question
Seleccione una o más de una: A. Fast insights into business activity B. Query Speed support C. Simplification of massive data D. High modeling flexibility. What are the components of The Enterprise Procurement Model Demo Scenario?
There are 3 correct answers to this question.
Seleccione una o más de una: A. Product B. Procurement C. Sales D. Services E. Stock. Which of the following is not an element of Analytical view?
Please choose the correct answer.
Seleccione una: A. Currency conversion is not applicable B. Read Data from the joined database tables C. Used to Joined table D. Join fact tables. When would you use a column store table instead of a row store table?
There are 2 correct answers to this question.
Seleccione una o más de una: A. When you require aggregation and analysis of values B. When there are mainly distinct values in the table C. When the table has a small number of records D. When you want to enable a full-text search of the table. You have created a graphical calculation view with a large number of columns. Which of the following do you use to ensure that only required columns are shown when querying the created view?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Function CE_PROJECTION B. The Type selection in the semantics area C. Projection nodes D. The Hidden checkbox in the semantics area. An Analytic Privilege consists of several restrictions. What are they?
There 3 correct answers to this question.
Seleccione una o más de una: A. Validity restrictions B. View restrictions C. Cube restrictions D. Activity restrictions E. Analytic restrictions. DB-Specific Properties that allows switching between storage types when running on an SAP HANAdatabase. What are these storage types?
There are 2 correct answers to this question.
Seleccione una o más de una: A. Re-use component store B. Development Store C. Column store D. Row store E. Technology store. You have a table of transactional data with different transaction types. You want to create an analyticview for only one of the transaction types. How can you ensure that only rows with the requiredtransaction type are displayed in the analytic view?
Please choose the correct answer.
Seleccione una: A. Create a filter on the table B. Create an input parameter C. Create a restricted column D. Create a calculated column. When are referential joins executed in analytical views?
Choose the correct answer.
Seleccione una: A. When fields are selected B. When all the tables are optimized C. When fields from both the tables are requested D. When fields are optimized. Explain The Authorization Concept and the types of privileges associated with it?
There are 3 correct answers to this question.
Seleccione una o más de una: A. Analytic privileges B. System privileges C. Application privileges D. Delta privileges E. Object privileges.
