[UPDATED Sep-2022] Best Value Available Preparation Guide for C_HANATEC_17 Exam [Q120-Q136] : Exams Labs Braindumps : http://blog.examslabs.com

Q120. You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?

A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schema

A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schema

A multitenant configuration with SYSTEMDB

The target database on SAP HANA 2.0 SPS00 or higher

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

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

Q123. Which application do you use to reset the memory statistics before you analyze a tenant database using SAP HANA cockpit?

Manage Databases

Manage Services

Resource Directory

Performance Monitor

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

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

Q126. Which connections do you need to enable explicitly for a Restricted user?
There are 2 correct answers to this question.

ODBC

JDBC

OLEDB

ADO.NET

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

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

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

Q130. You migrate an SAP HANA system using SUM database migration option. Which activities do you perform to activate the viewer mode for SAP support? Note: There are 2 correct answers.

Provide the sum observer URL to SAP support

Provide the SUM URL to SAP support

Create the OS user <sid>obs on the application server

Create the database user <sid>obs on the application server

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

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

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

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

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

Data transformation

Data cleansing

Data streaming

For data loading

Q136. The network security policies of your project restrict direct SQL connections to the SAP HANA databases. Which tools can you use to monitor the SAP HANA database? Note: There are 2 correct answers.

SAP Landscape Management

SAP HANA Cockpit

SAP HANA Data Management Suite

SAP Solution Manager

[UPDATED Sep-2022] Best Value Available Preparation Guide for C_HANATEC_17 Exam [Q120-Q136]

SAP C_HANATEC_17 Exam Description: