2022 New Year Express Limited Time 55% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 5763r953

Welcome To DumpsPedia

C_HANATEC_17 Sample Questions Answers

Questions 4

Which tools can you use to monitor the response time of individual SQL queries? Note: There are 2 correct answers.

Options:

A.

SQL Trace

B.

Statement Monitor

C.

SQL plan cache

D.

Thread Monitor

Buy Now
Questions 5

What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication? There are 2 correct answers to this question.

Options:

A.

Delta data shipping takes place in addition to continuous log replay.

B.

Delta data shipping takes place with continuous read-only access to the secondary system.

C.

Delta data shipping takes place in addition to continuous log shipping.

D.

Delta data shipping takes place every 5 minutes.

Buy Now
Questions 6

What software innovations did SAP deliver with SAP HANA? There are 2 correct answers to this question.

Options:

A.

Row and Delta store.

B.

Insert only on Column store.

C.

Partitioning.

D.

Compression and Decompression.

Buy Now
Questions 7

Which information is provided via the SUM Ul? There are 3 correct answers to this question.

Options:

A.

The active roadmap step

B.

The content of log files via the log viewer

C.

The memory consumption of SUM

D.

A progress bar for the overall procedure

Buy Now
Questions 8

Which tool shows you information about the list of tables to be pre-loaded during an SAP HANA system start?

Please choose the correct answer.

Options:

A.

hdbcons

B.

RecoverStateCheckerpy

C.

sap control

D.

HDBAdmin

Buy Now
Questions 9

What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? There are 2 correct answers to this question.

Options:

A.

Kernel settings

B.

Network configuration

C.

Memory configuration

D.

Missing OS patches

Buy Now
Questions 10

What must you do to convert an SAP HANA 1.0 single database system to an SAP HANA 2.0 multitenant database system?

Options:

A.

Export/import application and customer data

B.

Upgrade the SAP HANA database system

C.

Execute the SUM database migration option with system move

D.

Create the system database manually

Buy Now
Questions 11

What can you do to shorten the startup time of an SAP HANA system after a reboot?

Options:

A.

Flag all columnar tables for preload.

B.

Set the savepoint interval to a lower value.

C.

Set the preload column value in the Tables system table to FULL.

D.

Partition the row store across nodes.

Buy Now
Questions 12

The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the SAP HANA database request additional memory?

Options:

A.

Standby memory

B.

Physical memory

C.

Resident memory

D.

Virtual memory

Buy Now
Questions 13

SAP HANA, in the context of user management, allows you to do which of the following? There are 3 correct answers to this question.

Options:

A.

Create a restricted user

B.

Assign a user to a user group

C.

Create and delete users

D.

Lock and unlock users

Buy Now
Questions 14

Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question.

Options:

A.

Set the password for the system database user.

B.

Create an operating system user for the converted tenant database.

C.

Trigger the conversion in the SAP HANA cockpit 2.0.

D.

Generate the system database before the conversion.

Buy Now
Questions 15

logical error occurred in one tenant of your SAP HANA database. What action do you perform to make the tenant consistent again? Please choose the correct Answer:

Options:

A.

Recover the affected tenant. The system database is NOT recovered.

B.

Recover the system database first and then recover the affected tenant.

C.

Recover the affected tenant first and then recover the system database.

D.

Recover the system database. The affected tenant is recovered automatically.

Buy Now
Questions 16

Which backup scenarios are allowed in multitenant database containers? Note: There are 2 correct answers.

Options:

A.

The system database can initiate its own backup and the backup of tenant databases

B.

A backup of a tenant database can be recovered to an SAP HANA single-container system

C.

The system database should be recovered first in order to recover the tenant databases

D.

A tenant database can initiate its own backup unless this is prohibited by the system configuration

Buy Now
Questions 17

You upgrade an SAP HANA 1.0 system to SAP HANA 2.0. Which of the following activities are required to avoid compatibility issues after the upgrade. Note: There are 2 correct answers.

Options:

A.

Export the backup jobs history from SAP HANA 1.0 and import the history after the upgrade

B.

Delete all Backup schedules with the SAP HANA cockpit 1.0

C.

Create new backup schedules after the upgrade

D.

Convert all SAP HANA 1.0 backup schedules to SAP HANA 2.0 backup schedules

Buy Now
Questions 18

The recovery of your productive SAP HANA database fails during log replay. What is the fastest solution to complete the recovery.

Options:

A.

Restart the database and resume the interrupted recovery

B.

Resume the recovery from beginning

C.

Resume the interrupted recovery

D.

Replay the delta backups and log backups

Buy Now
Questions 19

Which script can you trigger from SAP HANA cockpit to collect diagnosis information?

Options:

A.

HanaHwCheck.py

B.

fullSystemlnfoDump.py

C.

hanachecker.py

D.

hanadumpviewer.py

Buy Now
Questions 20

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.

Options:

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

Buy Now
Questions 21

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.

Options:

A.

SAP HANA as a data mart for reporting and analytics.

B.

