Summer Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

C_HANATEC_17 PDF

$38.5

$109.99

3 Months Free Update

  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

C_HANATEC_17 PDF + Testing Engine

$61.6

$175.99

3 Months Free Update

  • Exam Name: SAP Certified Technology Associate - SAP HANA 2.0 SPS05
  • Last Update: Jun 15, 2024
  • Questions and Answers: 270
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

C_HANATEC_17 Engine

$46.2

$131.99

3 Months Free Update

  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included

C_HANATEC_17 Practice Exam Questions with Answers SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Certification

Question # 6

How do you ensure that Web-based applications send HTTPS requests to specific databases in an SAP HANA multiple-container system? Note: There are 2 correct answers.

A.

Check the hostnames mapping to internal HTTPS ports

B.

Configure an SAP Web Dispatcher for every tenant databases

C.

Configure an alias hostname for every tenant database

D.

Check that all requests with physical hostnames are forwarded to tenant databases

Full Access
Question # 7

What can you use the Secure User Store (hdbuserstore) for? There are 2 correct answers to this question.

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

Full Access
Question # 8

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

There are 2 correct answers to this question.

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)

Full Access
Question # 9

Which parameter do you set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory? There are 2 correct answers to this question.

A.

memory_tracking

B.

statement_memory_limit

C.

reject_memory_threshold

D.

total_statement_memory_limit

Full Access
Question # 10

Which system privilege must you have to redistribute tables across the hosts in your scale-out system?

A.

OPTIMIZER ADMIN

B.

DATA ADMIN

C.

WORKLOAD ADMIN

D.

RESOURCE ADMIN

Full Access
Question # 11

Which SQL privileges can you grant to another user?

A.

CREATE SCHEMA

B.

ATTACH DEBUGGER

C.

DATA ADM IN

D.

CATALOG READ

Full Access
Question # 12

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

A.

Manage Databases

B.

Manage Services

C.

Resource Directory

D.

Performance Monitor

Full Access
Question # 13

Which connection types are allowed when you use system replication with the Active/Active option? There are 2 correct answers to this question.

A.

Automatic round-robin statement routing

B.

Explicit read and write on the secondary system

C.

Explicit read only on the secondary system

D.

Implicit hint-based statement routing

Full Access
Question # 14

You suspect an authorization issue while executing SAP HANA reports that contain calculation views. How do you configure the authorization trace? There are 2 correct answers to this question.

A.

Specify the name of the table/view.

B.

Select INFO from the System Trace Level for the Indexserver component and then select AUTHORIZATION.

C.

Specify the user as the database user.

D.

Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATION.

Full Access
Question # 15

You administer a single-host system with 100GB physical memory. The global allocation limit and the individual service allocation limit are set to 90%. Three services are running-Service 1 has 25 GB of memory

allocated and service 2 has 40 GB allocated. What is the effective allocation limit of service 3?

A.

100 GB

B.

90 GB

C.

35 GB

D.

25 GB

Full Access
Question # 16

Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration? Please choose the correct answer.

A.

On the Additional Application Server (AAS) host

B.

On the source and target host

C.

On the remote target database host

D.

On the Primary Application Server (PAS) host

Full Access
Question # 17

Which technology does the SAP DBA Cockpit use to store the performance indicators? Please choose the correct answer.

A.

SAP Adaptive Server Enterprise

B.

SAP Business Intelligence

C.

SAP Intelligent Query

D.

SAP Analytics Cloud

Full Access
Question # 18

What do you do to prepare the database migration option of a Software Update Manager procedure? Note: There are 3 correct answers.

A.

Move the SPAM update archive into the download folder

B.

Extract the SAP HANA Client installation archive

C.

Move the stack.xml update file into the download folder

D.

Extract the SAP HANA database installation archive

E.

Move the R3trans update archive into the download folder

Full Access
Question # 19

You need to recover a tenant database backup from SAP HANA system 1 into SAP HANAsystem2. Which activities do you perform to restore the tenant? Note: There are 2 correct answers.

