Black Friday Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Question # 4

One of your systems show the internal Disk Full (Alert 30) alert. What is the root cause of this alert?

A.

Reading from the /hana/log/ volume is NOT possible

B.

Writing to the /hana/data/ volume is NOT possible

C.

Runing out of free space on the /hana/shared volume

D.

Exceeding system quota on the /usr/sap volume

Full Access
Question # 5

Which activities do you have to carry out to configure your Multiple Database Container (MDC) System to a higher database isolation between tenant databases on the operating system (OS) level? There are 3 correct answers to this question.

A.

Add dedicated tenant OS users to the shm group.

B.

Create dedicated tenant OS users for each tenant.

C.

Remove the adm OS user from the sapsys group.

D.

Add dedicated tenant OS users to the sapsys group.

E.

Lock the adm OS user.

Full Access
Question # 6

Which of the following tasks requires the BACKUP ADMIN authorization? There are 2 correct Answers to this question.

A.

Recovering the database without a user interface

B.

Physically deleting data and log backups and obsolete versions of the backup catalog from the backup location.

C.

Administration tasks executed on a tenant database through the system database.

D.

Backing up the database without a user interface.

Full Access
Question # 7

Which encryption services can you activate in SAP HANA? Note: There are 3 correct answers.

A.

Backup

B.

Data

C.

Log

D.

Pages in-memory

E.

Storage snapshot

Full Access
Question # 8

Assume your current partitioning plan of SAP HANA is NOT optimal. Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned? Please choose the correct answer.

A.

Check the number of partitions

B.

Check the correct location of tables and partitions

C.

Redistribute tables after adding host(s)

D.

Balance table distribution

Full Access
Question # 9

Which package of SAP HANA cloud platform provides a vast set of platform services for the most common pattern in software engineering, such as persistence, connectivity, identity and document management?

A.

SAP HANA Infrastructure Services

B.

SAP HANA Enterprise Cloud

C.

SAP HANA AppServices

D.

SAP HANA DBServices

Full Access
Question # 10

How are savepoints triggered? There are 2 correct answers to this question

A.

By a database soft shutdown.

B.

By issuing a transactional commit.

C.

By performing a delta merge.

D.

By performing a database backup.

Full Access
Question # 11

Which parameters do you need to change before you can analyse the memory usage of running SQL statements? There are 2 correct answers to this question.

A.

memory_tracking

B.

statement_memory_limit

C.

enable_tracking

D.

use_in_memory_tracing

Full Access
Question # 12

You investigate a hung SAP HANA database, and you CANNOT identify the blocking transactions. What causes could lead to this behavior? Note: There are 2 correct answers.

A.

A wrong role of a service in a failover situation

B.

An issue with the delta merge

C.

A setting to restrict CPU usage

D.

A long savepoint duration

Full Access
Question # 13

Which SAP HANA cockpit application can you use to investigate a system offline situation? Please choose the correct answer.

A.

CPU usage monitor

B.

Troubleshoot unresponsive system

C.

Full system information dump

D.

Out-of-memory event monitor

Full Access
Question # 14

Which operations are performed by SAP Landscape Management? Note: There are 2 correct answers.

A.

It de-centralizes landscape operations and provides local landscape view

B.

It automizes repetitive, time-intensive administration tasks

C.

It simplifies the management of SAP hybrid landscapes and standardizes SAP operations

D.

It replicates the storage in SAP landscape

Full Access
Question # 15

Why do we still need a persistent layer? There are 2 correct answers to this question.

A.

To store data that has been unloaded from memory

B.

To enable full database recovery if we have a power failure

C.

To hold the delta store for newly arrived records

D.

To store data that is frequently used

Full Access
Question # 16

You create a new user by copying an existing user. Which predelivered role of the existing user is automatically granted to the new user?

A.

Modeling

B.

Monitoring

C.

Repository

D.

Runtime

Full Access
Question # 17

Which tool do you use to check that the actual size of the backup file is the same as the size recorded in the backup file header?

Please choose the correct answer.

A.

hdb back int

B.

hdb backup diag

C.

hdb recover check

D.

hdb backup check

Full Access
Question # 18

You setup email notification for a specific alert threshold by using Alerts Configuration. When are the email notification sent? Note: There are 2 correct answers.

A.

When the alert checker identifies an issue

B.

When the alert checker identifies a resolved issue

C.

When the alert checker is turned off

D.

When the alert checker identifies a recurring issue

Full Access
Question # 19

How are user group administrators and user groups related?

There are 2 correct answers to this question.

A.

Only one user group administrator per user group

B.

Multiple user group administrators per user group

C.

Only one user group per user group administrator

D.

Multiple user groups per user group administrator

Full Access
Question # 20

Why does SAP HANA have a persistence storage layer that is disk-based? There are 2 correct answers to this question.

A.

To generate indexes for the column store

B.

To persist in-memory data

C.

To enable data recovery if the power fails

D.

To allow row store operations

Full Access
Question # 21

Which application do you use to reset the memory statistics before you analyze a tenant database using SAP HANA cockpit?

A.

Manage Databases

B.

Manage Services

C.

Resource Directory

D.

Performance Monitor

Full Access
Question # 22

What must you do to configure the data backup on a scale-out SAP HANA system? Note: There are 2 correct answers

A.

