Summer Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

C_HANATEC_17 Exam Dumps - SAP Certified Technology Associate - SAP HANA 2.0 SPS05

Question # 4

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

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

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

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

Which operation is executed before a table is repartitioned?

A.

Savepoint

B.

Delta merge

C.

Snapshot

D.

Reorganization

Full Access
Question # 9

How can the system database administrator disable tenant database functionalities? Please choose the correct answer.

A.

Using the hdbuserstore tool

B.

Using the resident hdblcm tool

C.

Using the Manage Restricted Features app

D.

Using the Manage Blacklisted Parameter app

Full Access
Question # 10

Which SAP recommendations do you follow to create an optimal table partitioning plan for SAP Business Suite powered by SAP HANA? Note: There are 2 correct answers.

A.

Have a high number of partitions per table

B.

Have a low number of keys

C.

Have partitions of a table on the same host

D.

Have a high number of partitioned tables

Full Access
Question # 11

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

A.

MONITOR ADMIN

B.

DATA ADMIN

C.

BACKUP ADMIN

D.

DATABASE ADMIN

Full Access
Question # 12

Your application runs with a technical user in a database of an SAP HANA multitenant database container. You want to execute a query across tenant databases. Which of the following prerequisites are required? There

are 2 correct answers to this question.

A.

User mapping

B.

User sharing

C.

Communication channel whitelist

D.

Bi-directional communication channels

Full Access
Question # 13

In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? There are 2 correct answers to this question.

A.

When the log buffer is full.

B.

When the time threshold is exceeded.

C.

When the log segment is full.

D.

When a commit occurs.

Full Access
Question # 14

What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring tool for productive SAP HANA databases?

A.

A dedicated server with at least 16 GB RAM with SUSE Linux Enterprise Server (SLES) or Red Hat Enterprise Linux (RHEL)

B.

A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed

C.

A central SAP HANA database 2.0 SPS05 multitenant database system with at least 16 GB of RAM

D.

SAP Netweaver 7.5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed

Full Access
Question # 15

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

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

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

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

What is a characteristic of the synchronous in-memory system replication mode in SAP HANA?

A.

The primary system waits until the secondary system confirms receiving the log

B.

The primary system waits until the secondary system confirms the log was persisted

C.

The primary system does NOT wait for confirmation of the secondary system

D.

The primary system suspends transactions processing until the connection to the secondary system is established

Full Access
Question # 20

Which system privilege must you have to manage black listed parameters in SAP HANA cockpit? Please choose the correct answer.

A.

DATABASE ADMIN

B.

WORKLOAD ADMIN

C.

INIFILE ADMIN

D.

RESOURCEADMIN

Full Access
Question # 21

Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.

A.

Cockpit User Administrator

B.

Cockpit User

C.

Cockpit Resource Administrator

D.

Cockpit Administrator

Full Access
Question # 22

Which privileges are assigned automatically when you create a technical user during the register resource procedure in SAP HANA cockpit? There are 2 correct answers to this question.

A.

SELECT on the _SYS_TELEMETRY schema

B.

RESOURCE ADMIN

C.

SELECT on the _SYS_STATISTICS schema

D.

CATALOG READ

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

How can troubleshoot HANA installer when its crashes There are 2 correct answers to this question.

A.

run hdblcm with the check_installation action

B.

set the environment variable HDB_INSTALLER_TRACE_FILE to the trace filename

C.

create the dirctory containing the trace file

D.

activate the debug mode for the database trace

Full Access
Question # 25

Why are repository roles preferred over catalog roles? Note: There are 2 correct answers.

A.

They are created by the technical user

B.

They are revoked if the database user that granted them is deleted.

C.

They are transportable runtime objects

D.

They are transportable design-time objects

Full Access
Question # 26

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

Which kinds of patches are available in the SAP HANA2.0 revision strategy? Note: There are 2 correct answers.

A.

Feature Package Stack

B.

Datacenter Service Point

C.

Support Package

D.

Support Package Stack

Full Access
Question # 28

What is a prerequisite when you install the SAP Landscape Management tool? Please choose the correct answer.

A.

SAP HANA XS Advanced

B.

SAP NetWeaver Application Server Java

C.

SAP Fiori launchpad

D.

SAP NetWeaver Application Server ABAP

Full Access
Question # 29

How do you ensure that Web-based applications send HTTPS requests to specific databases in an SAP HANA multiple-container system? Note: There are 2 correct answers.

A.

Check the hostnames mapping to internal HTTPS ports

B.

Configure an SAP Web Dispatcher for every tenant databases

C.

Configure an alias hostname for every tenant database

D.

Check that all requests with physical hostnames are forwarded to tenant databases

Full Access
Question # 30

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

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

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

A.

Kernel settings

B.

Network configuration

C.

Memory configuration

D.

Missing OS patches

Full Access
Question # 33

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

A.

rsecssfx

B.

hdbuserstore

C.

dbacockpit

D.

hdbnsutil

Full Access
Question # 34

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

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.

Full Access
Question # 35

You perform an SAP HANA migration to a scale-out landscape. When do you setup the table distribution?

A.

After the migration

B.

Before table creation

C.

After table creation

D.

Before the migration

Full Access
Question # 36

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

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

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

Full Access
Question # 38

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

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.

Full Access
Question # 39

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

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

Full Access
Question # 40

SAP HANA system replication is configured and active between two SAP HANA systems. After which action must you perform manual steps to synchronize the systems? Please choose the correct answer.

A.

A restart of the primary system

B.

A restart of the secondary system

C.

An upgrade of the secondary system

D.

An upgrade of the primary system

Full Access