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

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

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

Haninha

More Quizzes