HANA300 Extra Questions Flashcards
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
- Join on key or indexed columns
- Filter data as early as possible in the data flow
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
- Do not include scripted calculation views in your model
- Do not include analytic views in your model
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
- ‘Flattening’ of column engine expressions and stacked views into a plain SQL statement
Why is unfolding a good thing?
* Easier to debug SQL
* Improves performance
* Easier to export models to other SQL platforms
- Improves performance
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
- Automatic removal of not relevant data sources in a union
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
- Define constant values in a union node
- Define a union pruning table and refer to it from a calculation view
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
- Use variables to break up complex statements
- Avoid mixing CE plan operators and SQL relational operators
Which should you use for best performance?
* Column Engine (CE) expressions
* Plain SQL
- Plain SQL
Which are valid partition types?
* Hash robin
* Range
* Round hash
* Robin hash
* Round robin
* Hash
Range
* Round robin
* Hash
What are valid choices for data category of a calculation view built with Web IDE?
* Cube
* Attribute
* View
* SQL Access Only
* Dimension
- Cube
- SQL Access Only
- Dimension
In what languages can you write calculation expressions?
* SQL
* SQLScript
* Column Engine
* ABAP
- SQL
- Column Engine
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
- When you want to apply a user-provided filter on the final calculation view result
True or false: Input Parameters can be derived using SQLScript
* True
* False
- False
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
- To predefine a reuseable column that has been filtered by one or more attributes values
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
- In a project node
- In an aggregation node
- In a union node
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
- When I need to use the column in a filter but don’t wish to expose it to the reporting tool
What are valid types of hierarchy?
* Level Hierarchy
* Parent-child
* Dimensional
- Level Hierarchy
- Parent-child
True or false: Dimensions contains attributes and measures
* True
* False
- False
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
- Calculation views data category dimension
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
The user calling the function
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
Function
Procedure
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.
You want to create a dynamic analytic privilege.
Optimal performance is a priority.
The code should modify data in the table.
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.
- 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.
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
The code should modify data in the table
Optimal performance is a priority
You need to implement Data Definition Language (DDL)statements
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
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.
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
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
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.
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
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.
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
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
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.
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.
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
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
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
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
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
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
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
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
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
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.
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.
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
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.
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.
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
What are components of SAP HANA EIM?
There are 2 correct answers to this question.
Response:
SDI
SDA
SDS
SDQ
SDI
SDQ
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
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
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.
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.
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.
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
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)
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
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
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
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>
THE source amount
Null
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
