In a Star Join node, what do you join to the central entity (fact table)?
CUBE calculation views
Column tables
DIMENSION calculation views
. What are the prerequisite skills needed to develop SAP HANA applications, if they are based on a Fiori UI and use Node.js in the application server? (3 Correct)
ABAP language
HTTP protocol
SQL language
JavaScript language
SAP Screen Personas
. An XS Advanced project can contain multiple HDB modules.
TRUE
FALSE. When is the design time filter expression applied in a calculation view? (2 Correct)
Before any joins are executed within the calculation view
Before a query on the calculation view begins to execute
On the final result of a query, similar to a ‘where’ clause
. A calculation view CV1 has been created in your project folder but has never been built. Your perform a build of another calculation view CV2 that consumes CV1. The CV1 file will be included in the build of CV2.
FALSE TRUE. While converting currencies, in addition to source and target currencies, which value is also needed?
Country VAT rate
Time. Where possible, in your SQL code, always use calculation engine (CE) functions to ensure best performance.
TRUE FALSE. Why do you implement data anonymization?
To hide sensitive data by adding noise at the record level so that aggregated values still make sense but individual records are not exposed.
To remove complete records so that they cannot be seen by unauthorized users
To hide sensitive data using alternative characters such as ‘XXXXX’.
. Why is knowledge of SQL important to an SAP HANA modeler? (2 Correct)
So that they can choose to create calculation views using only SQL language
So that they can understand how to implement a function or procedure and consume this within a calculation view
So that they can extend the capabilities of a calculation view using SQL expressions
. To which storage tier does Native Store Extension (NSE) belong?
Warm Cold Hot. In a hierarchy, what is an orphan node?
A node that has no higher nodes
A node that has no lower nodes
A node that contains only one member
. Identify the object that adds a WHERE clause to the query.
Variable
Modeler Attributes Input parameter
. Which of the following tools is used to analyze dependencies between models? (2 Correct)
Impact analysis
Column lineage
Data lineage
. Which are valid source file types used to define the persistence layer of SAP HANA? (2 Correct)
.hdbcds
hdbtable sqltable. Which of the following development layers of an XS Advanced application are provided by an HDB module? (2 Correct)
Persistence layer
Business logic
User interface
Data modeling
. What is a dynamic analytic privilege?
A temporary analytic privilege that has a defined time validity set for its use
An analytic privilege that takes its filter values from variables defined in the calculation view
A reusable analytic privilege that can be used for several users who need to access different data.
. The Git architecture relies on a central server that stores a unique version of your source code and includes a check-out process that prevents several users from modifying the same source file at the same time.
TRUE
FALSE
. You are using the SQL console of the Web IDE. When are schema references not required in your code?
When writing SQL against a database connection of the type HDI Container
When writing SQL against a database connection of the type SAP HANA Database. In a calculated column, which do you use as a placeholder for a dynamic value in an expression?
Variable
Input parameter
. Why should I define my SAP HANA tables using source files rather than using the SQL statement ‘CREATE TABLE’ in the SQL Console of Web IDE?
The syntax is simpler
Performance of the table is better.
The table definition is easily transported as part of the overall application to ensure all project artifacts are kept together.
. How should you create a procedure?
Use the CREATE PROCEDURE statement in SQL Console
Write your code in a source file in the SAP Web IDE with the extension .hdbprocedure
. A HDB module always corresponds to a database schema.
TRUE
FALSE. Where do I define a pruning configuration table?
Join nodes.
Union nodes.
Projection nodes.
. You have successfully built a project that you imported into the SAP Web IDE workspace, but you cannot see the corresponding runtime database objects. What could be the reason?
Building a project does not generate the database objects defined in its HDB modules.
The project is not assigned to a Space.
You do not have the Developer role in the assigned Space.
. What is data masking? Replacing column values with a higher level group such as replacing a person id with team name
Obscuring column values by hiding some or all characters with replacement characters
Removing complete rows of data that should not be seen by users
. What are two types of modeled hierarchy you can create using calculation views? (2 Correct)
Parent-Child
Referential
Level
. Which flags are relevant to the control of the aggregation behavior? (2 Correct)
Keep Flag
Dynamic join
Transparent filter
. The database objects defined in design-time files located in the same project folder can have different namespaces.
TRUE
FALSE
. Procedures can be used in the FROM clause of a SELECT statement.
FALSE TRUE. When the Default Client property of a calculation view is set to Session Client, the data is filtered dynamically based on the CLIENT assigned to the user.
FALSE TRUE. When writing SQL against a database connection of the type SAP HANA Database.
Scalar Functions
Column Engine Functions
Table Functions
. Which type of node is used to end the parallelization of a data flow?
Projection
Union Aggregation. A restricted column provides a subset of the original column filtered by attribute values.
FALSE
TRUE. Which are valid table partition types in SAP HANA? (3 Correct)
Range Column Round Robin
Hash
. In an Aggregation node, a calculated column is always computed before the aggregate function.
TRUE FALSE. Why would you use SQL functions when modeling in calculation views?
When you need to define custom data processing logic that the graphical calculation view cannot provide
When you need to write results back to a table from a calculation view
As an alternative to developing a graphical calculation view when you prefer to use script. What is the purpose of the SQL Analyzer?
To highlight syntax errors in my SQL code.
To investigate the generated SQL for each node in my calculation view.
To identify the longest running SQL statements.
. Which database artifact do you use to access external data from an XS Advanced project?
Calculation view
Logical schema
User-provided service
Synonym
. To work with calculation view debug query, you first need to build the calculation view?
TRUE FALSE. Which are three valid aggregation functions for a rank node? (3 Correct)
Row Rank Sort Sum
.
|