Black Friday Special Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

Home > SAP > SAP Certified Technology Associate > C_HANATEC_17

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

Question # 4

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

A.

Create a restricted user

B.

Assign a user to a user group

C.

Create and delete users

D.

Lock and unlock users

Full Access
Question # 5

Which of the following users are able to start and stop a distributed SAP HANA Database System? There are 2 correct Answers to this question.

A.

ROOT user

B.

ADM user

C.

SYSTEM user

Full Access
Question # 6

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.

A.

hdbcons

B.

RecoverStateCheckerpy

C.

sap control

D.

HDBAdmin

Full Access
Question # 7

Reloading column tables in this way restores the database to a fully operational state more quickly. However, it does create performance overhead, and may not be necessary in nonproductive systems, how can you

deactivate the the reload feature? Please choose the correct answer.

A.

Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false

B.

Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false

C.

Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to true

D.

Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false

Full Access
Question # 8

You plan to migrate a non-SAP database to SAP HANA using the database migration option (DMO) of the Software Update Manager. Which advanced DMO options can you adjust to speed up the migration? There are 2

correct answers to this question.

A.

SAPup processes

B.

TP processes

C.

SQL processes

D.

R3trans processes

Full Access
Question # 9

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

You need to set up an SAP HANA system where several companies share the same SAP HANA instance. You have to provide each company a dedicated share of the instance for its data, configuration and

user management. Which deployment scenario do you use?

A.

Multiple Components on One Database (MCOD)

B.

Multitenant database containers (MDC)

C.

Technical co-deployment (TCD)

D.

Multiple Components on One System (MCOS)

Full Access
Question # 11

You need to analyze the high CPU load of running thread in more detail in the Thread Monitor. Which parameters do you need to change? Note: There are 2 correct answers.

A.

threshold_cpu_time

B.

cpu_time_measurement_mode

C.

load_monitor_granularity

D.

enable_tracking

Full Access
Question # 12

How are savepoints triggered? There are 2 correct answers to this question

A.

By a database soft shutdown.

B.

By issuing a transactional commit.

C.

By performing a delta merge.

D.

By performing a database backup.

Full Access
Question # 13

You administer a single-host system with 100GB physical memory. The global allocation limit and the individual service allocation limit are set to 90%. Three services are running-Service 1 has 25 GB of memory

allocated and service 2 has 40 GB allocated. What is the effective allocation limit of service 3?

A.

100 GB

B.

90 GB

C.

35 GB

D.

25 GB

Full Access
Question # 14

Why does SAP HANA have a persistence storage layer that is disk-based? There are 2 correct answers to this question.

A.

To generate indexes for the column store

B.

To persist in-memory data

C.

To enable data recovery if the power fails

D.

To allow row store operations

Full Access
Question # 15

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

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.

Full Access
Question # 16

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

A.

Data transformation

B.

Data cleansing

C.

Data streaming

D.

For data loading

Full Access
Question # 17

Which prerequisites are necessary for productively using SAP HANA cockpit 2.0?

There are 2 correct answers to this question.

A.

10 GBit/s network bandwidth

B.

16 GB RAM on a dedicated server

C.

An intel-based system with operating system Microsoft Windows

D.

An IBM Power System with operating system SUSE Linux Enterprise Server (SLES)

Full Access
Question # 18

What do you do to prepare the database migration option of a Software Update Manager procedure? Note: There are 3 correct answers.

A.

Move the SPAM update archive into the download folder

B.

Extract the SAP HANA Client installation archive

C.

Move the stack.xml update file into the download folder

D.

Extract the SAP HANA database installation archive

E.

Move the R3trans update archive into the download folder

Full Access
Question # 19

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

A.

SLAVE

B.

STANDBY

C.

WORKER

D.

MASTER 1

Full Access
Question # 20

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

How can you perform a complete back up of an SAP HANA database system? Please choose the correct answer.

A.

Back up the system database and all tenant databases individually.

B.

Back up the system database and all tenant databases in one step.

C.

