Valentine Day Sale - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

SAP C_HANATEC_17 Dumps

Page: 1 / 10
Total 270 questions

SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Questions and Answers

Question 1

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

Options:

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

Question 2

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

Options:

A.

System availability

B.

Alerts count

C.

Thread status

D.

CPU utilization

Question 3

Which default users will be created during the installation of the SAP HANA database system? There are 2 correct answers to this question.

Options:

A.

crypt

B.

sap

C.

Idapadm

D.

sapadm

Question 4

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

Question 5

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.

Question 6

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

Question 7

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

Question 8

Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? There are 2 correct answers to this question.

Options:

A.

The source and target database system are of the same type

B.

The Primary Application Server can be moved to a target system Landscape

C.

The target database is SAP Adaptive Server Enterprise (ASE)

D.

The source system is Application Server (AS) Java-base

Question 9

What additional action do you need to perform after you created a new tenant in an SAP HANA system replication configuration? Please choose the correct answer.

Options:

A.

Back up tenant database

B.

Copy tenant database.

C.

Start tenant database.

D.

Restart secondary system.

Question 10

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

Question 11

You need to analyze the high CPU load of running thread in more detail in the Thread Monitor. Which parameters do you need to change? Note: There are 2 correct answers.

Options:

A.

threshold_cpu_time

B.

cpu_time_measurement_mode

C.

load_monitor_granularity

D.

enable_tracking

Question 12

Which tool shows you information about the list of tables to be pre-loaded during an SAP HANA system start?

Please choose the correct answer.

Options:

A.

hdbcons

B.

RecoverStateCheckerpy

C.

sap control

D.

HDBAdmin

Question 13

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

Question 14

The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the SAP HANA database request additional memory?

Options:

A.

Standby memory

B.

Physical memory

C.

Resident memory

D.

Virtual memory

Question 15

Which of the following users are able to start and stop a distributed SAP HANA Database System? There are 2 correct Answers to this question.

Options:

A.

ROOT user

B.

ADM user

C.

SYSTEM user

Question 16

Where is the name server running in a multitenant database container system? Please choose the correct answer.

Options:

A.

Standby node

B.

Master node

C.

SYSTEMDB

Question 17

How do you trigger a savepoint in an SAP HANA database?

Options:

A.

Execute a delta merge

B.

Commit a transaction

C.

Start a log backup

D.

Perform a soft shutdown

Question 18

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

Question 19

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

Options:

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

Question 20

Which technology is used to install the SAP Landscape Management tool?

Please choose the correct answer.

Options:

A.

SAP NetWeaver Application Server for ABAP

B.

SAP Fiori launchpad

C.

SAP NetWeaver Application Server for Java

D.

SAP HANA XS advanced runtime

Question 21

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

Options:

A.

By a database soft shutdown.

B.

By issuing a transactional commit.

C.

By performing a delta merge.

D.

By performing a database backup.

Question 22

Out of complete SAP HANA platform, which from the following components are not part of SAP HANA Database? There are 3 correct answers to this question.

Options:

A.

HWCCT

B.

Database Services

C.

Smart Data Access

D.

INA file loader

E.

EPM Services

Question 23

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

Question 24

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

Question 25

You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database. From which location does the Recover Database app read the recovery information by default?

Options:

A.

$(DIR_INSTANCE)//trace

B.

$(DIR_INSTANCE)/backup/data

C.

$(DIR_INSTANCE)/../global/hdb/custom/config

D.

$(DIR_INSTANCE)/backup/log

Question 26

What do you require to perform a migration using the SUM database migration option? Note: There are 2 correct answers.

Options:

A.

OS/DB certified consultant

B.

Migration check Services

C.

Migration key

D.

Stack.xml file

Question 27

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

Question 28

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

Question 29

What happens when you rename a tenant in an SAP HANA database Note: There are 2 correct answers.

Options:

A.

The database is renamed

B.

The directories are renamed

C.

The backups are renamed

D.

The logs are renamed

Question 30

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

Question 31

Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? Please choose the correct answer.

Options:

A.

The R3LDCTL

B.

The Process Bucket monitor

C.

The Log viewer

D.

The Observer Monitor

Question 32

Which information is provided via the SUM Ul? There are 3 correct answers to this question.

Options:

A.

The active roadmap step

B.

The content of log files via the log viewer

C.

The memory consumption of SUM

D.

A progress bar for the overall procedure

Question 33

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

Question 34

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

Question 35

How can you use the results from a comparable the run to optimize the database migration option (DMO) procedure downtime for a production system?

There are 2 correct answers to this question.

Options:

A.

Use the Test Cycle option to determine the optimal number of R3load processes.

B.

Use the UPGANA.XML analysis file to optimize the number of R3load processes.

C.

Use the MIGRATE_DT_DUR.XML file to optimize table splitting and migration sequence.

D.

Use the MIGRATE_SOT_DUR.XML file to manually optimize table splitting of large tables.

Question 36

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.

Question 37

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

Question 38

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

Question 39

Why are repository roles preferred over catalog roles? Note: There are 2 correct answers.

Options:

A.

They are created by the technical user

B.

They are revoked if the database user that granted them is deleted.

C.

They are transportable runtime objects

D.

They are transportable design-time objects

Question 40

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

Options:

A.

Modeling

B.

Monitoring

C.

Repository

D.

Runtime

Page: 1 / 10
Total 270 questions