Following quiz provides Multiple Choice Questions (MCQs) related to SAP HANA. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
Q 1 - In SAP HANA Data replication, replicating data from a table in ECC system to HANA database, target table should have?
Target table should have same columns and data types otherwise you can use a new template table option.
Q 2 - Which of the below statement is true about Union and Union All set operators?
UNION is used to combine the results of two or more Select statements. However it will eliminate duplicate rows
This operation is similar to Union. But it also shows the duplicate rows.
Q 3 - In SAP HANA Modeling, which of the view type provides Modeler with an inbuilt nodes-Projection, Join, Union and Rank?
Graphical Calculation Views
Can consume other Analytical, Attribute, other Calculation Views & tables Built-in Union, Join, Projection & Aggregation nodes
Q 4 - Which of the below is used to handle queries and manipulates multidimensional data stored in OLAP cubes?
HANA can act as both relational as well as OLAP. When we use BW on HANA then we create cubes in BW and HANA will act as relational database and it will always produce a SQL Statement but when we directly access HANA views using OLAP connection then it will act as OLAP and MDX will be generated.
Q 5 - In SAP Data Services to replicate the data from SAP ECC to HANA database, which data store type should be used to create a data store for ECC and HANA system?
For ECC system, use SAP Applications while creating a datastore.
For SAP HANA, use Database as store type while creating a data store.
Q 6 - You have create a Universe on the top of HANA database to create reports in Web Intelligence. Which of the connection type can be used to publish Universe in Repository?
.cns- connection type represents secured Repository connection that should be used to create Data foundation.
.cnx-represents local unsecured connection and if you use this connection while creating a Universe and while publishing Universe it will not allow you to publish that to repository.
Q 7 - While creating a SAP HANA Modeling view, which user parameter allows you to add a new field in the Data Preview that doesn’t exist in database or view level?
Calculated column allows you to add a column at report level that doesn’t exist in database or view level.
Q 8 - Which of the below is not an audit trial type while configuring an audit policy in HANA system?
Syslog(default) − Logging system of Linux Operating System.
Database Table − Internal database table, user who has Audit admin or Audit operator system privilege he can only run select operation on this table.
CSV text − This type of audit trail is only used for test purpose in a non-production environment.
Q 9 - Which of the below option can be used to check the configuration, current alerts, all services running and manufacturer details in HANA system?
Administration tab is used to get all the details- about manufacturer, services running, alerts, performance, volumes, etc.
Q 10 - In SAP HANA Modeling, If a view is not activated how do you identify this by looking at the name of the view in package?