hana300

Which of the following are types of calculation views? Choose the correct answers. Cube. Composite. Cube with star join. Dimension.

A dimension can have attributes and measures. Determine whether this statement is true or false. True. False.

Dimensions can have attributes but not measures. Measures are defined only in cube, cube with star join and SQL access only, types of calculation views. True. False.

Which are true statements relating to calculation views of the type SQL access only? Choose the correct answers. They do not expose their meta data to reporting tools. They are mainly used for reusing inside other calculation views. They must include at least one measure. They include a star join node.

SQL access only calculation views can contain measures but measures are not mandatory and they cannot include star join nodes. True. False.

Which are supported data source types for calculation view consumption? Choose the correct answers. Calculation views. Flat files. Virtual tables. Column tables. Row tables.

What is a time-based dimension calculation view? Choose the correct answer. A view that is only accessible by users for a limited time. A view that stores the values of attributes across time.

What does SAP recommend you use to check your calculation view produces correct result? Choose the correct answer. Excel pivot tables. Custom SQL queries. Data preview function in the SAP Web IDE for SAP HANA.

In a calculation view semantic node, which are valid column types? Choose the correct answers. Measure. Attribute. Dimension. Cube.

Why do you hide columns in a dimension calculation view? Choose the correct answer. When you want to hide a column that is not required or allowed for client consumption. When you do not want to expose a sensitive column to a consuming calculation view. To ensure they can only be displayed along with other attributes and not used for drill-down navigation of filtering.

What is the purpose of the Projection node? Choose the correct answers. To apply filters on the data. To extract only the required columns from a data source. To aggregate measures. To join data sources.

Why do you use a Referential Join? Choose the correct answer. To improve performance of joins that do not need to check integrity if no column from the right table is selected by a query. When you need to display only facts that have associated master data attributes. When you want to display facts even when the associated master data attributes are missing.

Text Join is a Right Outer Join used to join a text table containing multi-language descriptions, to an attribute in a dimension. Determine whether this statement is true or false. True. False.

Text Join is a Left Outer Join used to join a text table containing multilanguage descriptions, to an attribute in a dimension Determine whether this statement is true or false. True. False.

Identify the type of join that ensures records are only selected if they fit within a specified date range. Choose the correct answer. Left Outer Join. Right Outer Join. Temporal Join. Full Outer Join.

In a union, you do not have to select all source columns and the source columns do not have to have the same name. Determine whether this statement is true or false. True. False.

You have customers who appear in table A and sometimes they also appear in table B. You want to select the customers that appear ONLY in table A. Which node type do you use? Choose the correct answer. Intersect. Minus. Union.

You have customers who appear in table A and sometimes they also appear in table B. You want to select only customer who appear in both tables. Which node type do you use?. Intersect. Minus. Union.

You have customers who appear in table A and sometimes they also appear in table B. You want to select all customers if they appeared in any table. Which node type do you use?. Intersect. Minus. Union.

In an Aggregation node, a calculated column is always computed before the aggregate function. Determine whether this statement is true or false. True. False.

In an Aggregation node, a calculated column is always computed after the aggregate function. Determine whether this statement is true or false. True. False.

Which flags are relevant to the control of the aggregation behavior? Choose the correct answers. Keep Flag. Transparent filter. Dynamic join.

Use Keep Flag and Transparent Filter to control the aggregation behavior. Dynamic Join is used to optimize joins, not aggregations. True. False.

In a Star Join node, what do you join to the central entity (fact table)? Choose the correct answer. CUBE calculation views. Column tables. DIMENSION calculation views.

You are only able to join DIMENSION calculation views in a Star Join node. True. False.

Which are three valid aggregation functions for a rank node? Choose the correct answers. Row. Rank. Sum. Sort.

Row, Rank and Sum are three valid aggregation functions for a rank node. Sort is not an aggregation function. True. False.

A restricted column provides a subset of the original column filtered by attribute values. Determine whether this statement is true or false. True. False.

