Summer Special Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia

C_HANATEC_17 Sample Questions Answers

Questions 4

Which backup scenarios are allowed in multitenant database containers? Note: There are 2 correct answers.

Options:

A.

The system database can initiate its own backup and the backup of tenant databases

B.

A backup of a tenant database can be recovered to an SAP HANA single-container system

C.

The system database should be recovered first in order to recover the tenant databases

D.

A tenant database can initiate its own backup unless this is prohibited by the system configuration

Buy Now
Questions 5

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.

Options:

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

Buy Now
Questions 6

What is the correct sequence of the following four steps in the restart of the SAP HANA database system? Please choose the correct answer.

Options:

A.

Aborted transactions are rolled back. 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded.

B.

Aborted transactions are rolled back.

C.

Row tables are loaded into memory. 3. Open transactions are recovered. 4. Column tables are loaded.

D.

Row tables are loaded into memory. 2. Column tables are loaded. 3. Open transactions are recovered. 4. Aborted transactions are rolled back.

E.

Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded.

Buy Now
Questions 7

Which products do you use for SAP HANA administration? There are 2 correct answers to this question.

Options:

A.

SAP Solution Manager

B.

SAP Web IDE for SAP HANA

C.

SAP HANA cockpit

D.

SAP Master Data Governance

Buy Now
Questions 8

You created a restricted user in the DB1 database. Which commands must you use to convert the restricted SAP HANA user to a standard SAP HANA user? There are 3 correct answers to this question.

Options:

A.

ALTER USER GRANT ROLE PUBLIC

B.

ALTER USER ENABLE CLIENT CONNECT

C.

ALTER USER ACTIVATE USER NOW

D.

ALTER USER GRANT CREATE ANY ON OWN SCHEMA

E.

ALTER USER ADD REMOTE IDENTITY

Buy Now
Questions 9

Which tool do you use to backup the root encryption keys?

Options:

A.

rsecssfx

B.

hdbuserstore

C.

dbacockpit

D.

hdbnsutil

Buy Now
Questions 10

Which of the following elements are valid rules for the location of the backup files? There are 3 correct answers to this question.

Options:

A.

The Volume ID is automatically added to a specified file name.

B.

The backup files should never be in the same directory and on the same file system as u data.

C.

The backup ID is unique for each persistence only.

D.

The backup folder will be created automatically when the backup process is started.

Buy Now
Questions 11

What can a user do when the backup operator system privileges is assigned?

Options:

A.

Perform data recovery

B.

Schedule backups

C.

Delete backups

D.

Configure backup settings

Buy Now
Questions 12

How can the system database administrator disable tenant database functionalities? Please choose the correct answer.

Options:

A.

Using the hdbuserstore tool

B.

Using the resident hdblcm tool

C.

Using the Manage Restricted Features app

D.

Using the Manage Blacklisted Parameter app

Buy Now
Questions 13

Which removal statuses allow you to remove a host from an SAP HANA scale-out landscape Note: There are 2 correct answers.

Options:

A.

Reorg not required

B.

Reorg pending

C.

Reorg finished

D.

Reorg active

Buy Now
Questions 14

Which information is recorded in the database trace of the SAP HANA database?

Options:

A.

Executed SQL statements on database level

B.

Performance indicators on a query level

C.

Database activities with the trace level ERROR

D.

Query execution plans on an application level

Buy Now
Questions 15

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.

Options:

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.

Buy Now
Questions 16

You need to periodically monitor if the SAP HANA primary system is online. Which tool do you use?

Options:

A.

systemreplicationStatus

B.

HDBAdmin

C.

hanasitter

D.

landscapeHostConfiguration

Buy Now
Questions 17

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

Options:

A.

User certificate

B.

Server certificate

C.

X.509 certificate

D.

Root certificate

Buy Now
Questions 18

Which fault recovery features can you implement to make your SAP HANA 2.0 production system more resilient against local hardware errors and software faults? There are 2 correct answers to this question.

Options:

A.

Service auto-restart

B.

Storage replication

C.

Host auto-failover

D.

Auto log backups

Buy Now
Questions 19

The recovery of your productive SAP HANA database fails during log replay. What is the fastest solution to complete the recovery.

Options:

A.

Restart the database and resume the interrupted recovery

B.