SAP HANA as a platform for providing database and application services to native SAP HANA-based applications.

C.

SAP HANA as a classic three-tier architecture as the primary database (for example. SAP NetWeaver Business Warehouse, SAP Business Suite Installation).

Buy Now
Questions 22

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

Options:

A.

Manage Databases

B.

Manage Services

C.

Resource Directory

D.

Performance Monitor

Buy Now
Questions 23

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

Options:

A.

The R3LDCTL

B.

The Process Bucket monitor

C.

The Log viewer

D.

The Observer Monitor

Buy Now
Questions 24

Which of the following tasks can you perform using the resident SAP HANA database lifecycle manager (HDBLCM)? Note: There are 3 correct answers.

Options:

A.

Rename the SAP HANA Database hostname

B.

Remove host roles

C.

Transport application changes

D.

Rename the SAP HANA database system

E.

Uninstall the individual components

Buy Now
Questions 25

When you use the database migration option reset procedure as a fallback scenario, which of the changes made during the migration are NOT reset? There are 3 correct answers to this question.

Options:

A.

The SAP ABAP kernel on the application server

B.

The DBACOCKPIT user on the SAP HANA database

C.

The updated BRTOOLS on the non-SAP database

D.

The deleted SAP BusinessObjects Business Intelligence data on the non-SAP database

E.

The shadow schema on the non-SAP database

Buy Now
Questions 26

Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server? There are 2 correct answers to this question.

Options:

A.

User mapping

B.

User creation

C.

Password policy configuration

D.

Role assignment

Buy Now
Questions 27

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

Options:

A.

Kerberos

B.

SAML

C.

PKCS #12

D.

X.509

Buy Now
Questions 28

Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure? There are 2 correct answers to this question.

Options:

A.

Move the latest R3trans update archive into the download folder.

B.

Extract the SAP HANA database software installation archive.

C.

Check if the latest SPAM/SAINT update is applied.

D.

Update the SAP Host Agent to the latest version

Buy Now
Questions 29

Which tools are integrated into the SAP HANA cockpit?

There are 3 correct answers to this question.

Options:

A.

Database Explorer

B.

HANA Sitter

C.

SQL Console

D.

SQL Analyzer

E.

HDB Admin

Buy Now
Questions 30

Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system? There are 2 correct answers to this question.

Options:

A.

Migrating to a target database, g. SAP HANA

B.

Performing an SAP software update

C.

Performing a Unicode conversion

D.

Performing a database upgrade of the source database

Buy Now
Questions 31

Which activity must you perform before you can replay a workload using the Capture and Replay Application? Note: There are 2 correct answers.

Options:

A.

Restore the source tenant backup into the target tenant

B.

Start the replayer on the source system

C.

Create the replayer user in the control system

D.

Create a secure store key on the control system host

Buy Now
Questions 32

During the delta merge process, to which memory areas is data inserted? There are 2 correct Answers to this question.

Options:

A.

Delta 2

B.

Main 2

C.

Delta 1

D.

Main 1

Buy Now
Questions 33

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

Options:

A.

SAP Adaptive Server Enterprise

B.

SAP Business Intelligence

C.

SAP Intelligent Query

D.

SAP Analytics Cloud

Buy Now
Questions 34

Which fault recovery features can you implement to make your SAP HANA 2.0 production system more resilient against local hardware errors and software faults? There are 2 correct answers to this question.

Options:

A.

Service auto-restart

B.

Storage replication

C.

Host auto-failover

D.

Auto log backups

Buy Now
Questions 35

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.

Options:

A.

memory_tracking

B.

statement_memory_limit

C.

reject_memory_threshold

D.

total_statement_memory_limit

Buy Now
Questions 36

you can establish SAP Solution Manager connectivity and configure a Remote Service Connection (via SAP Router) as part of the initial setup. Since Solution Manager 7.1 SP04, the SAP HANA databases can be integrated into SAP Solution Manager.

What are these components can be integrated into SAP HANA database?

There are 3 correct answers to this question.

Options:

A.

Performance Warehouse

B.

SAP HANA Database

C.

Alerting Infrastructure

D.

The transaction DBACockpit

Buy Now
Questions 37

The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question.

Options:

A.

The role name

B.

The privileges assigned to the role

C.

The users assigned to the role

D.

The users assigned by default to this role

Buy Now
Questions 38

Which system privileges are required for administrating tenant databases when being connected to the system database? There are 2 correct answers to this question.

Options:

A.

MONITOR ADMIN

B.

DATA ADMIN

C.

BACKUP ADMIN

D.

DATABASE ADMIN

Buy Now
Questions 39

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.

Options:

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

Buy Now
Questions 40

Which characteristics describe an SAP HANA Multiple Database Container (MDC) System?

There are 3 correct answers to this question.

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Buy Now
Exam Code: C_HANATEC_17
Exam Name: SAP Certified Technology Associate - SAP HANA 2.0 SPS05
Last Update: Jan 21, 2022
Questions: 270
$72  $159.99
$54  $119.99
$45  $99.99
buy now C_HANATEC_17