When is the design time filter expression applied in a calculation view? Choose the correct answers. Before a query on the calculation view begins to execute. On the final result of a query, similar to a ‘where’ clause. Before any joins are executed within the calculation view.

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. Determine whether this statement is true or false. True. False.

Identify the object that adds a WHERE clause to the query. Choose the correct answer. Modeler. Attributes. Input parameter. Variable.

It is a variable that adds a ‘WHERE’ clause to the query, and therefore filters the data right at the final stage before presentation of the results. True. False.

In a calculated column, which do you use as a placeholder for a dynamic value in an expression? Choose the correct answer. Variable. Input parameter.

You use an Input parameter as a placeholder for a dynamic value in an expression and not a variable. True. False.

In a hierarchy, what is an orphan node? Choose the correct answer. A node that has no higher nodes. A node that has no lower nodes. A node that contains only one member.

An orphan node has no higher (parent) node(s). True. False.

What are two types of modeled hierarchy you can create using calculation views? Choose the correct answers. Parent-Child. Referential. Level.

Parent-Child and Level are valid hierarchies. Referential is not a type of hierarchy but refers to a type of join. True. False.

While converting currencies, in addition to source and target currencies, which value is also needed? Choose the correct answer. Time. Country. VAT rate.

Time is required in addition to source and target currencies. True. False.

Why is knowledge of SQL important to an SAP HANA modeler? Choose the correct answers. 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.

SQL is important for modelers because they need to know how to read the logic written in SQL inside functions and procedures and also how they might extend the calculation view capabilities. True. False.

You are using the SQL console of the Web IDE. When are schema references not required in your code? Choose the correct answer. 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.

You never specify a schema when writing SQL against a HDI Container type database connection. True. False.

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? Choose the correct answer. 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.

Which are valid source file types used to define the persistence layer of SAP HANA? Choose the correct answers. .hdbtable. .sqltable. .hdbcds.

What types of user-defined SQL functions can you include as a data source in a calculation view? Choose the correct answers. Table Functions. Column Engine Functions. Scalar Functions.

Table functions are supported as data sources in SAP HANA calculation views. True. False.

Why would you use SQL functions when modeling in calculation views? Choose the correct answer. As an alternative to developing a graphical calculation view when you prefer to use script. When you need to write results back to a table from a calculation view. When you need to define custom data processing logic that the graphical calculation view cannot provide.

Functions allow you to write custom data processing logic that the graphical calculation view cannot provide. Functions are not a replacement for graphical calculation views to provide more flexibility. Functions are read only and do not allow writing to the database. True. False.

How should you create a procedure? Choose the correct answer. Write your code in a source file in the SAP Web IDE with the extension .hdbprocedure. Use the CREATE PROCEDURE statement in SQL Console.

You should never use the SQL ‘create’ statement to develop procedures. Instead, use the dedicated file type '.hdbprocedure' for procedure in the Web IDE development view. True. false.

Procedures can be used in the FROM clause of a SELECT statement. Determine whether this statement is true or false. True. False.

You CANNOT use procedures in the FROM clause of a SELECT statement. Only table functions can be used in the FROM clause. You CALL a procedure. True. False.

Where possible, in your SQL code, always use calculation engine (CE) functions to ensure best performance. Determine whether this statement is true or false. True. False.

SAP no longer recommends the use of CE functions as these severely limit the optimization possibilities, use standard SQL instead. True. False.

Where do I define a pruning configuration table? Choose the correct answers. Join nodes. Union nodes. Projection nodes.

A pruning configuration table optimizes unions and therefore is defined in a union node. True. False.

Which type of node is used to end the parallelization of a data flow? Choose the correct answer. Projection. Union. Aggregation.

A union node with only one source must be used to end the parallelization of a data flow. True. False.

To work with calculation view debug query, you first need to build the calculation view? Determine whether this statement is true or false. True. False.

You first need to build the calculation view to use the Query Debug mode. The Query Debug mode calls the runtime object of the calculation view and that is only available when you first build the calculation view. True. False.

