Summer Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sixtybuddy

Dumpsbuddy Logo
  1. Home
  2. SAP
  3. SAP Certified Technology Associate
  4. C_HANATEC_17
  5. SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Questions and Answers

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

Questions 4

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 5

Which operation is executed before a table is repartitioned?

Options:

A.

Savepoint

B.

Delta merge

C.

Snapshot

D.

Reorganization

Buy Now
Questions 6

Which target database does the SUM databases migration option provide by default? Note: There are 2 correct answers.

Options:

A.

SAp MaxDB

B.

SAP ASE

C.

SAP IQ

D.

SAP HANA

Buy Now
Questions 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.

Options:

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.

Buy Now
Questions 8

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 9

Which alert configuration properties can you configure in SAP HANA cockpit? There are 3 correct answers to this question.

Options:

A.

Schedule period

B.

Email alert notification

C.

Alert checker category

D.

Alert threshold values

E.

Schedule activation

Buy Now
Questions 10

Which certificates do you require for a trusted secure communication between the client and the SAP HANA database? Note: There are 2 correct answers.

Options:

A.

User certificate

B.

Server certificate

C.

X.509 certificate

D.

Root certificate

Buy Now
Questions 11

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

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

Options:

A.

Modeling

B.

Monitoring

C.

Repository

D.

Runtime

Buy Now
Questions 14

How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?

Options:

A.

Set up cross-database access control

B.

Set database isolation levels to high

C.

Edit the configuration change blacklist

D.

Assign internal communication ports

Buy Now
Questions 15

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

Options:

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

Buy Now
Questions 16

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

Options:

A.

System availability

B.

Alerts count

C.

Thread status

D.

CPU utilization

Buy Now
Questions 17

In which situations can you resume the failed recovery of your productive SAP HANA tenant database?

There are 2 correct answers to this question.

Options:

A.

An aborted recovery of a log backup

B.

An aborted recovery of a complete data backup

C.

An aborted recovery of delta data backup

D.

An aborted recovery of the configuration files

Buy Now
Questions 18

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 19

Which action do you perform when the data area in an SAP HANA database is running out of space?

Options:

A.

Create a new tenant database

B.

Extend the file system size in the operating system level

C.

Extend the size of the database volume

D.

Create a new database volume

Buy Now
Questions 20

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

Options:

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

Buy Now
Questions 21

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

Options:

A.

RoundRobin

B.

Hash

C.

Range-Range

D.

Range

Buy Now
Questions 22

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

Options:

A.

Hash

B.

Composite

C.

Range

D.

Round-robin

E.

Cluster

Buy Now
Questions 23

Which user credentials are requested during the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to an SAP HANA 2.0 database tenant? There are 3 correct answers to this question.

Options:

A.

The DBACOCKPIT user of the tenant database

B.

The S-user for the SAP Support Portal connection

C.

The SYSTEM user of the system database

D.

The DDIC user in client 000 of the A BAP system

E.

The SAP user in client 000 of the ABAP system

Buy Now
Questions 24

In which circumstances do you create a column store table? There are 3 correct answers to this question.

Options:

A.

When the calculations are based on a small number of columns

B.

When aggregations or fast search is required

C.

When accessing complete records

D.

When the table has a large number of columns

Buy Now
Questions 25

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 26

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.

Options:

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.

Buy Now
Questions 27

Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?

Options:

A.

DBA Cockpit

B.

hdblcm

C.

hdbsql

D.

SAP HANA cockpit

Buy Now
Questions 28

How do you trigger a savepoint in an SAP HANA database?

Options:

A.

Execute a delta merge

B.

Commit a transaction

C.

Start a log backup

D.

Perform a soft shutdown

Buy Now
Questions 29

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

Options:

A.

Data transformation

B.

Data cleansing

C.

Data streaming

D.

For data loading

Buy Now
Questions 30

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 31

The Add System Archive Link is a new feature that allows users to connect to multiple SAP HANA systems.

From which method one user can manage the list of all systems in a centrally-accessible archive (with read only link to other user)?

Options:

A.

File Export SAP HANA Landscape

B.

File archive SAP HANA Landscape

C.

File archive SAP HANA Export

D.

File Export Landscape SAP HANA

Buy Now
Questions 32

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.

Options:

A.

Near Zero Downtime

B.

Database migration options of SUM

C.

Export/import using SAP Provisioning Manager

D.

Phases update

Buy Now
Questions 33

Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.

Options:

A.

SLAVE

B.

STANDBY

C.

WORKER

D.

MASTER 1

Buy Now
Questions 34

You investigate a hung SAP HANA database, and you CANNOT identify the blocking transactions. What causes could lead to this behavior? Note: There are 2 correct answers.

Options:

A.

A wrong role of a service in a failover situation

B.

An issue with the delta merge

C.

A setting to restrict CPU usage

D.

A long savepoint duration

Buy Now
Questions 35

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
Questions 36

Which backup and recovery scenario is allowed in multitenant database containers?

Options:

A.

A backup of a tenant database can be recovered to the system database.

B.

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

C.

After the recovery of a tenant database, the system database needs a backup.

D.

A tenant database can initiate its own backup, but the system database executes the recovery.

Buy Now
Questions 37

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 38

Which of the following events occur while the merge operation is running? There are 2 correct answers to this question.

Options:

A.

The content of the first main storage and the committed entries in the first delta storage are merged into the new second main storage.

B.

The content of the complete main storage is persisted to disk.

C.

Uncommitted changes in the first delta storage are rolled back.

D.

All write operations go to the second delta storage.

Buy Now
Questions 39

What is included with the Predictive Analysis Library (PAL)? There are 2 correct answers to this question.

Options:

A.

Predictive algorithms

B.

Flowgraphs

C.

Text mining functions

D.

Data preparation functions

Buy Now
Questions 40

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

There are 2 correct answers to this question.

Options:

A.

LDAP identity provider

B.

Scopes

C.

User group

D.

LDAP authorization mode

Buy Now
Exam Code: C_HANATEC_17
Exam Name: SAP Certified Technology Associate - SAP HANA 2.0 SPS05
Last Update: Apr 19, 2024
Questions: 270

PDF + Testing Engine

$130
buy now C_HANATEC_17 pdf + testing engine

Testing Engine

$95
buy now C_HANATEC_17 testing engine

PDF (Q&A)

$80
buy now C_HANATEC_17 pdf