Make your own quiz Manage my Quizzes Plans / Features Guides and Help Contact Privacy & Security

SAP 1 - 20/

What are the core capabilities of the SAP HANA database? Note: There are 3 correct answers to this question

Parallel processing can be performed across multiple CPUs.

Every row is a secondary index.

There is a special format for programming

All operations are performed in memory

Data can be stored in a column store

Which of the following are features of non-native applications? Note: There are 3 correct answers to this question

Existing applications can be used without change

They use an external application server

They can be extended to run on SAP HANA

They connect directly to SAP HANA

They use SAP HANA XS

Which of the following main components does SAP HANA comprise? Note: There are 3 correct answers to this question

SAP HANA appliance software

SAP HANA application cloud

SAP HANA database

SAP HANA OData

SAP HANA SQL

Which perspectives does a developer use to build SAP HANA applications? Note: There are 3 correct answers to this question

The Debug perspective

The Modeling perspective

The SAP HANA Development perspective

The Administration Console perspective

The JavaScript perspective

Which views are displayed in the SAP HANA Development perspective? Note: There are 3 correct answers to this question

Navigator (SAP HANA Systems)

Project Explorer

SAP HANA Repositories

SQL editor

Job log

Which type of access does the SAP HANA Repositories view provide to repository content in SAP HANA studio?

Full read/write access

Access to local content only

Read-only browse access

Write access

Which of the following operations does the SAP HANA client perform?

It connects the SAP HANA repository to the SAP HANA database.

It connects the SAP HANA studio to another instance of the SAP HANA studio.

It connects Web browsers to the SAP HANA studio

It connects the SAP HANA studio to the SAP HANA repository

What is the SAP HANA studio? Note: There are 3 correct answers to this question.

An Eclipse-based development environment

An Eclipse-based modeling environment

An Eclipse-based writing tool

An Eclipse-based administration tool

An Eclipse-based upgrade tool

What is a design-time object in SAP HANA?

Transportable content stored in the SAP HANA repository

Only active content stored in the SAP HANA repository

All content stored in the SAP HANA database catalog

Only inactive content stored in the SAP HANA repository

What do you use to request access to a running SAP HANA system?

Search engines

SAP HANA forum

SAP Community Mailing List

SAP HANA Developer Center

How can you reduce the cost of an SAP HANA system with Amazon Web Services (AWS) in the Cloud? Note: There are 3 correct answers to this question

Op the instance when not using the instance

Choose a lower HANA instance size when creating a stack in AWS

Use Request Spot Instances to bid on an instance

Start your instance using an EBS Optimized Volume

Choose a higher HANA instance size when creating a stack in AWS

Where does an SAP HANA application store design-time content?

In the SAP HANA application descriptors

On the SAP HANA Web server

In dedicated XSJS files

In the SAP HANA repository

Which of the following are core application files? Note: There are 2 correct answers to this question.

.xsaccess

.xsproject

.xsapp

.xslogon

Which of the following application files has no content?

Xsprivileges

.xssqlcc

.xsaccess

.xsapp

What is meant by the term hdbtable?

A syntax used to define table access permissions

A syntax used to define a design-time representation of a table

A syntax used to define runtime representation of a table

A syntax used to specify table authorization

What is the main advantage of the design-time approach to data modeling?

Transportability of data models between SAP HANA systems

Longer, more accurate data-model design process

Faster data-model design process

Immediate availability of data model

What is the file extension associated with a design-time schema definition?

.hdbschema

.schema

.sch

.hdbsch

Which of the following are valid keywords in a design-time sequence definition for SAP HANA? Note: There are 3 correct answers to this question.

Stop_with=

Depends_on_sequence=

Start_with=

Cycles=

Schema=

What is the file extension associated with a design-time SQL view definition?

.hdbvws

.vws

.view

.hdbview

What is meant by the key word "cycles = true"?

When a sequence reaches the end, it is reversed

When a sequence reaches the end, a different sequence is triggered

The sequence remains open-ended

When a sequence reaches the end, it starts over again

What is the correct file extension for a design-time role definition?

.hdbrole

.dbr

.xsrole

.role

At is the name of the _SYS_REPO procedure used to grant a role to an SAP HANA user?

GRANT_ ACTIVATED_ROLE

GRANT_ACTIVE_ROLE

GRANT_INACTIVE_ROLE

GRANT_USER_ROLE

