Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dumps65

DumpsWrap Logo

SAP C_HANATEC_17 Dumps

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

You install a productive multi-host system with failover capabilities. Which storage condition prerequisites must be ensured? Note: There are 2 correct answers.

Options:

A.

The standby host has file access

B.

The standby host has NO file access

C.

The failed worker host has access to write files

D.

The failed worker host no lonqer has access to write to files

Question 2

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.

Question 3

Which programming languages are supported when you develop an application on SAP HANA extended application services? Note: There are 2 correct answers.

Options:

A.

Node.js

B.

C++

C.

Lisp.js

D.

ABAP

Question 4

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 5

In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role?

Options:

A.

Indexserve.ini

B.

Nameserver.ini

C.

Multidb.ini

D.

Sapprofile.ini

Question 6

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

Question 7

SAP HANA, in the context of user management, allows you to do which of the following? There are 3 correct answers to this question.

Options:

A.

Create a restricted user

B.

Assign a user to a user group

C.

Create and delete users

D.

Lock and unlock users

Question 8

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 9

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)

Question 10

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

Options:

A.

Merge per column

B.

Fully load the delta store into memory

C.

Perform memory-only delta merges

D.

Partition the table

Question 11

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

Options:

A.

Backup

B.

Data

C.

Log

D.

Pages in-memory

E.

Storage snapshot

Question 12

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 13

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 14

The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question.

Options:

A.

The role name

B.

The privileges assigned to the role

C.

The users assigned to the role

D.

The users assigned by default to this role

Question 15

Which alert configuration properties can you configure in SAP HANA cockpit? There are 3 correct answers to this question.

Options:

A.

Schedule period

B.

Email alert notification

C.

Alert checker category

D.

Alert threshold values

E.

Schedule activation

Question 16

What are the merge methods that are triggered by the SAP HANA system processes? There are 2 correct answers to this question.

Options:

A.

Critical

B.

Auto

C.

Hard

D.

Smart

Question 17

What software innovations did SAP deliver with SAP HANA? There are 2 correct answers to this question.

Options:

A.

Row and Delta store.

B.

Insert only on Column store.

C.

Partitioning.

D.

Compression and Decompression.

Question 18

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 19

Which features are provided by the Manage Full System Information Dumps app in SAP HANA cockpit? There are 2 correct answers to this question.

Options:

A.

Diagnosis information

B.

Runtime environment

C.

End-to-end Trace

D.

SAP HANA minichecks

Question 20

Which prerequisites are necessary for productively using SAP HANA cockpit 2.0?

There are 2 correct answers to this question.

Options:

A.

10 GBit/s network bandwidth

B.

16 GB RAM on a dedicated server

C.

An intel-based system with operating system Microsoft Windows

D.

An IBM Power System with operating system SUSE Linux Enterprise Server (SLES)

Question 21

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

Question 22

You needt to integrate an existing SAP HANA2.0 SPS05 database system into the SAP HANA cockpit monitor infrastructure. Where do you create the technical user needed for the resource registration?

Options:

A.

In the first tenant

B.

In the SYSTEMDB and all tenants

C.

In the SYSTEMDB and the first tenant

D.

In the SYSTEMDB

Question 23

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 24

Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store? There are 2 correct answers to this question.

Options:

A.

SAP HANA tenant database replication

B.

Internal communication channels with the system PKI

C.

HTTPS client access using the SAP HANA Web Dispatcher

D.

Client-server communication over JDBC

Question 25

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?

Options:

A.

Installation log file

B.

COCKPIT_ADMIN user logs

C.

Installation logs screen

D.

Installation config screen

Question 26

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 27

Which SQL privileges can you grant to another user?

Options:

A.

CREATE SCHEMA

B.

ATTACH DEBUGGER

C.

DATA ADM IN

D.

CATALOG READ

Question 28

In which scenario do you need SAP expert sizing? There are 2 correct answers to this question.

Options:

A.

Customers want to migrate their existing SAP NetWeaver-based systems to run on SAP HANA

B.

Consolidating multiple ERP source systems into one ERP system on SAP HANA

C.

Carving out ERP functionality from the source system to the ERP on SAP HANA system.

D.

Customers are new to SAP applications and SAP HANA

Question 29

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

Question 30

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

Options:

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)

Question 31

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 32

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

Question 33

What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answers to this question.

Options:

A.

Having the data and log volumes on the different disks.

B.

Obtaining the hardware certification from SAP for the existing hardware you are going to use.

C.

Obtaining C_HANATEC_XX Certification.

D.

Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connectivity.

Question 34

You plan to set up an SAP HANA2.0 system on intel-based hardware platform. Which of the following operating systems can you use Note: There are 2 correct answers.

Options:

A.

Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 7.2

B.

SUSE Linux Enterprise Server (SLES) for SAP Applications 12 SP1

C.

SUSE Linux Enterprise Server (SLES) for SAP Applications 11 SP1

D.

Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 6.5

Question 35

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 36

What are advantages of column store tables? There are 3 correct answers to this question.

Options:

A.

Columns can be partitioned

B.

Only the columns required are actually loaded to memory

C.

They are optimized for high-volume read /write transactional processing

D.

Data footprint is automatically reduced through compression

Question 37

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 38

Which system privilege must you have to manage black listed parameters in SAP HANA cockpit? Please choose the correct answer.

Options:

A.

DATABASE ADMIN

B.

WORKLOAD ADMIN

C.

INIFILE ADMIN

D.

RESOURCEADMIN

Question 39

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 40

How can you optimize the Database Migration Option (DMO) procedure downtime for a production system? There are 2 correct answers to this question.

Options:

A.

Provide the measured table migration duration data for optimal table sequencing during benchmarking.

B.

Set the optimal number of R31oad processes during benchmarking and the DMO procedure

C.

Use the Test Cycle opt on to find the optimal number of R31oad processes in a test run.

D.

Use the benchmarking option to find the optimal throughput during the DMO procedure.

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