SAP HANA Objective type Questions and Answers

11. How can you evaluate the speed of a calculation within the database? (Choose two)
A. Use the Data Preview function in the SAP HANA studio.
B. Execute a Web Intelligence report and check the duration of the previous refresh.
C. Execute an information space using SAP Business Objects Explorer.
D. Write and execute an appropriate SQL statement.
Ans:  A,D
12. If you want to create or drop tables in a schema, which privilege type do you need?
A. SYSTEM
B. ANALYTIC
C. PACKAGE
D. SQL
Ans:  D
13. Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?
A. Crystal Reports
B. Dashboards
C. Explorer
D. WebIntelligence
Ans:  D
14. Which new connection type is available as of SAP BusinessObjects Data Services 4.0?
A. Operational Data Provider
B. BAPI function calls
C. IDOCs
D. Read table via ABAP data flows
Ans:  A
15. Which of the following tasks must you perform before you build a business layer within the SAP BusinessObjects Information Design Tool (IDT) on top of SAP HANA? 
A. Publish the connection to CMS.
B. Build a query to test the connection.
C. Build a relational connection to SAP HANA.
D. Build an OLAP connection to SAP HANA.
E. Build a data foundation.
Ans:  A,C,E
16. Which delivered role is mandatory for a system administrator in SAP HANA?
A. SYS_ADMIN
B. CONTENT_ADMIN
C. SAP_ALL
D. IC MODELER
Ans:  B
17. What are benefits of using a business layer on top of SAP HANA? (Choose two)
A. An extra layer of granular security
B. Improved database calculation speed
C. Fast throughput via BICS connectivity
D. Users can use business names instead of technical names
Ans:  A,D


18. SAP HANA database is ____
 
  A. A sort of SAP GUI used to access SAP servers.
  B. A general purpose ANSI compliant in-memory database.
  C. Used to store mountains of OLAP data.
  D. A hardware product made by hardware manufacturers.
Ans:  B


19. What is SAP HANA Appliance?
 
  A. It is a combination of software from SAP and certified hardware from vendors like Dell, IBM, Cisco, Fujitsu.
  B. It is a piece of hardware from vendors like Dell, IBM, Cisco, Fujitsu.
  C. Is solely produced by SAP AG only.
  D. It is a combination of BI, BOBJ and HANA.
Ans:   A


20. What BI standards does HANA support? (3 correct answers)
 
  A. ODBC
  B. JDBC
  C. MDX
  D. MIME
Ans:   A, B, C

More Questions & Answers:-
Page1 Page2 Page3 Page4 Page5

Top 50 SAP HANA Objective type Questions and Answers

1.  Which of the following is NOT a replication method for data replication from a source system to SAP Hana?
a.        ETL based
b.        Trigger based
c.        Time based
d.        Log based
Answer: c
2.  Which of the following statements are true?
a.        There are four types of information views: attribute view, analytic view, hierarchy view and calculation view. All these views are non-materialized views.
b.        An analytic view is used to model data that includes measures.
c.        Calculated attributes are derived from one or more existing attributes or constants.
d.        Calculation views can include measures and be used for multidimensional reporting or can contain no measures and used for list-type of reporting
Answer: d
3.  HANA supports which of the following hierarchies?
a.        Time Based hierarchies
b.        Level Hierarchies
c.        Parent/Child Hierarchies
d.        Matrix organization Hierarchies
Ans: b, c
4.  SAP HANA modeler is a graphical data modeling tool which allows you to design analytical models and later analytical privileges, that governs the access to those models. Which of the following represents a logic flow of activities?
a.        Import source system metadata -> Create Information Models -> Provision Data -> Deploy -> Consume
b.        Import source system metadata ->  Provision Data  ->Create Information Models -> Deploy -> Consume
c.        Import source system metadata -> Provision Data -> Deploy -> Create Information Models -> Consume
d.        Import source system metadata ->  Deploy  ->Create Information Models -> Provision Data -> Consume
Ans:  b
5.  The two queries below, which is more efficient?
a.        Matmoves = SELECT * FROM MSEG
FOR EACH matmove in matmoves
       IF matmove.whichPlant = “I” THEN
                Plant_text = SELECT plant_text FROM WERKS WHERE id = matmove.plant
          ELSE
                Plant_text = SELECT plant_text FROM WERKS_EXT WHERE id=matmove.
plant
         END


b.         If which_plant = “I” THEN
       Plant_text = plant_int_text
ELSE
       Plant_text = plant_ext_text
Ans:  b
6   Which of the following statements are true?
a.        One table may appear in exactly one schema
b.        It is possible to grant authorizations on a table level.
c.        Authorizations granted on a schema are automatically propagated to all objects within the schema
Ans:  c
8.  You have a Web Intelligence report that requires data from SAP HANA filtered for a specific year.    Where do you apply the filter for optimal performance?
A. In the universe
B. In the Web Intelligence report
C. In the analytic view
D. In the calculation view using an attribute value variable
Ans:  C
9.  What are the key benefits of using SAP BusinessObjects Explorer with SAP HANA? (Choose three)
A. You do not need to create your own queries to access information.
B. You can easily create your own queries to access information.
C. You can access information for data discovery intuitively.
D. You can execute ad-hoc business analytics quickly.
E. You can easily create an IDT business layer.
Ans:  A,C,D
10. Which of the following properties of a derived attribute view can you modify?
A. Description
B. Description mapping
C. Calculated attributes
D. Filters
Ans:  A

More Questions & Answers:-
Page1 Page2 Page3 Page4 Page5