Which of the following sequences are included in the EPM data? Note: There are 3 correct answers to this question.

Purchase Order ID

Goods Receipt ID

Address ID

Text ID

Invoice ID

Which of the following synonyms is included with the EPM data?

T00A

TCURZ

TCURC

T002

Which files are required for an automated table load using a design-time configuration? Note: There are 3 correct answers to this question.

A table content file

A table-import data file

A table-import model file

A CSV file

A table-import index file

What is the mandatory file extension for the file used to define table-import data?

.hdbid

.hdbtid

.hdbdata

.hdbd

Can you create a new field in an attribute view?

Yes, but you cannot fill the new field with data. This must be done in a calculation view.

No, you must define the new field in the analytic view.

No, you must insert the new field in the source system as a placeholder.

Yes, you can.

What is the normal way to check the correctness of an attribute view?

With an SQL script

With an SAPUI5 script

With a query in SAP BW

With data preview in SAP HANA studio

Which of the following are properties of an output column? Note: There are 3 correct answers to this question.

Hidden

Key Attribute

Template

Output Color

Drilldown Enabled

How many objects can you use in the data foundation?

One

As many as you like

None

Objects are automatically assigned

Where can you define a calculated column?

Only in an attribute view

In all components of a model

Only in an analytic view

In analytic and attribute views

Which of the following characters can you use in a calculation view name? Note: There are 3 correct answers to this question.

Upper-case letters (A-Z)

Lower-case letters (a-z)

Underscores (_)

Integers (0-9)

Wildcards/Special characters (*, -)

Which of the following are functions of the component projection in a calculation view? Note: There are 2 correct answers to this question

Define unions

Define expressions

Define output fields

Create hierarchy

Format output

Which "elements" are used in the expression that defines a calculated column in a calculation view? Note: There are 3 correct answers to this question.

Columns

Output parameters

Input parameters

Calculated columns

Measures

Which "functions" can be used in the expression that defines a calculated column in a calculation view? Note: There are 3 correct answers to this question.

Date functions

Derived functions

Mathematical functions

Miscellaneous functions

Integer functions

For what do you need analytic privileges? Note: There are 3 correct answers to this question

To retrieve data from an attribute view

To create an analytic user

To retrieve data from a calculation view

To call a query

To retrieve data from an analytic view

With analytic privileges, you can restrict access in a data container to: Note: There are 3 correct answers to this question.

An attribute field in a Calculation view

A private dimension of an Analytic view

An attribute field in an Analytic view

A field from an attribute view

A public dimension of an Analytic view

What concept enables you to make the definition of analytic privileges more flexible?

Dynamic privileges

Value restrictions

Schema definitions

The "Applicable to all content models" option

When programming with SQLScript...

You must keep in mind that there are combinations of statements, which could block parallel execution

You do not need to worry about parallel execution, because all statements are guaranteed to run in parallel

You have to optimize the script for parallel execution with focus on synchronization

You have no possibility to create parallel SQLScript procedures

As well as SQLScript, which programming language can you use to write procedures?

XSJS

C++

NoSQL

R-Language

Procedures can be defined...

To be executed sequentially using the keywords EXECUTE SEQUENTIALLY

As purely imperative using the keywords IMPERATIV ONLY

To return a view using the keywords AS VIEW

As read-only procedures using the keywords READS SQL DATA

Which character is used as a prefix to an input parameters referenced in SQL SELECT statements and CE functions?

@ (at)

* (asterisk)

: (colon)

(hash)

Where are activated procedures stored by default?

In the same schema as your JavaScript sources

In the "PROC" schema

In the "SYS_BIC" schema

On your local PC

The Calculation Engine (CE) is the execution engine for what? There are 2 correct answers to this question.

XS-JavaScript functions

Calculation views

Semantic media mining in the database

SQLScript-based procedures

Complex arithmetic functions, such as sin, cos, tan, and derivative

What are CE functions?

Implementations of many standard SQL statements directly in the calculation engine

Implementations of all standard SQL statements directly in the calculation engine

Implementations of the 5 most used standard SQL statements

The 5 basic functions the database combines to execute all possible SQL queries

Which loop statements are part of the correct SQLScript syntax of SAP HANA? There are 2 correct answers to this question.

REPEAT ... UNTIL ... END REPEAT

FOR IN ... DO ... END FOR;

