SAP HANA Appliance Modeling – Advanced Quiz 1 | Attempts: 928

1.

The 3 important benefits of using SAP HANA are :

A.

Centralized database
B.

Possibility for real-time data analysis
C.

Faster data access
D.

Built-in reporting functions with SAP HANA Studio

Correct Answer(s)
B. Possibility for real-time data analysis
C. Faster data access
D. Built-in reporting functions with SAP HANA Studio

Explanation
The answer is correct because these are indeed three important benefits of using SAP HANA. Possibility for real-time data analysis means that users can analyze data in real-time, allowing for quick decision-making and improved business operations. Faster data access refers to the ability to retrieve and process data quickly, leading to increased efficiency and productivity. Built-in reporting functions with SAP HANA Studio provide users with a comprehensive tool for creating and generating reports, making it easier to analyze and present data. Overall, these benefits highlight the advantages of using SAP HANA in terms of data analysis, speed, and reporting capabilities.

Rate this question:

2.

Which of the following are the components or features of SAP HANA Appliance ? (3 correct answers)

A.

Calculation Engine
B.

Real-Time Data Replication
C.

Row & Column In-Memory
D.

SAP Applications

Correct Answer(s)
A. Calculation Engine
B. Real-Time Data Replication
C. Row & Column In-Memory

Explanation
The components or features of SAP HANA Appliance include the Calculation Engine, Real-Time Data Replication, and Row & Column In-Memory. These components allow for fast and efficient data processing, real-time data replication for up-to-date information, and the ability to store and analyze data in both row and column formats. SAP Applications are not mentioned as a component or feature of SAP HANA Appliance.

Rate this question:

3.

Which of the following cannot be done with SAP HANA ?

A.

Data Modeling
B.

Data Management
C.

Persistent storage for data recovery
D.

None of the above

Correct Answer
D. None of the above

Explanation
SAP HANA is a powerful in-memory database platform that allows for various tasks such as data modeling and data management. It also provides persistent storage for data recovery, ensuring that data can be restored in case of any failures. Therefore, the correct answer is "None of the above" as all the mentioned tasks can be done with SAP HANA.

Rate this question:

4.

Which of the following are features of Big Data ? (3 correct answers)

A.

Velocity
B.

Variety
C.

Viscosity
D.

Volume

Correct Answer(s)
A. Velocity
B. Variety
D. Volume

Explanation
The features of Big Data are Velocity, Variety, and Volume. Velocity refers to the speed at which data is generated and processed. Variety refers to the different types and formats of data, including structured, unstructured, and semi-structured data. Volume refers to the large amount of data being generated and stored. Viscosity is not a feature of Big Data.

Rate this question:

5.

As of November 2012 the SPS release for SAP HANA Appliance 1.0 is :

A.

01
B.

02
C.

03
D.

04

Correct Answer
D. 04

Explanation
The correct answer is 04. This suggests that as of November 2012, the SPS release for SAP HANA Appliance 1.0 is version 04.

Rate this question:

6.

The codes from BWA Trex Engine is used in SAP HANA database in :

A.

Persistence Layer
B.

Row Store
C.

Column Store
D.

All of the above

Correct Answer
C. Column Store

Explanation
The codes from BWA Trex Engine are used in SAP HANA database in the Column Store. The Column Store is a storage and processing technique that stores data in columns rather than rows, allowing for faster data retrieval and analysis. By using the BWA Trex Engine, which is a search and analytics engine, in the Column Store, SAP HANA can efficiently process and analyze large volumes of data.

Rate this question:

7.

Which of the following is used for end users to perform basic modeling functions and upload data to SAP HANA database ?

A.

MS Excel
B.

SAP HANA IC
C.

BODS
D.

Webi

Correct Answer
B. SAP HANA IC

Explanation
SAP HANA IC, or SAP HANA Information Composer, is used for end users to perform basic modeling functions and upload data to the SAP HANA database. It allows users to create and manage information models, define data sources, and perform data transformations. With SAP HANA IC, end users can easily upload data from various sources into the SAP HANA database and perform basic modeling tasks to analyze and visualize the data.

Rate this question:

8.

In which of the following scenario the output tables must be manually created ?

A.

Graphical Calculation View
B.

Script Based Calculation View
C.

BODS
D.

SAP LT

Correct Answer
B. Script Based Calculation View

Explanation
The output tables must be manually created in the scenario of a Script Based Calculation View. Unlike a Graphical Calculation View, where the tables are automatically generated based on the graphical design, a Script Based Calculation View requires manual creation of output tables using SQL scripts. This gives the user more control and flexibility over the structure and content of the output tables. BODS and SAP LT are not relevant to this question as they are not calculation view types.

Rate this question:

9.

Which of the following is a reporting tool ?

A.

SAP Crystal Reports
B.

SAP Business Objects Dashboard
C.

SAP Business Objects Explorer
D.

All of the above

Correct Answer
D. All of the above

Explanation
All of the options listed - SAP Crystal Reports, SAP Business Objects Dashboard, and SAP Business Objects Explorer - are reporting tools. SAP Crystal Reports is a tool used to design and generate reports from a wide range of data sources. SAP Business Objects Dashboard is a tool that allows users to create interactive dashboards and visualizations for data analysis and reporting. SAP Business Objects Explorer is a self-service data exploration tool that enables users to search, explore, and analyze data from various sources. Therefore, all of the options mentioned are reporting tools.

Rate this question:

10.

Which of the following are correct ?

A.

Read modules are always stored in the source
B.

Actual data is stored in Analytic Views
C.

A package is created for each user
D.

Analytic Privileges has to be assigned to users or roles

Correct Answer
D. Analytic Privileges has to be assigned to users or roles

Explanation
Analytic Privileges need to be assigned to users or roles in order to provide access to specific data or perform specific actions within an analytic view. This ensures that only authorized users or roles can access and manipulate the data stored in the analytic view.

Rate this question:

11.

When Info Cube design is concerned SAP HANA : (3 correct answers)

A.

Can work with “flat” structures
B.

Does not need E- and F-fact tables
C.

Info Cubes can be created under Catalog
D.

Info Cubes are created under Content

Correct Answer(s)
A. Can work with “flat” structures
B. Does not need E- and F-fact tables
D. Info Cubes are created under Content

Explanation
SAP HANA can work with "flat" structures, meaning it can handle data models that do not have complex hierarchical relationships. It does not require E- and F-fact tables, which are typically used in traditional data warehousing systems. Info Cubes in SAP HANA are created under the Content folder, not under the Catalog folder.

Rate this question:

12.

For faster reporting in SAP HANA : (2 correct answers)

A.

Activation is done at Database Layer
B.

Calculations are done at User Interface Layer
C.

DATA is stored In-Memory at the Database Layer
D.

Joins are created in the reporting tools

Correct Answer(s)
A. Activation is done at Database Layer
C. DATA is stored In-Memory at the Database Layer

Explanation
In SAP HANA, activation is done at the database layer, which means that the database objects are compiled and optimized for faster execution. This helps in improving the performance of the system. Additionally, data is stored in-memory at the database layer, which allows for faster data access and processing. Storing data in-memory eliminates the need for disk I/O, resulting in quicker response times. Therefore, both activation at the database layer and storing data in-memory contribute to faster reporting in SAP HANA.

Rate this question: