March Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 2493360325

Good News !!! C_HANATEC_17 SAP Certified Technology Associate - SAP HANA 2.0 SPS05 is now Stable and With Pass Result

C_HANATEC_17 Practice Exam Questions and Answers

SAP Certified Technology Associate - SAP HANA 2.0 SPS05

Last Update 14 hours ago
Total Questions : 270

C_HANATEC_17 is stable now with all latest exam questions are added 14 hours ago. Just download our Full package and start your journey with SAP Certified Technology Associate - SAP HANA 2.0 SPS05 certification. All these SAP C_HANATEC_17 practice exam questions are real and verified by our Experts in the related industry fields.

C_HANATEC_17 PDF

C_HANATEC_17 PDF (Printable)
$48
$119.99

C_HANATEC_17 Testing Engine

C_HANATEC_17 PDF (Printable)
$56
$139.99

C_HANATEC_17 PDF + Testing Engine

C_HANATEC_17 PDF (Printable)
$70.8
$176.99
Question # 1

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

Discussion 0
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

Discussion 0
Question # 3

What must you do to convert an SAP HANA 1.0 single database system to an SAP HANA 2.0 multitenant database system?

Options:

A.  

Export/import application and customer data

B.  

Upgrade the SAP HANA database system

C.  

Execute the SUM database migration option with system move

D.  

Create the system database manually

Discussion 0
Question # 4

In single-host SAP HANA systems, you can use plain attached storage devices, such as Small Computers System Interface hard drives, solid-state drives (SSDs), or storage area networks (SANs).

However, to build a multi-host system with failover capabilities, the storage must ensure which of the following conditions?

There are 2 correct answers to this question.

Options:

A.  

SYSTEM users replaced by standby host

B.  

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

C.  

The standby host has file access

D.  

The standby host has access to write to files

Discussion 0
Question # 5

Which backup types you can schedule using SAP Hana cockpit 2.0. There are 2 correct answers to this question.

Options:

A.  

Delta Backup

B.  

Backup of Configuration files

C.  

Data Backup

D.  

Data Snapshot

Discussion 0
Question # 6

Which role do you need in order to assign users to groups in the SAP HANA cockpit?

Please choose the correct answer.

Options:

A.  

Cockpit User Role

B.  

Cockpit Administrator Role

C.  

Cockpit User Administrator Role

D.  

Cockpit Database Administrator Role

Discussion 0
Question # 7

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

Discussion 0
Question # 8

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

Discussion 0
Question # 9

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

Discussion 0
Question # 10

What are the prerequisites for using the Web user interface for HDBLCM? There are 2 correct answers to this question.

Options:

A.  

The SAP HANA database is revision 90 or higher

B.  

The communication port 1329 is open

C.  

Internet Explorer - Version 8 or higher

D.  

The communication port 1129 is open

Discussion 0
Question # 11

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.

Discussion 0
Question # 12

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

Discussion 0
Question # 13

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.

Discussion 0
Question # 14

Which types of backup can you use to copy an SAP HANA tenant database?

There are 2 correct answers to this question.

Options:

A.  

Full database backup

B.  

Data snapshot

C.  

Delta database backup

D.  

Fallback snapshot

Discussion 0
Question # 15

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

Options:

A.  

RoundRobin

B.  

Hash

C.  

Range-Range

D.  

Range

Discussion 0
Question # 16

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.

Discussion 0
Question # 17

What can you do to shorten the startup time of an SAP HANA system after a reboot?

Options:

A.  

Flag all columnar tables for preload.

B.  

Set the savepoint interval to a lower value.

C.  

Set the preload column value in the Tables system table to FULL.

D.  

Partition the row store across nodes.

Discussion 0
Question # 18

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

Discussion 0
Question # 19

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.

Discussion 0
Question # 20

Which of the following SAP HANA capability allows you to load and replicate data in real time from ABAP source systems and non-ABAP source systems to an SAP HANA environment? Please choose the correct

answer.

Options:

A.  

SAP HANA landscape transformation replication server

B.  

SAP HANA dynamic tearing

C.  

SAP HANA remote data sync

D.  

SAP HANA smart data streaming

Discussion 0
Question # 21

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)

Discussion 0
Question # 22

In which circumstances do you create a column store table? There are 3 correct answers to this question.

Options:

A.  

When the calculations are based on a small number of columns

B.  

When aggregations or fast search is required

C.  

When accessing complete records

D.  

When the table has a large number of columns

Discussion 0
Question # 23

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

Discussion 0
Question # 24

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

Discussion 0
Question # 25

What is included with the Predictive Analysis Library (PAL)? There are 2 correct answers to this question.

Options:

A.  

Predictive algorithms

B.  

Flowgraphs

C.  

Text mining functions

D.  

Data preparation functions

Discussion 0
Question # 26

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

Discussion 0
Question # 27

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.

Discussion 0
Question # 28

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

Discussion 0
Question # 29

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

Discussion 0
Question # 30

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

Discussion 0
Question # 31

What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication? There are 2 correct answers to this question.

Options:

A.  

Delta data shipping takes place in addition to continuous log replay.

B.  

Delta data shipping takes place with continuous read-only access to the secondary system.

C.  

Delta data shipping takes place in addition to continuous log shipping.

D.  

Delta data shipping takes place every 5 minutes.

Discussion 0
Question # 32

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

Discussion 0
Question # 33

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

Discussion 0
Question # 34

What is the recommended disk space for /hana/shared/ for single-node SAP HANA systems? Please choose the correct Answer:.

Options:

A.  

Size [installation(single-node)] = MIN (2 x RAM; 2 TB)

B.  

Size [installation(single-node)] = MIN (1 x RAM; 1 TB)

C.  

Size [installation(single-node)] = MIN (2 x RAM; 1 TB)

D.  

Size [installation(single-node)] = MAX (2 x RAM; 1 TB)

Discussion 0
Question # 35

You upgrade an SAP HANA 1.0 system to SAP HANA 2.0. Which of the following activities are required to avoid compatibility issues after the upgrade. Note: There are 2 correct answers.

Options:

A.  

Export the backup jobs history from SAP HANA 1.0 and import the history after the upgrade

B.  

Delete all Backup schedules with the SAP HANA cockpit 1.0

C.  

Create new backup schedules after the upgrade

D.  

Convert all SAP HANA 1.0 backup schedules to SAP HANA 2.0 backup schedules

Discussion 0
Question # 36

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

Discussion 0
Question # 37

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

Discussion 0
Question # 38

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

Discussion 0
Question # 39

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

Discussion 0
Question # 40

What are the advantages of the DMO procedure? There are 3 correct answers to this question.

Options:

A.  

DMO is an inplace procedure by default, keeping the application server host.

B.  

DMO allows an easy reset during the procedure.

C.  

DMO allows a lower target release on SAP HANA database.

D.  

DMO combines several steps into one procedure.

Discussion 0
Get C_HANATEC_17 dumps and pass your exam in 24 hours!

Free Exams Sample Questions