Download SAP HANA 2.0 SPS05 C_HANATEC_17 Dumps Questions

test2022-07-06T06:55:19+00:00

Searching for online C_HANATEC_17 free dumps? We created this C_HANATEC_17 Dumps Questions to help you prepare for the SAP Certified Technology Associate – SAP HANA 2.0 SPS05 exam. It resembles the actual exam atmosphere. Our C_HANATEC_17 Dumps Questions cover all of the subjects covered on the C_HANATEC_17 exam, so you’ll know exactly how to pass the genuine C_HANATEC_17 certification exam. All of the questions are comparable to the ones you’ll see on the C_HANATEC_17 test. Our online platform teaches you the skills you’ll need to pass the SAP C_HANATEC_17 exam.

Get the C_HANATEC_17 practice exam to test yourself.

Page 1 of 7

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

3 * RAM (Appliance)

1.2 * RAM (TDI)

Min. 1 * RAM

Min. 0.5 * RAM

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

Delta Backup

Backup of Configuration files

Data Backup

Data Snapshot

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

Merge per column

Fully load the delta store into memory

Perform memory-only delta merges

Partition the table

4. What is a prerequisite when you install the SAP Landscape Management tool? Please choose the correct answer.

SAP HANA XS Advanced

SAP NetWeaver Application Server Java

SAP Fiori launchpad

SAP NetWeaver Application Server ABAP

5. Which tool do you use to check that the actual size of the backup file is the same as the size recorded in the backup file header? Please choose the correct answer.

hdb back int

hdb backup diag

hdb recover check

hdb backup check

6. Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? Please choose the correct answer.

The R3LDCTL

The Process Bucket monitor

The Log viewer

The Observer Monitor

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

SAP Application Performance Standard (SAPS)

Network throughput

Input/output operations per second (IOPS)

Main memory

Persistent storage

8. Which types of backup can you use to copy an SAP HANA tenant database? There are 2 correct answers to this question.

Full database backup

Data snapshot

Delta database backup

Fallback snapshot

9. You perform an SAP HANA migration to a scale-out landscape. When do you setup the table distribution?

After the migration

Before table creation

After table creation

Before the migration

10. 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 row count is executed for the migrated tables.

The content comparison is performed for repository tables.

A check sum is generated every 10000 rows.

The clustered tables are decluttered.

Page 2 of 7

11. The recovery of your productive SAP HANA database fails during log replay .

What is the fastest solution to complete the recovery?

Restart the database and resume the interrupted recovery

Resume the recovery from beginning

Resume the interrupted recovery

Replay the delta backups and log backups

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

1.2

1.6

4.0

3.0

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

hana/log/<sid>

/hana/<hostname>

/hana/shared

/hana/<sid>

14. 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.

Performance Warehouse

SAP HANA Database

Alerting Infrastructure

The transaction DBACockpit

15. 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.

Use the Test Cycle option to determine the optimal number of R3load processes.

Use the UPGAN

XML analysis file to optimize the number of R3load processes.

Use the MIGRATE_DT_DU

XML file to optimize table splitting and migration sequence.

Use the MIGRATE_SOT_DU

XML file to manually optimize table splitting of large tables.

16. Which actions take place during a database migration option (DMO) procedure when performing an in-place migration? There are 2 correct answers to this question.

One table is migrated per R3load pair.

TABART is considered for the creation of R3load control files.

SAP up decides which tables to split.

De-pooling of tables is done during the procedure.

17. 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.

basepathjogmirror

basespath_export

basepathjogbackup

basepath_databackup

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

Rename the SAP HANA database system.

Uninstall SAP HANA database components.

Update SAP HANA and its components.

Extract components.

19. Which information is provided by the backup catalog. Please choose the correct answer

Backup destination

Progress of a backup

Backup configuration

Backup ID

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

Password of the user sapadm

SAP HANA System ID (SID)

Data and Log path

Installation path

Page 3 of 7

21. 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.

Proposed solution

Schedule activation

Threshold values

Check interval

22. You are registering an SAP HANA database resource using SAP HANA cockpit manager .

