Month End Special - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

C_HANATEC_17 Questions and Answers

Question # 6

Which SAP HANA features can you use to manage the database peak load? There are 2 correct answers to this question.

A.

Admission control

B.

Capture and replay

C.

Thread throttling

D.

Workload classes

Full Access
Question # 7

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

A.

To store connection information on the SAP HANA XS Advanced engine

B.

To configure failover supporting a 3-tier scenario

C.

To configure an SAP HANA Auto-Restart Fault Recovery Support

D.

To store connection information on the SAP HANA database client

Full Access
Question # 8

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.

A.

SYSTEM users replaced by standby host

B.

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

C.

The standby host has file access

D.

The standby host has access to write to files

Full Access
Question # 9

Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? There are 2 correct answers to this question.

A.

The source and target database system are of the same type

B.

The Primary Application Server can be moved to a target system Landscape

C.

The target database is SAP Adaptive Server Enterprise (ASE)

D.

The source system is Application Server (AS) Java-base

Full Access
Question # 10

What are the prerequisites for using the Web user interface for HDBLCM? There are 2 correct answers to this question.

A.

The SAP HANA database is revision 90 or higher

B.

The communication port 1329 is open

C.

Internet Explorer - Version 8 or higher

D.

The communication port 1129 is open

Full Access
Question # 11

One of your systems show the internal Disk Full (Alert 30) alert. What is the root cause of this alert?

A.

Reading from the /hana/log/ volume is NOT possible

B.

Writing to the /hana/data/ volume is NOT possible

C.

Runing out of free space on the /hana/shared volume

D.

Exceeding system quota on the /usr/sap volume

Full Access
Question # 12

What is the correct sequence of the following four steps in the restart of the SAP HANA database system? Please choose the correct answer.

A.

Aborted transactions are rolled back. 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded.

B.

Aborted transactions are rolled back.

C.

Row tables are loaded into memory. 3. Open transactions are recovered. 4. Column tables are loaded.

D.

Row tables are loaded into memory. 2. Column tables are loaded. 3. Open transactions are recovered. 4. Aborted transactions are rolled back.

E.

Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded.

Full Access
Question # 13

Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store? There are 2 correct answers to this question.

A.

SAP HANA tenant database replication

B.

Internal communication channels with the system PKI

C.

HTTPS client access using the SAP HANA Web Dispatcher

D.

Client-server communication over JDBC

Full Access
Question # 14

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

A.

System replication

B.

Automatic savepoint

C.

Storage replication

D.

Standby node

Full Access
Question # 15

USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards. What happens if you drop USER B from the HANA database?

A.

The privilege remains assigned to both USER A and USER C.

B.

The privilege is revoked from USER A, but not USER C.

C.

The privilege is revoked from both USER A and USER C.

D.

The privilege is revoked from USER C, but not USER A.

Full Access
Question # 16

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

A.

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

B.

DMO allows an easy reset during the procedure.

C.

DMO allows a lower target release on SAP HANA database.

D.

DMO combines several steps into one procedure.

Full Access
Question # 17

What are advantages of column store tables? There are 3 correct answers to this question.

A.

Columns can be partitioned

B.

Only the columns required are actually loaded to memory

C.

They are optimized for high-volume read /write transactional processing

D.

Data footprint is automatically reduced through compression

Full Access
Question # 18

Your SAP HANA database is locked down. Which action can you still perform?

A.

Check database license

B.

Check overall database status

C.

Check session memory

D.

Configure system properties

Full Access
Question # 19

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

A.

Standby node

B.

Master node

C.

SYSTEMDB

Full Access
Question # 20

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

A.

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

B.

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

C.

Provide the measured table migration duration for table sequencing during benchmarking

D.

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

Full Access
Question # 21

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.

A.

Specify the name of the table/view.

B.

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

C.

Specify the user as the database user.

D.

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

Full Access
Question # 22

Which components of SAP HANA Indexserver allow clients to connect and communicate with the SAP HANA database? Please choose the correct Answer:.

A.

Request Processing and Execution Control

