Explore topic-wise InterviewSolutions in .

BAU stands for___________
Choose the CORRECT OPTION from below LIST
(1)Business And Usual
(2)Business At Usual
(3)Business As Usual

Answer:-(3)Business As Usual

Can SAP HANA database be used by any application, other than SAP?
Choose the CORRECT OPTION from below LIST
(1)Yes
(2)No

Answer:-(2)No

Which perspective is USED to create joins?
CHOOSE the correct option from below LIST
(1)Administration & Modeling
(2)Debug & MODELLING
(3)Modeler
(4)All of the above

Answer:-(3)Modeler

How many perspectives are AVAILABLE in SAP HANA Studio (SPS03)?
Choose the CORRECT option from below LIST
(1)4
(2)8
(3)9
(4)10

Answer:-(2)8

If you WANT to create or drop tables in a schema, which privilege type do you need?
Choose the correct option from below LIST
(1)SYSTEM
(2)ANALYTIC
(3)PACKAGE
(4)SQL

Answer:-(4)SQL

How can you evaluate the speed of a calculation within the database?
Choose the correct option from below LIST
(1)Use the Data Preview function in the SAP HANA studio.
(2)Execute a Web Intelligence report and check the duration of the PREVIOUS refresh.
(3)Execute an INFORMATION space using SAP Business OBJECTS Explorer.
(4)Write and execute an appropriate SQL statement.

Answer:-(1) and (4)

What BI standards does HANA support?
CHOOSE the correct OPTION from below list
(1)ODBC
(2)JDBC
(3)MDX
(4)MIME

Answer:-(1),(2) and (3)

Select the PROPERTIES of a derived attribute view can you modify?
Choose the CORRECT option from below list
(1)DESCRIPTION
(2)Description MAPPING
(3)Calculated attributes
(4)Filters

Answer:-(1)Description

Which ONE of the FOLLOWING is NOT a part of Index Server?
Choose the CORRECT option from below list
(1)Planning engine
(2)Calc engine
(3)Name server
(4)PERSISTENCE layer

Answer:-(3)Name server

Select the key benefits of using SAP BUSINESSOBJECTS Explorer with SAP HANA?
Choose the correct OPTION from below list
(1)You do not NEED to create your own queries to access information.
(2)You can easily create your own queries to access information.
(3)You can access information for data discovery intuitively.
(4)You can execute ad-hoc business analytics quickly.
(5)You can easily create an IDT business layer.

Answer:-(1),(3) and (4)

What in column storage STORES uncommitted data in SAP HANA?
Choose the correct option from below LIST
(1)Main storage
(2)L1 Delta BUFFER store
(3)L2 Delta buffer
(4)Persistence layer

Answer:-(2)L1 Delta buffer store

The 4 phases of AGILE Project MANAGEMENT methodology are_________
Choose the correct option from below list
(1)Define, DEVELOP, Release, Evaluate
(2)Define, Develop, Evaluate, Release
(3)Define, Evaluate, Release, Develop
(4)Evaluate, Define, Release, Develop

Answer:-(1)Define, Develop, Release, Evaluate

In SAP HANA Savepoints are associated with?
CHOOSE the correct option from below LIST
(1)Persistence layer
(2)SQL Processor
(3)Metadata manager
(4)Planning engine

Answer:-(1)Persistence layer

Which of the following STATEMENTS are TRUE in term SAP HANA?
Choose the correct option from below list
(1)One table may APPEAR in exactly one SCHEMA
(2)It is possible to grant authorizations on a table level.
(3)Authorizations granted on a schema are automatically propagated to all objects within the schema

Answer:-(3)Authorizations granted on a schema are automatically propagated to all objects within the schema

Which of the following statements are true in SAP HANA?
Choose the correct option from below list
(1)There are four types of information views: attribute VIEW, analytic view, hierarchy view and calculation view. All these views are non-materialized views.
(2)An analytic view is USED to model data that includes measures.
(3)Calculated attributes are derived from one or more EXISTING attributes or constants.
(4)Calculation views can INCLUDE measures and be used for multidimensional reporting or can contain no measures and used for list-type of reporting

Answer:-(4)Calculation views can include measures and be used for multidimensional reporting or can contain no measures and used for list-type of reporting

SAP HANA supports which of below hierarchies?
CHOOSE the CORRECT OPTION from below list
(1)TIME Based hierarchies
(2)Level hierarchies
(3)Parent/Child hierarchies
(4)Matrix Organization hierarchies

Answer:-(2) and (3) both

Which storage type stores data in a vertical fashion?
CHOOSE the CORRECT OPTION from below list
(1)Row store
(2)COLUMN store
(3)Cubes
(4)None of the above

Answer:-(2)Column store

The SAP HANA SYSTEM can be created within _____
Choose the correct OPTION from below list
(1)Modeler
(2)RESOURCE
(3)NAVIGATOR
(4)SAP GUI

Answer:-(3)Navigator

Which HANA related TOOL is an Eclipse plug-in tool?
CHOOSE the correct OPTION from below list
(1)SAP Lumira
(2)SAP HANA Studio
(3)IDT
(4)SAP CRYSTAL Reports

Answer:-(2)SAP HANA Studio

Which of the following SAP HANA component is a hardware component?
CHOOSE the correct OPTION from below list
(1)Name server
(2)Multi-core processor
(3)INDEX server
(4)Calculation engine

Answer:-(2)Multi-core processor

SAP HANA SERVER can be accessed by _______
CHOOSE the correct option from below list
(1)SAP GUI
(2)Any web BROWSER
(3)Only Internet EXPLORER
(4)HANA Studio

Answer:-(4)HANA Studio

The NUMBER of STEPS in the testing activity for SAP IMPLEMENTATION is_______
Choose the correct OPTION from below list
(1)1
(2)2
(3)3
(4)4

Answer:-(3)3

ASAP Methodology STANDS for________
Choose the correct option from below list
(1)As Short As POSSIBLE
(2)Accelerated SAP
(3)As SOON As Possible

Answer:-(2)Accelerated SAP

Which server checks the performance and health of OVERALL components of SAP HANA system?
CHOOSE the correct option from below list
(1)Pre-processor server
(2)Index server
(3)Name server
(4)STATISTICAL server

Answer:-(4)Statistical server

Which of the following is a core COMPONENT of SAP HANA environment?
Choose the CORRECT option from below list
(1)SAP HANA Studio
(2)SAP Business Objects BI4
(3)DATABASE
(4)In-memory computing engine

Answer:-(4)In-memory computing engine