Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SAP > HANA300 Extra Questions > Flashcards

HANA300 Extra Questions Flashcards

1
Q

Which of these are recommended to ensure good performance?
* Join on key or indexed columns
* Projection nodes should always be placed above aggregation nodes in a calculation view
* Filter data as early as possible in the data flow
* Avoid calculations after aggregations

A
  • Join on key or indexed columns
  • Filter data as early as possible in the data flow
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

You have set the flag in your view to execute only in the SQL engine. What design rules must you follow in order to achieve the best performance?
* Avoid use of input parameters, always use variables
* Do not include scripted calculation views in your model
* Do not include analytic views in your model
* You should also set the SQL flag in the underlying views

A
  • Do not include scripted calculation views in your model
  • Do not include analytic views in your model
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What do we mean by ‘unfolding’?
* ‘Flattening’ of column engine expressions and stacked views into a plain SQL statement
* Breaking down complex SQL into smaller chunks to execute in sequence

A
  • ‘Flattening’ of column engine expressions and stacked views into a plain SQL statement
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Why is unfolding a good thing?
* Easier to debug SQL
* Improves performance
* Easier to export models to other SQL platforms

A
  • Improves performance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is union pruning?
* Automatic removal of not relevant data sources in a union
* Removal of columns that are not common to all sources in the union
* Removal of rows from the result of a union that are empty

A
  • Automatic removal of not relevant data sources in a union
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What options do I have to implement union pruning?
* Define constant values in a union node
* Write filter expressions in a table function
* Define a union pruning table and refer to it from a calculation view

A
  • Define constant values in a union node
  • Define a union pruning table and refer to it from a calculation view
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which are good practices when writing SQL?
* Use variables to break up complex statements
* Avoid Grouping Sets
* Use IF-THEN-ELSE statements to help control the data flow
* Avoid mixing CE plan operators and SQL relational operators

A
  • Use variables to break up complex statements
  • Avoid mixing CE plan operators and SQL relational operators
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which should you use for best performance?
* Column Engine (CE) expressions
* Plain SQL

A
  • Plain SQL
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which are valid partition types?
* Hash robin
* Range
* Round hash
* Robin hash
* Round robin
* Hash

A

Range
* Round robin
* Hash

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are valid choices for data category of a calculation view built with Web IDE?
* Cube
* Attribute
* View
* SQL Access Only
* Dimension

A
  • Cube
  • SQL Access Only
  • Dimension
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

In what languages can you write calculation expressions?
* SQL
* SQLScript
* Column Engine
* ABAP

A
  • SQL
  • Column Engine
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Why do you implement a variable rather than an input parameter?
* When you want to apply a user-provided filter on the final calculation view result
* When you want to push down a user-provided filter to a lower level calculation view
* When you want to provide a dynamic value to a calculated expression
* When you want to apply a user defined filter on a measure

A
  • When you want to apply a user-provided filter on the final calculation view result
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

True or false: Input Parameters can be derived using SQLScript
* True
* False

A
  • False
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Why do you define a restricted column?
* So it can only be seen by specified users
* To predefine a reuseable column that has been filtered by one or more attributes values
* To prevent developers from using a column in their calculation view that is forbidden
* To limit the amount of data that is produced if data sets ar very large

A
  • To predefine a reuseable column that has been filtered by one or more attributes values
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Where can you define a filter?
* In the semantics node
* Using the filter node
* In a project node
* In an aggregation node
* In a union node

A
  • In a project node
  • In an aggregation node
  • In a union node
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Why might I hide a column in the semantics node?
* To set a default hidden state so that a user can later decide if they want to expose it in the reporting tool
* When I need to use the column in a filter but don’t wish to expose it to the reporting tool
* When my calculation view does not require a column from a table
* To define a column as inactive so that I can decide to activate it later

A
  • When I need to use the column in a filter but don’t wish to expose it to the reporting tool
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What are valid types of hierarchy?
* Level Hierarchy
* Parent-child
* Dimensional

A
  • Level Hierarchy
  • Parent-child
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

True or false: Dimensions contains attributes and measures
* True
* False

A
  • False
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

In a star join node what can I join to the central data foundation?
* Calculation views data category cube
* Tables
* Calculation views data category dimension
* Calculation views data category cube with star join

A
  • Calculation views data category dimension
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

