HANA300 Extra Questions Flashcards

(83 cards)

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
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
Column
26
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.
You have not built the project yet. Your HDB module references a user-provided service that does not exist.
27
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
Disaster recovery Log replication
28
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
Enable drilldown in a value help list
29
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.
Your column tables' delta store is frequently larger than its main store.
30
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. 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
31
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.
Specify the join cardinality. Limit the number of joined columns.
32
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
Create an SQL analytic privilege based on a parent-child hierarchy
33
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
Inner join
34
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.
Authorizations are at the application level. It uses ABAP CDS views.
35
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.
Join on key fields between tables in a dimension view.
36
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.
Generate additional root nodes. Assign them to a node at the root level
37
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
ONLY the required columns and the required partitions
38
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
To generate additional Meta data that can be used for analysis of a hierarchy structure
39
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
Variables to break up complex statements Flow control logic Creation of column tables
40
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
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
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
From the underlying dimension views
42
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
SDI SDA
43
Refactoring is used with which of the following actions? Please choose the correct answer. Response: Deployment Documenting Improving your modeling design Translating
Improving your modeling design
44
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
Value help views Query views
45
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.
Your function includes a TRUNCATE statement.
46
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.
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
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
Using both row-based and column-based tables
48
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.
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
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.
To identify the longest running SQL statements.
50
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
Create SQL expression to define the concealing logic for the column Include an anonymization node in the calculation view
51
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
To support development of custom logic within calculation views
52
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.
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
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
Spatial joins Referential joins
54
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
To generate a list of descendants for a hierarchy node
55
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 view with a filter A SQL analytic privilege
56
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
The build of Model A is successful The build of the entire HDB module is successful
57
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
Procedures Analytic Privileges Calculation Views
58
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
In the SAP HANA database
59
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
Input parameters Value help Variables
60
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
SAP HANA as a database SAP HANA as a reporting server
61
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
Assign tables as the only data sources in the nodes that start the parallelization block
62
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
Repository of ready-made predictive algorithms Repository of ready-made business functions
63
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
Store data in column tables Use dictionary compression Eliminate indices
64
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
To provide key system performance information for one or more HANA instances
65
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
Debug Query Mode
66
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
Integration of SAP HANA optimized BW models such as ADSOs or OpenODS views with SAP HANA Calculation views
67
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
- 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
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
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
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
_SYS_BIC schema
70
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
SAP Analysis for Microsoft Office
71
What are components of SAP HANA EIM? There are 2 correct answers to this question. Response: SDI SDA SDS SDQ
SDI SDQ
72
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
Enable drilldown in a value help list
73
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
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
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.
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
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.
You can loop through records.
76
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.
Push down aggregations to SAP HANA. Investigate partitioning of large tables. Minimize the transfer of data between the execution engines.
77
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
2 3
78
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)
Managed cloud as a service (MCaaS)
79
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
SAP HANA Studio development perspective Web IDE for SAP HANA
80
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
Processing Services Database Services Application Services Integration Services
81
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
Inner join
82
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
THE source amount Null
83
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
Reuse views