Summer Special Sales Coupon - 55% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4s55disc

C_HANATEC_17 PDF

$49.5

$109.99

3 Months Free Update

Add to Cart
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

C_HANATEC_17 PDF + Testing Engine

$79.2

$175.99

3 Months Free Update

Add to Cart
  • Exam Name: SAP Certified Technology Associate - SAP HANA 2.0 SPS05
  • Last Update: May 14, 2022
  • Questions and Answers: 270
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

C_HANATEC_17 Engine

$59.4

$131.99

3 Months Free Update

Add to Cart
  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included

C_HANATEC_17 SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Questions and Answers

Question # 6

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.

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

Full Access
Question # 7

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.

A.

Store the logon credentials of the replayer user in the secure store.

B.

Create a replayer user account on the target operating system.

C.

Preprocess the captured workload on the source system.

D.

Restore the source system tenant backup to the target tenant.

E.

Create a replayer user account in the target database system.

Full Access
Question # 8

Which tools can you use to start and stop an SAP HANA database? Note: There are 3 correct answers.

A.

DBA cockpit

B.

SAP HANA application life cycle management (HDBLCM)

C.

HDB command

D.

SAP HANA cockpit

E.

Sapcontrol

Full Access
Question # 9

What are prerequisites for changing the SSFS Master Keys? There are 2 correct answers to this question.

A.

You have the system privilege I IN I FILE ADMIN

B.

You have the credentials of the Operating system user adm that was created when the system was installed

C.

You have the credentials of the SYSTEM user

D.

You have the server root privilege INIFILE ADMIN

Full Access
Question # 10

You are registering an SAP HANA database resource using SAP HANA cockpit manager. Which privileges are automatically assigned when you initially create the COCKPIT_MONITOR technical user?

There are 2 correct answers to this question.

A.

DATABSE ADMIN

B.

CATALOG READ

C.

SELECT on the SYS_TELEMETRY schema

D.

SELECT on the SYS_STATISTICS schema

Full Access
Question # 11

Which types of backup can you use to copy an SAP HANA tenant database?

There are 2 correct answers to this question.

A.

Full database backup

B.

Data snapshot

C.

Delta database backup

D.

Fallback snapshot

Full Access
Question # 12

Which tools are integrated into the SAP HANA cockpit?

There are 3 correct answers to this question.

A.

Database Explorer

B.

HANA Sitter

C.

SQL Console

D.

SQL Analyzer

E.

HDB Admin

Full Access
Question # 13

What are some of the characteristics of the design-time role? There are 3 correct answers to this question.

A.

The role can be transported between systems.

B.

The role is revoked if the grantee user is deleted.

C.

The role is granted and revoked directly by the database user.

D.

The role is created by technical user _SYS_REPO.

E.

The role is granted through the execution of stored procedures.

Full Access
Question # 14

You create a new user by copying an existing user. Which predelivered role of the existing user is automatically granted to the new user?

A.

Modeling

B.

Monitoring

C.

Repository

D.

Runtime

Full Access
Question # 15

Which of the following SAP HANA capability allows you to load and replicate data in real time from ABAP source systems and non-ABAP source systems to an SAP HANA environment? Please choose the correct

answer.

A.

SAP HANA landscape transformation replication server

B.

SAP HANA dynamic tearing

C.

SAP HANA remote data sync

D.

SAP HANA smart data streaming

Full Access
Question # 16

Which operation is executed before a table is repartitioned?

A.

Savepoint

B.

Delta merge

C.

Snapshot

D.

Reorganization

Full Access
Question # 17

The SAP HANA database is NOT reachable, and the root cause is unclear. Which SAP HANA cockpit functions allow you to investigate this situation? Note: There are 2 correct answers.

A.

Troubleshoot unresponsive system

B.

Overall database status

C.

Manage full system information dumps

D.

Open blocked transactions

Full Access
Question # 18

You created a restricted user in the DB1 database. Which commands must you use to convert the restricted SAP HANA user to a standard SAP HANA user? There are 3 correct answers to this question.

A.

ALTER USER GRANT ROLE PUBLIC

B.

ALTER USER ENABLE CLIENT CONNECT

C.

ALTER USER ACTIVATE USER NOW

D.

ALTER USER GRANT CREATE ANY ON OWN SCHEMA

E.

ALTER USER ADD REMOTE IDENTITY

Full Access
Question # 19

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

A.

HanaHwCheck.py

B.

fullSystemlnfoDump.py

C.

hanachecker.py

D.

hanadumpviewer.py