A.

Create the tenant in the target database

B.

Recover the tenant with the Initialize Log Area option

C.

Copy the transaction logs to the target database

D.

Start the recovered tenant database

Full Access
Question # 20

You define the parameters for the password policy of an SAP HANA tenant database. Where are these parameters stored?

A.

indexserver.ini

B.

multidb.ini

C.

global.ini

D.

nameserver.ini

Full Access
Question # 21

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

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

Full Access
Question # 22

Which fault recovery features can you implement to make your SAP HANA 2.0 production system more resilient against local hardware errors and software faults? There are 2 correct answers to this question.

A.

Service auto-restart

B.

Storage replication

C.

Host auto-failover

D.

Auto log backups

Full Access
Question # 23

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

A.

Object Privileges

B.

Analytic Privileges

C.

System Privileges

D.

Package Privileges

Full Access
Question # 24

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.

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.

Full Access
Question # 25

Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure?

There are 2 correct answers in this question.

A.

The SUM folder needs to exist.

B.

The source database is up and running.

C.

The DMO procedure hasn't reached downtime yet.

D.

A cleanup has already been triggered.

Full Access
Question # 26

you can establish SAP Solution Manager connectivity and configure a Remote Service Connection (via SAP Router) as part of the initial setup. Since Solution Manager 7.1 SP04, the SAP HANA databases can be integrated into SAP Solution Manager.

What are these components can be integrated into SAP HANA database?

There are 3 correct answers to this question.

A.

Performance Warehouse

B.

SAP HANA Database

C.

Alerting Infrastructure

D.

The transaction DBACockpit

Full Access
Question # 27

Which preparation tasks do you need to perform before starting the copy and move process for a tenant database? There are 3 correct answers to this question.

A.

Create credentials for authenticated access to the source system.

B.

Create a tenant on the target system identical to the source system.

C.

Back up the source tenant database.

D.

Configure a secure connection from target system to source system.

E.

Create credentials for authenticated access to the target system.

Full Access
Question # 28

Which value for the Autostart parameter do you use to control the automatic start of an SAP HANA system? Please choose the correct answer.

A.

On

B.

0

C.

Off

D.

1

Full Access
Question # 29

What are the supported operating systems for SAP HANA on IBM Power Servers? There are 2 correct answers to this question.

A.

For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4

B.

For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.2

C.

For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6. 10

D.

For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15

Full Access
Question # 30

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

A.

By a database soft shutdown.

B.

By issuing a transactional commit.

C.

By performing a delta merge.

D.

By performing a database backup.

Full Access
Question # 31

Which of the following events occur while the merge operation is running? There are 2 correct answers to this question.

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.

Full Access
Question # 32

Which system usage types are automatically assigned to ties in the SAP HANA cockpit?

There are 3 correct answers to this question.

A.

Test

B.

Development

C.

Production

D.

Quality assurance

E.

Custom

Full Access
Question # 33

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.

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.

Full Access
Question # 34

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

A.

DBA cockpit

B.

SAP HANA application life cycle management (HDBLCM)

C.

HDB command

D.

SAP HANA cockpit

E.

Sapcontrol

Full Access
Question # 35

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?

A.

Multiple Components on One Database (MCOD)

B.

Multitenant database containers (MDC)

C.

Technical co-deployment (TCD)

D.

Multiple Components on One System (MCOS)

Full Access
Question # 36

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

There are 2 correct answers to this question.

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

Full Access
Question # 37

Which SAP recommendations do you follow to create an optimal table partitioning plan for SAP Business Suite powered by SAP HANA? Note: There are 2 correct answers.

A.

Have a high number of partitions per table

B.

Have a low number of keys

C.

Have partitions of a table on the same host

D.

Have a high number of partitioned tables

Full Access
Question # 38

What must you do to configure the data backup on a scale-out SAP HANA system? Note: There are 2 correct answers

A.

Verify that data and log backup destinations are valid throughout the system

B.

Change the backup configuration for each node

