100 Top Sap Hana Multiple Choice Questions and Answers

Sap Hana Multiple Choice Questions:-

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. Mat moves = SELECT * FROM MSEG
FOR EACH mat move in man moves
I may move.which last = ā€œIā€ THEN
Plant_text = SELECT plant_text FROM WERKS WHERE id = mat move.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

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 Business Objects 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 the 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

SAP HANA Objective Questions Pdf Free Download::

21. Can SAP HANA database be used by any application, other than SAP?
A. Yes
B. No
Ans: B

22. SAP HANA server can be accessed by _______
A. SAP GUI
B. Any web browser
C. Only Internet Explorer
D. HANA Studio
Ans: D

23. What method is used to extract tables from ECC server in real time?
A. SLT based table data provisioning
B. Information Design Tool (IDT)
C. BI R3 extraction services
D. None of the above
Ans: A

24. Which one of the following are components of SAP HANA Studio?
A. Navigator
B. Job Log
C. Where-Used List
D. All of the above
Ans: D

25. How many perspectives are available in SAP HANA Studio (SPS03)?
A. 4
B. 8
C. 9
D. 10
Ans: B

26. Which perspective is used to create joins?
A. Administration & Modeling
B. Debug & Modelling
C. Modeler
D. All of the above
Ans: C

27. The SAP HANA system can be created within _____
A. Modeler
B. Resource
C. Navigator
D. SAP GUI
Ans: C

28. Can we create multiple connections to the same SAP HANA system?
A. Yes
B. No
Ans: A

29. The login user who has maximum authorizations in an SAP HANA database is ______
A. SYS
B. SYSTEM
C. Administrator
D. Root

Ans: B

30. Can the attribute views be created with 1 table?
A. Yes
B. No
Ans: A

31. By default, the maximum number of rows displayed from a table is ______

A. 1000
B. 5000
C. Unlimited
D. None of the Above
Ans: B

32. For faster reads, SAP HANA reads the table’s column wise.

A. True
B. False
Ans: A

33. Using SAP HANA Studio, table can be _______, ________, _______ (3 correct answers)

A. Created manually
B. Created using SQL
C. Replicated from other systems
D. Just copied from other systems
Ans: A,B,C

34. When the Administration Console is the perspective selected, which of the following can be viewed under the HANA system?

A. Catalog
B. Content
C. Both of them
D. None of them
Ans: A

35. Ultimately, the SAP HANA database will replace all databases used in BI/BW, ECC, and all other SAP Systems.

A. True
B. False
Ans: A

36. In the SAP HANA Studio, the physical tables are stored ______

A. Under Catalogs
B. Under Content
C. In both
D. Nowhere
Ans: A

37. When deleting a table, what options can be selected? (2 correct answers)

A. Delete Catalog Object
B. Delete All Rows
C. Drop The Table
D. All of the above
Ans: A, B

38. Users are created under ______

A. Catalog
B. Content
C. Any of them
D. None of them
Ans: A

39. Can SAP HANA run on SUSE Linux?

A. Yes
B. No
Ans: A

40. The option to send a table from Quality Assurance System to Production System is _______

A. Use CTS+
B. Use Import from Quality Assurance System
C. Use Export from Quality Assurance System
D. Use the Transport Management System

41. To create a user, we have to ________

A. Use T-Code SU01
B. Use T-Code SU10
C. Use Users folder under Authorization in Catalog
D. Use Users folder under Authorization in Content
Ans: C

42. Which user has privileges to Root Package?

A. SYS
B. SYSTEM
C. Both of the above
D. Administrator

Ans: B

43. Which role is specifically assigned to a user involved in creating views?

A. SAPSR3_POWER_USER
B. PUBLIC
C. MODELING
D. None of the above

Ans: C

44. SAP HANA system is memory based and persistent storage is not necessary.

A. True
B. False
Ans: B

45. SAP HANA contains OLAP data (only) in the memory.

A. True
B. False
Ans: B

46. When you are creating an SAP HANA system in the SAP HANA Studio, a user should be used as the login user. SYSTEM can be the only user for this purpose.

A. True
B. False
Ans: B

47. If you have only one SAP HANA system physically, then you can create only one HANA system icon in the SAP HANA Studio.

A. True
B. False
Ans: B

48. SAP HANA database is ______

A. Oracle based
B. Sybase based
C. MS SQL based
D. Informix based
Ans: B

49. Joins are created under ______

A. Content
B. Catalog
C. Schema
D. Authorization
Ans: A

50. In SAP HANA Studio, HANA systems can be created under nested folders identical to the departments in your company.

A. True
B. False
Ans: A