Haninha
Which of the following is a SQL command type language? 2 Answer
Data Object Language (DOL)
Data Manipulation Language (DML)
Command Line Language(CLL)
Transaction Control Language (TCL)
Which of the following is a characteristic of a query execution plan? 1 answer
It has to be optimised to obtain results
It explains the way the database gives back the results of a query
It gives hints to optimise the execution of SAP BW queries
Developers have to make it up when setting up the database structure
Which of the following are main components of a database? 2 Answer
Application engine
Data and parameter files
Backup engine
Query processor
When should column-based tables be chosen over row based tables? 2 Answers
The table has a large number of rows, and columnar operations (such as aggregate or scan) are required.
The table has a small number of rows.
The columns of the table contain mainly distinct value
The table is typically searched based on values of a few columns
How does the creation of indexes for a column table influence the performance of query execution in an ? 1 Answer
It improves query performance if the indexed field is included in a WHERE clause
It improves the performance of all queries on that table
It decreases the performance of all queries to that table
It slows down the performance of the whole SAP HANA database
Which of the following statements describe characteristics of the savepoint? 2 Answers
The savepoint write a complete database image to persistent storage
One purpose of performing savepoint is to speed up restart
It is possible to restore a consistent state of the database from the savepoint without the
The time interval for writing savepoints to fixed to be 5 minutes.
Which of the following are features of the SAP HANA database? 1 Answer
Faster CPU by increasing clock rates
Column based storage in memory
Optimized disk access by minimising the number of disk pages to be read into main memory
Parallel processing with fast communication between processor cores
Which of the following statements describe characteristics of the delta merge? 3 Answers
During the merge operation the complete main storage is rewritten because the values need to be resorted.
A delta merge leads to a sub-second unavailability of the database
Column store automatically performs a delta merge when the delta storage exceeds defined limits.
After a delta merge is successfully finished, the delta storage memory size shrinks to 0
The purpose of a delta merge is to move changes collected in delta storage in read optimised
Which of the following indexservers does not have its own persistence in a scale out scenario? 1 Answer
Slave
Worker
Master
Standby
What is the standard SQL level of isolation in the SAP HANA studio? 1 Answer
TRANSACTION LEVEL
APPLICATION LEVEL
DATABASE LEVEL
STATEMENT LEVEL
Which of the following processes must be running to view SAP HANA diagnosis files if the SAP HANA? 1 Answer
Daemon
Sapstartsrv
Disp+work
SMD Agent
Where can you securely store encrypted database passwords to allow users to access database ? 1 Answer
Hdbuserstore
Hdbpassvault
Passvault
Hdbkeystore
A Company wants to restrict data access to a specific year for certain users. Which privilege type must you define in SAP HANA to achieve this requirement? 1 Answer
Object privilege
Analytical privilege
Package privilege
System privilege
Which of the following can trigger data backups? 3 Answers
DBACockpit
Dataprovisioning
Hdbsql
SAP Host agent
SAP HANA studio
A customer complains about poor performance when they query a column table with 5 billion reads. Where can you check the load status of this table? 2 Answers
On the runtime info tab of the table definition
In the M_CS_TABLES view
In the M_TABLE_PERSISTENCE_LOCATIONS view
In the M_TABLES view
How do you restart an SAP HANA database in a scale-out scenario? 3 Answers
Use the SAP HANA studio
Use the sap control tab
Use the stopsap/startsap command
Use the HDB stop/HDB start command on the master node only
Use the HDB stop/HDB start command on all nodes individually
Where can you monitor more than one SAP HANA system in the SAP HANA studio?
Administration Console
HDBSQL
DBACockpit
System Monitor
Which of the following privileges can you assign to a user role? 3 Answers
System privileges
Administrator privileges
Analytic privileges
Access privileges
Object privileges
A customer is using a SAP ERP and they decide to use SAP HANA as a scenario to speed up reporting? 1 answer
SAP Landscape transformation (SLT)
SAP Data Services (DS)
SAP Adaptive Server Enterprise (SAP ASE)
SAP HAN Direct Extractor Connection (DXC)
What are the types of data backups supported for the SAP HANA database? 1 Answer
Incremental backup
Full online backup
Full offline backup
Differential backup
What is recommended procedure to backup the content of customer specific configuration files? 1 Answer
Backup the files via DBCockpit using the CONFIG variant
Backup the files manually by copying then to an external directory
Backup the files using the hdbsql-tool with the complete option
Perform an SAP HANA database backup via the SAP HANA studio using the – all option
Which of the following information is presented in the HANA license key? 1 Answer
SAP HANA build number
SAP HANA licensed memory amount
SAP HANA edition type
SAP HANA support package number
{"name":"Haninha", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Which of the following is a SQL command type language? 2 Answer, Which of the following is a characteristic of a query execution plan? 1 answer, Which of the following are main components of a database? 2 Answer","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}