Which privileges are automatically assigned when you initially create the COCKPIT_MONITOR technical user? There are 2 correct answers to this question.

DATABSE ADMIN

CATALOG READ

SELECT on the SYS_TELEMETRY schema

SELECT on the SYS_STATISTICS schema

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

Persisted redo logs

Automatic savepoints

Memory allocation limit

Delta merge

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

SAP HANA tenant database replication

Internal communication channels with the system PKI

HTTPS client access using the SAP HANA Web Dispatcher

Client-server communication over JDBC

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

backint.log

backup.log

sapstartsrv.log

available.log

26. Which file systems are supported for the SAP HANA database system? There are 2 correct answers to this question.

GPFS

EXT3

MPFS

Dxfs

27. Where do you investigate a failed uninstall of an SAP HANA scale-out system?

/usr/sap//hostctrl/work

/hana/log/<SID>

/hana/shared/log

/var/tmp/hdblcm.log

28. Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question

Preprocessor

XS Engine

Index server

Compile server

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

SLAVE

STANDBY

WORKER

MASTER 1

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

It de-centralizes landscape operations and provides local landscape view

It automizes repetitive, time-intensive administration tasks

It simplifies the management of SAP hybrid landscapes and standardizes SAP operations

It replicates the storage in SAP landscape

Page 4 of 7

31. Which operation is executed before a table is repartitioned?

Savepoint

Delta merge

Snapshot

Reorganization

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

SAP HANA cockpit 2.0 - Manage Databases

hdbsql

SAP HANA Studio - System view

sapcontrol

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

Export/import application and customer data

Upgrade the SAP HANA database system

Execute the SUM database migration option with system move

Create the system database manually

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

Row and Delta store.

Insert only on Column store.

Partitioning.

Compression and Decompression.

35. Which system privileges are required for administrating tenant databases when being connected to the system database? There are 2 correct answers to this question.

MONITOR ADMIN

DATA ADMIN

BACKUP ADMIN

DATABASE ADMIN

36. A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0 .

Which system privileges do you assign to the technical user account on the target system?

CATALOG READ

DATA ADMIN

MONITOR ADMIN

USER ADMIN

37. Which package of SAP HANA cloud platform provides a vast set of platform services for the most common pattern in software engineering, such as persistence, connectivity, identity and document management?

SAP HANA Infrastructure Services

SAP HANA Enterprise Cloud

SAP HANA AppServices

SAP HANA DBServices

38. Which parameters do you need to change before you can analyse the memory usage of running SQL statements? There are 2 correct answers to this question.

memory_tracking

statement_memory_limit

enable_tracking

use_in_memory_tracing

39. What happens when you rename a tenant in an SAP HANA database Note: There are 2 correct answers.

The database is renamed

The directories are renamed

The backups are renamed

The logs are renamed

40. Which of the following tasks can you perform using the resident SAP HANA database lifecycle manager (HDBLCM)? Note: There are 3 correct answers.

Rename the SAP HANA Database hostname

Remove host roles

Transport application changes

Rename the SAP HANA database system

Uninstall the individual components

Page 5 of 7

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

Manage Databases

Manage Services

Resource Directory

Performance Monitor

42. Which backup and recovery scenario is allowed in multitenant database containers?

A backup of a tenant database can be recovered to the system database.

The system database should be recovered first in order to recover the tenant databases.

After the recovery of a tenant database, the system database needs a backup.

A tenant database can initiate its own backup, but the system database executes the recovery.

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

Flag all columnar tables for preload.

Set the savepoint interval to a lower value.

Set the preload column value in the Tables system table to FUL

Partition the row store across nodes.

44. Which script can you trigger from SAP HANA cockpit to collect diagnosis information?

HanaHwCheck.py

fullSystemlnfoDump.py

hanachecker.py

hanadumpviewer.py

45. What can you assign to a user with the User Management app in SAP HANA cockpit? There are 2 correct answers to this question.

LDAP identity provider

Scopes

User group

LDAP authorization mode

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

Diagnosis information

Runtime environment

End-to-end Trace

SAP HANA minichecks

47. What are prerequisites for changing the SSFS Master Keys? There are 2 correct answers to this question.

