SAP HANA 2.0 SPS05 Certification Exam C_HANATEC_17 Test Questions

Regina2021-08-18T03:37:56+00:00

The experience certified team from ITExamShop have written the SAP HANA 2.0 SPS05 Certification Exam C_HANATEC_17 Test Questions to make sure that you can read real exam questions and answers to prepare for SAP Certified Technology Associate – SAP HANA 2.0 SPS05 certification exam well. Every candidate wants to be familiar with the real exam questions before taking the actual exam, and always chooses the online resource as the preparation. ITExamShop C_HANATEC_17 test questions with the great Q&As ensure that you can pass SAP certification C_HANATEC_17 exam in the first attempt.

Come to check C_HANATEC_17 free questions before getting the great C_HANATEC_17 test questions.

Page 1 of 8

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

When you need to extend the scale-out memory

When you need to optimize the standby node memory.

When you need to measure total memory

When you need to actively free up memory.

2. A user is complaining about missing privileges when executing a query.

How do you configure the indexserver trace to obtain the missing privileges? Please choose the correct answer

Select trace level Warning for the authentication component.

Select trace level Error for the auditing component.

Select trace level Info for the authorization component.

Select trace level Debug for the authenticationcodec component.

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

4. Out of complete SAP HANA platform, which from the following components are not part of SAP HANA Database? There are 3 correct answers to this question.

HWCCT

Database Services

Smart Data Access

INA file loader

EPM Services

5. 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<schema-id> user?

hdbuserstore

xuser

Secure store in file system (SSFS)

ABAP secure store file system (SSFS)

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

Table partitions can be distributed over all nodes.

The row store can be distributed over all nodes.

Cross-node joins must be avoided.

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

7. You need to periodically monitor if the SAP HANA primary system is online.

Which tool do you use?

systemreplicationStatus

HDBAdmin

hanasitter

landscapeHostConfiguration

8. Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag This page displays the detailed status of the selected SAP HANA system.

Which of the following options are listed? There are 3 correct answers to this question.

Monitoring and Administration

Performance Management

Resource Management

Security

Memory Management

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

10. You created a restricted user in the DB1 database.

Which commands must you use to convert the restricted SAP HANA user to a standard SAP HANA user? There are 3 correct answers to this question.

ALTER USER <USERNAME> GRANT ROLE PUBLIC

ALTER USER <USERNAME> ENABLE CLIENT CONNECT

ALTER USER <USERNAME> ACTIVATE USER NOW

ALTER USER GRANT CREATE ANY ON OWN SCHEMA

ALTER USER <USERNAME> ADD REMOTE IDENTITY

Page 2 of 8

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

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

System replication

Automatic savepoint

Storage replication

Standby node

13. Your customer wants to know when the productive SAP HANA system was updated and to which version.

Where do you find this information? There are 2 correct answers to this question

In the SAP HANA database explorer for SAP HANA cockpit 2.0

In the catalog view of the SAP HANA Web-based Development Workbench

In the General Information app of SAP HANA cockpit 2.0

In the administration editor of the SAP HANA studio

14. Which target database does the SUM databases migration option provide by default? Note: There are 2 correct answers.

SAp MaxDB

SAP ASE

SAP IQ

SAP HANA

15. Which information is stored in the SYSTEMDB of an SAP HANA multitenant database container system? Note: There are 2 correct answers.

Topology data on the location of tables and table partitions

Monitoring data in the SYSTEMDB and all tenant databases

Users and authorizations of the SYSTEMDB and all tenant databases

Landscape topology data on the system as a whole

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

Schedule period

Email alert notification

Alert checker category

Alert threshold values

Schedule activation

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

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

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

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

Delta data shipping takes place every 5 minutes.

18. Which table partitioning types does SAP HANA support? There are 3 correct answers to this question.

Hash

Composite

Range

Round-robin

Cluster

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

Start the recovery from the tenant database using SAP HANA cockpit 2.0

Recover all the databases using Initialize Log Area option

