Практический тест HA300

Which of the following are types of calculation views? Note:There are 3 correct answers to this question. Cube. Composite. Cube with star join. Dimension.

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

Which are true statements relating to calculation views of the type SQL access only? Note:There are 2 correct answers to this question. 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 source types for calculation view consumption? Note:There are 4 correct answers to this question. 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? Note:There are 2 correct answers to this question. 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? Note:There are 2 correct answers to this question. 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.

A 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.

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.

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

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

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.

Which are three valid aggregation functions for a rank node? Note:There are 3 correct answers to this question. Row. Rank. Sum. Sort.

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? Note:There are 2 correct answers to this question. 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.

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.

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.

What are two types of modeled hierarchy you can create using calculation views? Note:There are 2 correct answers to this question. Parent-Child. Referential. Level.

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

Why is knowledge of SQL important to an SAP HANA modeler? Note:There are 2 correct answers to this question. 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 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.

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.

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.

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.

Procedures can be used in the FROM clause of a SELECT statement. Determine whether this statement is true or false. 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? Note:There are 2 correct answers to this question. .hdbtable. .sqltable. .hdbcds.

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.

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

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

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.

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.

Which are valid table partition types in SAP HANA? Note:There are 3 correct answers to this question. Range. Hash. Round Robin. Column.

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

Which of the following tools is used to analyze dependencies between models? Note:There are 2 correct answers to this question. Data lineage. Column lineage. Impact Lineage.

Which of the following development layers of an XS Advanced application are provided by an HDB module? Note:There are 2 correct answers to this question. Persistence layer. User interface. Business logic. Data modeling.

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.

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.

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.

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.

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

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.

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.

Why should you develop skills in textual, spatial, graph and predictive modeling? Choose the correct answer. To add more types of data to your calculation views to produce more powerful models. Because calculation view modeling will soon be replaced by these types of models. To improve the run-time performance of calculation views.