WHILE ... DO ... END WHILE;

: ... IF ... THEN JUMP ;

In general, what is the effect of using imperative logic in the SAP HANA Database?

One record is processed at a time.

You have to write your procedure in pure C.

Imperative code performs bulk operations on an entire record set.

For which schema do you need all privileges to be able to debug?

_SYS_BI

_SYS_BIC

_SYS_REPO

_SYS_RT

What do you currently have to set up in your debug configuration?

The IP and port of your SAP HANA system

None of these

Input parameter values

The number of iterations through the procedure

The programmer can decide whether the procedure is executed in parallel or not.

During debugging process are you able to place breakpoint?

Yes

Not Applicable

What is debugging process?

Debugging, in computer programming and engineering, is a multistep process that involves identifying a problem, isolating the source of the problem, and then either correcting the problem or determining a way to work around it.

Debugging is a signal that tells the debugger to temporarily suspend execution of your program at a certain point.

Debugging is the process of taking an algorithm and encoding it into a notation.

Which of the following are traits of classic ABAP applications? Note: There are 2 correct answers to this question.

The application server is not involved with UI rendering.

The database is only used for data storage.

Application logic is executed in the application server, instead of using advanced SQL capabilities

The application server must be very small.

The database is used for many stored procedures.

What increases the performance of applications for the XS Engine?

Locality and deep integration with the database

High performance of the connection between the client and the XS Engine

A wide range of client devices

The calculation power of the XS Engine

Where do you find the SAPUI5 help in your SAP HANA database?

Hostname:port/sap/ui5/1/sdk/index.html

Hostname:port/sap/ui5/1/sdk/overview.html

Hostname:port/sap/ui5/1/API/index.html

Hostname:port/sap/ui5/1/API/overview.html

Which path do you have to specify for the "src=" attribute in your .html-file to have the correct settings for your SAP HANA system?

/sap/ui5/resources/sap-ui-core.js

Sap/ui5/1/resources/sap-ui-core.js

Sap/ui5/resources/sap-ui-core.js

/sap/ui5/1/resources/sap-ui-core.js

In the code line var myButton = new sap.ui.commons.Button("btn"), what does the parameter "btn" set for this element?

Alert-text for the on-click event

Text

Name

Which of the following are OData query options? Note: There are 3 correct answers to this question.

$filter

$select

$equals

$top

$bottom

Which of the following are steps in the OData development process? Note: There are 2 correct answers to this question.

Data Migration Definition

UI Call to OData Service

Data End Point Definition

Data Start Point Definition

Which of the following are the possible response types for an OData service? Note: There are 2 correct answers to this question.

YAML

Txt

JSON

Atom-XML

Which is the easiest data format to consume directly in custom JavaScript code?

YAML

Txt

Atom-XML

JSON

Which of the following statements about OData services is correct? Note: There are 2 correct answers to this question.

Each entity needs its own service.

Each entity needs a table/view on which it is defined.

Each entity needs a key.

Each entity needs at least one stored procedure.

How do you get the records from you OData entity into your table?

.bindData("path",...)

.bind("path",...)

.bindProperty("path",...)

.bindRows("path",...)

Which of the following functionalities are implemented for the SAPUI5 Table Columns by default? Note: There are 2 correct answers to this question.

Filtering (by string)

Syntax-highlighting

Sort ascending

Auto-completion

Which of the following rules apply to the development model of SAP HANA XS? Note: There 3 correct answers to this question.

The UI rendering is performed completely in the client.

All development artifacts are stored in the SAP HANA repository

SQLScript is the primary programing language for implementing REST-based services.

The business logic is performed completely on the client side

The business logic is performed completely on the server side.

When would you use JavaScript rather than SQLScript? Note: There 3 correct answers to this question.

To implement control flow logic

To avoid massive data copies to the application server

To create a new service

To embed data-intensive application logic into the database

To implement validation logic

Which of the following steps do you have to perform if you want to create and test a simple JavaScript service? Note: There are 3 correct answers to this question.

Call the service from a client UI.

Create the XS JavaScript source file.

Activate the XS JavaScript source file in SAP HANA studio

Create an HTTP request/response API.

Include the source file in the XS JavaScript Library.

Why would you create an XS project before creating an XSJS service?

To have access to the SAP HANA Development perspective

To be able to use the XS JavaScript Source File wizard

To have access to the SAP-specific online documentation

