SAP HANA Appliance Modeling – Advanced Quiz 2

1.

Following 3 functions can be done In Administration Console :
- A.
  
  Monitoring systems
- B.
  
  Starting and stopping systems
- C.
  
  Advanced modeling for administrative purpose
- D.
  
  Backup an instance
Correct Answer(s)
A. Monitoring systems
B. Starting and stopping systems
D. Backup an instance

Explanation
The Administration Console allows users to perform various functions. These include monitoring systems, starting and stopping systems, and backing up an instance. Monitoring systems involves keeping track of the performance and status of different systems. Starting and stopping systems allows users to initiate or halt the operation of specific systems. Backup an instance enables users to create a copy of a particular instance for safekeeping or future use. These functions are essential for effective administration and management of systems.

Rate this question:
2.

The metadata of created column views are located in schema :
- A.
  
  _SYS_REPO
- B.
  
  _SYS_BIC
- C.
  
  _SYS_BI
- D.
  
  SYSTEM
Correct Answer
C. _SYS_BI

Explanation
The metadata of created column views are located in the _SYS_BI schema.

Rate this question:
3.

System Monitor can be used to view :
- A.
  
  Performance
- B.
  
  Landscape
- C.
  
  Volumes
- D.
  
  All of the above
Correct Answer
D. All of the above

Explanation
System Monitor is a tool that provides an overview of various aspects of a system. It allows users to view performance metrics such as CPU usage, memory usage, and disk activity. Additionally, it provides information about the system landscape, including the running processes and services. Furthermore, it allows users to monitor volumes, which includes information about the disk space usage and file system statistics. Therefore, the correct answer is "All of the above" as System Monitor can be used to view performance, landscape, and volumes.

Rate this question:
4.

Which of the following in not a name of a perspective ?
- A.
  
  Debug
- B.
  
  Team Synchronizing
- C.
  
  Data Modelling
- D.
  
  Resource
Correct Answer
C. Data Modelling

Explanation
The question asks for a perspective that is not a name. "Data Modelling" is not a perspective, but rather a process or technique used in analyzing and organizing data. The other options, "Debug," "Team Synchronizing," and "Resource," could potentially be perspectives or aspects to consider in a certain context or situation.

Rate this question:
5.

Which of the following statements is wrong ?
- A.
  
  The default perspective is Administration Console
- B.
  
  By default the Quick Launch opens for the first instance in the navigation tree
- C.
  
  SAP HANA persists redundant data for each model and creates materialized aggregates
- D.
  
  Index Server, Statistics Server, Name Server Preprocessor Server and XS Engine are components of SAP HANA database system
Correct Answer
C. SAP HANA persists redundant data for each model and creates materialized aggregates

Explanation
The given statement that "SAP HANA persists redundant data for each model and creates materialized aggregates" is wrong. In SAP HANA, redundant data is not persisted for each model. Instead, SAP HANA uses in-memory technology to store and process data, eliminating the need for redundant data storage. Additionally, SAP HANA uses columnar storage and compression techniques to optimize data storage and retrieval, rather than creating materialized aggregates.

Rate this question:
6.

The topology information and actual data stores are stored in :
- A.
  
  Statistics Server and Name Server
- B.
  
  Name Server and XS Engine
- C.
  
  Name Server and Index Server
- D.
  
  Packages
Correct Answer
C. Name Server and Index Server

Explanation
The correct answer is Name Server and Index Server. The Name Server is responsible for storing the topology information, which includes the metadata about the system's components and their locations. The Index Server, on the other hand, is responsible for storing and managing the actual data stores, including tables and indexes. Therefore, the topology information and actual data stores are stored in the Name Server and Index Server.

Rate this question:
7.

Which of the following statements are correct ? (3 correct answers)
- A.
  
  Column Store tables originated fro SAP TREX
- B.
  
  Tracing data is stored on disk and moved to memory buffers when needed
- C.
  
  Calculation Engine is part of Index Server
- D.
  
  Sybase Replication Server is log based and not used for real time replication
