SAP HANA - Views

12 Questions | Total Attempts: 816

SettingsSettingsSettings
Please wait...
SAP HANA Quizzes & Trivia

Test your SAP HANA skills. Good Luck !


Questions and Answers
  • 1. 
    What views can be created under the packages? (3 correct answers)
    • A. 

      Calculated View

    • B. 

      Attribute View

    • C. 

      Calculation View

    • D. 

      Analytic View

  • 2. 
    The purpose of creating Attribute views is to _____and ______ (2 correct answers)
    • A. 

      Select only a few fields from a table for reporting

    • B. 

      Join tables of different types

    • C. 

      Join tables of the same type

    • D. 

      Create analytic view

  • 3. 
    Analytic views can be created with ______
    • A. 

      Only Attribute views

    • B. 

      Tables and Attribute views

    • C. 

      Only Tables

    • D. 

      Neither with Tables nor with Attribute views

  • 4. 
    The shape of the icon used to show an attribute view is _____
    • A. 

      A Star

    • B. 

      A Cube

    • C. 

      A Square

    • D. 

      Multiple Squares

  • 5. 
    Attribute views can be created under ______
    • A. 

      Catalog

    • B. 

      Package

    • C. 

      Authorization

    • D. 

      All of the above

  • 6. 
    Which of the following can be used to see the tabs for raw data, distinct values and analysis of a table or a view?
    • A. 

      New view

    • B. 

      Open Definition

    • C. 

      Open Content

    • D. 

      Open Data Preview

  • 7. 
    Views are saved under the schema ______
    • A. 

      _SYS_BIC

    • B. 

      _SYS_BI

    • C. 

      _SYS_REPO

    • D. 

      IC_TABLES

  • 8. 
    We can limit the user access for _____, ______ and ______ (3 correct answers)
    • A. 

      Packages

    • B. 

      SQL Objects

    • C. 

      System Privileges

    • D. 

      Top Pull Down Menu

  • 9. 
    Only one schema is created for one login ID.
    • A. 

      True

    • B. 

      False

  • 10. 
    Analytic privileges can be created under _____
    • A. 

      Catalog folder

    • B. 

      Package

    • C. 

      Authorization folder

    • D. 

      None of the above

  • 11. 
    A package can be created under another package.
    • A. 

      True

    • B. 

      False

  • 12. 
    Which of the following statement is correct?
    • A. 

      A package name is always in lower case

    • B. 

      A package name is always in upper case.

    • C. 

      A package name can use uppers and lowers.

    • D. 

      Package contains user names