To have access to the XSJS debugger and code completion

You want to reuse the getMessage function from the SAP HANA demo content in your service. How do you recommend implementing this? Note: There are 2 correct answers to this question.

Copy the getMessage function from the library and paste it into your code.

Call the getMessage function by specifying the package path and file name.

Call the getMessage function using an alias for the package path and file name.

Use the "$.import" API by specifying the package path and file name.

Which parameter do you have to pass to the $.db.getConnection API when you want to connect to the database from an anonymous service?

The port number

The database name

The server name

The SQL CC ID for user name and password

You use the Download to Excel function in your service to provide data as an MS Excel-type file download. Which line do you have to add to your Download to Excel function if you want users to be able to consume your service even from a Web site running on a different host from your SAP HANA system?

$.response.headers.set('access-control-allow-origin', '*');

$.response .contentType = 'application/vnd.ms-excel; charset=utf-16le';

$.response.status = $.net.http.OK;

$.response.headers.set('Content-Disposition', 'attachment; filename=Excel.xls');

You build a new user interface. Which of the following SAPUI5 methods can you use in the controller of your user interface to retrieve a JavaScript object for a particular UI element on the screen?

Sap.ui.view()

Sap.ui.jsonview()

Sap.ui.resource()

Sap.ui.getCore()

What do you recommend when using the debugger in SAP HANA Developer Studio?

Debug your program on the productive system.

Use different port numbers for the server and client debugger configuration.

Switch on the debugger only when you need it.

Allow the network firewall around your SAP HANA system to expose the debugger port to the outside world.

What do you have to specify when you create a new debug configuration for a service-side JavaScript? Note: There are 3 correct answers to this question.

The SAP HANA port number

The name of the debug configuration

The SAP HANA host name

The XS session ID

The logon language

Which of the following tasks can you perform in the source code view of the debugger? Note: There are 3 correct answers to this question.

Single step through the code.

Set breakpoints.

Start the debugger.

Group breakpoints by type.

Drill in to see values in the running code.

To define a delivery unit, you need: There are 2 correct answers to this question

A Valid To date

A vendor ID

A delivery unit name

A Created On timestamp

What must you do before you can assign an artifact to a delivery unit?

Assign the artifact to an application.

Assign the artifact to a system.

Assign the artifact to a project.

Assign the artifact to a package.

What is a disadvantage of assigning a package to a delivery unit in the Content view of an SAP HANA system?

System performance is adversely affected.

You cannot create new packages in this view.

You cannot reassign a package to another delivery unit.

You cannot automatically assign sub-packages.

What is the purpose of APIs in SAP HANA UI Integration Services?

You do not use APIs with SAP HANA UI Integration Services

To redesign widgets

To implement communication between widgets

To check widgets for compatibility

Which of the following are main features of SAP HANA UI Integration Services? There are 3 correct answers to this question.

Customization

Page building

Property persistence

Application link enabling

Content storage

Which of the following statements is true regarding the technical offerings of SAP Fiori applications?

All analytical SAP Fiori applications run on any database supported by SAP Business Suite

All transactional SAP Fiori applications require SAP Business Suite powered by SAP HANA

The SAP Fiori launchpad runs within the SAP Fiori Fact Sheet interface.

While some transactional SAP Fiori applications run on any database, the remaining SAP Fiori application types require SAP Business Suite powered by SAP HANA.

When using SAPUI5, how is the UI rendering performed?

Delta blocks are rendered on the server and then injected into the DOM on the client side.

Service calls are made from the client side to retrieve UI rendering that took place within the server neutral zone.

The UI is completely rendered on the server side.

The UI is completely rendered on the client side.

Which of the following statements is most accurate regarding the target devices of SAPUI5-based applications?

SAPUI5 is designed to target only mobile devices including smartphones and tablets.

SAPUI5 targets the SAPGUI and can only be rendered within a Windows desktop SAPGUI installation

SAPUI5 is designed to target only desktop Web browsers.

SAPUI5 can target multiple devices including smartphones, tablets, and desktop browsers.

Within SAP HANA, how are SAP Fiori launchpads created?

Via the SAP Fiori Services App Site development artifact (xsappsite)

Via the SAP Fiori Services Launchpad development artifact (xslaunchpad)

Via the UI Integration Services Launchpad development artifact (xslaunchpad)