Recover the system database before recovering all tenant databases

Start the recovery from the system database SAP HANA cockpit 2.0

20. Which action do you perform when the data area in an SAP HANA database is running out of space?

Create a new tenant database

Extend the file system size in the operating system level

Extend the size of the database volume

Create a new database volume

Page 3 of 8

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

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

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

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

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

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

Create a restricted user

Assign a user to a user group

Create and delete users

Lock and unlock users

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

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

OPTIMIZER ADMIN

DATA ADMIN

WORKLOAD ADMIN

RESOURCE ADMIN

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

Savepoint

Delta merge

Snapshot

Reorganization

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

Disable auditing

Grant or revoke user

Modification of an audit policy

Create or drop user

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

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

HanaHwCheck.py

fullSystemlnfoDump.py

hanachecker.py

hanadumpviewer.py

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

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

The Log viewer

The Observer Monitor

Page 4 of 8

31. In the General Licensing Process which of the following statements are true regarding Temporary license keys? There are 2 correct answers to this question.

Temporary license keys are manually installed by the SAP HANA system

Temporary license keys are automatically installed by the SAP HANA system

After 28 days, the temporary license expires and the system is locked down

After 90 days, the temporary license expires and the system is locked down

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

100 GB

90 GB

35 GB

25 GB

33. When you use the database migration option reset procedure as a fallback scenario, which of the changes made during the migration are NOT reset? There are 3 correct answers to this question.

The SAP ABAP kernel on the application server

The DBACOCKPIT user on the SAP HANA database

The updated BRTOOLS on the non-SAP database

The deleted SAP BusinessObjects Business Intelligence data on the non-SAP database

The shadow schema on the non-SAP database

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

Admission control

Capture and replay

Thread throttling

Workload classes

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

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

The CPU architecture must be identical.

An explicit read-only connect on between both systems must be available

Both must have the same SAP HANA version.

Both systems are located in the same data center.

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

Service auto-restart

Storage replication

Host auto-failover

Auto log backups

38. You install a productive multi-host system with failover capabilities.

Which storage condition prerequisites must be ensured? Note: There are 2 correct answers.

The standby host has file access

The standby host has NO file access

The failed worker host has access to write files

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

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

Deletion of audit entries from the audit trail

Installation of SAP HANA license

Changes to system configuration

Creation, modification or deletion of audit policies

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

Page 5 of 8

41. Which properties can you adjust in SAP HANA Admission Control? There are 3 correct answers to this question.

CPU threshold for rejecting requests

Maximum request queue size

Maximum parallel 10 requests

Memory limit for queuing requests

SQL statement request memory limit

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

The SAP HANA database is revision 90 or higher

The communication port 1329 is open

Internet Explorer - Version 8 or higher

The communication port 1129 is open

43. To ensures that the database can be restored to the most recent committed state after a restart which of the following Indexserver components make sure such consistency and maintain durable changes?

Storage Engine

Disk Storage

Relational Engines

Request Processing

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

45. Which certificates do you require for a trusted secure communication between the client and the SAP HANA database? Note: There are 2 correct answers.

User certificate

Server certificate

509 certificate

Root certificate

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

Move the SPAM update archive into the download folder

Extract the SAP HANA Client installation archive

Move the stack.xml update file into the download folder

Extract the SAP HANA database installation archive

Move the R3trans update archive into the download folder

47. Which tool do you use to backup the root encryption keys?

rsecssfx

hdbuserstore

dbacockpit

hdbnsutil

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

run hdblcm with the check_installation action

set the environment variable HDB_INSTALLER_TRACE_FILE to the trace filename

create the dirctory containing the trace file

activate the debug mode for the database trace

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

When the log buffer is full.

When the time threshold is exceeded.

When the log segment is full.

When a commit occurs.

50. Which of the following recovery types is not supported for delta backups?

Recover the database to its most recent state.

Recover the database to a specific point in time.

Recover the database to a specific data backup.

Page 6 of 8

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

