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

Welcome To DumpsPedia
  1. Home
  2. SAP
  3. SAP Certified Technology Associate
  4. C_HANATEC_17
  5. SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Questions and Answers

C_HANATEC_17 Sample Questions Answers

Questions 4

Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with the read-enabled mode? Note: There are 2 correct answers.

Options:

A.

The same number of active hosts and standby hosts must be installed

B.

Both must have the same SAP HANA version

C.

An explicit read-only connection between both systems must be available

D.

The CPU architecture must be identical

Buy Now
Questions 5

Which certificates can you manage in SAP HANA cockpit 2.0? There are 2 correct answers to this question.

Options:

A.

Kerberos

B.

SAML

C.

PKCS #12

D.

X.509

Buy Now
Questions 6

Which connections do you need to enable explicitly for a Restricted user?

There are 2 correct answers to this question.

Options:

A.

ODBC

B.

JDBC

C.

OLEDB

D.

ADO.NET

Buy Now
Questions 7

USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards. What happens if you drop USER B from the HANA database?

Options:

A.

The privilege remains assigned to both USER A and USER C.

B.

The privilege is revoked from USER A, but not USER C.

C.

The privilege is revoked from both USER A and USER C.

D.

The privilege is revoked from USER C, but not USER A.

Buy Now
Questions 8

Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.

Options:

A.

SLAVE

B.

STANDBY

C.

WORKER

D.

MASTER 1

Buy Now
Questions 9

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

Buy Now
Questions 10

Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system? There are 2 correct answers to this question.

Options:

A.

Migrating to a target database, g. SAP HANA

B.

Performing an SAP software update

C.

Performing a Unicode conversion

D.

Performing a database upgrade of the source database

Buy Now
Questions 11

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 12

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

Buy Now
Questions 13

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 14

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 15

What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases? There are 2 correct answers to this question.

Options:

A.

The cross-tenant database communication must be explicitly activate

B.

The bidirectional communication channel must be whiteliste

C.

The user in the source system must have sufficient privileges in the target database

D.

The user in the source system must be associated with a user in the target database

Buy Now
Questions 16

What can you directly assign to a user with the Manage Users app in SAP HANA cockpit? There are 2 correct answers to this question.

Options:

A.

Role collections

B.

Scopes

C.

Roles

D.

Privileges

Buy Now
Questions 17

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 18

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 19

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 20

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

Buy Now
Questions 21

What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? Please choose

Options:

A.

Metadata Manager and Transaction Manager

B.

Page Management and logge

C.

Column Store and Row Store

D.

Session Management and log Volumes

Buy Now
Questions 22

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 23

Which information is stored in the SYSTEMDB of an SAP HANA multitenant database container system? Note: There are 2 correct answers.

Options:

A.

Topology data on the location of tables and table partitions

B.

Monitoring data in the SYSTEMDB and all tenant databases

C.

Users and authorizations of the SYSTEMDB and all tenant databases

D.

Landscape topology data on the system as a whole

Buy Now
Questions 24

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

Options:

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.

Buy Now
Questions 25

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 26

Which partitioning option distributes rows equally for load balancing in the SAP HANA database?

Options:

A.

RoundRobin

B.

Hash

C.

Range-Range

D.

Range

Buy Now
Questions 27

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 28

Which of the following actions are audited by default in SAP HANA? There are 2 correct answers to this question.

Options:

A.

Deletion of audit entries from the audit trail

B.

Installation of SAP HANA license

C.

Changes to system configuration

D.

Changes to system configuration

E.

Creation, modification or deletion of audit policies

Buy Now
Questions 29

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

Buy Now
Questions 30

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 31

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 32

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

Options:

A.

hana/log/

B.

/hana/

C.

/hana/shared

D.

/hana/

Buy Now
Questions 33

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 34

Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool? There are 3 correct answers to this question.

Options:

A.

Store the logon credentials of the replayer user in the secure store.

B.

Create a replayer user account on the target operating system.

C.

Preprocess the captured workload on the source system.

D.

Restore the source system tenant backup to the target tenant.

E.

Create a replayer user account in the target database system.

Buy Now
Questions 35

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 36

Which tools can you use to start and stop an SAP HANA database? Note: There are 3 correct answers.

Options:

A.

DBA cockpit

B.

SAP HANA application life cycle management (HDBLCM)

C.

HDB command

D.

SAP HANA cockpit

E.

Sapcontrol

Buy Now
Questions 37

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.

Options:

A.

SAP Landscape Management

B.

SAP HANA Cockpit

C.

SAP HANA Data Management Suite

D.

SAP Solution Manager

Buy Now
Questions 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

Buy Now
Questions 39

You must design a high-availability SAP HANA database system with 8 hosts (6 worker and 2 standby) that also uses multitenant database containers. Which rules apply?

There are 2 correct answers to this question.

Options:

A.

The system database must run on the standby host.

B.

The system database instance must run on all hosts (worker and standby).

C.

The tenant databases must be able to be scaled out to all hosts (worker and standby).

D.

The tenant databases must run on the worker hosts.

Buy Now
Questions 40

The SAP HANA database is NOT reachable, and the root cause is unclear. Which SAP HANA cockpit functions allow you to investigate this situation? Note: There are 2 correct answers.

Options:

A.

Troubleshoot unresponsive system

B.

Overall database status

C.

Manage full system information dumps

D.

Open blocked transactions

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