C.

Specify the individual backup destination on each node

D.

Ensure the availability of shared backup storage

Full Access
Question # 39

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

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)

Full Access
Question # 40

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?

A.

$(DIR_INSTANCE)//trace

B.

$(DIR_INSTANCE)/backup/data

C.

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

D.

$(DIR_INSTANCE)/backup/log

Full Access
Question # 41

Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit?

There are 3 correct answers to this question.

A.

Cockpit User

B.

Database User

C.

sap

D.

adm

E.

Root

Full Access
Question # 42

You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?

A.

A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schema

B.

A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schema

C.

A multitenant configuration with SYSTEMDB

D.

The target database on SAP HANA 2.0 SPS00 or higher

Full Access
Question # 43

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

There are 2 correct answers to this question.

A.

Full database backup

B.

Data snapshot

C.

Delta database backup

D.

Fallback snapshot

Full Access
Question # 44

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

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

Full Access
Question # 45

What is the minimum space requirement for the Data Volume? There are 2 correct answers to this question.

A.

3 * RAM (Appliance)

B.

1.2 * RAM (TDI)

C.

Min. 1 * RAM

D.

Min. 0.5 * RAM

Full Access
Question # 46

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

A.

Create a restricted user

B.

Assign a user to a user group

C.

Create and delete users

D.

Lock and unlock users

Full Access
Question # 47

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

A.

Modeling

B.

Monitoring

C.

Repository

D.

Runtime

Full Access
Question # 48

Which information is recorded in the database trace of the SAP HANA database?

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

Full Access
Question # 49

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

A.

hana/log/

B.

/hana/

C.

/hana/shared

D.

/hana/

Full Access
Question # 50

Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure? There are 2 correct answers to this question.

A.

Move the latest R3trans update archive into the download folder.

B.

Extract the SAP HANA database software installation archive.

C.

Check if the latest SPAM/SAINT update is applied.

D.

Update the SAP Host Agent to the latest version

Full Access
Question # 51

How can you perform a complete back up of an SAP HANA database system? Please choose the correct answer.

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.

Full Access
Question # 52

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

There are 2 correct answers to this question.

A.

ODBC

B.

JDBC

C.

OLEDB

D.

ADO.NET

Full Access
Question # 53

Which R3load mode is used during an inplace SUM database migration option procedure?

A.

Socket

B.

File

C.

Network

D.

Pipe

Full Access
Question # 54

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

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

Full Access
Question # 55

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

A.

Backup

B.

Data

C.

Log

D.

Pages in-memory

E.

Storage snapshot

Full Access
Question # 56

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

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.

Full Access
Question # 57

What is the correct minimum requirement for log volume and/hana/shared/ file system for an SAP HANA database system? Please choose the correct answer.

A.

For 256 GB system, Log volume = 128 GB,/hana/shared/ = 256 GB

B.

For 512 GB system, Log volume = 512 GB,/hana/shared/ = 256 GB

C.

For 1 TB system, Log volume = 1 TB,/hana/shared/ = 1TB

D.

For 2 TB system, Log volume = 1 TB,/hana/shared/ = 1TB

Full Access
Question # 58

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.

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.

Full Access
Question # 59

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

A.

Diagnosis information

B.

Runtime environment

C.

End-to-end Trace

D.

SAP HANA minichecks

Full Access
Question # 60

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

A.

Row and Delta store.

B.

Insert only on Column store.

C.

Partitioning.

D.

Compression and Decompression.

Full Access
Question # 61

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

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.

Full Access
Question # 62

Your SAP HANA database is locked down. Which action can you still perform?

A.

Check database license

B.

Check overall database status

C.

Check session memory

D.

Configure system properties

Full Access
Question # 63

How are user group administrators and user groups related?

There are 2 correct answers to this question.

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

Full Access
Question # 64

Which best practices do you apply when you optimize the table distribution in a scale-out SAP HANA database?

There are 2 correct answers to this question.

A.

Table partitions can be distributed over all nodes.

