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

  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 SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Questions and Answers

Questions 4

What are some advantages of a system replication with operation mode logreplay compared to delta_datashipping Note: There are 2 correct answers.

Options:

A.

Takeover time is shorter

B.

CPU load is reduced

C.

Network traffic is reduced

D.

Memory consumption is lower

Buy Now
Questions 5

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 6

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 7

Which operating system process takes care of starting the SAP HANA database system services?

Please choose the correct answer.

Options:

A.

hdbrsutil

B.

hdbdaemon

C.

apstartsrv

D.

sapstart

Buy Now
Questions 8

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

Options:

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.

Buy Now
Questions 9

What do you require to perform a migration using the SUM database migration option? Note: There are 2 correct answers.

Options:

A.

OS/DB certified consultant

B.

Migration check Services

C.

Migration key

D.

Stack.xml file

Buy Now
Questions 10

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

Buy Now
Questions 11

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 12

Which SAP HANA features can you use to manage the database peak load? There are 2 correct answers to this question.

Options:

A.

Admission control

B.

Capture and replay

C.

Thread throttling

D.

Workload classes

Buy Now
Questions 13

Which privileges are assigned automatically when you create a technical user during the register resource procedure in SAP HANA cockpit? There are 2 correct answers to this question.

Options:

A.

SELECT on the _SYS_TELEMETRY schema

B.

RESOURCE ADMIN

C.

SELECT on the _SYS_STATISTICS schema

D.

CATALOG READ

Buy Now
Questions 14

What is the correct sequence of the following four steps in the restart of the SAP HANA database system? Please choose the correct answer.

Options:

A.

Aborted transactions are rolled back. 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded.

B.

Aborted transactions are rolled back.

C.

Row tables are loaded into memory. 3. Open transactions are recovered. 4. Column tables are loaded.

D.

Row tables are loaded into memory. 2. Column tables are loaded. 3. Open transactions are recovered. 4. Aborted transactions are rolled back.

E.

Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded.

Buy Now
Questions 15

Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? There are 2 correct answers to this question.

Options:

A.

SYNCMEM

B.

FULL SYNC

C.

SYNC

D.

ASYNC

Buy Now
Questions 16

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

Options:

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

Buy Now
Questions 17

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.

Buy Now
Questions 18

Which SAP HANA feature ensure that committed data is NOT lost if there is a power failure? Note: There are 2 correct answers.

Options:

A.

Persisted redo logs

B.

Automatic savepoints

C.

Memory allocation limit

D.

Delta merge

Buy Now
Questions 19

Which option do you choose to protect your SAP HANA scale-out system using host autofailover?

Options:

A.

System replication

B.

Automatic savepoint

C.

Storage replication

D.

Standby node

Buy Now
Questions 20

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 21

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.

Buy Now
Questions 22

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

Buy Now
Questions 23

Which diagnostic file can you use to monitor the status of database recovery?

Options:

A.

backint.log

B.

backup.log

C.

sapstartsrv.log

D.

available.log

Buy Now
Questions 24

During the delta merge process, to which memory areas is data inserted? There are 2 correct Answers to this question.

Options:

A.

Delta 2

B.

Main 2

C.

Delta 1

D.

Main 1

Buy Now
Questions 25

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.

Options:

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

Buy Now
Questions 26

In which situations can you resume the failed recovery of your productive SAP HANA tenant database?

There are 2 correct answers to this question.

Options:

A.

An aborted recovery of a log backup

B.

An aborted recovery of a complete data backup

C.

An aborted recovery of delta data backup

D.

An aborted recovery of the configuration files

Buy Now
Questions 27

Which information is provided by the backup catalog. Please choose the correct Answer:.

Options:

A.

Backup destination

B.

Progress of a backup

C.

Backup configuration

D.

Backup ID

Buy Now
Questions 28

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

Buy Now
Questions 29

You migrate an SAP HANA system using SUM database migration option. Which activities do you perform to activate the viewer mode for SAP support? Note: There are 2 correct answers.

Options:

A.

Provide the sum observer URL to SAP support

B.

Provide the SUM URL to SAP support

C.

Create the OS user obs on the application server

D.

Create the database user obs on the application server

Buy Now
Questions 30

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.

Options:

A.

memory_tracking

B.

statement_memory_limit

C.

reject_memory_threshold

D.

total_statement_memory_limit

Buy Now
Questions 31

Which parameters are mandatory when using the hdblcm tool in batch mode? There are 2 correct answers to this question.

Options:

A.

Password of the user sapadm

B.

SAP HANA System ID (SID)

C.

Data and Log path

D.

Installation path

Buy Now
Questions 32

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.

Buy Now
Questions 33

Which of the following users are able to start and stop a distributed SAP HANA Database System? There are 2 correct Answers to this question.

Options:

A.

ROOT user

B.

ADM user

C.

SYSTEM user

Buy Now
Questions 34

What is the additional disk space factor required during delta merge operations? Please choose the correct answer.

Options:

A.

1.2

B.

1.6

C.

4.0

D.

3.0

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 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 37

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

Options:

A.

3 * RAM (Appliance)

B.

1.2 * RAM (TDI)

C.

Min. 1 * RAM

D.

Min. 0.5 * RAM

Buy Now
Questions 38

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

Buy Now
Questions 39

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

Buy Now
Questions 40

Your customer asks you to set up alert monitoring in SAP HANA cockpit 2.0. Which alert properties can you configure?

There are 2 correct answers to this question.

Options:

A.

Proposed solution

B.

Schedule activation

C.

Threshold values

D.

Check interval

Buy Now
Exam Code: C_HANATEC_17
Exam Name: SAP Certified Technology Associate - SAP HANA 2.0 SPS05
Last Update: Apr 23, 2024
Questions: 270

PDF + Testing Engine

$66.4  $165.99
buy now C_HANATEC_17 pdf + testing engine

Testing Engine

$46  $114.99
buy now C_HANATEC_17 testing engine

PDF (Q&A)

$42  $104.99
buy now C_HANATEC_17 pdf