You have the system privilege I IN I FILE ADMIN

You have the credentials of the Operating system user <sid>adm that was created when the system was installed

You have the credentials of the SYSTEM user

You have the server root privilege INIFILE ADMIN

48. 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.

Having the data and log volumes on the different disks.

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

Obtaining C_HANATEC_XX Certification.

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

49. 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.

When a savepoint occurs

When the log buffer is full

After the configured time threshold has been exceeded

When the log segment is full

50. In which situations can you resume the failed recovery of your productive SAP HANA tenant database? There are 2 correct answers to this question.

An aborted recovery of a log backup

An aborted recovery of a complete data backup

An aborted recovery of delta data backup

An aborted recovery of the configuration files

Page 6 of 7

51. 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.

SAP HANA landscape transformation replication server

SAP HANA dynamic tearing

SAP HANA remote data sync

SAP HANA smart data streaming

52. After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?

It determines and rolls forward aborted transactions

It rolls back write transactions that were open when the database was stopped

It reloads a savepoint with the restored consistent state of the database

It rolls back changes of committed transactions that were NOT written to the data area

53. You create a new user by copying an existing user .

Which predelivered role of the existing user is automatically granted to the new user?

Modeling

Monitoring

Repository

Runtime

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

Indexserve.ini

Nameserver.ini

Multidb.ini

Sapprofile.ini

55. 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?

Installation log file

COCKPIT_ADMIN user logs

Installation logs screen

Installation config screen

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

Delta 2

Main 2

Delta 1

Main 1

57. Why do we still need a persistent layer? There are 2 correct answers to this question.

To store data that has been unloaded from memory

To enable full database recovery if we have a power failure

To hold the delta store for newly arrived records

To store data that is frequently used

58. In which of the following SAP HANA scenarios is it recommended to encrypt communication between the client software and SAP HANA? There are 2 correct answers to this question.

SAP HANA as a data mart for reporting and analytics.

SAP HANA as a platform for providing database and application services to native SAP HANA-based applications.

SAP HANA as a classic three-tier architecture as the primary database (for example. SAP NetWeaver Business Warehouse, SAP Business Suite Installation).

59. 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.

Check the hostnames mapping to internal HTTPS ports

Configure an SAP Web Dispatcher for every tenant databases

Configure an alias hostname for every tenant database

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

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

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

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

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

Customers are new to SAP applications and SAP HANA

Page 7 of 7

61. Which of the following elements are required for implementing a database copy? There are 2 correct answers to this question.

A data backup (file-based backups or backups using a third-party backup tool) or a storage snapshot of the source system is available.

The target database must have a the same or higher version than the source database.

You don't have to be concerned about disk space and memory of the target database.

Source and target databases can have different number and types of services.

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

Columns can be partitioned

Only the columns required are actually loaded to memory

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

Data footprint is automatically reduced through compression

63. Which hardware KPIs do you need to size before performing a tailored data center integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answers to this questions.

DRAM required for the static data memory area

Persistent memory (PMEM) required for backups

Total disk space required for the log volume

Network bandwidth for the storage zone

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

Kerberos

SAML

PKCS #12

509

65. You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as in-place migration .

Which steps take place during downtime? There are 2 correct answers to this question.

Activation of dictionary objects in phase ACT_UPG

XPRaS execution in phase XPRAS_AIMMRG

Migration of application tables in phase EU_CLONE_MIG_DT_RUN

Creation of application tables in the target database in phase EU_CLONE_MIG_DT_CREATE

66. How are user group administrators and user groups related? There are 2 correct answers to this question.

Only one user group administrator per user group

Multiple user group administrators per user group

Only one user group per user group administrator

Multiple user groups per user group administrator

67. Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.

Cockpit User Administrator

Cockpit User

Cockpit Resource Administrator

Cockpit Administrator

68. Which prerequisites must be fulfilled when recovering a tenant database? There are 2 correct answers to this question.

Before the recovery starts, the tenant database must be stopped.

The whole system is shut down, including all tenant databases

You need the logon credentials of the <sid> adm user.

You need the logon credentials of the system database user.