Olete.in – MCQs, Mock Tests & Government Job Prep | SAP HANA Sap Hana Multiple Choice Questions Set 1

Which of the following is NOT a replication method for data replication from a source system to SAP Hana?

1. ETL based
2. Trigger-based
3. Time-based
4. Log-based

✅ Correct Answer: 3

Which of the following statements are true?

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

✅ Correct Answer: 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?

1. Import source system metadata -> Create Information Models -> Provision Data -> Deploy -> Consume
2. Import source system metadata -> Provision Data ->Create Information Models -> Deploy -> Consume
3. Import source system metadata -> Provision Data -> Deploy -> Create Information Models -> Consume
4. Import source system metadata -> Deploy ->Create Information Models -> Provision Data -> Consume

✅ Correct Answer: 2

Which of the following statements are true?

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
4. None of these

✅ Correct Answer: 3

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?

1. In the universe
2. In the Web Intelligence report
3. In the analytic view
4. In the calculation view using an attribute value variable

✅ Correct Answer: 3

Which of the following properties of a derived attribute view can you modify?

1. Description
2. Description mapping
3. Calculated attributes
4. Filters

✅ Correct Answer: 1

If you want to create or drop tables in a schema, which privilege type do you need?

1. SYSTEM
2. ANALYTIC
3. PACKAGE
4. SQL

✅ Correct Answer: 4

Which SAP BusinessObjects reporting tool should you use to answer ad-hoc questions and interact with shared information?

1. Crystal Reports
2. Dashboards
3. Explorer
4. WebIntelligence

✅ Correct Answer: 4

Which new connection type is available as of SAP BusinessObjects Data Services 4.0?

1. Operational Data Provider
2. BAPI function calls
3. IDOCs
4. Read table via ABAP data flows

✅ Correct Answer: 1

Which delivered role is mandatory for a system administrator in SAP HANA?

1. SYS_ADMIN
2. CONTENT_ADMIN
3. SAP_ALL
4. IC MODELER

✅ Correct Answer: 2

What are the benefits of using a business layer on top of SAP HANA? (Choose two)

1. An extra layer of granular security
2. Users can use business names instead of technical names
3. Fast throughput via BICS connectivity
4. Both (A) and (B)

✅ Correct Answer: 4

SAP HANA database is ____

1. A sort of SAP GUI used to access SAP servers.
2. A general purpose ANSI compliant in-memory database.
3. Used to store mountains of OLAP data.
4. A hardware product made by hardware manufacturers.

✅ Correct Answer: 2

What is SAP HANA Appliance?

1. It is a combination of software from SAP and certified hardware from vendors like Dell, IBM, Cisco, Fujitsu.
2. It is a piece of hardware from vendors like Dell, IBM, Cisco, Fujitsu.
3. Is solely produced by SAP AG only.
4. It is a combination of BI, BOBJ, and HANA.

✅ Correct Answer: 1

SAP HANA server can be accessed by _______

1. SAP GUI
2. Any web browser
3. Only Internet Explorer
4. HANA Studio

✅ Correct Answer: 4

What method is used to extract tables from ECC server in real time?

1. SLT based table data provisioning
2. Information Design Tool (IDT)
3. BI R3 extraction services
4. None of the above

✅ Correct Answer: 1