Via the UI Integration Services App Site development artifact (xsappsite)

Which of the following statements are true about spatial data? Note: There are 2 correct answers to this question.

Spatial data is data that describes the position, shape, and orientation of objects in a defined space.

Spatial data is represented as 2D geometric shapes.

Spatial data allows for the ability to time travel

Spatial data is represented as 3D geometric shapes.

Spatial data must be stored in a remote database.

Which of the following are spatial data types in SAP HANA? Note: There are 3 correct answers to this question.

ST_CIRCLE

ST_POINT

ST_LINESTRING

ST_POLYGON

ST_QUADRILLATERAL

Which of the following are components of the SAP HANA fulltext search architecture? Note: There are 3 correct answers to this question.

SInA API for JavaScript

Search API for SQLScript

SAP HANA Info Access toolkit

Graphical Search Designer

Fulltext Search via SQL

Which of the following is a true statement regarding fulltext indexing of content within SAP HANA?

Fulltext indexing takes place via the SInA API for JavaScript in the XS layer of SAP HANA.

Fulltext indexing happens directly within the SAP HANA database as a special index type.

Fulltext indexing is only possible via a search model built on top of column tables

Fulltext indexing requires copying of the data to an external TREX server.

After installing a new SAP HANA system, what must be done to use the SAP HANA Application Lifecycle Management tool?

The tool must be installed using the HALM add-on.

The tool must be activated in the configuration setup of SAP HANA.

The tool can be launched immediately after SAP HANA has been installed.

An additional license must be purchased and downloaded from the SAP Service Marketplace

What is the primary criterion for choosing SAP HANA Transport Container as your transport scenario?

You want a lightweight, no-installation transport tool.

You have the SAP HANA content as part of several solutions (BI, Mobile, and so on).

You want a standalone transport management without an ABAP system and you want to transport only SAP HANA content.

You have the SAP HANA content exclusively used by the ABAP system (ABAP for SAP HANA).

Where are all development artifacts stored?

In the SAP HANA repository

In the SAP HANA client

On the OS file system of the SAP HANA server

In the SAP HANA development archive

Which of the following are benefits of choosing SAP HANA extended application services-based development? Note: There are 3 correct answers to this question.

Encryption of all command subroutines

Speed of development

Single integrated technology stack

Simplicity at runtime

Zero backup crating

What is SAP hybris Marketing, data management?

A solution to provide data modeling capabilities relying on SAP HANA

A solution to migrate legacy data from another non-SAP environment

A solution to replicate data from SAP CRM to SAP hybris Marketing

A solution to provide continuously enriched customer profiles from all interactions and sources

Which SAP hybris Marketing components support the execution of automated marketing campaigns? Note: There are 2 correct answers to this question.

Orchestration

Retention

Acquisition

Insights

What industry-specific analytical content is included in the scope of SAP hybris Marketing RDS?

Telecommunications

Consumer Products

Retail

Banking

Which enhanced analyses for marketing insight are delivered in the scope of SAP hybris Marketing RDS? Note: There are 3 correct answers to this question.

Rebate analysis

Discount analysis

Market basket analysis

Value contribution

Customer segment performance

Which data integration tool do you use to bring SAP CRM data into SAP hybris Marketing?

SAP HANA smart data access

SAP Data Services

SAP Landscape Transformation Replication Server

SAP Event Stream Processor

What RDS-specific content is delivered by SAP hybris Marketing RDS? Note: There are 3 correct answers to this question.

SAP HANA models for industry-specific content for telco

SAP Predictive Analytics models

SAP BusinessObjects Business Intelligence dashboards and reports

SAPUI5 front-end content

SAP Lumira content

In which SAP HANA studio folder are database tables stored?

Security

Content

Catalog

Provisioning

When creating an attribute view in SAP HANA studio, where do you add the database tables in the editor?

Semantics

Content

Properties

Data foundation

Which SAP hybris Marketing Customizing object do we use to establish a link between the SAP HANA data source and SAP hybris Marketing customer segmentation?

Segmentation profile

Segmentation attribute

Segmentation object

Data source alias

{"name":"SAP 1 - 20\/", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What are the core capabilities of the SAP HANA database? Note: There are 3 correct answers to this question, Which of the following are features of non-native applications? Note: There are 3 correct answers to this question, Which of the following main components does SAP HANA comprise? Note: There are 3 correct answers to this question","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}