Updated Apr-2023 Test Engine to Practice C_HANATEC_17 Test Questions [Q103-Q127]

Rate this post

Updated Apr-2023 Test Engine to Practice C_HANATEC_17 Test Questions

C_HANATEC_17 Real Exam Questions Test Engine Dumps Training With 272 Questions

Prerequisites of SAP C_HANATEC_17 Exam

To pass SAP C_HANATEC_17 exam, candidates must have thorough knowledge of SAP ERP and in-depth knowledge of Business Processes. Candidates need to have knowledge about the core modules and its business processes.Obviously, candidates must be well versed with the technical aspects of SAP HANA. They should have at least one project under their belt. SAP C_HANATEC_17 Dumps contains the right questions and answers that will help you get prepared for the actual exam. That is why we recommend using this product as your first step towards certification. Answer the questions that are included in this product in the same manner as you do in the actual exam. This way, you will be able to evaluate your performance in an effective manner. You can use the practice test to evaluate your performance before you purchase the product. You can use it to evaluate the quality of the product. If you are satisfied with the quality, then you can purchase the product. This way, you can be sure that you will get a high-quality product. We provide customer support 24/7.

QUESTION 103
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

QUESTION 104
Which removal statuses allow you to remove a host from an SAP HANA scale-out landscape Note: There are 2 correct answers.

Reorg not required

Reorg pending

Reorg finished

Reorg active

QUESTION 105
In single-host SAP HANA systems, you can use plain attached storage devices, such as Small Computers System Interface hard drives, solid-state drives (SSDs), or storage area networks (SANs).
However, to build a multi-host system with failover capabilities, the storage must ensure which of the following conditions?
There are 2 correct answers to this question.

SYSTEM users replaced by standby host

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

The standby host has file access

The standby host has access to write to files

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

QUESTION 107
Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit?
There are 3 correct answers to this question.

Cockpit User

Database User

sap

<sid>adm

Root

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

R3ta

Log tail Viewer

Table comparison

R3load utilization

QUESTION 109
You suspect an authorization issue while executing SAP HANA reports that contain calculation views. How do you configure the authorization trace? There are 2 correct answers to this question.

Specify the name of the table/view.

Select INFO from the System Trace Level for the Indexserver component and then select AUTHORIZATION.

Specify the user as the database user.

Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATION.

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

Cockpit User Role

Cockpit Administrator Role

Cockpit User Administrator Role

Cockpit Database Administrator Role

QUESTION 111
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

QUESTION 112
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 FULL.

Partition the row store across nodes.

QUESTION 113
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

QUESTION 114
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

QUESTION 115
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

QUESTION 116
How are savepoints triggered? There are 2 correct answers to this question

By a database soft shutdown.

By issuing a transactional commit.

By performing a delta merge.

By performing a database backup.

QUESTION 117
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)

QUESTION 118
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

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

QUESTION 120
Which R3load mode is used during an inplace SUM database migration option procedure?

Socket

File

Network

Pipe

QUESTION 121
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

QUESTION 122
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

QUESTION 123
Which characteristics describe an SAP HANA Multiple Database Container (MDC) System?
There are 3 correct answers to this question.

Each tenant database runs its own compile server and the preprocessor server.

Database Isolation increases the isolation between tenant databases on the operating system level.

A Multitenant Database Container system is identified by a single System ID (SID).

The name server owns information about the location of tables and table partitions in databases.

The name server provides index server functionality for the system database.

QUESTION 124
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

QUESTION 125
Which file system locations do you need to specify when installing the SAP HANA multi-host database system using the default settings?
There are 2 correct answers to this question.

/hana/shared

/hana/log/<SID>

/usr/sap/hostctrl

/usr/sap/<SID>

QUESTION 126
Where is SDI used? There are 2 correct answers to this question.

Data transformation

Data cleansing

Data streaming

For data loading

QUESTION 127
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