SAP Certification C_HANATEC_17 Study Guides

dumps2021-12-14T03:47:29+08:00

dumps SAP SAP Certification C_HANATEC_17 exam, SAP Certified Technology Associate - SAP HANA 2.0 SPS05 C_HANATEC_17 study guides 0 Comments

SAP Certification C_HANATEC_17 exam is easy to pass now. All the SAP Certified Technology Associate – SAP HANA 2.0 SPS05 C_HANATEC_17 study guides are the best preparation material. In real SAP C_HANATEC_17 exam, there are 80 questions, and you have 180 minutes to complete all the questions. The cut score of C_HANATEC_17 exam is 61%. The available languages are English and Japanese. Free SAP Certification C_HANATEC_17 exam study guides are available below.

Page 1 of 9

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

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

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

4. Which activity must you perform before you can replay a workload using the Capture and Replay Application? Note: There are 2 correct answers.

Restore the source tenant backup into the target tenant

Start the replayer on the source system

Create the replayer user in the control system

Create a secure store key on the control system host

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

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. Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer.

_SYS_WORKLOAD_REPLAY

_SYS_STATISTICS

_SYS_SQL_ANALYZER

_SYS_TELEMETRY

8. What can a user do when the backup operator system privileges is assigned?

Perform data recovery

Schedule backups

Delete backups

Configure backup settings

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

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

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

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

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

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

Page 2 of 9

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

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

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

SAP HANA Live for SAP Business Suite is an accelerator.

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

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

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

13. After confirming Lock now, which actions are still possible? Choose the correct answer.

Releasing and importing transport requests via the Transport Manager (SE09) and Transport Management System (STMS)

88Creating and changing application data (e.g. VA01) and user master records SU01)

Developing via ABAP workbench (SE80)

Applying SAP notes via Note Assistant (SNOTE)

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

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

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

Socket

File

Network

Pipe

17. Which SUM database migration option utility do you use to check and monitor table splitting?

R3ta

Log tail Viewer

Table comparison

R3load utilization

18. Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit? There are 3 correct answers to this question.

Production

Custom

Test

Sandbox

Development

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

20. Your customer has purchased a 1.5 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 1TB nodes in an SAP HANA scale-out system with three worker and one standby nodes? Please choose the correct answer.

375 GB

1.5 TB

512 GB

1.0 TB

Page 3 of 9

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

22. For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.

Business Suite on HANA

SAP HANA Live for SAP Business Suite

SAP S/4HANA

Web-based native applications based on XS

23. What cryptographic libraries are supported in SAP HANA by default? There are 2 correct answers to this question.

LibgCrypt

OpenSSL

Common Cryptolib

WolfCrypt

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

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

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

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

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

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

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

Kerberos

SAML

PKCS #12

509

Page 4 of 9

31. How can you ensure that a consistent database status is saved using data snapshots? Please choose the correct answer.

Trigger a save point.

Create a fullback snapshot.

Create an internal database snapshot.

Execute the hdbbackupdiag tool.

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

To store connection information on the SAP HANA XS Advanced engine

To configure failover supporting a 3-tier scenario

To configure an SAP HANA Auto-Restart Fault Recovery Support

To store connection information on the SAP HANA database client

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

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

>= 8cpu

>= 12cpu

35. What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring tool for productive SAP HANA databases?

A dedicated server with at least 16 GB RAM with SUSE Linux Enterprise Server (SLES) or Red Hat Enterprise Linux (RHEL)

A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed

A central SAP HANA database 2.0 SPS05 multitenant database system with at least 16 GB of RAM

SAP Netweaver 7.5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed

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

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

Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 7.2

SUSE Linux Enterprise Server (SLES) for SAP Applications 12 SP1

SUSE Linux Enterprise Server (SLES) for SAP Applications 11 SP1

Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 6.5

38. What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? There are 2 correct answers to this question.

Kernel settings

Network configuration

Memory configuration

Missing OS patches

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

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

Page 5 of 9

41. In which replication mode is the primary system blocked until the secondary system is available?

syncmem

full sync

async

sync

42. Which SQL privileges can you grant to another user?

CREATE SCHEMA

ATTACH DEBUGGER

DATA ADM IN

CATALOG READ

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

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

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

DMO allows an easy reset during the procedure.

DMO allows a lower target release on SAP HANA database.

DMO combines several steps into one procedure.

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

OS/DB certified consultant

Migration check Services

Migration key

Stack.xml file

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

Storage Engine

Disk Storage

Relational Engines

Request Processing

47. Why are repository roles preferred over catalog roles? Note: There are 2 correct answers.

They are created by the technical user

They are revoked if the database user that granted them is deleted.

They are transportable runtime objects

They are transportable design-time objects

48. How can you optimize the Database Migration Option (DMO) procedure downtime for a production system? There are 2 correct answers to this question.

Provide the measured table migration duration data for optimal table sequencing during benchmarking.

Set the optimal number of R31oad processes during benchmarking and the DMO procedure

Use the Test Cycle opt on to find the optimal number of R31oad processes in a test run.

Use the benchmarking option to find the optimal throughput during the DMO procedure.

49. Which is the relationship between the user group operators and the user groups? There are 2 correct answers to this question.

Only one user group per user group operator

Only one user group operator per user group

Multiple user groups per user group operator

Multiple user group operators per user group

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

The content of the first main storage and the committed entries in the first delta storage are merged into the new second main storage.

The content of the complete main storage is persisted to disk.

Uncommitted changes in the first delta storage are rolled back.

All write operations go to the second delta storage.

Page 6 of 9

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

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

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

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

55. What is XS?

A native, lightweight application server

A data cleansing engine

An optional engine to handle excessive data loads

A user interface

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

57. Which information is provided via the SUM Ul? There are 3 correct answers to this question.

The active roadmap step

The content of log files via the log viewer

The memory consumption of SUM

A progress bar for the overall procedure

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

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

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

Page 7 of 9

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

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

63. The SAP HANA database is NOT reachable, and the root cause is unclear .

Which SAP HANA cockpit functions allow you to investigate this situation? Note: There are 2 correct answers.

Troubleshoot unresponsive system

Overall database status

Manage full system information dumps

Open blocked transactions

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

A wrong role of a service in a failover situation

An issue with the delta merge

A setting to restrict CPU usage

A long savepoint duration

65. Which administration tool can you use to start and stop the SAP HANA database system?

DBA Cockpit

SAP Solution Manager

SAP Landscape Management

SAP HANA HDBSQL

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

backint.log

backup.log

sapstartsrv.log

available.log

67. You needt to integrate an existing SAP HANA2.0 SPS05 database system into the SAP HANA cockpit monitor infrastructure. Where do you create the technical user needed for the resource registration?

In the first tenant

In the SYSTEMDB and all tenants

In the SYSTEMDB and the first tenant

In the SYSTEMDB

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

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

70. In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function? There are 2 correct answers to this question.

The input parameter must be set to mandatory.

The function can return multiple values.

The function must be of the type scalar.

The generated value can be overwritten at runtime.

Page 8 of 9

71. Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? There are 2 correct answers to

Keep all partitions on different hosts.

Keep the number of partitions per table high.

Keep the number of partitioned tables low.

Keep the number of key columns low.

72. What is a characteristic of the synchronous in-memory system replication mode in SAP HANA?

The primary system waits until the secondary system confirms receiving the log

The primary system waits until the secondary system confirms the log was persisted

The primary system does NOT wait for confirmation of the secondary system

The primary system suspends transactions processing until the connection to the secondary system is established

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

74. Which default users will be created during the installation of the SAP HANA database system? There are 2 correct answers to this question.

<sid>crypt

sap<sid>

Idapadm

sapadm

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

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

77. Which information is provided via the SUM UI? There are 3 correct answers to this question.

The content of log files via the log viewer

The memory consumption of SUM

A progress bar for the overall procedure

The active roadmap step

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

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

80. Your SAP HANA database is locked down .

Which action can you still perform?

Check database license

Check overall database status

Check session memory

Configure system properties

Page 9 of 9

81. How can you minimize the database migration option (DMO) downtime?

Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3load processes

Use the benchmarking tool for a productive database migration with the DMO procedure

Provide the measured table migration duration for table sequencing during benchmarking

Adjust the number of R3load processes during benchmarking and the DMO procedure

SAP Certification C_HANATEC_17 Study Guides

SAP Certification C_HANATEC_17 Study Guides

Share this post

Leave a Reply Cancel reply

Related Posts