Resume the recovery from beginning

C.

Resume the interrupted recovery

D.

Replay the delta backups and log backups

Buy Now
Questions 20

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.

Options:

A.

Proposed solution

B.

Schedule activation

C.

Threshold values

D.

Check interval

Buy Now
Questions 21

Which system privilege must you have to restrict features for tennant databases in the SAP HANA cockpit?

Please choose the correct answer.

Options:

A.

INFILE ADMIN

B.

WORKLOAD ADMIN

C.

DATABASE ADMIN

D.

RESOURCE ADMIN

Buy Now
Questions 22

Which value for the Autostart parameter do you use to control the automatic start of an SAP HANA system? Please choose the correct answer.

Options:

A.

On

B.

0

C.

Off

D.

1

Buy Now
Questions 23

You plan to migrate a non-SAP database to SAP HANA using the database migration option (DMO) of the Software Update Manager. Which advanced DMO options can you adjust to speed up the migration? There are 2

correct answers to this question.

Options:

A.

SAPup processes

B.

TP processes

C.

SQL processes

D.

R3trans processes

Buy Now
Questions 24

Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?

Options:

A.

DBA Cockpit

B.

hdblcm

C.

hdbsql

D.

SAP HANA cockpit

Buy Now
Questions 25

How are user group administrators and user groups related?

There are 2 correct answers to this question.

Options:

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

Buy Now
Questions 26

Which best practices do you apply when you optimize the table distribution in a scale-out SAP HANA database?

There are 2 correct answers to this question.

Options:

A.

Table partitions can be distributed over all nodes.

B.

The row store can be distributed over all nodes.

C.

Cross-node joins must be avoided.

D.

The columns of a table can be distributed over all nodes.

Buy Now
Questions 27

When can you load and unload individual tables and table columns manually in an SAP HANA tenant database? There are 2 correct answers to this question.

Options:

A.

When you need to extend the scale-out memory

B.

When you need to optimize the standby node memory.

C.

When you need to measure total memory

D.

When you need to actively free up memory.

Buy Now
Questions 28

Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? There are 2 correct answers to

Options:

A.

Keep all partitions on different hosts.

B.

Keep the number of partitions per table high.

C.

Keep the number of partitioned tables low.

D.

Keep the number of key columns low.

Buy Now
Questions 29

Which script can you trigger from SAP HANA cockpit to collect diagnosis information?

Options:

A.

HanaHwCheck.py

B.

fullSystemlnfoDump.py

C.

hanachecker.py

D.

hanadumpviewer.py

Buy Now
Questions 30

In which replication mode is the primary system blocked until the secondary system is available?

Options:

A.

syncmem

B.

full sync

C.

async

D.

sync

Buy Now
Questions 31

Which file systems are supported for the SAP HANA database system? There are 2 correct answers to this question.

Options:

A.

GPFS

B.

EXT3

C.

MPFS

D.

Dxfs

Buy Now
Questions 32

Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)? There are 3 correct answers to this question.

Options:

A.

Validation of the operating system configuration settings for the Linux kernel

B.

Measurement of the data throughput between CPU and DRAM

C.

Validation of the LPAR configuration settings on IBM Power servers

D.

Measurement of data throughput between SAP HANA nodes and storage

E.

Measurement of data throughput between the Linux kernel and CPU

Buy Now
Questions 33

You need to recover a tenant database backup from SAP HANA system 1 into SAP HANAsystem2. Which activities do you perform to restore the tenant? Note: There are 2 correct answers.

Options:

A.

Create the tenant in the target database

B.

Recover the tenant with the Initialize Log Area option

C.

Copy the transaction logs to the target database

D.

Start the recovered tenant database

Buy Now
Questions 34

Which activity must you perform before you can replay a workload using the Capture and Replay Application? Note: There are 2 correct answers.

Options:

A.

Restore the source tenant backup into the target tenant

B.

Start the replayer on the source system

C.

Create the replayer user in the control system

D.

Create a secure store key on the control system host

Buy Now
Questions 35

Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag This page displays the detailed status of the selected SAP HANA system. Which of the

following options are listed? There are 3 correct answers to this question.

Options:

A.

Monitoring and Administration

B.

Performance Management

C.

Resource Management

D.

Security

E.

Memory Management

