Quiz
MIsc
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (26)
1List down the elements involved in User Management and Security in SAP HANA?
- AAssign job security
- BManage users
- CCreate users
- DAssign security
- EWork management
2Why is a security concept in SAP HANA required?
- ADatabase administration should be restricted to skilled
- BAccess to ERP tables must be restricted
- CEditing of SAP HANA data models should only be possible for “Users.” of the model
- DNeed to have selected users in SAP HANA for Information Management
3How will you select a preference for Validation rules?
- AWindows- Modeler – Preferences-SAP HANA-Validation Rules
- BWindows- SAP HANA-Preferences-Modeler-Validation Rules
- CWindows- Preferences-SAP HANA-Modeler-Validation Rules
- DWindows- SAP HANA-Modeler-Preferences-Validation Rules
4In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement?
- ACOLUMN
- BLOCAL TEMPORARY
- CROW
- DGLOBAL TEMPORARY
5What are the elements of ABAP Database Integration?
- ADB client-server
- BApplication server
- CDB For ABAP
- DClient database handling
- EOther DB
6Name the views that are available to administer and monitor one or several SAP HANA systems?
- AThe System Monitor view
- BThe Landscape view
- CThe Administration view
- DThe Security view
7What are the two different kinds of Identifiers used to represent names used in SQL statement?
- AUndelimited Identifiers
- BLimited identifiers
- CDelimited identifiers
- DNumeric identifiers
8To upload data from flat files, SAP HANA offers several features. What are these important features?
- AThe application suggests the column name and data type for the new tables, and it is possible to edit them
- BWhen loading new data in the table, it gets appended to the existing data
- CThe new table always has a 2:2 mapping between the file and table columns
- DThe supported file types for upload are: .cssv, .xlls, and .xlsxxx
9What views will be most efficient for General Modeling Principles?
- ASchema view
- BColumn view
- CAnalytical view
- DAttribute view
10Discuss the main capabilities of SAP BusinessObjects Analysis for Office?
- ASort data by characteristics
- BSuggests style sets for crosstabs
- CConvert crosstab cells to formula
- DAnalyze data with the design panel
11What are the components of The Enterprise Procurement Model Demo Scenario?
- ASales
- BStock
- CProcurement
- DProduct
- EServices
12What is an attribute view and what are its practices?
- AUsed in diagrammatic Projections
- BUsed to join tables
- CMay contain filters
- DMay use in calculation views
- EMay contains flow charts
13Discuss the conditions required to ensure the Referential Integrity?
- AThere are two joins in the able
- BThere are three joins in the table
- CThere is at least one join in the other table
- DReferential integrity holds true in both the directions
14You have defined the following SQLScript procedure:
CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA
Which type of database procedures can be called in this SQLScript procedure?- AWrite only
- BRead only
- CRead-update
- DRead-write
15Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP?
- ASwap axes
- BCreate Presentations
- CInsert filter components
- DCreate data by members and tables
16Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources?
- AContent folder
- BSecurity folder
- CProvisioning folder
- DAdministration folder
17An Analytic Privilege consists of several restrictions. What are they?
- AAnalytic restrictions
- BCube restrictions
- CActivity restrictions
- DValidity restrictions
- EView restrictions
18What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA
Modeling?- AService-based profitability
- BCosting-based Profitability
- CAccount-based Profitability
- DProduct-based Profitability
19If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available?
- AIndex search
- BFreestyle search
- CFuzzy search
- DWeights for ranking
- EPoint base ranking
20How will you hide the attributes that are not required for client consumption?
- ABy setting the hidden property flag of the attribute in the View
- BBy setting the hidden property flag of the attribute column
- CBy setting the hidden property flag of the attribute in the Semantics screen
- DBy setting the hidden property flag of the attribute provider
21Which engine is used to execute Analytic View?
- ACalc Engine
- BOLAP Engine
- CSQL Engine
- DJoin Engine
22What is the operating system supported by HANA?
- ARed Hat Enterprise Linux (RHEL)
- BSUSE Linux Enterprise Server
- CBoth Linux and Window 8
- DOnly Windows 8
23What is the main purpose of Analytic Privilege?
- ARestrict user to access modeling view
- BRestrict users to access database tables
- CRestrict row level access so that user will be able to see only certain portion of the data
24What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster?
- AServices-Name and index server on all nodes
- BHigh availability configuration
- CActive clusters for all servers
- DShared file systems for only one server
25Which data provisioning methods can you use when you need real time replications?
- ASAP Replication server
- BSAP Landscape transformation Replication server (SAP SLT)
- CSAP Data services
- DSAP HANA Direct extractor connection (SAP DXC)
26Which SAP HANA engine executes Calculation view?
- AOLAP Engine
- BCalculation Engine
- CSQL Engine
- DJOIN Engine
Information
- Description
- Quiz on MIsc, created by SUJAY MESHRAM on 23/12/2020.
- Author
- SUJAY MESHRAM
- Language
- English
- Views
- 5
- History
- Created on 23 Dec 2020 · updated on 24 Dec 2020
- Tags
- Rating
- No ratings yet Rate this quiz