[Q151-Q175] Free C_HANATEC_17 Questions for SAP C_HANATEC_17 Exam [May-2023]

4/5 - (1 vote)

Free C_HANATEC_17 Questions for SAP C_HANATEC_17 Exam [May-2023]

Validate your C_HANATEC_17 Exam Preparation with C_HANATEC_17 Practice Test (Online & Offline)

NEW QUESTION 151
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.

NEW QUESTION 152
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

NEW QUESTION 153
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

NEW QUESTION 154
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

NEW QUESTION 155
Which partitioning option distributes rows equally for load balancing in the SAP HANA database?

RoundRobin

Hash

Range-Range

Range

NEW QUESTION 156
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

NEW QUESTION 157
Your customer has security restrictions that prohibit direct SQL connections from your PC to the productive SAP HANA system.
Which tools can you use to monitor the system alerts of the SAP HANA database from your PC? There are 2 correct answers to this question.

SAP HANA studio

DBA Cockpit

SAP NANA cockpit 2.0

HDBSQL command line tool

NEW QUESTION 158
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

NEW QUESTION 159
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.

NEW QUESTION 160
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.

NEW QUESTION 161
What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases?
There are 2 correct answers to this question.

The cross-tenant database communication must be explicitly activate

The bidirectional communication channel must be whiteliste

The user in the source system must have sufficient privileges in the target database

The user in the source system must be associated with a user in the target database

NEW QUESTION 162
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

NEW QUESTION 163
Where can you check the trace and log files when your SAP HANA database is NOT available? There are 2 correct answers to this question.

In the /usr/sap/<SID>/HDB<instance number>/<host>/trace path on the operating system

In the Trace app of the SAP HANA Web-based Development Workbench

In the Diagnosis Files app of the SAP HANA cockpit for offline administration

In the Troubleshoot Unresponsive System app of SAP HANA cockpit 2.0

NEW QUESTION 164
Which trace do you use to create a graphical representation of an individual SQL Statement?

Performance trace

Expensive statements trace

SQL trace

Plan trace

NEW QUESTION 165
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

NEW QUESTION 166
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)

NEW QUESTION 167
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

NEW QUESTION 168
Which tool do you use to investigate an SAP HANA system that is started but can’t be reached using SQL? There are 2 correct answers to this question.

HANASitter

hdbcons

HDBAdmin

Sapcontrol

NEW QUESTION 169
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

NEW QUESTION 170
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

NEW QUESTION 171
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

NEW QUESTION 172
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

NEW QUESTION 173
You are checking and monitoring SAP HANA system replication. Which status indicates a temporary connection loss of the secondary system?
Please choose the correct answer.

Syncing

Error

Initializing

Unknown

NEW QUESTION 174
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

NEW QUESTION 175
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

Loading …