You created a user-defined function with the INVOKER security option. Which user’s authorizations are checked when the function is executed?
Please choose the correct answer.

Response:

The SYSTEM user
The user calling the function
The container’s technical user
The owner of the function

A

The user calling the function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

In SAP Web IDE for SAP HANA, what can a flow graph generate in a predictive analysis scenario?
There are 2 correct answers to this question
Container
Task
Function
Procedure

A

Function
Procedure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Why would you develop an SQL procedure instead of a function?
There are 3 correct answers to this question.

Response:

A temporary table must be created within the code.
You want to create a dynamic analytic privilege.

You need to use conditional logic.

Optimal performance is a priority.

The code should modify data in the table.

A

You want to create a dynamic analytic privilege.
Optimal performance is a priority.
The code should modify data in the table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.

What is the correct approach?
Please choose the correct answer.

Response:

  • Combine the transaction tables using a star join node in a calculation view of type cube with star join.
  • Use the same star join node to connect the dimensions to the fact table.
  • Combine the transaction tables using a star join node in a calculation view of type cube with star join.
  • Use a join node to join the dimensions to the fact table.
  • Combine the transaction tables using a join node in a calculation view of type cube with star join.
  • Use a star join node to join the dimensions to the fact table.
  • Combine the transaction tables using an aggregation node in a calculation view of type cube with star join.
  • Use a star join node to join the dimensions to the fact table.
A
  • Combine the transaction tables using a join node in a calculation view of type cube with star join.
  • Use a star join node to join the dimensions to the fact table.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

When would you develop an SQL procedure instead of a function?
There are 3 correct answers to this question.

The code should modify data in the table

You need to use conditional logic

You want to create a dynamic analytic privilege

Optimal performance is a priority

You need to implement Data Definition Language (DDL)statements

A

The code should modify data in the table
Optimal performance is a priority
You need to implement Data Definition Language (DDL)statements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What type of input parameters do you use to choose the data from a field in the current table?
Please choose the correct answer.

Response:

Value help

Direct

Column

Derived from table

A

Column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

After importing a project in the workspace of the SAP Web IDE, you execute a build at the HDB module level. The build fails. What could be the reason?
There are 2 correct answers to this question.

Response:

You have not built the project yet.

Your HDB module references a user-provided service that does not exist.

You have not defined the HDI build plug-in version.

You have not assigned the project to a space.

A

You have not built the project yet.

Your HDB module references a user-provided service that does not exist.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What do you need for Active/Active (read-enabled) mode?
There are 2 correct answers to this question.

Response:

Disaster recovery

Multitenant Database Containers (MDC)

Extended storage

Log replication

A

Disaster recovery
Log replication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

Which of the following can a level hierarchy do?
Please choose the correct answer.

Response:

Have time-dependency

Be used for a bill of materials (BOM) structure

Enable drilldown in a value help list

Show variable deepness in the data

A

Enable drilldown in a value help list

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

In which of the following scenarios would you benefit from enabling table portioning in SAP HANA?
Please choose the correct answer.

Response:

Your stacked model consists of multiple calculation views.

you have a larger column store table that is consumed in a view with a variable on COUNTRY column.

Your column tables’ delta store is frequently larger than its main store.

You have a large row store table that is consumed in view with a variable on COUNTRY column.

A

Your column tables’ delta store is frequently larger than its main store.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

You require faster performance for a frequently queried calculation view. You have just enabled the static Results cache for this calculation view with a cache period = 120 minutes.

What are effects of this action?
There are 3 correct answers to this question.

Response:

A. Users MAY NO LONGER see the most current data in the output.

B. Additional memory will be consumed by the calculation view

C. Updating of the underlying tables in the calculation view will be delayed for 120 minutes.

D. Variables can no longer be used by this calculation view

E. CPU usage for the calculation view will be reduced

A

A. Users MAY NO LONGER see the most current data in the output.

C. Updating of the underlying tables in the calculation view will be delayed for 120 minutes.

E. CPU usage for the calculation view will be reduced

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

Which of the following approaches improve the performance of joins in a cube calculation view?
There are 2 correct answers to this question.

Response:

Determine join direction in a full outer join.

Use an inner join.

Specify the join cardinality.

Limit the number of joined columns.

A

Specify the join cardinality.