SAP HANA Web-based Development Workbench

SAP HANA cockpit

SAP HANA cleaner

SAP HANA database explorer

52. What is the recommended disk space for /hana/shared/<SID> for single-node SAP HANA systems? Please choose the correct answer

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

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

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

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

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

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

Socket

File

Network

Pipe

55. What is the first node limit for planning an SAP S/4HANA scale-out system? There are 2 correct answers to this question.

>= 6TB

>= 8TB

>= scpu

>= i2cpu

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

SYNCMEM

FULL SYNC

SYNC

ASYNC

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

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

Delete all Backup schedules with the SAP HANA cockpit 1.0

Create new backup schedules after the upgrade

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

58. What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? Please choose

Metadata Manager and Transaction Manager

Page Management and logge

Column Store and Row Store

Session Management and log Volumes

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

Backup

Data

Log

Pages in-memory

Storage snapshot

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

Page 7 of 8

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

Move the latest R3trans update archive into the download folder.

Extract the SAP HANA database software installation archive.

Check if the latest SPAM/SAINT update is applied.

Update the SAP Host Agent to the latest version

62. Assume your current partitioning plan of SAP HANA is NOT optimal.

Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned? Please choose the correct answer.

Check the number of partitions

Check the correct location of tables and partitions

Redistribute tables after adding host(s)

Balance table distribution

63. You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one productive system.

Which of the following installation requirements are mandatory? There are 2 correct answers to this question.

The system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.

The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.

The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

64. Which products do you use for SAP HANA administration? There are 2 correct answers to this question.

SAP Solution Manager

SAP Web IDE for SAP HANA

SAP HANA cockpit

SAP Master Data Governance

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

On the Additional Application Server (AAS) host

On the source and target host

On the remote target database host

On the Primary Application Server (PAS) host

66. Which system privileges do you require to view roles that are granted to other users? Note: There are 2 correct answers.

CATALOG READ

USER ADMIN

DATA ADM IN

ROLE ADMIN

67. USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards.

What happens if you drop USER B from the HANA database?

The privilege remains assigned to both USER A and USER

The privilege is revoked from USER A, but not USER

The privilege is revoked from both USER A and USER

The privilege is revoked from USER C, but not USER

68. SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason.

Which parameters do you adjust to manage the event log? There are 2 correct answers to this question.

max_queue_size

queue_wait_time_threshold

recordjimit

queue_timeout

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

70. Why does SAP HANA have a persistence storage layer that is disk-based? Note: There are 2 correct answers.

To persist in-memory data

To ensure maximum performance

To enable database scale-up

To allow a restart if the power fails

Page 8 of 8

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

To generate indexes for the column store

To persist in-memory data

To enable data recovery if the power fails

To allow row store operations

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

Takeover time is shorter

CPU load is reduced

Network traffic is reduced

Memory consumption is lower

73. Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool? There are 3 correct answers to this question.

Store the logon credentials of the replayer user in the secure store.

Create a replayer user account on the target operating system.

Preprocess the captured workload on the source system.

Restore the source system tenant backup to the target tenant.

Create a replayer user account in the target database system.

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

75. You need to rename a tenant database using the Manage Database app in the SAP HANA cockpit.

Which prerequisite do you require? Note: There are 2 correct answers.

The tenant database must be on one host

The tenant database is stopped

You have the DATABASE ADMIN system privileges

The system database must be on the master node

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

When the calculations are based on a small number of columns

When aggregations or fast search is required

When accessing complete records

When the table has a large number of columns

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

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

threshold_cpu_time

cpu_time_measurement_mode

load_monitor_granularity

enable_tracking

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

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

Near Zero Downtime

Database migration options of SUM

Export/import using SAP Provisioning Manager

Phases update

Welcome To Choose Required IT Certification Exams Online

SAP HANA 2.0 SPS05 Certification Exam C_HANATEC_17 Test Questions

Come to check C_HANATEC_17 free questions before getting the great C_HANATEC_17 test questions.

Author