SAP HANA – Variables And Restricted Measures

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Uwinpro
U
Uwinpro
Community Contributor
Quizzes Created: 25 | Total Attempts: 13,639
Questions: 10 | Attempts: 414

SettingsSettingsSettings
SAP HANA Quizzes & Trivia

Test your SAP HANA skills.
Good Luck !


Questions and Answers
  • 1. 

    Variable are created and defined in the area named ________

    • A.

      Data Foundation

    • B.

      Output

    • C.

      Navigator

    • D.

      Quick Launch

    Correct Answer
    B. Output
    Explanation
    Variables are created and defined in the area named "Output". This area is where the final result or outcome of a program or function is displayed or stored. It is the section where the values of variables are printed or written to a file for further use or analysis.

    Rate this question:

  • 2. 

    Filters are applied in ______

    • A.

      Output window

    • B.

      Navigator window

    • C.

      Quick Launch

    • D.

      Logical View

    Correct Answer
    D. Logical View
    Explanation
    Filters are applied in the Logical View. The Logical View is a representation of the project structure that allows users to organize and navigate through the different components of the project. Filters can be applied to the Logical View to display only specific components based on certain criteria. This helps in managing large projects by allowing users to focus on relevant components and hide unnecessary ones.

    Rate this question:

  • 3. 

    When defining variables, which of the following details are asked by the SAP HANA SP04 system ? (3 correct answers)

    • A.

      Variable name

    • B.

      Data type, lengths and scale

    • C.

      Attribute

    • D.

      Selection Type and default value

    Correct Answer(s)
    A. Variable name
    C. Attribute
    D. Selection Type and default value
    Explanation
    When defining variables in the SAP HANA SP04 system, the following details are asked: variable name, attribute, selection type, and default value. The variable name is necessary to identify the variable, while the attribute specifies the characteristics or properties of the variable. The selection type determines how the variable can be selected or filtered, and the default value is the initial value assigned to the variable if no other value is specified.

    Rate this question:

  • 4. 

    When defining variables, which of the following details are asked by the SAP HANA SP02 system ? (3 correct answers)

    • A.

      Package name

    • B.

      Variable name

    • C.

      Data type, lengths and scale

    • D.

      Selection type without default value

    Correct Answer(s)
    B. Variable name
    C. Data type, lengths and scale
    D. Selection type without default value
    Explanation
    When defining variables in the SAP HANA SP02 system, the system asks for the variable name, data type, lengths and scale, and the selection type without default value. These details are necessary to properly define and use variables in the system. The package name is not mentioned as one of the details asked by the system, so it is not one of the correct answers.

    Rate this question:

  • 5. 

    When defining Restricted Measure, which of the following details are asked by the system ? (2 correct answers)

    • A.

      Measure

    • B.

      Restrictions

    • C.

      Server name

    • D.

      Package name

    Correct Answer(s)
    A. Measure
    B. Restrictions
    Explanation
    The system asks for the details of Measure and Restrictions when defining Restricted Measure. The Measure refers to the specific metric or parameter that needs to be measured or restricted, while Restrictions refer to the specific limitations or conditions that need to be applied to the Measure. The system requires this information in order to accurately define and implement the Restricted Measure.

    Rate this question:

  • 6. 

    1. In SAP HANA SP04 when saving and activating a view, a new window named “Activate” opens and we can select multiple views from the left box to move to the right box and activate. 2. This is same in SAP HANA SP02 as well.

    • A.

      The first statement is correct and not the second

    • B.

      The second statement is correct and not the first

    • C.

      Both statements are correct

    • D.

      Both statements are wrong

    Correct Answer
    A. The first statement is correct and not the second
    Explanation
    The explanation for the given correct answer is that the first statement is correct and not the second because it states that in SAP HANA SP04, when saving and activating a view, a new window named "Activate" opens and allows the selection of multiple views to be moved to the right box and activated. The second statement contradicts this by stating that the same feature is available in SAP HANA SP02, which is incorrect. Therefore, only the first statement is correct.

    Rate this question:

  • 7. 

    Which of the following statement is correct ?

    • A.

      Restricted measures can be used to restrict the output based on a fact.

    • B.

      The screen used to define Restricted Measures in not the same in SAP HANA SP02 and SP04.

    • C.

      Restricted measures can be used to restrict the output based on an attribute.

    • D.

      We cannot add restrictions while defining the Restricted Measures.

    Correct Answer
    C. Restricted measures can be used to restrict the output based on an attribute.
    Explanation
    The correct answer is "Restricted measures can be used to restrict the output based on an attribute." This statement accurately describes the functionality of restricted measures in SAP HANA. Restricted measures allow users to apply restrictions or filters on the output based on specific attributes or conditions. This helps in narrowing down the data and focusing on specific subsets of information.

    Rate this question:

  • 8. 

    Which of the following statement is correct ?

    • A.

      Restricted Measures can be created for Attribute Views.

    • B.

      Restricted Measures can be created for Analytic Views.

    • C.

      Restricted Measures can be created for tables.

    • D.

      All of the above are correct.

    Correct Answer
    B. Restricted Measures can be created for Analytic Views.
    Explanation
    Restricted Measures can be created for Analytic Views. This means that in SAP HANA, it is possible to define restricted measures, which are calculated measures based on specific conditions or filters, within an analytic view. These restricted measures allow for more advanced and customized calculations to be performed on the data within the analytic view.

    Rate this question:

  • 9. 

    Restricted Measures, once created cannot be changed.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    Restricted Measures can be changed after they are created. Restricted Measures are a feature in certain software or systems that allow administrators to set limitations or restrictions on certain actions or behaviors. These restrictions can be modified or updated as needed by the administrators. Therefore, the statement that Restricted Measures cannot be changed is false.

    Rate this question:

  • 10. 

    We can create Restricted Views in the Quick Launch Window.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    Restricted Views cannot be created in the Quick Launch Window. The Quick Launch Window is used to display links to lists, libraries, and other content within a SharePoint site. It does not have the capability to create restricted views, which are typically used to limit access or filter data within a list or library. Therefore, the correct answer is False.

    Rate this question:

Quiz Review Timeline +

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

  • Current Version
  • Mar 15, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 13, 2012
    Quiz Created by
    Uwinpro
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.