Verify that data and log backup destinations are valid throughout the system

B.

Change the backup configuration for each node

C.

Specify the individual backup destination on each node

D.

Ensure the availability of shared backup storage

Full Access
Question # 23

Which file system locations do you need to specify when installing the SAP HANA multi-host database system using the default settings?

There are 2 correct answers to this question.

A.

/hana/shared

B.

/hana/log/

C.

/usr/sap/hostctrl

D.

/usr/sap/

Full Access
Question # 24

Your application runs with a technical user in a database of an SAP HANA multitenant database container. You want to execute a query across tenant databases. Which of the following prerequisites are required? There

are 2 correct answers to this question.

A.

User mapping

B.

User sharing

C.

Communication channel whitelist

D.

Bi-directional communication channels

Full Access
Question # 25

You administer a single-host system with 100GB physical memory. The global allocation limit and the individual service allocation limit are set to 90%. Three services are running-Service 1 has 25 GB of memory

allocated and service 2 has 40 GB allocated. What is the effective allocation limit of service 3?

A.

100 GB

B.

90 GB

C.

35 GB

D.

25 GB

Full Access
Question # 26

The data storage of your productive SAP HANA instance crashed and you need to recover the database. The log storage is still intact. You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old To which point in time you can recover to minimize the data.

A.

the latest incremental backup

B.

the latest log backup

C.

the last full data backup

D.

the last commited transaction

Full Access
Question # 27

Which is the relationship between the user group operators and the user groups? There are 2 correct answers to this question.

A.

Only one user group per user group operator

B.

Only one user group operator per user group

C.

Multiple user groups per user group operator

D.

Multiple user group operators per user group

Full Access
Question # 28

Which file system locations are suggested to install an SAP HANA multi-host system? There are 2 correct answers to this question.

A.

hana/log/

B.

/hana/

C.

/hana/shared

D.

/hana/

Full Access
Question # 29

What are the prerequisites for using the Web user interface for HDBLCM? There are 2 correct answers to this question.

A.

The SAP HANA database is revision 90 or higher

B.

The communication port 1329 is open

C.

Internet Explorer - Version 8 or higher

D.

The communication port 1129 is open

Full Access
Question # 30

After confirming Lock now, which actions are still possible? Choose the correct Answer:.

A.

Releasing and importing transport requests via the Transport Manager (SE09) and Transport Management System (STMS)

B.

88Creating and changing application data (e.g. VA01) and user master records SU01)

C.

Developing via ABAP workbench (SE80)

D.

Applying SAP notes via Note Assistant (SNOTE)

Full Access
Question # 31

Which certificates do you require for a trusted secure communication between the client and the SAP HANA database? Note: There are 2 correct answers.

A.

User certificate

B.

Server certificate

C.

X.509 certificate

D.

Root certificate

Full Access
Question # 32

What is included with the Predictive Analysis Library (PAL)? There are 2 correct answers to this question.

A.

Predictive algorithms

B.

Flowgraphs

C.

Text mining functions

D.

Data preparation functions

Full Access
Question # 33

What do you do to prepare the database migration option of a Software Update Manager procedure? Note: There are 3 correct answers.

A.

Move the SPAM update archive into the download folder

B.

Extract the SAP HANA Client installation archive

C.

Move the stack.xml update file into the download folder

D.

Extract the SAP HANA database installation archive

E.

Move the R3trans update archive into the download folder

Full Access
Question # 34

Which technology does the SAP DBA Cockpit use to store the performance indicators? Please choose the correct answer.

A.

SAP Adaptive Server Enterprise

B.

SAP Business Intelligence

C.

SAP Intelligent Query

D.

SAP Analytics Cloud

Full Access
Question # 35

You migrate an SAP HANA system using SUM database migration option. Which activities do you perform to activate the viewer mode for SAP support? Note: There are 2 correct answers.

A.

Provide the sum observer URL to SAP support

B.

Provide the SUM URL to SAP support

C.

Create the OS user obs on the application server

D.

Create the database user obs on the application server

Full Access
Question # 36

At the end of the SAP HANA Cockpit 2.0 installations, how can you obtain the URL of the SAP HANA cockpit and the SAP HANA cockpit manager?

A.

Installation log file

B.

COCKPIT_ADMIN user logs

C.

Installation logs screen

D.

Installation config screen

Full Access
Question # 37

Your customer asks you to set up alert monitoring in SAP HANA cockpit 2.0. Which alert properties can you configure?

There are 2 correct answers to this question.

A.

Proposed solution

B.

Schedule activation

C.

Threshold values

D.

Check interval

Full Access
Question # 38

The network security policies of your project restrict direct SQL connections to the SAP HANA databases. Which tools can you use to monitor the SAP HANA database? Note: There are 2 correct answers.

A.

SAP Landscape Management

B.

SAP HANA Cockpit

C.

SAP HANA Data Management Suite

D.

SAP Solution Manager

Full Access
Question # 39

How can you shorten the delta merge runtime of a table?

A.

Merge per column

B.

Fully load the delta store into memory

C.

Perform memory-only delta merges

D.

Partition the table

Full Access
Question # 40

Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media? There are 2 correct answers to this question.

A.

Rename the SAP HANA database system.

B.

Uninstall SAP HANA database components.

C.

Update SAP HANA and its components.

D.

Extract components.

Full Access