Correct Answer(s)
A. Column Store tables originated fro SAP TREX
B. Tracing data is stored on disk and moved to memory buffers when needed
C. Calculation Engine is part of Index Server

Explanation
Column Store tables originated from SAP TREX. This means that SAP TREX was the original source or creator of Column Store tables.

Tracing data is stored on disk and moved to memory buffers when needed. This statement suggests that tracing data, which is used for monitoring and debugging purposes, is initially stored on disk and then transferred to memory buffers when it is required.

Calculation Engine is part of Index Server. This statement implies that the Calculation Engine, which performs calculations and computations, is a component or part of the Index Server.

Sybase Replication Server is log based and not used for real-time replication. This statement states that Sybase Replication Server is log-based, meaning it replicates data based on transaction logs, and it is not used for real-time replication.

Rate this question:
8.

Which of the following is Trigger-Based ?
- A.
  
  SAP Landscape Trigger
- B.
  
  SAP BODS
- C.
  
  Direct Extractor Connection
- D.
  
  SAP Landscape Transformation
Correct Answer
D. SAP Landscape Transformation

Explanation
SAP Landscape Transformation is the trigger-based option among the given choices. This solution enables the transformation of data in real-time or batch mode, triggering actions based on certain events or conditions. It allows for the replication of data from various sources into the SAP system, ensuring data consistency and integrity. With SAP Landscape Transformation, businesses can implement data-driven processes and make informed decisions based on real-time data updates.

Rate this question:
9.

When SAP LT is concerned :
- A.
  
  Controller modules are always in the source
- B.
  
  Controller modules are stored in the SLT system
- C.
  
  Controller modules are always in the destination
- D.
  
  None of the above answers are correct
Correct Answer
B. Controller modules are stored in the SLT system

Explanation
The correct answer is that controller modules are stored in the SLT system. This means that when SAP LT (Landscape Transformation) is being used, the controller modules, which are responsible for controlling the data replication process, are stored within the SLT system itself. This allows for efficient management and control of the data replication process.

Rate this question:
10.

Which of the following updates the Logging Tables in the source system in SLT ?
- A.
  
  Table updater
- B.
  
  Syslog
- C.
  
  DB Trigger
- D.
  
  Syslog.conf
Correct Answer
C. DB Trigger

Explanation
A DB Trigger is used to update the Logging Tables in the source system in SLT. When a specific event occurs in the database, the trigger is activated and executes a set of predefined actions, which in this case involves updating the Logging Tables. This allows for real-time monitoring and logging of changes happening in the source system.

Rate this question:
11.

Which of the following are types of SAP HANA editions ? (2 correct answers)
- A.
  
  SBOP Edition
- B.
  
  Platform edition
- C.
  
  Enterprise Extended edition
- D.
  
  UI edition
Correct Answer(s)
B. Platform edition
C. Enterprise Extended edition

Explanation
The correct answer is Platform edition and Enterprise Extended edition. These are two types of SAP HANA editions. The SBOP Edition and UI edition are not types of SAP HANA editions.

Rate this question:
12.

Which of the following is not true about Persistent Storage?
- A.
  
  Comprises of data, log and In-Memory database
- B.
  
  It ensures that the changes are durable and roll back to the most recent committed state is possible after a restart
- C.
  
  Data is stored in disk volumes that are organized in pages of 8,16,64,512 and 4000k
- D.
  
  Undo log pages are written in data volumes
Correct Answer
A. Comprises of data, log and In-Memory database

SAP HANA Appliance Modeling – Advanced Quiz 2

Following 3 functions can be done In Administration Console :

The metadata of created column views are located in schema :

System Monitor can be used to view :

Which of the following in not a name of a perspective ?

Which of the following statements is wrong ?

The topology information and actual data stores are stored in :

Which of the following statements are correct ? (3 correct answers)

Which of the following is Trigger-Based ?

When SAP LT is concerned :

Which of the following updates the Logging Tables in the source system in SLT ?

Which of the following are types of SAP HANA editions ? (2 correct answers)

Which of the following is not true about Persistent Storage?