Hanatec Set1 Que

(1)

©SAP Certification Questions www.sap

SAP Certified

(Edition 2013)

©SAP Certification Questions www.sap-certification-info.com

SAP Certified Technology Associate

(2)

QUESTION NO: 1

What is the connection type for communication between the SAP LT Replication Server and the non

A.TRFC

B. Web service C. QRFC

D.Database

QUESTION NO: 2

Which user must have SELECT privilege schema? A.<SID>ADM B. SYSTEM C. _SYS_BIC D._SYS_REPO QUESTION NO: 3

What is the purpose of the save point process in SAP HANA?

A. Save logs to persistent storage when a transaction is committed.

B. Free up memory by saving less frequently used data to persistent storage.

C. Save changed data and logs to persistent storage on a regular basis.

D. Save changed data to persistent storage when a transaction is committed.

QUESTION NO: 4

Which of the following are recovery types in SAP HANA database? (Choose two)

A. Recovery with incremental backup B. Recovery until cancel

C. Full recovery

D. Point in time recovery

What is the connection type for communication between the SAP LT Replication Server and the non-SAP source system?

Which user must have SELECT privilege with the grant option on the data

What is the purpose of the save point process in SAP HANA?

Save logs to persistent storage when a transaction is committed.

Free up memory by saving less frequently used data to persistent Save changed data and logs to persistent storage on a regular basis.

Save changed data to persistent storage when a transaction is

