SAP HANA Appliance Modeling – Advanced Quiz 2

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Uwinpro
U
Uwinpro
Community Contributor
Quizzes Created: 25 | Total Attempts: 13,771
| Attempts: 337
SettingsSettings
Please wait...
  • 1/12 Questions

    Following 3 functions can be done In Administration Console :

    • Monitoring systems
    • Starting and stopping systems
    • Advanced modeling for administrative purpose
    • Backup an instance
Please wait...
SAP HANA Quizzes & Trivia
About This Quiz

SAP HANA Appliance Modeling \u2013 Advanced Quiz 2 assesses knowledge on system monitoring, schema metadata, and data storage in SAP HANA. It tests understanding of administration console functions, perspectives, and data integrity in HANA environments, crucial for advanced data management roles.

Quiz Preview

  • 2. 

    The metadata of created column views are located in schema :

    • _SYS_REPO

    • _SYS_BIC

    • _SYS_BI

    • SYSTEM

    Correct Answer
    A. _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 :

    • Performance

    • Landscape

    • Volumes

    • All of the above

    Correct Answer
    A. 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 ?

    • Debug

    • Team Synchronizing

    • Data Modelling

    • Resource

    Correct Answer
    A. 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 ?

    • The default perspective is Administration Console

    • By default the Quick Launch opens for the first instance in the navigation tree

    • SAP HANA persists redundant data for each model and creates materialized aggregates

    • Index Server, Statistics Server, Name Server Preprocessor Server and XS Engine are components of SAP HANA database system

    Correct Answer
    A. 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 :

    • Statistics Server and Name Server

    • Name Server and XS Engine

    • Name Server and Index Server

    • Packages

    Correct Answer
    A. 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)

    • Column Store tables originated fro SAP TREX

    • Tracing data is stored on disk and moved to memory buffers when needed

    • Calculation Engine is part of Index Server

    • Sybase Replication Server is log based and not used for real time replication

    Correct Answer(s)
    A. Column Store tables originated fro SAP TREX
    A. Tracing data is stored on disk and moved to memory buffers when needed
    A. 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 ?

    • SAP Landscape Trigger

    • SAP BODS

    • Direct Extractor Connection

    • SAP Landscape Transformation

    Correct Answer
    A. 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 :

    • Controller modules are always in the source

    • Controller modules are stored in the SLT system

    • Controller modules are always in the destination

    • None of the above answers are correct

    Correct Answer
    A. 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 ?

    • Table updater

    • Syslog

    • DB Trigger

    • Syslog.conf

    Correct Answer
    A. 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)

    • SBOP Edition

    • Platform edition

    • Enterprise Extended edition

    • UI edition

    Correct Answer(s)
    A. Platform edition
    A. 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?

    • Comprises of data, log and In-Memory database

    • It ensures that the changes are durable and roll back to the most recent committed state is possible after a restart

    • Data is stored in disk volumes that are organized in pages of 8,16,64,512 and 4000k

    • Undo log pages are written in data volumes

    Correct Answer
    A. Comprises of data, log and In-Memory database

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 22, 2012
    Quiz Created by
    Uwinpro

Related Topics

Featured Quizzes

Basketball Quiz Questions And Answers Basketball Quiz Questions And Answers
Best Friend Quiz: Are You Really Best Friends? Best Friend Quiz: Are You Really Best Friends?
Are You Ready For IQ Quiz: Test Your Intelligence Now Are You Ready For IQ Quiz: Test Your Intelligence Now
What Is My Talent? What Is My Talent?
What Ethnicity Do I Look Like? What Ethnicity Do I Look Like?
Do I Have a Crush on Him? Quiz Do I Have a Crush on Him? Quiz
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.