Full Access
Question # 20

Which operations are performed by SAP Landscape Management? Note: There are 2 correct answers.

A.

It de-centralizes landscape operations and provides local landscape view

B.

It automizes repetitive, time-intensive administration tasks

C.

It simplifies the management of SAP hybrid landscapes and standardizes SAP operations

D.

It replicates the storage in SAP landscape

Full Access
Question # 21

In which scenario do you need SAP expert sizing? There are 2 correct answers to this question.

A.

Customers want to migrate their existing SAP NetWeaver-based systems to run on SAP HANA

B.

Consolidating multiple ERP source systems into one ERP system on SAP HANA

C.

Carving out ERP functionality from the source system to the ERP on SAP HANA system.

D.

Customers are new to SAP applications and SAP HANA

Full Access
Question # 22

Which of the following tasks requires the BACKUP ADMIN authorization? There are 2 correct Answers to this question.

A.

Recovering the database without a user interface

B.

Physically deleting data and log backups and obsolete versions of the backup catalog from the backup location.

C.

Administration tasks executed on a tenant database through the system database.

D.

Backing up the database without a user interface.

Full Access
Question # 23

Which system privilege must you have to restrict features for tennant databases in the SAP HANA cockpit?

Please choose the correct answer.

A.

INFILE ADMIN

B.

WORKLOAD ADMIN

C.

DATABASE ADMIN

D.

RESOURCE ADMIN

Full Access
Question # 24

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 # 25

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.

A.

memory_tracking

B.

statement_memory_limit

C.

reject_memory_threshold

D.

total_statement_memory_limit

Full Access
Question # 26

Which of the following privileges allow read access to data in SAP HANA information models depending on certain values or combination of values?

A.

Object Privileges

B.

Analytic Privileges

C.

System Privileges

D.

Package Privileges

Full Access
Question # 27

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

A.

The content of log files via the log viewer

B.

The memory consumption of SUM

C.

A progress bar for the overall procedure

D.

The active roadmap step

Full Access
Question # 28

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.

A.

Provide the sum observer URL to SAP support

B.

Provide the SUM URL to SAP support

C.

Create the OS user obs on the application server

D.

Create the database user obs on the application server

Full Access
Question # 29

Which tool do you use to backup the root encryption keys?

A.

rsecssfx

B.

hdbuserstore

C.

dbacockpit

D.

hdbnsutil

Full Access
Question # 30

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 # 31

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 # 32

Which table partitioning types does SAP HANA support? There are 3 correct answers to this question.

A.

Hash

B.

Composite

C.

Range

D.

Round-robin

E.

Cluster

Full Access
Question # 33

You need to update the location where a copy of the persistent data is saved. Which of the following parameters do you change? Note: There are 2 correct answers.

A.

basepathjogmirror

B.

basespath_export

C.

basepathjogbackup

D.

basepath_databackup

Full Access
Question # 34

How can you use the results from a comparable the run to optimize the database migration option (DMO) procedure downtime for a production system?

There are 2 correct answers to this question.

A.

Use the Test Cycle option to determine the optimal number of R3load processes.

B.

Use the UPGANA.XML analysis file to optimize the number of R3load processes.

C.

Use the MIGRATE_DT_DUR.XML file to optimize table splitting and migration sequence.

D.

Use the MIGRATE_SOT_DUR.XML file to manually optimize table splitting of large tables.

Full Access
Question # 35

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.

A.

SAP Landscape Management

B.

SAP HANA Cockpit

C.

SAP HANA Data Management Suite

D.

SAP Solution Manager

Full Access
Question # 36

Which information can you analyze using the Troubleshoot Unresponsive System application?

A.

System availability

B.

Alerts count

C.

Thread status

D.

CPU utilization

Full Access
Question # 37

What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? Please choose

A.

Metadata Manager and Transaction Manager

B.

Page Management and logge

C.

Column Store and Row Store

D.

Session Management and log Volumes

Full Access
Question # 38

Which update methods can yo use to minimize the business downtime during the upgrade of an SAP HANA database? Note: There are 2 correct answers.

A.

Near Zero Downtime

B.

Database migration options of SUM

C.

Export/import using SAP Provisioning Manager

D.

Phases update

Full Access
Question # 39

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

A.

Manage Databases

B.

Manage Services

C.

Resource Directory

D.

Performance Monitor

Full Access
Question # 40

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.

A.

Check the number of partitions

B.

Check the correct location of tables and partitions

C.

Redistribute tables after adding host(s)

D.

Balance table distribution

Full Access