New Year Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. SAP
  3. SAP Certified Technology Associate
  4. C_HANATEC_17 - SAP Certified Technology Associate - SAP HANA 2.0 SPS05

SAP C_HANATEC_17 SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Exam Practice Test

Page: 1 / 27
Total 270 questions
Get C_HANATEC_17 Full Access Download C_HANATEC_17 PDF

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

Question 1

Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question.

Options:

A.

Set the password for the system database user.

B.

Create an operating system user for the converted tenant database.

C.

Trigger the conversion in the SAP HANA cockpit 2.0.

D.

Generate the system database before the conversion.

Question 2

What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario? There are 3 correct Answers to this question.

Options:

A.

SAP Application Performance Standard (SAPS)

B.

Network throughput

C.

Input/output operations per second (IOPS)

D.

Main memory

E.

Persistent storage

Question 3

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.

Options:

A.

/hana/shared

B.

/hana/log/

C.

/usr/sap/hostctrl

D.

/usr/sap/

Question 4

Which of the following are characteristics of SAP HANA Smart Data Streaming?

Options:

A.

It provides reports and analysis on the received data.

B.

It is a standalone product for use with any target system.

C.

It acts based on combinations of events.

D.

It uses databases queries.

Question 5

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

Question 6

Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with secondary time travel? There are 2 correct answers to this question.

Options:

A.

The CPU architecture must be identical.

B.

An explicit read-only connect on between both systems must be available

C.

Both must have the same SAP HANA version.

D.

Both systems are located in the same data center.

Question 7

Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer.

Options:

A.

_SYS_WORKLOAD_REPLAY

B.

_SYS_STATISTICS

C.

_SYS_SQL_ANALYZER

D.

_SYS_TELEMETRY

Question 8

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

Options:

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

Question 9

Who owns an SAP HANA Deployment Infrastructure (HDI) role? Please choose the correct answer.

Options:

A.

The SYSTEM user of the tenant database

B.

The user who created the role

C.

The _SYS_REPO technical user

D.

The container-specific technical user

Question 10

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.

Question 11

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

Question 12

Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app?

There are 2 correct answers to this question.

Options:

A.

Daemon

B.

Preprocessor

C.

Index server

D.

Compile server

Question 13

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 14

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

Question 15

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 16

Which actions are performed during the database migration option (DMO) procedure when you select the 'Do not compare table contents' option?

There are 2 correct answers to this question.

Options:

A.

A row count is executed for the migrated tables.

B.

The content comparison is performed for repository tables.

C.

A check sum is generated every 10000 rows.

D.

The clustered tables are decluttered.

Question 17

In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? There are 2 correct answers to this question.

Options:

A.

When the log buffer is full.

B.

When the time threshold is exceeded.

C.

When the log segment is full.

D.

When a commit occurs.

Question 18

What are some of the characteristics of the design-time role? There are 3 correct answers to this question.

Options:

A.

The role can be transported between systems.

B.

The role is revoked if the grantee user is deleted.

C.

The role is granted and revoked directly by the database user.

D.

The role is created by technical user _SYS_REPO.

E.

The role is granted through the execution of stored procedures.

Question 19

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 20

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 21

A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer.

Options:

A.

recover the system database and the affected tenant with the initialize log area option

B.

restore the database and recover the affected tenant upto moment of the problem

C.

recover the affected tenant upto moment of the problem

D.

recover the affected tenant with the initialize log area option

Question 22

Reloading column tables in this way restores the database to a fully operational state more quickly. However, it does create performance overhead, and may not be necessary in nonproductive systems, how can you

deactivate the the reload feature? Please choose the correct answer.

Options:

A.

Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false

B.

Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false

C.

Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to true

D.

Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false

Question 23

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

Options:

A.

To persist in-memory data

B.

To ensure maximum performance

C.

To enable database scale-up

D.

To allow a restart if the power fails

Question 24

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

Options:

A.

Manage Databases

B.

Manage Services

C.

Resource Directory

D.

Performance Monitor

Question 25

Which of the following tools can be used for User Administration? There are 3 correct Answers to this question.

Options:

A.

SAP NetWeaver Identity Management

B.

hdbsql

C.

Resident hdblcm

D.

SAP HANA Cockpit

Question 26

SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason. Which parameters do you adjust to manage the event log? There are 2 correct answers to this question.

Options:

A.

max_queue_size

B.

queue_wait_time_threshold

C.

record_limit

D.

queue_timeout

Question 27

What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? There are 2 correct answers to this question.

Options:

A.

Kernel settings

B.

Network configuration

C.

Memory configuration

D.

Missing OS patches

Question 28

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 29

Where is SDI used? There are 2 correct answers to this question.

Options:

A.

Data transformation

B.

Data cleansing

C.

Data streaming

D.

For data loading

Question 30

Which of the following privileges allow read access to data in SAP HANA information models depending on certain values or combination of values?

Options:

A.

Object Privileges

B.

Analytic Privileges

C.

System Privileges

D.

Package Privileges

Question 31

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.

Question 32

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

Question 33

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

Question 34

In the General Licensing Process which of the following statements are true regarding Temporary license keys?

There are 2 correct answers to this question.

Options:

A.

Temporary license keys are manually installed by the SAP HANA system

B.

Temporary license keys are automatically installed by the SAP HANA system

C.

After 28 days, the temporary license expires and the system is locked down

D.

After 90 days, the temporary license expires and the system is locked down

Question 35

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

Question 36

Which user credentials are requested during the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to an SAP HANA 2.0 database tenant? There are 3 correct answers to this question.

Options:

A.

The DBACOCKPIT user of the tenant database

B.

The S-user for the SAP Support Portal connection

C.

The SYSTEM user of the system database

D.

The DDIC user in client 000 of the A BAP system

E.

The SAP user in client 000 of the ABAP system

Question 37

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

Options:

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

Question 38

You are checking and monitoring SAP HANA system replication. Which status indicates a temporary connection loss of the secondary system?

Please choose the correct answer.

Options:

A.

Syncing

B.

Error

C.

Initializing

D.

Unknown

Question 39

Which tools can you use to monitor the response time of individual SQL queries? Note: There are 2 correct answers.

Options:

A.

SQL Trace

B.

Statement Monitor

C.

SQL plan cache

D.

Thread Monitor

Question 40

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

Options:

A.

CPU usage monitor

B.

Troubleshoot unresponsive system

C.

Full system information dump

D.

Out-of-memory event monitor

Load More C_HANATEC_17 Questions 
Page: 1 / 27
Total 270 questions
Get C_HANATEC_17 Full Access Download C_HANATEC_17 PDF