Buy Now
Questions 36

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.

Options:

A.

hdb back int

B.

hdb backup diag

C.

hdb recover check

D.

hdb backup check

Buy Now
Questions 37

Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server? There are 2 correct answers to this question.

Options:

A.

User mapping

B.

User creation

C.

Password policy configuration

D.

Role assignment

Buy Now
Questions 38

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

Options:

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

Buy Now
Questions 39

Which tools are integrated into the SAP HANA cockpit?

There are 3 correct answers to this question.

Options:

A.

Database Explorer

B.

HANA Sitter

C.

SQL Console

D.

SQL Analyzer

E.

HDB Admin

Buy Now
Questions 40

Which parameter do you set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory? There are 2 correct answers to this question.

Options:

A.

memory_tracking

B.

statement_memory_limit

C.

reject_memory_threshold

D.

total_statement_memory_limit

Buy Now
Questions 41

Which information can you collect by running the fullSystemlnfoDump.py script when the SQL connection is available? Please choose the correct Answer:.

Options:

A.

A selection of rows of schema _SYS_XS

B.

A selection of .log files

C.

A selection of .trc files

D.

A selection of rows of schema SAP

Buy Now
Questions 42

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 can you recover to minimize the data loss? Please choose the correct answer.

Options:

A.

The last full data backup

B.

The latest log backup

C.

The latest incremental backup

D.

The last commited transaction

Buy Now
Questions 43

Which information can you analyze using the Troubleshoot Unresponsive System application?

Options:

A.

System availability

B.

Alerts count

C.

Thread status

D.

CPU utilization

Buy Now
Questions 44

Which actions take place during a database migration option (DMO) procedure when performing an in-place migration?

There are 2 correct answers to this question.

Options:

A.

One table is migrated per R3load pair.

B.

TABART is considered for the creation of R3load control files.

C.

SAP up decides which tables to split.

D.

De-pooling of tables is done during the procedure.

Buy Now
Questions 45

logical error occurred in one tenant of your SAP HANA database. What action do you perform to make the tenant consistent again? Please choose the correct Answer:

Options:

A.

Recover the affected tenant. The system database is NOT recovered.

B.

Recover the system database first and then recover the affected tenant.

C.

Recover the affected tenant first and then recover the system database.

D.

Recover the system database. The affected tenant is recovered automatically.

Buy Now
Questions 46

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

Options:

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

Buy Now
Questions 47

How can you perform a complete back up of an SAP HANA database system? Please choose the correct answer.

Options:

A.

Back up the system database and all tenant databases individually.

B.

Back up the system database and all tenant databases in one step.

C.

Back up the complete database system.

D.

Backup the complete storage system.

Buy Now
Questions 48

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

Options:

A.

Rename the SAP HANA database system.

B.

Uninstall SAP HANA database components.

C.

Update SAP HANA and its components.

D.

Extract components.

Buy Now
Questions 49

Which hardware KPIs do you need to size before performing a tailored data center integration (TDI) installation for a productive SAP HANA database system?

There are 2 correct answers to this questions.

Options:

A.

DRAM required for the static data memory area

B.

Persistent memory (PMEM) required for backups

C.

Total disk space required for the log volume

D.

Network bandwidth for the storage zone

Buy Now
Questions 50

A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0. Which system privileges do you assign to the technical user account on the target system?

Options:

A.

CATALOG READ

B.

DATA ADMIN

C.

MONITOR ADMIN

D.

USER ADMIN

Buy Now
Questions 51

How can you minimize the database migration option (DMO) downtime?

Options:

A.

Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3load processes

B.

Use the benchmarking tool for a productive database migration with the DMO procedure

C.

Provide the measured table migration duration for table sequencing during benchmarking

D.

Adjust the number of R3load processes during benchmarking and the DMO procedure

Buy Now
Questions 52

What is a prerequisite when you install the SAP Landscape Management tool? Please choose the correct answer.

Options:

A.

SAP HANA XS Advanced

B.

SAP NetWeaver Application Server Java

C.

SAP Fiori launchpad

D.

SAP NetWeaver Application Server ABAP

Buy Now
Questions 53

After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?

Options:

A.

It determines and rolls forward aborted transactions

B.

It rolls back write transactions that were open when the database was stopped

C.