B.

The row store can be distributed over all nodes.

C.

Cross-node joins must be avoided.

D.

The columns of a table can be distributed over all nodes.

Full Access
Question # 65

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.

A.

basepathjogmirror

B.

basespath_export

C.

basepathjogbackup

D.

basepath_databackup

Full Access
Question # 66

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

A.

Delta Backup

B.

Backup of Configuration files

C.

Data Backup

D.

Data Snapshot

Full Access
Question # 67

Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)? There are 3 correct answers to this question.

A.

Validation of the operating system configuration settings for the Linux kernel

B.

Measurement of the data throughput between CPU and DRAM

C.

Validation of the LPAR configuration settings on IBM Power servers

D.

Measurement of data throughput between SAP HANA nodes and storage

E.

Measurement of data throughput between the Linux kernel and CPU

Full Access
Question # 68

How can troubleshoot HANA installer when its crashes There are 2 correct answers to this question.

A.

run hdblcm with the check_installation action

B.

set the environment variable HDB_INSTALLER_TRACE_FILE to the trace filename

C.

create the dirctory containing the trace file

D.

activate the debug mode for the database trace

Full Access
Question # 69

Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media? There are 2 correct answers to this question.

A.

Rename the SAP HANA database system.

B.

Uninstall SAP HANA database components.

C.

Update SAP HANA and its components.

D.

Extract components.

Full Access
Question # 70

You installed an SAP Netweaver-based application on an SAP HANA database. What is the default secure user store to store the password of the SAP user?

A.

hdbuserstore

B.

xuser

C.

Secure store in file system (SSFS)

D.

ABAP secure store file system (SSFS)

Full Access
Question # 71

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

A.

System availability

B.

Alerts count

C.

Thread status

D.

CPU utilization

Full Access
Question # 72

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.

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

Full Access
Question # 73

Which actions are always recorded when auditing is active? Note: There are 2 correct answers.

A.

Disable auditing

B.

Grant or revoke user

C.

Modification of an audit policy

D.

Create or drop user

Full Access
Question # 74

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

A.

Indexserve.ini

B.

Nameserver.ini

C.

Multidb.ini

D.

Sapprofile.ini

Full Access
Question # 75

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

A.

Kerberos

B.

SAML

C.

PKCS #12

D.

X.509

Full Access
Question # 76

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.

A.

threshold_cpu_time

B.

cpu_time_measurement_mode

C.

load_monitor_granularity

D.

enable_tracking

Full Access
Question # 77

Which backup scenarios are allowed in multitenant database containers? Note: There are 2 correct answers.

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

Full Access
Question # 78

Which of the following statements are true about SAP HANA Live? There are 2 correct answers to this question.

A.

SAP HANA Live for SAP Business Suite focuses on Enterprise Data Warehouse cases, and not on live operational reporting.

B.

SAP HANA Live for SAP Business Suite is a Rapid Deployment Solution.

C.

SAP HANA Live for SAP Business Suite is an accelerator.

D.

SAP HANA Live for SAP Business Suite comprises of an Analytical Model.

E.

SAP HANA Live for SAP Business Suite comes with a comprehensive set of predefined models from across the SAP Business Suite.

Full Access
Question # 79

Which tools do you use to delete diagnosis files? There are 2 correct answers to this question.

A.

SAP HANA Web-based Development Workbench

B.

SAP HANA cockpit

C.

SAP HANA cleaner

D.

SAP HANA database explorer

Full Access
Question # 80

Which of the following system privileges can you assign to an SAP HANA database user? Note: There are 3 correct answers.

A.

CREATE ANY

B.

EXPORT

C.

EXECUTE

D.

CREATE SCHEMA

E.

DEVELOPMENT

Full Access
Question # 81

You switched the SAP HANA database to normal log mode. When does the system perform a regular log backup? Note: There are 2 correct answers.

A.

When a savepoint occurs

B.

When the log buffer is full

C.

After the configured time threshold has been exceeded

D.

When the log segment is full

Full Access