B.

Relational Engines

C.

External Interfaces

D.

Storage Engine and Disk Storage

Full Access
Question # 23

What can you directly assign to a user with the Manage Users app in SAP HANA cockpit? There are 2 correct answers to this question.

A.

Role collections

B.

Scopes

C.

Roles

D.

Privileges

Full Access
Question # 24

Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? Please choose the correct answer.

A.

The R3LDCTL

B.

The Process Bucket monitor

C.

The Log viewer

D.

The Observer Monitor

Full Access
Question # 25

What is XS?

A.

A native, lightweight application server

B.

A data cleansing engine

C.

An optional engine to handle excessive data loads

D.

A user interface

Full Access
Question # 26

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

A.

A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schema

B.

A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schema

C.

A multitenant configuration with SYSTEMDB

D.

The target database on SAP HANA 2.0 SPS00 or higher

Full Access
Question # 27

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.

A.

Having the data and log volumes on the different disks.

B.

Obtaining the hardware certification from SAP for the existing hardware you are going to use.

C.

Obtaining C_HANATEC_XX Certification.

D.

Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connectivity.

Full Access
Question # 28

Which information is provided by the backup catalog. Please choose the correct Answer:.

A.

Backup destination

B.

Progress of a backup

C.

Backup configuration

D.

Backup ID

Full Access
Question # 29

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.

A.

When you need to extend the scale-out memory

B.

When you need to optimize the standby node memory.

C.

When you need to measure total memory

D.

When you need to actively free up memory.

Full Access
Question # 30

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.

A.

One table is migrated per R3load pair.

B.

TABART is considered for the creation of R3load control files.

C.

SAP up decides which tables to split.

D.

De-pooling of tables is done during the procedure.

Full Access
Question # 31

You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database. From which location does the Recover Database app read the recovery information by default?

A.

$(DIR_INSTANCE)//trace

B.

$(DIR_INSTANCE)/backup/data

C.

$(DIR_INSTANCE)/../global/hdb/custom/config

D.

$(DIR_INSTANCE)/backup/log

Full Access
Question # 32

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

A.

Procedures

B.

Sequences

C.

Tables

D.

Views

Full Access
Question # 33

Which connection types are allowed when you use system replication with the Active/Active option? There are 2 correct answers to this question.

A.

Automatic round-robin statement routing

B.

Explicit read and write on the secondary system

C.

Explicit read only on the secondary system

D.

Implicit hint-based statement routing

Full Access
Question # 34

What are some advantages of a system replication with operation mode logreplay compared to delta_datashipping Note: There are 2 correct answers.

A.

Takeover time is shorter

B.

CPU load is reduced

C.

Network traffic is reduced

D.

Memory consumption is lower

Full Access
Question # 35

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.

A.

The CPU architecture must be identical.

B.

An explicit read-only connect on between both systems must be available

C.

Both must have the same SAP HANA version.

D.

Both systems are located in the same data center.

Full Access
Question # 36

Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with the read-enabled mode? Note: There are 2 correct answers.

A.

The same number of active hosts and standby hosts must be installed

B.

Both must have the same SAP HANA version

C.

An explicit read-only connection between both systems must be available

D.

The CPU architecture must be identical

Full Access
Question # 37

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?

A.

SAP HANA Infrastructure Services

B.

SAP HANA Enterprise Cloud

C.

SAP HANA AppServices

D.

SAP HANA DBServices

Full Access
Question # 38

What can you assign to a user with the User Management app in SAP HANA cockpit?

There are 2 correct answers to this question.

A.

LDAP identity provider

B.

Scopes

C.

User group

D.

LDAP authorization mode

Full Access
Question # 39

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

A.

Keep all partitions on different hosts.

B.

Keep the number of partitions per table high.

C.

Keep the number of partitioned tables low.

D.

Keep the number of key columns low.

Full Access
Question # 40

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

A.

SAP Adaptive Server Enterprise

B.

SAP Business Intelligence

C.

SAP Intelligent Query

D.

SAP Analytics Cloud

Full Access