following are recovery types in SAP HANA database? (Choose

Recovery with incremental backup Recovery until cancel

Point in time recovery

What is the connection type for communication between the SAP LT

with the grant option on the data

Save logs to persistent storage when a transaction is committed.

Free up memory by saving less frequently used data to persistent Save changed data and logs to persistent storage on a regular basis.

Save changed data to persistent storage when a transaction is

(3)

QUESTION NO: 5

Which of the following must be running to view SAP HANA Diagnosis Files the SAP HANA database is offline?

A.sapstartsrv B. SMD Agent C. r3trans D.disp+work QUESTION NO: 6

Which actions to you need to perform to configure SAP HANA single sign A.Generate and import X.509 certificate

B. Generate and import PSE key

C. Generate and import Kerberos keytab D.Generate and import SSH rsa key QUESTION NO: 7

What information is presented when you check the license key? A.SAP HANA support package number

B. SAP HANA edition type

C. SAP HANA licensed memory amount D.SAP HANA build number

QUESTION NO: 8

Which of the following Kerberos implementations is supported for single sign-on in SAP HANA? (Choose two)

A.Red Hat Linux version 4 and later Kerberos implementation

B. "Advanced Encryption Standard (AES) Encryption for Kerberos 5" on HP UX

C. MIT's Kerberos Network Authentication Protocol

D.Windows Active Directory Domain Kerberos implementation

Which of the following must be running to view SAP HANA Diagnosis Files the SAP HANA database is offline?

Which actions to you need to perform to configure SAP HANA single sign Generate and import X.509 certificate

Generate and import PSE key

Generate and import Kerberos keytab Generate and import SSH rsa key

What information is presented when you check the license key? SAP HANA support package number

SAP HANA edition type

SAP HANA licensed memory amount SAP HANA build number

Which of the following Kerberos implementations is supported for single on in SAP HANA? (Choose two)

Red Hat Linux version 4 and later Kerberos implementation

"Advanced Encryption Standard (AES) Encryption for Kerberos 5" on HP MIT's Kerberos Network Authentication Protocol

Windows Active Directory Domain Kerberos implementation

Which of the following must be running to view SAP HANA Diagnosis Files if

Which actions to you need to perform to configure SAP HANA single sign-on?

Which of the following Kerberos implementations is supported for single

(4)

HP-QUESTION NO: 9

What happens when you add a standby host to an existing S system? (Choose two)

A. The standby host takes over one of the active index servers. B. The standby host registers with the index server.

C. The standby host starts an index server and waits.

D. The standby host registers with the master name server. QUESTION NO: 10

SAP Support needs to access a customer's SAP HANA studio remotely. Which entry must the client maintain in SAP Service Marketplace?

A. Preprocessor server B. Statistics server C. Name server

D. Master index server QUESTION NO: 11

Which of the following is most relevant for CPU sizing of a SAP HANA appliance?

A. The amount of disk storage

B. The SAP HANA hardware platform

C. The number of concurrent users logged onto SAP HANA D. The number of users actively running analytics in SAP HANA QUESTION NO: 12

Where do you check log and trace files in SAP HANA studio? A. Administration Editor

Performance tab Diagnosis Files tab B. Modeler

Diagnosis Files tab

C. Administration Editor

What happens when you add a standby host to an existing SAP HANA

The standby host takes over one of the active index servers. The standby host registers with the index server.

The standby host starts an index server and waits.

The standby host registers with the master name server.

SAP Support needs to access a customer's SAP HANA studio remotely. Which entry must the client maintain in SAP Service Marketplace?

the following is most relevant for CPU sizing of a SAP HANA

The amount of disk storage

The SAP HANA hardware platform

The number of concurrent users logged onto SAP HANA The number of users actively running analytics in SAP HANA

Where do you check log and trace files in SAP HANA studio?

AP HANA

The standby host takes over one of the active index servers.

SAP Support needs to access a customer's SAP HANA studio remotely. Which

the following is most relevant for CPU sizing of a SAP HANA

(5)

System Information tab D.Administration Editor Diagnosis Files tab

QUESTION NO: 13

Which of the following requires a dedicated network interface to SAP HANA? A.SAP HANA studio

B. SAP LT

C. Backup destination

D.SAP BusinessObjects Business Intelligence platform QUESTION NO: 14

Which tools can you use to monitor the query time from SAP HANA? A.Performance tab of the System Monitor

B. SQL Trace

C. Central Management Console D.Event Viewer

QUESTION NO: 15

Which technologies use trigger

A.Test Data Migration Server (TDMS) B. ABAP extractors

C. TREX engine

D.Near Zero Downtime

E. Standard SQL database replication QUESTION NO: 16

Which of the following can you use to configure the connection between the source system and

SAP HANA in the SAP LT system? (Choose two) A.Transaction LTR

B. SAP NetWeaver Administrator

C. SAP HANA studio -> Administration Console Administration Editor

Which of the following requires a dedicated network interface to SAP HANA?

SAP BusinessObjects Business Intelligence platform

Which tools can you use to monitor the query time from SAP HANA? Performance tab of the System Monitor

Central Management Console

Which technologies use trigger-based replication? (Choose two) Test Data Migration Server (TDMS)

Standard SQL database replication

Which of the following can you use to configure the connection between the T system? (Choose two)

SAP NetWeaver Administrator -> Configuration -> Destination > Administration Console -> Add System

Which of the following requires a dedicated network interface to SAP HANA?

Which tools can you use to monitor the query time from SAP HANA?

Which of the following can you use to configure the connection between the

(6)

D.Web Dynpro application IUUC_REPLICATION_CONFIG QUESTION NO: 17

Which operating system commands show the SAP HANA processes? (Choose two) A.HDB proc B. HDB version C. HDB admin D.HDB info QUESTION NO: 18

Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?

A.SAP HANA system setup Modeling

Data

Provisioning Consumptio n

B. SAP HANA system setup Data

Provisioning Consumption Modeling

C. Data Provisioning SAP HANA system setup Modeling

Consumption

D. SAP HANA system setup Data Provisioning

Modeling Consumption

Web Dynpro application IUUC_REPLICATION_CONFIG

commands show the SAP HANA processes? (Choose

Which of the following sequences of steps is used to implement SAP HANA

SAP HANA system setup

commands show the SAP HANA processes? (Choose

(7)

QUESTION NO: 19

A customer complains about poor performance when they query a column table with 5 billion records. You suspect that this table is partially loaded into memory. Where can you to check the load status of this table? (Choose two)

A.On the Runtime Information tab of the table defin B. In the M_TABLES view

C. In the M_CS_TABLES view

D.In the M_TABLE_PERSISTENCE_LOCATIONS view QUESTION NO: 20

The SAP LT trigger-based approach uses a log table to record all relevant changes. Where is this log table stored?

A.In SAP LT

B. In SAP Solution Manager C. In the source system D.In SAP HANA

QUESTION NO: 21

A company wants to restrict data access to a specific year for certain users. Which privilege type must you define in SAP HANA to achieve this

requirement? A.SQL privileges B. Package privileges C. System privileges D.Analytic privileges QUESTION NO: 22

Which delivered role is mandatory for a system administrator in SAP HANA? A.CONTENT_ADMIN

B. IC MODELER C. SYS_ADMIN

about poor performance when they query a column table with 5 billion records. You suspect that this table is partially loaded into memory. Where can you to check the load status of this table?

On the Runtime Information tab of the table definition In the M_CS_TABLES view

In the M_TABLE_PERSISTENCE_LOCATIONS view

based approach uses a log table to record all relevant changes. Where is this log table stored?

In SAP Solution Manager

Which delivered role is mandatory for a system administrator in SAP HANA? about poor performance when they query a column table with 5 billion records. You suspect that this table is partially loaded into memory. Where can you to check the load status of this table?

based approach uses a log table to record all relevant

(8)

D.SAP_ALL

QUESTION NO: 23

You need to retrieve data from region and specific users.

How can you implement this security strategy?

A.By assigning package privileges to the necessary users B. By assigning analytic privileges to the necessary users C. By assigning SQL privileges to the necessary users D.By assigning system privileges to the necessary users QUESTION NO: 24

Which of the following are benefits of using accelerators with SAP HANA? (Choose two)

A.They eliminate the need for customization. B. They provide prebuilt customer

C. They reduce the time required for implementation. D.They provide prebuilt business content.

QUESTION NO: 25

Which of the following are required to enable SAP HANA high availability? (Choose two)

A.SAP HANA distributed systems

B. SUSE Linux Enterprise High Availability Extension C. Redundant storage and network

D.High-performance computing clustering for Linux QUESTION NO: 26

Which of the following commands installs or updates the repository for SAP HANA studio?

A. hdbinst -a studio - -repository=<target_repository_path> B. hdbinst -a studio - -repository=<source_repository_path>

C. hdbinst -a studio - -copy_repository=<source_repository_path> You need to retrieve data from SAP HANA that is restricted to a certain

How can you implement this security strategy?

By assigning package privileges to the necessary users By assigning analytic privileges to the necessary users By assigning SQL privileges to the necessary users By assigning system privileges to the necessary users

Which of the following are benefits of using accelerators with SAP HANA? They eliminate the need for customization.

They provide prebuilt customer-specific solutions. They reduce the time required for implementation. They provide prebuilt business content.

Which of the following are required to enable SAP HANA high availability?

SAP HANA distributed systems

SUSE Linux Enterprise High Availability Extension Redundant storage and network

performance computing clustering for Linux

Which of the following commands installs or updates the repository for SAP

repository=<target_repository_path> repository=<source_repository_path>

copy_repository=<source_repository_path> SAP HANA that is restricted to a certain

Which of the following are benefits of using accelerators with SAP HANA?

Which of the following are required to enable SAP HANA high availability?

Which of the following commands installs or updates the repository for SAP

(9)

D. hdbinst -a studio - -copy_repository=< QUESTION NO: 27

Which of the following must you configure to enable monitoring of SAP HANA in DBA Cockpit?

A. The CCMS agent in SAP HANA

B. A database connection in the table DBCON C. The CCMS connection in DBA cockpit

D. A database connection in DBA Cockpit QUESTION NO: 28

Which of the following connections require the highest network bandwidth? A. SAP HANA and SBO BI

B. SAP HANA and SAP HANA studio C. SAP HANA and SAP BW

D. SAP HANA and SAP NetWeaver Portal QUESTION NO: 29

What is the correct communication data flow between diagnostics in SAP Solution Manager and SAP HANA in the monitor scenario?

A. Solution Manager HostAgent SAP HANA B. Solution Manager SMDAgent SAP HANA C. Solution Manager HostAgent SMDAgent SAP HANA D.Solution copy_repository=<target_repository_path>

Which of the following must you configure to enable monitoring of SAP HANA

The CCMS agent in SAP HANA

A database connection in the table DBCON The CCMS connection in DBA cockpit

A database connection in DBA Cockpit

Which of the following connections require the highest network bandwidth? SAP HANA and SBO BI

SAP HANA and SAP HANA studio SAP HANA and SAP BW

SAP HANA and SAP NetWeaver Portal

What is the correct communication data flow between diagnostics in SAP Solution Manager and SAP HANA in the monitor scenario?

target_repository_path>

Which of the following must you configure to enable monitoring of SAP HANA

Which of the following connections require the highest network bandwidth?

(10)

Manager SMDAgent HostAgent SAP HANA

QUESTION NO: 30

What is the recommended approach by SAP when loading tables into SAP HANA from SAP ERP via Data Services?

A.Use open hub

B. Use the data staging server C. Use the ABAP application tier D.Use the Replication Server QUESTION NO: 31

Which of the following must be shared by SAP HANA nodes in a high availability scenario?

A.Virtual host name B. Storage

C. Shared memory D.Network

QUESTION NO: 32

Which of the following components must be enable SAP Early Watch Alerts? (Choose two) A.CCMS agent

B. Collection script C. Host agent D.SMD agent

What is the recommended approach by SAP when loading tables into SAP HANA from SAP ERP via Data Services?

Use the data staging server Use the ABAP application tier Use the Replication Server

Which of the following must be shared by SAP HANA nodes in a high

Which of the following components must be installed in SAP HANA to enable SAP Early Watch Alerts? (Choose two)

What is the recommended approach by SAP when loading tables into SAP

Which of the following must be shared by SAP HANA nodes in a high

(11)

QUESTION NO: 33

What must you configure in Data Services 4.0 to establish a connection to SAP ERP? A.A DB connection B. A datastore C. An RFC connection D.An InfoObject QUESTION NO: 34

Which new connection type is available as of SAP BusinessObjects Data Services 4.0?

A.BAPI function calls

B. Read table via ABAP data flows C. IDOCs

D.Operational data provider QUESTION NO: 35

Which of the following files should be considered in your SAP HANA backup strategy? (Choose three)

A. Configuration files B. Dump files

C. Export and import files D. Kernel files

E. Data and log files QUESTION NO: 36

Which of the following components A. Index server

B. Preprocessor server C. Statistics server D. Name server

What must you configure in Data Services 4.0 to establish a connection to

Which new connection type is available as of SAP BusinessObjects Data

Read table via ABAP data flows Operational data provider

Which of the following files should be considered in your SAP HANA backup

Export and import files

Which of the following components enables SAP HANA high availability? What must you configure in Data Services 4.0 to establish a connection to

Which new connection type is available as of SAP BusinessObjects Data

Which of the following files should be considered in your SAP HANA backup

(12)

QUESTION NO: 37

You need to create a role that allows read

HANA Administration Editor. Which of the following to assign to that role? (Choose two)

A. System privilege SERVICE_ADMIN B. System privilege CONTENT_ADMIN

C. SQL privilege SELECT for the SQL object SYS_STATISTICS D. System privilege DATA_ADMIN

QUESTION NO: 38

In which of the following situations is a recovery of an SAP HANA database applicable? (Choose three)

A. Corruption of kernel binary files B. Crash of the SLT server

C. Reset of the system to a specific point in time D. Disk crash of the log area

E. Disk crash of the data area QUESTION NO: 39

Which of the following source data sizes should you use to size SAP HANA memory?

A.Total uncompressed size of source database

B. Total uncompressed size of tables and indexes required for queries C. Total compressed size of source database

D.Total uncompressed size of tables required for queries QUESTION NO: 40

Of the databases that can be used for Data Services 4.0, which of the following is bundled with Information Platform Services (mini

A.SYBASE Adaptive Server Enterprise B. SAP MaxDB

C. MS SQL Server Express

You need to create a role that allows read-only access to the tabs of SAP HANA Administration Editor. Which of the following privileges do you need to assign to that role? (Choose two)

System privilege SERVICE_ADMIN System privilege CONTENT_ADMIN

SQL privilege SELECT for the SQL object SYS_STATISTICS System privilege DATA_ADMIN

situations is a recovery of an SAP HANA database applicable? (Choose three)

Corruption of kernel binary files Crash of the SLT server

Reset of the system to a specific point in time Disk crash of the log area

Disk crash of the data area

Which of the following source data sizes should you use to size SAP HANA

Total uncompressed size of source database

Total uncompressed size of tables and indexes required for queries Total compressed size of source database

Total uncompressed size of tables required for queries

Of the databases that can be used for Data Services 4.0, which of the following is bundled with Information Platform Services (mini-BOE)?

SYBASE Adaptive Server Enterprise MS SQL Server Express

only access to the tabs of SAP privileges do you need

situations is a recovery of an SAP HANA database

Which of the following source data sizes should you use to size SAP HANA

Total uncompressed size of tables and indexes required for queries

Of the databases that can be used for Data Services 4.0, which of the BOE)?

(13)

D.MySQL

QUESTION NO: 41

Which of the following do you add when you "scale out" SAP HANA? A. Data storage

B. Memory C. Servers D. CPUs

QUESTION NO: 42

Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)? (Choose two)

A. Ensure that replicated changes are kept within the logging tables. B. Record relevant changes in logging tables.

C. Decluster table classes into a transparent format. D. Include only relevant tables for DB recording. QUESTION NO: 43

You are using SAP BusinessObjects Data Services as your ETL tool.

What is the next step required after you have created the datastore and imported the metadata from an SAP ERP system into SAP HANA?

A. Import data from the SAP ERP system into SAP HANA.

B. Create a connection in SAP BusinessObjects Data Services to the SAP ERP system.

C. Import the metadata from SAP HANA into SAP BusinessObjects Data Services.

D. Create an SAP BusinessObjects Data Services j HANA.

Which of the following do you add when you "scale out" SAP HANA?

Which of the following are functions of the DB trigger within SAP Transformation (SLT)? (Choose two)

Ensure that replicated changes are kept within the logging tables. Record relevant changes in logging tables.

Decluster table classes into a transparent format. Include only relevant tables for DB recording.

Import data from the SAP ERP system into SAP HANA.

Create a connection in SAP BusinessObjects Data Services to the SAP ERP Import the metadata from SAP HANA into SAP BusinessObjects Data Create an SAP BusinessObjects Data Services job to migrate data to SAP Which of the following do you add when you "scale out" SAP HANA?

Which of the following are functions of the DB trigger within SAP

Ensure that replicated changes are kept within the logging tables.

Create a connection in SAP BusinessObjects Data Services to the SAP ERP Import the metadata from SAP HANA into SAP BusinessObjects Data ob to migrate data to SAP

(14)

QUESTION NO: 44

Which driver is required for the connection between SAP HANA and SAP BusinessObjects Explorer? A. BICS B. JDBC C. ODBO D. ODBC QUESTION NO: 45

Which of the following URLs do you define for Software A.https://<host>:8443/studio_repository/

B. https://<host>:8444/studio_repository/ C. http://<host>:8443/studio_repository/ D.http://<host>:8444/studio_repository/ QUESTION NO: 46

In SAP HANA, what is the recommended memory size you must dynamic objects?

A.The same size as the uncompressed source data B. The same size as the total size of the log files C. The same size as the total size of the data files

D.The same size as the memory required for static data QUESTION NO: 47

Which of the following can be imported into and exported from SAP HANA studio? (Choose three)

A.SQL statements B. Landscape C. Tables D.Models E. Variants

Which driver is required for the connection between SAP HANA and SAP BusinessObjects Explorer?

Which of the following URLs do you define for Software Update Manager? https://<host>:8443/studio_repository/

https://<host>:8444/studio_repository/ http://<host>:8443/studio_repository/ http://<host>:8444/studio_repository/

In SAP HANA, what is the recommended memory size you must

The same size as the uncompressed source data The same size as the total size of the log files The same size as the total size of the data files

The same size as the memory required for static data

Which of the following can be imported into and exported from SAP HANA Which driver is required for the connection between SAP HANA and SAP

Update Manager?

In SAP HANA, what is the recommended memory size you must reserve for

(15)

QUESTION NO: 48

In Microsoft Windows, to which folder are the logs written by default during the SAP HANA studio installation?

A.%TEMP%\hdb_studio_<time_stamp>

B. %USERPROFILE%\hdb_studio_<time_stamp> C. %USERNAME%\hdb_studio_<time_stamp> D.C:\Program Files (x86)\

QUESTION NO: 49

Your customer wants to implement an SAP product that A. Provides near real-time replication to SAP HANA, B. Connects SAP HANA to a non

C. Uses SAP BW extractors. What do you recommend?

A.SAP Legacy System Migration Workbench (LSMW) B. SAP BusinessObjects Data Services 4.0

C. SAP Landscape Transformation (SLT) D.Sybase Replication Server

QUESTION NO: 50

Which of the following Information Platform Services components must you install for Data Services 4.0? (Choose two)

A.File Repository Server

B. Monitoring Processing Server C. Platform Processing Services D.Auditing Proxy Processing Service QUESTION NO: 51

What type of data is transferred between the SAP HANA database and end user clients?

A.Application data B. Configuration data

In Microsoft Windows, to which folder are the logs written by default during HANA studio installation?

hdb_studio_<time_stamp>

hdb_studio_<time_stamp> hdb_studio_<time_stamp>

\hdb_studio_<time_stamp>

Your customer wants to implement an SAP product that: time replication to SAP HANA,

SAP HANA to a non-SAP source system and SAP BW, and SAP BW extractors.

What do you recommend?

SAP Legacy System Migration Workbench (LSMW) SAP BusinessObjects Data Services 4.0

SAP Landscape Transformation (SLT) Sybase Replication Server

Which of the following Information Platform Services components must you install for Data Services 4.0? (Choose two)

Monitoring Processing Server Platform Processing Services Auditing Proxy Processing Service

What type of data is transferred between the SAP HANA database and end In Microsoft Windows, to which folder are the logs written by default during

SAP source system and SAP BW, and

Which of the following Information Platform Services components must

(16)

C. Configuration models D.Data models

QUESTION NO: 52

Which tool do you use for complex data transformation of SAP ERP data? A.Sybase Replication Server

B. SAP Landscape Transformation (SLT) C. SAP BusinessObjects Explorer

D.SAP BusinessObjects Data Services QUESTION NO: 53

Which of the following are Manager? (Choose two)

A. Host agent running on SAP Solution Manager B. SMD agent running on SAP Solution Manger C. SMD agent running on SAP HANA

D. Host agent running on SAP HANA QUESTION NO: 54

When you try to stop SAP HANA using the sapcontrol command, you receive the error messagE. "Command not found". What is the reason for the error?

A. The host agent is not installed.

B. The SAP HANA database is not installed. C. The SAP HANA client is not installed. D. SAP SUM is not installed.

QUESTION NO: 55

You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to

perform to accomplish this? (Choose three)

A. Choose an attribute and define restricted values for it. Assign the analytic privilege to a user or role.

Which tool do you use for complex data transformation of SAP ERP data? Sybase Replication Server

SAP Landscape Transformation (SLT) SAP BusinessObjects Explorer

SAP BusinessObjects Data Services

Which of the following are required to monitor SAP HANA in SAP Solution

Host agent running on SAP Solution Manager SMD agent running on SAP Solution Manger SMD agent running on SAP HANA

Host agent running on SAP HANA

When you try to stop SAP HANA using the sapcontrol command, you receive the error messagE. "Command not found". What is the reason for

The host agent is not installed.

The SAP HANA database is not installed. The SAP HANA client is not installed. SAP SUM is not installed.

s? (Choose three)

Choose an attribute and define restricted values for it. Assign the analytic privilege to a user or role.

Which tool do you use for complex data transformation of SAP ERP data?

required to monitor SAP HANA in SAP Solution

When you try to stop SAP HANA using the sapcontrol command, you receive the error messagE. "Command not found". What is the reason for

(17)

C. Assign values to be restricted to a content table.

D. Assign values to be restricted. Choose at least one information assign restrictions.

E. Assign restricted values to the attribute view. QUESTION NO: 56

In addition to the in-memory database, which of the following technologies are part of SAP HANA? (Choose two)

A. Columnar store

B. Asymmetric multi-processing C. Diskless data storage

D. Massive parallel processing QUESTION NO: 57

You installed SAP HANA Database using 51 as your system number. Which network port is used for Standard SQL communication for client access? A.55113

B. 31551 C. 35100 D.35115

QUESTION NO: 58

Which of the following privileges do you need to activate views? A.SELECT option on the _SYS_BIC schema

B. SELECT option on the _SYS_BI schema C. SELECT option on the _SYS_REPO schema D.SELECT option on the _SYS schema

QUESTION NO: 59

Which security settings can you apply in analytic privileges? (Choose two) A. Restrict access to hierarchies.

B. Restrict access within an analytic view using measure values. C. Restrict access within an analytic view using attribute values. D.Grant access to analytic views.

Assign values to be restricted to a content table.

Assign values to be restricted. Choose at least one information Assign restricted values to the attribute view.

memory database, which of the following technologies are part of SAP HANA? (Choose two)

processing Massive parallel processing

You installed SAP HANA Database using 51 as your system number. Which network port is used for Standard SQL communication for client access?

Which of the following privileges do you need to activate views? SELECT option on the _SYS_BIC schema

SELECT option on the _SYS_BI schema SELECT option on the _SYS_REPO schema SELECT option on the _SYS schema

security settings can you apply in analytic privileges? (Choose two) Restrict access to hierarchies.

Restrict access within an analytic view using measure values. Restrict access within an analytic view using attribute values. Grant access to analytic views.

Assign values to be restricted. Choose at least one information model to

memory database, which of the following technologies

You installed SAP HANA Database using 51 as your system number. Which network port is used for Standard SQL communication for client access?

Which of the following privileges do you need to activate views?

security settings can you apply in analytic privileges? (Choose two)

Restrict access within an analytic view using measure values. Restrict access within an analytic view using attribute values.

(18)

QUESTION NO: 60

You are designing architecture HANA (COPA Accelerator).

To which network in the diagram should you connect your SAP ECC system? A.SAP HANA Administrative Network (3)

B. SAP HANA Data Network (4)

C. SAP HANA Data Backup Network (1) D.SAP HANA Client Network (2)

QUESTION NO: 61

Which of the following is used to deploy SAP A.Java Support Package Management

B. Server-side export/import

architecture for SAP ERP Profitability Analysis with SAP HANA (COPA Accelerator).

To which network in the diagram should you connect your SAP ECC system? SAP HANA Administrative Network (3)

SAP HANA Data Network (4)

SAP HANA Data Backup Network (1) SAP HANA Client Network (2)

Which of the following is used to deploy SAP-delivered content in SAP HANA? Java Support Package Management (JSPM)

side export/import

for SAP ERP Profitability Analysis with SAP

To which network in the diagram should you connect your SAP ECC system?

(19)

C. SAP Transport Management System (STMS)

D.SAP NetWeaver Development Infrastructure (NWDI) QUESTION NO: 62

In which file do you configure the maximum size of the delta storage memory? A. preprocessor.ini B. executer.ini C. global.ini D. indexserver.ini QUESTION NO: 63

Which view in SAP HANA studio do you use to add additional users? A. Navigator view

B. Quick Launch view C. Properties view D. Console view

QUESTION NO: 64

Which of the following are functions of the Transformation (SLT) server? (Choose two) A.Schedule replication processes.

B. Write data to the SAP HANA system using the DB connection. C. Create repositories in the source system.

D.Map database structures between SAP HANA and the source system. QUESTION NO: 65

What are the recommended ways to perform a database backup? (Choose two)

A.Use the./hdbsetup command B. Use SAP HANA Studio

C. Use SQL commands

SAP Transport Management System (STMS)

SAP NetWeaver Development Infrastructure (NWDI)

In which file do you configure the maximum size of the delta storage

Which view in SAP HANA studio do you use to add additional users?

Which of the following are functions of the controller on the SAP Landscape Transformation (SLT) server? (Choose two)

Schedule replication processes.

Write data to the SAP HANA system using the DB connection. Create repositories in the source system.

Map database structures between SAP HANA and the source system.

What are the recommended ways to perform a database backup? (Choose

Use the./hdbsetup command

In which file do you configure the maximum size of the delta storage

Which view in SAP HANA studio do you use to add additional users?

controller on the SAP Landscape

Write data to the SAP HANA system using the DB connection.

Map database structures between SAP HANA and the source system.

(20)

D.Use the BRBACKUP command QUESTION NO: 66

You have an SAP HANA productive system with sensitive data. How can you restrict modeling users from viewing this data? (Choose two)

A.Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users. B. Allow modeling only on the SAP HANA development system and export/import the models to the productive system.

C. Use randomized data for the development of data models.

D.Remove ALTER SYSTEM in the system privileges for the modeling users. QUESTION NO: 67

What must you do in SAP LT to establish a connection between a non SAP source system database and SAP HANA? (Choose three)

A.Create the source database connection in table DBCON. B. Define the SAP LT RFC connection to SAP HANA.

C. Define the SAP LT database connection to SAP HANA. D.Define an RFC connection to the source system.

E. Add a source database connection in the DBA Cockpit. QUESTION NO: 68

What must you do to configure SAP HANA high availability? A. Right click the Navigator panel and choose Add System… B. Run command./hdbinst

autostart=off.

C. Call stored procedure SYS.UPDATE_LANDSCAPE_CONFIGURATION. D. Run command./hdbaddhost

role=standby. QUESTION NO: 69

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database?

A. Do a homogeneous system copy from your current DB to SAP HANA DB. Use the BRBACKUP command

You have an SAP HANA productive system with sensitive data. How can you restrict modeling users from viewing this data? (Choose two)

Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users. Allow modeling only on the SAP HANA development system and export/import the models to the productive system.

Use randomized data for the development of data models.

Remove ALTER SYSTEM in the system privileges for the modeling users.

What must you do in SAP LT to establish a connection between a non SAP source system database and SAP HANA? (Choose three)

Create the source database connection in table DBCON. Define the SAP LT RFC connection to SAP HANA.

Define the SAP LT database connection to SAP HANA. Define an RFC connection to the source system.

Add a source database connection in the DBA Cockpit.

What must you do to configure SAP HANA high availability? Right click the Navigator panel and choose Add System…

Run command./hdbinst --SID=<SID> --password=<password> Call stored procedure SYS.UPDATE_LANDSCAPE_CONFIGURATION. Run command./hdbaddhost --SID=<SID> --password=<password>

Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying database?

Do a homogeneous system copy from your current DB to SAP HANA DB. You have an SAP HANA productive system with sensitive data. How can you restrict modeling users from viewing this data? (Choose two)

Remove SAP_DATA_ADMIN in the SQL privileges for the modeling users. Allow modeling only on the SAP HANA development system and

Remove ALTER SYSTEM in the system privileges for the modeling users.

What must you do in SAP LT to establish a connection between a

non-password=<password> --Call stored procedure SYS.UPDATE_LANDSCAPE_CONFIGURATION.

password=<password>

--Which tasks do you have to perform if you want to use SAP BW with SAP

(21)

B. Ensure that you have at least SAP NetWeaver installed.

C. Do a heterogeneous system copy from your current DB to SAP HANA DB. D. Recreate SAP BW indexes after SAP HANA database migration.

QUESTION NO: 70

Which view displays the current SAP HANA Support Package level? A. M_LANDSCAPE_HOST_CONFIGURATION

B. M_VERSION_MEMORY C. M_HOST_INFORMATION D. M_DATABASE

QUESTION NO: 71

Which of the following commands stops the SAP HANA database? A. HDB stop

B. stopsap hdb C. HDB -stop D. stop HDB

QUESTION NO: 72

Which of the following configuration files contains the backup locations of log and data files?

A. attributes.ini B. global.ini

C. indexserver.ini D. localclient.ini QUESTION NO: 73

Which command is recommended by SAP to install an SAP HANA database via a graphical user interface (GUI)?

A. ./hdbsetup B. ./sapinst C. ./hdbinst

D. ./hdbinst – install

Ensure that you have at least SAP NetWeaver Business Warehouse 7.02 Do a heterogeneous system copy from your current DB to SAP HANA DB. Recreate SAP BW indexes after SAP HANA database migration.

Which view displays the current SAP HANA Support Package level? M_LANDSCAPE_HOST_CONFIGURATION

M_VERSION_MEMORY M_HOST_INFORMATION

Which of the following commands stops the SAP HANA database?

following configuration files contains the backup locations of log

Which command is recommended by SAP to install an SAP HANA database user interface (GUI)?

Business Warehouse 7.02 Do a heterogeneous system copy from your current DB to SAP HANA DB. Recreate SAP BW indexes after SAP HANA database migration.

Which view displays the current SAP HANA Support Package level?

Which of the following commands stops the SAP HANA database?

following configuration files contains the backup locations of log

(22)

QUESTION NO: 74

What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA?

A.SAP Legacy System Migration Workbench (LSMW) B. SAP BusinessObjects Data Services

C. SAP Landscape Transformation (SLT) D.SAP BW extractors

QUESTION NO: 75

Which of the following can you use to replicate data from SAP BW to SAP HANA?

A.An RFC connection to SAP LT B. Open hub with Data Services 4.0 C. Open hub with SAP LT

D.A database connection to Data Services 4.0 QUESTION NO: 76

Which of the following is an SQL privilege? A.DEVELOPMENT

B. DROP

C. SAVEPOINT ADMIN D.EXPORT

QUESTION NO: 77

Which of the following steps is required for configuring SAP Transformation (SLT)?

A.Define a DB connection from SLT to the source system. B. Define an RFC connection from SLT to SAP HANA.

C. Define the number of jobs to be used for data replication. D.Define the number of background work processes in SLT.

What can you use to transform data from SAP Business Warehouse (BW)

SAP Legacy System Migration Workbench (LSMW) BusinessObjects Data Services

SAP Landscape Transformation (SLT)

Which of the following can you use to replicate data from SAP BW to SAP

An RFC connection to SAP LT Open hub with Data Services 4.0

A database connection to Data Services 4.0

Which of the following is an SQL privilege?

Which of the following steps is required for configuring SAP Landscape

Define a DB connection from SLT to the source system. Define an RFC connection from SLT to SAP HANA.

Define the number of jobs to be used for data replication. Define the number of background work processes in SLT.

What can you use to transform data from SAP Business Warehouse (BW)

Which of the following can you use to replicate data from SAP BW to SAP

(23)

QUESTION NO: 78

If you want to create or drop tables in a schema, which privilege type do you need? A.Analytic B. SQL C. System D.Package QUESTION NO: 79

Which of the following users allow you to install SAP HANA studio on a Windows client platform? (Choose two)

A.<SID>ADM users without administrator privileges B. Domain users with administrator privileges

C. Local users with administrator privileges D.Local users without administrator privileges QUESTION NO: 80

Which of the following are parts of SAP A. Disk sizing

B. Network bandwidth sizing C. Memory sizing

D. CPU sizing

E. Data and log file sizing

If you want to create or drop tables in a schema, which privilege type do you

Which of the following users allow you to install SAP HANA studio on a (Choose two)

<SID>ADM users without administrator privileges Domain users with administrator privileges

Local users with administrator privileges Local users without administrator privileges

Which of the following are parts of SAP HANA sizing? (Choose three)

Network bandwidth sizing

If you want to create or drop tables in a schema, which privilege type do you

Which of the following users allow you to install SAP HANA studio on a