This app is an All-In-One package to provide everything to HANA Lovers.
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
You want to repeatedly load data from a flat file into SAP HANA with SAP Data Services. The target table is not available in SAP HANA and must be recreated with every scheduled data load. The structure of the target table is identical to the structure of the source table. Which of the following steps must you perform? Note: There are 3 correct answers to this question.
Enter the table name and schema name.
Import metadata of the target table from the SAP HANA datastore.
Drop a template table into the data flow.
Map the source structure to the template table.
Create a table in the SAP HANA studio.
What are characteristics of a constraint filter? Note: There are 2 correct answers to this question.
It is applied on a table before the query execution.
It is applied on the result set of an SQL query.
It is defined during the design time on a table.
It is defined during the runtime in the SQL query.
Which connection type is required from the SAP ERP system to SAP HANA to enable a CO-PA side-byside scenario? Please choose the correct answer
Secondary database connection
Remote Function Call
You want to create a customer segmentation on your SAP HANA data. Which of the following do you use? Please choose the correct answer.
SAP HANA Business Function Library
SAPUI5 runtime library
SAP HANA Predictive Analysis Library
Two attribute views in the same analytic view contain the same column name: the ID from the Customer attribute view and the ID from the Product attribute view. In the output, the system automatically renamed one column to ID_1. You want to indicate that ID_1 originated from the Product attribute view by renaming it to ID_PRODUCT. Where in the attribute properties of ID_1 can you change this? Note: There are 2 correct answers to this question.
In the alias label
In the label
In the alias name
In the name
You have a replicated an SAP ERP transaction table that contains a language field and a text table containing descriptions in various languages. You create an attribute view by joining these two tables using a text join. As which of the following join types does the text join act in this context? Please choose the correct answer.
Left outer join
Right outer join
Which of the following describe an SAP HANA attribute view? Note: There are 3 correct answers to this question.
It is a persistent store of data.
It is a reusable object in analytic views.
It is a copy of data after transformation.
It is a set of tables joined together.
It is a reusable object in calculation views.
Which CE function do you use to implement an inner join between two tables on a list of join attributes? Please choose the correct answer.
You have created several information models. A colleague has to create new tables in the existing schema and extend your information models. Which privileges do you give to your colleague? Note: There are 2 correct answers to this question.