Elearning_HA_300_W_18

Which of the following are types of calculation views? 3 Answers. Cube. Composite. Cube with star join. Dimension.

A dimension can have attributes and measures. True. False.

Which are true statements relating to calculation views of the type SQL access only? 2 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.

Which are supported data sources for calculation view consumption? 4 Answers. Calculation views. Flat files. Virtual tables. Column tables. Row tables.

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

In a calculation view, which are valid output column types? 2 Answers. Measure. Attribute. Dimension. Cube.

Why do you hide columns in a dimension calculation view?. 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? 2 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?. 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.

A Text Join is a Right Outer Join used to join a text table containing multi-language descriptions, to an attribute in a dimension. True. False.

Identify the type of join that ensures records are only selected if they fit within a specified date range. 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. 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?. Intersect. Minus. Union.

In an Aggregation node, a calculated column is always computed before the aggregate function. True. False.

Which flags are relevant to the control of the aggregation behavior? 2 Answers. Keep Flag. Transparent filter. Dynamic join.

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

Which are three valid aggregation functions for a rank node? 3 Answers. Row. Rank. Sum. Sort.

A restricted column provides a subset of the original column filtered by attribute values. True. False.

When is the filter expression applied in a calculation view? 2 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. True. False.

Why do you use a variable?. To provide a missing value to a formula. To filter results.

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

In a hierarchy, what is an orphan node?. A node that has no parent node. A node that has no child nodes. A node that contains only one member.

What are two types of modeled hierarchy you can create using calculation views? 2 Answers. Parent-Child. Referential. Level.

While converting currencies, in addition to source and target currencies, which is also needed?. Date. Country. VAT rate.

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

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

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

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.

Which are valid source file types used to define the persistence layer of SAP HANA? 2 Answers. .hdbtable. .sqltable. .hdbdropcreatetable.

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

Why would you use SQL functions when modeling in calculation views?. 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.

SAP recommends always create tables using SQL statements in the SQL console. True. False.

Which is the source file type that you use to load a table?. hdbtable. hdbdropcreatetable. hdbtabledata.

Virtual tables usually provide superior performance compared to standard tables. True. False.

Why would you define a pruning configuration table?. To define the conditions that determine when a complete data source can be pruned from a union. To define the optimal path that should be used to prune data sources from a union .

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

To work with calculation view debug query, you first need to build the calculation view?. True. False.

What is the purpose of the SQL Analyzer?. 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.

Which are valid table partition types in SAP HANA? 3 Answers. Range. Hash. Round Robin. Column.

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

Which of the following tools is used to analyze dependencies between models? 2 Answers. Data lineage. Column lineage. Impact analysis.

In a full stack application development project using Web IDE XS Advanced, which are provided by an HDB module? 2 Answers. Persistence layer. User interface. Business logic. Data modeling layer.

An XS Advanced project can contain multiple HDB modules. True. False.

The database objects defined in design-time files located in the same project folder can have different namespaces. True. False.

A HDB module always corresponds to a physical database schema. 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 in the Database Explorer. What could be the reason?. 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. True. False.

Which database artifact do you use to access external data that is outside your project?. Calculation view. Synonym. Logical schema. User-provided service.

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.

What is a dynamic analytic privilege?. 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. A temporary analytic privilege that has a defined time validity set for its use.

What is data masking?. 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.

Why do you implement data anonymization?. 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.