Limit the number of joined columns.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

Which scenario is supported to base an analytic privilege on a hierarchy defined on an attribute column?
Please choose the correct answer.

Response:

Create an SQL analytic privilege based on a level hierarchy

Create a classical analytic privilege based on a parent-child hierarchy

Create a classical analytic privilege based on a level hierarchy

Create an SQL analytic privilege based on a parent-child hierarchy

A

Create an SQL analytic privilege based on a parent-child hierarchy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Which type of join supports a temporal conditions in a calculation view?
Please choose the correct answer.

Response:

Referential join

Left outer join

Inner join

Text join

A

Inner join

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

How does SAP S/4HANA embedded analytics differ from SAP HANA Live?
There are 2 correct answers to this question.

Response:

Authorizations are at the application level.

Authorizations are at the database level.

It uses ABAP CDS views.

It uses SAP HANA calculation views.

A

Authorizations are at the application level.
It uses ABAP CDS views.

35
Q

What performance technique should you implement to improve join performance?
Please choose the correct answer.

Response:

Use joins instead of unions for combining large datasets.

Join on key fields between tables in a dimension view.

Do NOT use dynamic joins if you require optimal performance.

Always use referential joins in star join views.

A

Join on key fields between tables in a dimension view.

36
Q

Question:

Which options do you have to handle orphan nodes in your hierarchy?
There are 2 correct answers to this question.

Response:

Generate additional root nodes.

Assign them to a node at the root level

Assign them to a level below the root.

Define an expression to determine a parent.

A

Generate additional root nodes.

Assign them to a node at the root level

37
Q

A partitioned column table is present only in the persistent layer of an SAP HANA system Which columns and partitions are loaded into memory when the table is accessed by an application?
Please choose the correct answer.

Response:

ONLY the required partitions and all the columns

ONLY the required columns and the required partitions

All the partitions but ONLY the required columns

A

ONLY the required columns and the required partitions

38
Q

Why do you use a hierarchy function node in a calculation view?
Please choose the correct answer.

Response:

To assist the developer by visualising hierarchies

To enable hierarchical navigation in reporting tools

To display value help using hierarchies

To generate additional Meta data that can be used for analysis of a hierarchy structure

A

To generate additional Meta data that can be used for analysis of a hierarchy structure

39
Q

What does SQLScript provide in SAP HANA?
There are 3 correct answers to this question.

Response:

Variables to break up complex statements

Flow control logic

Powerful client-side processing

Aggregation functions such as AVG()

Creation of column tables

A

Variables to break up complex statements

Flow control logic

Creation of column tables

40
Q

Which of the following are correct statements relating to the flat file import function of SAP HANA Studio?
There are 3 correct answers to this question.

Response:

The new table always has a 1:1 mapping between the file and table columns

The supported file types for upload are .csv, and .txt

When loading new data in a table that already contains data, the new data is appended to the existing data

Renaming of columns and changing data types is allowedwhen loading data to new HANA tables

A

The new table always has a 1:1 mapping between the file and table columns

When loading new data in a table that already contains data, the new data is appended to the existing data

Renaming of columns and changing data types is allowedwhen loading data to new HANA tables

41
Q

From where does the Extract Semantics feature get the definition of hierar- chies?
Please choose the correct answer.

Response:

From the underlying dimension views

From the table data sources

From the current calculation view

From the SQL view data sources

A

From the underlying dimension views

42
Q

Which data provisioning tools can use SAP HANA adapters?
There are 2 correct answers to this question.

Response:

SDI

SAP HANA streaming analytics

SAP Replication Server

SDA

A

SDI

SDA

43
Q

Refactoring is used with which of the following actions?
Please choose the correct answer.

Response:

Deployment

Documenting

Improving your modeling design

Translating

A

Improving your modeling design

44
Q

Which of the following VDM views can be called by applications and reports?
There are 2 correct answers to this question.

Response:

Reuse views

Private views

Value help views

Query views

A

Value help views

Query views

45
Q

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The build of the table function fails.

Which of the following could be a valid reason?
Please choose the correct answer.

Response:

Your function refers to a scalar function.

You did not define at least one input parameter.

Your function includes a TRUNCATE statement.

You did NOT define a valid table type.

A

Your function includes a TRUNCATE statement.

46
Q