What is the purpose of the SQL Analyzer? Choose the correct answers. To identify the longest running SQL statements. To investigate the generated SQL for each node in my calculation view. To highlight syntax errors in my SQL code.

You can use SQL Analyzer to identify the longest running SQL statements and many other issues that might contribute to poor run-time performance, such as use of cache, query unfolding, etc. True. False.

You use the Query Debug mode to investigate the generated SQL for each node in your calculation view. True. False.

Syntax errors in SQL code are highlighted in the SQL Console of Web IDE. True. False.

Which are valid table partition types in SAP HANA? Choose the correct answers. Range. Hash. Round Robin. Column.

Range, Hash, Round Robin are valid table partition types. Column is not a table partition type. True. False.

To which storage tier does Native Store Extension (NSE) belong? Choose the correct answer. Cold. Hot. Warm.

Native Store Extension (NSE) belongs to the cold storage tier. True. False.

Native Store Extension (NSE) belongs to the warm storage tier. True. False.

Which of the following tools is used to analyze dependencies between models? Choose the correct answers. Data lineage. Column lineage. Impact analysis.

Data Lineage and Impact Analysis are tools used to analyze the dependencies between models, whereas Column Lineage only shows the origin of a column within a single model. True. False.

Which of the following development layers of an XS Advanced application are provided by an HDB module? Choose the correct answers. Persistence layer. User interface. Business logic. Data modeling.

The persistence layer and data modeling layer are defined in an HDB module. The user interface typically uses HTML5 or UI5 modules, and the business logic uses Java or Node.js modules. True. False.

An XS Advanced project can contain multiple HDB modules. Determine whether this statement is true or false. True. False.

The database objects defined in design-time files located in the same project folder can have different namespaces. Determine whether this statement is true or false. True. False.

The rules defining namespaces are defined at the folder level (any level of the folder structure). This means all database objects created within a folder always inherit the same namespace provided by the folder. You cannot define a namespace at the database object level. True. False.

A HDB module always corresponds to a database schema. Determine whether this statement is true or false. True. False.

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? Choose the correct answer. The project is not assigned to a Space. Building a project does not generate the database objects defined in its HDB modules. You do not have the Developer role in the assigned Space.

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. Determine whether this statement is true or false. True. False.

A design-time file that has never been built is ignored by the dependency check performed by the HDI builder if it is not part of the build scope. True. False.

Which database artifact do you use to access external data from an XS Advanced project? Choose the correct answer. Calculation view. Synonym. Logical schema. User-provided service.

Calculation views can consume external data, but they need a synonym to access this data. A logical schema can be used to define synonyms more dynamically, but this is something defined in XS Advanced, it is not a database artifact. As for the userprovided service, it is required to access data from an external schema but it is not a database artifact. True. False.

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. Determine whether this statement is true or false. True. False.

The Git architecture is not centralized but distributed, which means that several contributors to a project can have the complete project code on their own computer. There is no check-in / check-out process, compared with other types of control-version systems. True. False.

What is a dynamic analytic privilege? Choose the correct answer. A reusable analytic privilege that can be used for several users who need to access different data. An analytic privilege that takes its filter values from variables defined in the calculation view. temporary analytic privilege that has a defined time validity set for its use.

A dynamic privilege is a reusable analytic privilege that can be assigned to several users who need to access different data. True. False.

What is data masking? Choose the correct answer. Obscuring column values by hiding some or all characters with replacement characters. Replacing column values with a higher level group such as replacing a person id with team name. Removing complete rows of data that should not be seen by users.

Data masking is obscuring column values by hiding some or all characters with replacement characters, such as a bank card xxxx-xxxx-xxxx-3476. True. False.

Why do you implement data anonymization? Choose the correct answer. To hide sensitive data using alternative characters such as ‘XXXXX’. 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.

data anonymization uses algorithms to hide sensitive data by adding noise at the record level so that aggregated values still make sense but individual records are not exposed. True. False.