Back up the complete database system.

D.

Backup the complete storage system.

Full Access
Question # 22

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

Which of the following actions are possible when managing roles? There are 3 correct answers to this question.

A.

A role can contain either other roles or privileges but not both together

B.

A role can contain other roles and privileges at the same time

C.

A role can be nested to multiple other roles

D.

A role can contain multiple other roles

Full Access
Question # 24

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

Which of the following elements are required for implementing a database copy? There are 2 correct answers to this question.

A.

A data backup (file-based backups or backups using a third-party backup tool) or a storage snapshot of the source system is available.

B.

The target database must have a the same or higher version than the source database.

C.

You don't have to be concerned about disk space and memory of the target database.

D.

Source and target databases can have different number and types of services.

Full Access
Question # 26

Which removal statuses allow you to remove a host from an SAP HANA scale-out landscape Note: There are 2 correct answers.

A.

Reorg not required

B.

Reorg pending

C.

Reorg finished

D.

Reorg active

Full Access
Question # 27

You needt to integrate an existing SAP HANA2.0 SPS05 database system into the SAP HANA cockpit monitor infrastructure. Where do you create the technical user needed for the resource registration?

A.

In the first tenant

B.

In the SYSTEMDB and all tenants

C.

In the SYSTEMDB and the first tenant

D.

In the SYSTEMDB

Full Access
Question # 28

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

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

You are installing several SAP HANA systems with a standard setup. How can you automate this activity?

A.

Export and import the standard configurations from SAP HANA cocpit

B.

Copy the ini files to all systems

C.

Copy the complete install folders to all hosts

D.

Generate a configuration template using hdblcm

Full Access
Question # 31

How can you optimize the Database Migration Option (DMO) procedure downtime for a production system? There are 2 correct answers to this question.

A.

Provide the measured table migration duration data for optimal table sequencing during benchmarking.

B.

Set the optimal number of R31oad processes during benchmarking and the DMO procedure

C.

Use the Test Cycle opt on to find the optimal number of R31oad processes in a test run.

D.

Use the benchmarking option to find the optimal throughput during the DMO procedure.

Full Access
Question # 32

How are user group administrators and user groups related?

There are 2 correct answers to this question.

A.

Only one user group administrator per user group

B.

Multiple user group administrators per user group

C.

Only one user group per user group administrator

D.

Multiple user groups per user group administrator

Full Access
Question # 33

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.

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

Full Access
Question # 34

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

A.

User certificate

B.

Server certificate

C.

X.509 certificate

D.

Root certificate

Full Access
Question # 35

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

Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)? There are 3 correct answers to this question.

A.

Validation of the operating system configuration settings for the Linux kernel

B.

Measurement of the data throughput between CPU and DRAM

C.

Validation of the LPAR configuration settings on IBM Power servers

D.

Measurement of data throughput between SAP HANA nodes and storage

E.

Measurement of data throughput between the Linux kernel and CPU

Full Access
Question # 37

Where can you check the trace and log files when your SAP HANA database is NOT available? There are 2 correct answers to this question.

A.

In the /usr/sap//HDB//trace path on the operating system

B.

In the Trace app of the SAP HANA Web-based Development Workbench

C.

In the Diagnosis Files app of the SAP HANA cockpit for offline administration

D.

In the Troubleshoot Unresponsive System app of SAP HANA cockpit 2.0

Full Access
Question # 38

Which system usage types are automatically assigned to ties in the SAP HANA cockpit?

There are 3 correct answers to this question.

A.

Test

B.

Development

C.

Production

D.

Quality assurance

E.

Custom

Full Access
Question # 39

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

You plan to set up an SAP HANA2.0 system on intel-based hardware platform. Which of the following operating systems can you use Note: There are 2 correct answers.

A.

Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 7.2

B.

SUSE Linux Enterprise Server (SLES) for SAP Applications 12 SP1

C.

SUSE Linux Enterprise Server (SLES) for SAP Applications 11 SP1

D.

Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 6.5

Full Access