What performance techniques should you implement to improve join performance?
There are 3 correct answers to this question.

Response:

Join as many tables as possible in a star join view’s data foundation.

Use unions instead of joins for combining large datasets.

Always specify the cardinality of a join.

Always mark joins as dynamic to improve performance.

Use left outer joins instead of right outer joins.

A

Use unions instead of joins for combining large datasets.

Always specify the cardinality of a join.

Always mark joins as dynamic to improve performance.

Use left outer joins instead of right outer joins.

47
Q

What enables the delta buffer technique to speed up both reads and inserts in SAP HANA?
Please choose the correct answer.

Response:

Using both row-based and column-based tables

Using row-based tables only

Using only the insert-only technique

Using column-based tables only

A

Using both row-based and column-based tables

48
Q

You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source which is a table. When trying to build the calculation view, there is a namespace-relatedissue and the build fails.

What could be the reason?
There are 2 correct answers to this question.

Response:

The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

The imported calculation view and its data source have different namespaces.

The .hdinamespace file specifies a different namespace property than the one in the identifier of the calculation view.

The .hdinamespace specifies “sub-folder”:”append”, so calculation views can only be created in subfolders.

A

The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

The imported calculation view and its data source have different namespaces.

49
Q

When do you use the SQL Analyzer?
Please choose the correct answer.

Response:

To identify the longest running SQL statements.

To investigate the generated SQL for each node in my calculation view.

To hide the syntax errors in my SQL code​.

To highlight syntax errors in my SQL code.

A

To identify the longest running SQL statements.

50
Q

Your calculation view presents employee names which must only be seen by managers. Which steps are required to implement this?
There are 2 correct answers to this question.

Response:

Assign the UNMASK privilege to the managers for the calculation view

Create SQL expression to define the concealing logic for the column

Set the column to hidden in the calculation view

Include an anonymization node in the calculation view

A

Create SQL expression to define the concealing logic for the column

Include an anonymization node in the calculation view

51
Q

Why do we support SQL development in SAP HANA data modelling projects?
Please choose the correct answer.

Response:

To provide access to your data model to additional client tools.

To make changes to the runtime objects of your calculation view with SQL

To support development of custom logic within calculation views

As an alternative to developing calculation views when high performance is essential

A

To support development of custom logic within calculation views

52
Q

Which of the following are capabilities of SAP HANA Live Browser?
There are 3 correct answers to this question.

Response:

You can develop personal lists of frequently used query views.

You can graphically illustrate the dependencies between SAP HANA Live views.

You can launch the views using SAP Analysis Edition for Microsoft Excel.

You can adjust the views by adding additional columns.

A

You can develop personal lists of frequently used query views.

You can graphically illustrate the dependencies between SAP HANA Live views.

You can launch the views using SAP Analysis Edition for Microsoft Excel.

53
Q

Which join types are available in a Join node of a calculation view?
There are 2 correct answers to this question.

Response:

Spatial joins

Referential joins

Cross joins

Temporal joins

A

Spatial joins

Referential joins

54
Q

Why would you implement a hierarchy function node in a calculation view?
Please choose the correct answer.

Response:

To assist the developer by visualizing hierarchies

To enable a hierarchical drill-down in reporting tools

To generate a list of descendants for a hierarchy node

To display value help using hierarchies

A

To generate a list of descendants for a hierarchy node

55
Q

What can you use to limit users to see only 2018 data?
There are 2 correct answers to this question.

Response:

An object privilege

A view with a restricted column

A view with a filter

A SQL analytic privilege

A

A view with a filter

A SQL analytic privilege

56
Q

You have Model B that is based on Model A. You have successfully built both models. You delete Model B. What happens during the build?
There are 2 correct answers to this question.

Response:

You get an error when you build the entire HDB module

The build of Model A is successful

You get a build error when you build Model A

The build of the entire HDB module is successful

Model B gets deleted from the HDI container

A

The build of Model A is successful

The build of the entire HDB module is successful

57
Q

In SAP HANA Studio, what would you find in a Package?
There are 3 correct answers to this question.

Response:

Tables

Procedures

Analytic Privileges

Calculation Views

A

Procedures

Analytic Privileges

Calculation Views

58
Q

Where is SAP HANA Live installed?
Please choose the correct answer.

Response:

In the reporting tool

In the SAP HANA database

On SAP Landscape Transformation Replication Server

On the SAP ERP application server

A

In the SAP HANA database

59
Q

You want to show a male and female option to end users. What feature do you use?
There are 3 correct answers to this question.

Response:

Expressions

Domain fix values

Input parameters

Value help

Variables

A

Input parameters

Value help

Variables

60
Q

Which deployment scenarios feature security staying in the application server and end users not logging in to the SAP HANA system?
There are 2 correct answers to this question.

Response:

SAP HANA as a side-by-side accelerator
SAP HANA as a database
SAP HANA as a reporting server
SAP HANA as a platform with an SAP HANA XS application

A

SAP HANA as a database
SAP HANA as a reporting server

61
Q

You want to control parallelization in a calculation view. Which action is mandatory when you define the parallelization block?
Please choose the correct answer.

Response:

Define a source column as partitioning value in the start node of the parallelization block

Define a projection node as the end of the parallelization block

Assign tables as the only data sources in the nodes that start the parallelization block

Define a union node as the start of the parallelization block

A

Assign tables as the only data sources in the nodes that start the parallelization block

62
Q

What is the SAP HANA Application Function Library (AFL)?
There are 2 correct answers to this question.

Response:

Repository of ready-made predictive algorithms

Repository of ready-to-run applications that are powered by SAP HANA

Repository of ready-made business functions

Repository of connections that can be used by business functions

A

Repository of ready-made predictive algorithms

Repository of ready-made business functions

63
Q

Which technologies does SAP HANA use to load more data into memory?
There are 3 correct answers to this question.

Response:

Store data in column tables

Use dictionary compression

Use ZIP compression

Eliminate indices

Use multicore CPU parallelism

A

Store data in column tables

Use dictionary compression

Eliminate indices

64
Q

What is a role of the SAP HANA Cockpit?
Please choose the correct answer.

Response:

To provide key system performance information for one or more HANA instances

To secure the SAP HANA Database​

To provide KPIs to help focus on business performance

To provide an application developer collaboration hub

A

To provide key system performance information for one or more HANA instances

65
Q

Which tool should you use to generate and execute the SQL for a specific node of your calculation view?
Please choose the correct answer.

Response:

Debug Query Mode

Explain Plan

SQL Analyzer

Database Explorer

A

Debug Query Mode

66
Q

In SAP BW, when we refer to mixed modeling, what do we mean?
Please choose the correct answer.

Response:

Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation views

Integration of SAP NetWeaver Components into complex SAP HANA BW models

Integration of models from BW on non-HANA databases combined with SAP HANA optimized BWmodels

Integration of classic BW models such as InfoSets or InfoCubes with SAP HANA Calculation views

A

Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation views

67
Q

You have created attribute views and analytic views in the SAP HANA 1.0 XS Classic environment using SAP HANA Studio. You want to migrate them to the new XS Advanced environment of SAP HANA 2.0 SPS05.

What is the sequence of the activities?
Please choose the correct answer.

Response:

  • Convert attribute views and analytic views to calculation views
  • Migrate calculation views using the migration assistant
  • Import the .zip file into the SAP Web IDE workspace
  • Migrate calculation views using migration assistant
  • Convert attribute views and analytic views to calculation views
  • Import the .zip file into the SAP Web IDE workspace
  • Import the .zip file into the SAP Web IDE workspace
  • Migrate calculation views using migration assistant
  • Convert attribute views and analytic views to calculation views
  • Import the .zip file into the SAP Web IDE workspace
  • Convert attribute views and analytic views to calculation views
  • Migrate calculation views using the migration assistant
A
  • Convert attribute views and analytic views to calculation views
  • Migrate calculation views using the migration assistant
  • Import the .zip file into the SAP Web IDE workspace
68
Q

When using the CONTAINS predicate, what are the restrictions you must you keep in mind?
There are 2 correct answers to this question.

Response:

Wild cards* and? Are supported for text columns but not string columns

If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables.

Non-physical columns, such as calculated columns, are not search-relevant

The NOT (-) operator can only be specified directly after the OR operator

A

If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables.

Non-physical columns, such as calculated columns, are not search-relevant

69
Q

In an XSA/HDI environment, where do you find run-time objects?
Please choose the correct answer.

Response:

_SYS_BIC schema

Repository package

Database user schema

Container schema

A

_SYS_BIC schema

70
Q

Which business intelligence tool can publish storyboards?
Please choose the correct answer.

Response:

SAP Lumira, designer edition

SAP BusinessObjects Web Intelligence

SAP BusinessObjects Analysis, edition for Microsoft Office

SAP Analysis for Microsoft Office

A

SAP Analysis for Microsoft Office

71
Q

What are components of SAP HANA EIM?
There are 2 correct answers to this question.

Response:

SDI

SDA

SDS

SDQ

A

SDI

SDQ

72
Q

Which of the following can a level hierarchy do?
Please choose the correct answer.

Response:

Be used for a bill of materials (BOM) structure

Enable drilldown in a value help list

Show variable deepness in the data

Have time-dependency

A

Enable drilldown in a value help list

73
Q

In SAP Web IDE for SAP HANA, which of the following tasks do you need to complete before you can build the SAP HANA database (HDB) module successfully?
There are 2 correct answers to this question.

Response:

Assign the project to a space to which you have developer authorizations

Ensure that the name of your HDB module is included in the corresponding schema names

Ensure that you have only one HDB module in your project

Explicitly build the HDB module instead of the project

A

Assign the project to a space to which you have developer authorizations

Ensure that the name of your HDB module is included in the corresponding schema names

74
Q

What are the rules for defining a stepparent in a hierarchy?
There are 2 correct answers to this question.

Response:

The stepparent node ID must be entered according to the node style you selected for the hierarchy.

The stepparent node must already exist in the hierarchy at any level.
The stepparent node must already exist in the hierarchy at the root level.

A stepparent only applies to parent-child hierarchies.

A

The stepparent node ID must be entered according to the node style you selected for the hierarchy.

The stepparent node must already exist in the hierarchy at the root level.

75
Q

What should you keep in mind when using imperative logic in SQLScript?
Please choose the correct answer.

Response:

You can only use if-then logic.

It matches SQL’s set-oriented paradigm.

It delivers the best possible performance.

You can loop through records.

A

You can loop through records.

76
Q

What performance techniques should you implement to improve the performance of SAP HANA information views?
There are 3 correct answers to this question.

Response:

Perform calculation before aggregation in your analytic views.

Push down aggregations to SAP HANA.

Investigate partitioning of large tables.

Apply filters as late as possible.

Minimize the transfer of data between the execution engines.

A

Push down aggregations to SAP HANA.

Investigate partitioning of large tables.

Minimize the transfer of data between the execution engines.

77
Q

How many tiers do you usually find in an SAP HANA application?
There are 2 correct answers to this question.

Response:

2

3

4

1

A

2

3

78
Q

Which type of cloud solution is SAP HANA Enterprise Cloud an example of?
Please choose the correct answer.

Response:

Platform as a service (PaaS)

Software as a service (SaaS)

Managed cloud as a service (MCaaS)

Infrastructure as a service (IaaS)

A

Managed cloud as a service (MCaaS)

79
Q

Where do you build a flowgraph?
There are 2 correct answers to this question.

Response:

SAP HANA Studio development perspective

Web IDE for SAP HANA

Web-based development workbench

SAP HANA Studio modeler perspective

A

SAP HANA Studio development perspective

Web IDE for SAP HANA

80
Q

What are the four SAP HANA platform services?
There are 4 correct answers to this question.

Response:

Processing Services

Database Services

Application Services

Security Services

Integration Services

A

Processing Services

Database Services

Application Services

Integration Services

81
Q

You join two tables using a referential join and set the cardinality to 1…n What type of join is executed at runtime if your query does not request columns from the right table?
Please choose the correct answer.

Response:

Right outer join

left outer join

Inner join

Full outer join

A

Inner join

82
Q

You set up in currency conversion in a calculation view. When your currency conversion fails, what could you choose to populate the target column?
There are 2 correct answers to this question.

Response:

THE source amount

A DEFAULT value

Null

<EMPTY>
</EMPTY>

A

THE source amount

Null

83
Q

Which of the following views can you extend with the SAP HANA Live Extension Assistant?
Please choose the correct answer.

Response:

Query views with a union

All SAP-delivered views

Your own custom views

Reuse views

A

Reuse views

SAP (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions