Prepare C_HANATEC_17 Exam with Using C_HANATEC_17 Dump Questions

Category:

SAP Free Dumps

Comments:

0 Comments

Post Date:

March 10, 2023

If you are serious about passing your SAP C_HANATEC_17 certification exam, practicing with C_HANATEC_17 dumps questions is an essential step in your preparation process. These C_HANATEC_17 dumps will help you assess your knowledge, identify your strengths and weaknesses, and improve your chances of passing the exam on the first try. So why wait? Start practicing today and give yourself the best possible chance of success! Test free C_HANATEC_17 exam dumps questions below.

Page 1 of 9

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

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

memory_tracking

statement_memory_limit

reject_memory_threshold

total_statement_memory_limit

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

4. Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?

Please choose the correct answer.

SQL

User-Specific

End-to-End

Kernel profiler

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

Back up the system database and all tenant databases individually.

Back up the system database and all tenant databases in one step.

Back up the complete database system.

Backup the complete storage system.

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 of the following elements are valid rules for the location of the backup files? There are 3 correct answers to this question.

The Volume ID is automatically added to a specified file name.

The backup files should never be in the same directory and on the same file system as u data.

The backup ID is unique for each persistence only.

The backup folder will be created automatically when the backup process is started.

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

SELECT on the _SYS_TELEMETRY schema

RESOURCE ADMIN

SELECT on the _SYS_STATISTICS schema

CATALOG READ

9. The Add System Archive Link is a new feature that allows users to connect to multiple SAP HANA systems.

From which method one user can manage the list of all systems in a centrally-accessible archive (with read only link to other user)?

File Export SAP HANA Landscape

File archive SAP HANA Landscape

File archive SAP HANA Export

File Export Landscape SAP HANA

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

Page 2 of 9

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

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

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

Multiple Components on One Database (MCOD)

Multitenant database containers (MDC)

Technical co-deployment (TCD)

Multiple Components on One System (MCOS)

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

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

16. Who owns an SAP HANA Deployment Infrastructure (HDI) role? Please choose the correct answer.

The SYSTEM user of the tenant database

The user who created the role

The _SYS_REPO technical user

The container-specific technical user

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

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

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

System availability

Alerts count

Thread status

CPU utilization

20. Which programming languages are supported when you develop an application on SAP HANA extended application services? Note: There are 2 correct answers.

Node.js

C++

Lisp.js

ABAP

Page 3 of 9

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

Perform data recovery

Schedule backups

Delete backups

Configure backup settings

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

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

DBA cockpit

SAP HANA application life cycle management (HDBLCM)

HDB command

SAP HANA cockpit

Sapcontrol

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

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

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

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

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

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

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

Page 4 of 9

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

The system database must run on the standby host.

The system database instance must run on all hosts (worker and standby).

The tenant databases must be able to be scaled out to all hosts (worker and standby).

The tenant databases must run on the worker hosts.

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

33. Which tools are integrated into the SAP HANA cockpit? There are 3 correct answers to this question.

Database Explorer

HANA Sitter

SQL Console

SQL Analyzer

HDB Admin

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

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

36. Which technology is used to install the SAP Landscape Management tool? Please choose the correct answer.

SAP NetWeaver Application Server for ABAP

SAP Fiori launchpad

SAP NetWeaver Application Server for Java

SAP HANA XS advanced runtime

37. Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure? There are 2 correct answers in this question.

The SUM folder needs to exist.

The source database is up and running.

The DMO procedure hasn't reached downtime yet.

A cleanup has already been triggered.

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

Create the tenant in the target database

Recover the tenant with the Initialize Log Area option

Copy the transaction logs to the target database

Start the recovered tenant database

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

40. Which information can you collect by running the fullSystemlnfoDump.py script when the SQL connection is available? Please choose the correct answer.

A selection of rows of schema _SYS_XS

A selection of .log files

A selection of .trc files

A selection of rows of schema SAP

Page 5 of 9

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

Have a high number of partitions per table

Have a low number of keys

Have partitions of a table on the same host

Have a high number of partitioned tables

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

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

Executed SQL statements on database level

Performance indicators on a query level

Database activities with the trace level ERROR

Query execution plans on an application level

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

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

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

Please choose the correct answer.

hdbrsutil

hdbdaemon

apstartsrv

sapstart

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

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

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

Kerberos

SAML

PKCS #12

509

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

Page 6 of 9

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

SAP Adaptive Server Enterprise

SAP Business Intelligence

SAP Intelligent Query

SAP Analytics Cloud

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

Test

Development

Production

Quality assurance

Custom

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

System replication

Automatic savepoint

Storage replication

Standby node

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

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

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

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

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

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

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

Page 7 of 9

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

Savepoint

Delta merge

Snapshot

Reorganization

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

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

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

crypt

sap

Idapadm

sapadm

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

66. How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?

Set up cross-database access control

Set database isolation levels to high

Edit the configuration change blacklist

Assign internal communication ports

67. Which of the following tasks requires the BACKUP ADMIN authorization? There are 2 correct Answers to this question.

Recovering the database without a user interface

Physically deleting data and log backups and obsolete versions of the backup catalog from the backup location.

Administration tasks executed on a tenant database through the system database.

Backing up the database without a user interface.

68. How can the system database administrator disable tenant database functionalities? Please choose the correct answer.

Using the hdbuserstore tool

Using the resident hdblcm tool

Using the Manage Restricted Features app

Using the Manage Blacklisted Parameter app

69. Which trace do you use to create a graphical representation of an individual SQL Statement?

Performance trace

Expensive statements trace

SQL trace

Plan trace

70. Which database objects can you manipulate if you have the ALL PRIVILEGES activity? There are 2 correct answers to this question.

Procedures

Sequences

Tables

Views

Page 8 of 9

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

72. Where is the name server running in a multitenant database container system? Please choose the correct answer.

Standby node

Master node

SYSTEMDB

73. A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer.

recover the system database and the affected tenant with the initialize log area option

restore the database and recover the affected tenant upto moment of the problem

recover the affected tenant upto moment of the problem

recover the affected tenant with the initialize log area option

74. Which partitioning option distributes rows equally for load balancing in the SAP HANA database?

RoundRobin

Hash

Range-Range

Range

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

76. Which components of SAP HANA Index server allow clients to connect and communicate with the SAP HANA database? Please choose the correct answer:

Request Processing and Execution Control

Relational Engines

External Interfaces

Storage Engine and Disk Storage

77. Which system privilege must you have to restrict features for tennant databases in the SAP HANA cockpit? Please choose the correct answer.

INFILE ADMIN

WORKLOAD ADMIN

DATABASE ADMIN

RESOURCE ADMIN

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

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

How do you configure the index server 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.

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

Page 9 of 9

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

Backup

Data

Log

Pages in-memory

Storage snapshot

TAGS:

C_HANATEC_17, C_HANATEC_17 exam dumps

Notify of

Label

Name*

Email*

Website

Label

Name*

Email*

Website

0 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

Get C_HANATEC_17 Dumps Full Version

Q&As: 270
Versions: PDF and Software Download Now

About Dumpsinfo

Dumpsinfo is a good platform providing the latest exam information and dumps questions for all IT certification exams. You can study all the latest exam dumps questions online.

[email protected]

Mon - Sat 9:00am - 6:00pm

Prepare C_HANATEC_17 Exam with Using C_HANATEC_17 Dump Questions

Related

Posts

Good C_THR83_2411 Exam Dumps Save Your Preparation Time

Online C_THR70_2411 Dumps Help You Understand Questions Well

SAP C_THR95_2411 Exam Questions Simulate Actual C_THR95_2411 Exam

P_C4H34_2411 Dumps Help You Study Objectives

About Us

EMAIL

Services

Opening Hours