SAP HANA - Views
Settings
Test your SAP HANA skills. Good Luck !
- 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
Back to top