It reloads a savepoint with the restored consistent state of the database

D.

It rolls back changes of committed transactions that were NOT written to the data area

Buy Now
Questions 54

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.

Options:

A.

User mapping

B.

User sharing

C.

Communication channel whitelist

D.

Bi-directional communication channels

Buy Now
Questions 55

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

Options:

A.

SAP Adaptive Server Enterprise

B.

SAP Business Intelligence

C.

SAP Intelligent Query

D.

SAP Analytics Cloud

Buy Now
Questions 56

Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.

Options:

A.

Cockpit User Administrator

B.

Cockpit User

C.

Cockpit Resource Administrator

D.

Cockpit Administrator

Buy Now
Questions 57

Which of the following tasks can you perform using the resident SAP HANA database lifecycle manager (HDBLCM)? Note: There are 3 correct answers.

Options:

A.

Rename the SAP HANA Database hostname

B.

Remove host roles

C.

Transport application changes

D.

Rename the SAP HANA database system

E.

Uninstall the individual components

Buy Now
Questions 58

You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one productive system. Which of the following installation requirements are mandatory? There are 2 correct answers to this question.

Options:

A.

The system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.

B.

The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.

C.

The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

D.

The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

Buy Now
Questions 59

Due to a hardware failure of your persistence area, your SAP HANA database needs to be restored. Which tasks do you perform to recover the complete system? Note: There are 2 correct answers.

Options:

A.

Start the recovery from the tenant database using SAP HANA cockpit 2.0

B.

Recover all the databases using Initialize Log Area option

C.

Recover the system database before recovering all tenant databases

D.

Start the recovery from the system database SAP HANA cockpit 2.0

Buy Now
Questions 60

Which of the following events occur while the merge operation is running? There are 2 correct answers to this question.

Options:

A.

The content of the first main storage and the committed entries in the first delta storage are merged into the new second main storage.

B.

The content of the complete main storage is persisted to disk.

C.

Uncommitted changes in the first delta storage are rolled back.

D.

All write operations go to the second delta storage.

Buy Now
Questions 61

Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question

Options:

A.

Preprocessor

B.

XS Engine

C.

Index server

D.

Compile server

Buy Now
Questions 62

Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?

Please choose the correct answer.

Options:

A.

SQL

B.

User-Specific

C.

End-to-End

D.

Kernel profiler

Buy Now
Questions 63

Which update methods can yo use to minimize the business downtime during the upgrade of an SAP HANA database? Note: There are 2 correct answers.

Options:

A.

Near Zero Downtime

B.

Database migration options of SUM

C.

Export/import using SAP Provisioning Manager

D.

Phases update

Buy Now
Questions 64

What is the correct sequence of the following four steps when you restart the SAP HANA database system?

Please choose the correct answer.

Options:

A.

1. Row tables are loaded into memory.

2. Open transactions are recovered.

3. Aborted transactions are rolled back.

4. Column tables are loaded.

B.

1. Aborted transactions are rolled back.

2. Open transactions are recovered.

3. Row tables are loaded into memory.

4. Column tables are loaded.

C.

1. Row tables are loaded into memory.

2. Column tables are loaded.

3. Open transactions are recovered.

4. Aborted transactions are rolled back.

D.

1. Aborted transactions are rolled back.

2. Row tables are loaded into memory.

3. Open transactions are recovered.

4. Column tables are loaded.

Buy Now
Questions 65

Your SAP HANA database is locked down. Which action can you still perform?

Options:

A.

Check database license

B.

Check overall database status

C.

Check session memory

D.

Configure system properties

Buy Now
Questions 66

Which kinds of patches are available in the SAP HANA2.0 revision strategy? Note: There are 2 correct answers.

Options:

A.

Feature Package Stack

B.

Datacenter Service Point

C.

Support Package

D.

Support Package Stack

Buy Now
Questions 67

Which table partitioning types does SAP HANA support? There are 3 correct answers to this question.

Options:

A.

Hash

B.

Composite

C.

Range

D.

Round-robin

E.

Cluster

Buy Now
Questions 68

Which tool do you use to investigate an SAP HANA system that is started but can't be reached using SQL? There are 2 correct answers to this question.

Options:

A.

HANASitter

B.

hdbcons

C.

HDBAdmin

D.

Sapcontrol

Buy Now
Questions 69

What is the minimum space requirement for the Data Volume? There are 2 correct answers to this question.

Options:

A.

3 * RAM (Appliance)

B.

1.2 * RAM (TDI)

C.

Min. 1 * RAM

D.

Min. 0.5 * RAM

Buy Now
Questions 70

Which system privilege must you have to redistribute tables across the hosts in your scale-out system?

Options:

A.

OPTIMIZER ADMIN

B.

DATA ADMIN

C.

WORKLOAD ADMIN

D.

RESOURCE ADMIN

Buy Now
Questions 71

Which characteristics describe an SAP HANA Multiple Database Container (MDC) System?

There are 3 correct answers to this question.

Options:

A.

Each tenant database runs its own compile server and the preprocessor server.

B.

Database Isolation increases the isolation between tenant databases on the operating system level.

C.

A Multitenant Database Container system is identified by a single System ID (SID).

D.

The name server owns information about the location of tables and table partitions in databases.

E.

The name server provides index server functionality for the system database.

Buy Now
Questions 72

Which SAP recommendations do you follow to create an optimal table partitioning plan for SAP Business Suite powered by SAP HANA? Note: There are 2 correct answers.

Options:

A.

Have a high number of partitions per table

B.

Have a low number of keys

C.

Have partitions of a table on the same host

D.

Have a high number of partitioned tables

Buy Now
Questions 73

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?

Options:

A.

SAP HANA Infrastructure Services

B.

SAP HANA Enterprise Cloud

C.

SAP HANA AppServices

D.

SAP HANA DBServices

Buy Now
Questions 74

How can you ensure that a consistent database status is saved using data snapshots? Please choose the correct answer.

Options:

A.

Trigger a save point.

B.

Create a fullback snapshot.

C.

Create an internal database snapshot.

D.

Execute the hdbbackupdiag tool.

Buy Now
Questions 75

Which system privileges do you require to view roles that are granted to other users? Note: There are 2 correct answers.

Options:

A.

CATALOG READ

B.

USER ADMIN

C.

DATA ADM IN

D.

ROLE ADMIN

Buy Now
Questions 76

You need to update the location where a copy of the persistent data is saved. Which of the following parameters do you change? Note: There are 2 correct answers.

Options:

A.

basepathjogmirror

B.

basespath_export

C.

basepathjogbackup

D.

basepath_databackup

Buy Now
Questions 77

What can you use the Secure User Store (hdbuserstore) for? There are 2 correct answers to this question.

Options:

A.

To store connection information on the SAP HANA XS Advanced engine

B.

To configure failover supporting a 3-tier scenario

C.

To configure an SAP HANA Auto-Restart Fault Recovery Support

D.

To store connection information on the SAP HANA database client

Buy Now
Questions 78

You need to set up an SAP HANA system where several companies share the same SAP HANA instance. You have to provide each company a dedicated share of the instance for its data, configuration and

user management. Which deployment scenario do you use?

Options:

A.

Multiple Components on One Database (MCOD)

B.

Multitenant database containers (MDC)

C.

Technical co-deployment (TCD)

D.

Multiple Components on One System (MCOS)

Buy Now
Questions 79

Which properties can you adjust in SAP HANA Admission Control? There are 3 correct answers to this question.

Options:

A.

CPU threshold for rejecting new requests

B.

Memory threshold for queuing new request

C.

Memory limits for new SQL statement requests

D.

Maximum queue size for requests

E.

Maximum number of parallel request

Buy Now
Questions 80

Which actions are always recorded when auditing is active? Note: There are 2 correct answers.

Options:

A.

Disable auditing

B.

Grant or revoke user

C.

Modification of an audit policy

D.

Create or drop user

Buy Now
Questions 81

Which tools do you use to delete diagnosis files? There are 2 correct answers to this question.

Options:

A.

SAP HANA Web-based Development Workbench

B.

SAP HANA cockpit

C.

SAP HANA cleaner

D.

SAP HANA database explorer

Buy Now
Exam Code: C_HANATEC_17
Exam Name: SAP Certified Technology Associate - SAP HANA 2.0 SPS05
Last Update: Jun 19, 2024
Questions: 270
$64  $159.99
$48  $119.99
$40  $99.99
buy now C_HANATEC_17