CC

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

How many result tables are produced from running an End User Unit Test?. 3. 4. 2.

As well as reading records one by one, using cursors allows you to change the record, too. True. False.

The results of a hierarchy generator function can be used only once. True. False.

In a SELECT with an OVER() clause, which of the following statements are true? (2 Correct). An OVER clause with ORDER BY cannot contain a PARTITIONED BY. PARTITIONED BY specifies the order of the rows in the result set. ORDER BY specifies the order of the rows in the result set. The SELECT statement cannot return NULL values. The PARTITION BY clause is optional.

A transactional savepoint allows you to perform a partial rollback within a complex transaction. TRUE. FALSE.

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

What are the three types of hierarchy function? (3 Correct). Table. Navigation. Generation. Scalar.

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.

The SQL Console is found in the Development view of the Web IDE. TRUE. FALSE.

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

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?. Minus. Intersect. Union.

In a calculation view semantic node, which are valid column types? (2 Correct). Dimension. Cube. Attribute. Measure.

Which are supported data source types for calculation view consumption? (4 Correct). Calculation views. Virtual tables. Column tables. Flat files. Row tables.

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

Why do you implement SQLScript Logging?. To record timestamps of all developers who have updated a SQL object. To identify the SQLScript code that is never used and can be removed. To highlight weak code design that might lead to poor performance. To capture the runtime log at the user level to support debugging.

What is the purpose of the Projection node? (2 Correct). To apply filters on the data. To join data sources. To extract only the required columns from a data source. To aggregate measures.

What are best practices with SQLScript? (2 Correct). Split complex queries into logical sub-queries. Avoid cursors. Use dynamic SQL.

If the current row has a value of 5000 and the three preceding rows have a value (in order) of 1000, 1500, and 3000, which rows would be included in ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING?. 1000, 1500, 3000, and 5000. 1000 and 1500. 1500 and 3000. 1500.

Table User-Defined Functions can accept any number of input parameters and return any number of table results. FALSE. TRUE.

What is the difference between GROUP BY CUBE and GROUP BY ROLLUP?. GROUP BY ROLLUP cannot be used in a SELECT statement. GROUP BY CUBE is not part of the ANSI SQL-99 standard. GROUP BY CUBE aggregates in every dimension.

Which two statements are correct regarding table functions? (2 Correct). They can return multiple tables. They must be free of side effects. They can have any number of input parameters. They are used in the WHERE clause of a SELECT statement.

What is a user-defined library?. A repository for storing custom SQL code that is used frequently. A group of variables, procedures and functions, which are related. A collection of frequently used input parameters that form part of a test script.

What is the SAP HANA Deployment Infrastructure (HDI)?. A source code versioning framework for SAP HANA source files. A type of application that is built from components developed in multiple languages. An isolated environment for storing SAP HANA database runtime objects.

What is SQLScript?. A replacement for SQL that provides a more powerful language for developers. An open source version of SQL that is supported by most well-known databases. A set of extensions on top of standard SQL that exploit the specific features of SAP HANA.

Declarative Logic can only use a limited set of SQL Script language. FALSE. TRUE.

What states can be returned using a combination of EXISTS and IN predicates? (3 Correct). Unknown. FALSE. TRUE. Incorrect.

Why do you use a Referential Join?. When you want to display facts even when the associated master data attributes are missing. 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.

What is the recommended approach for creating procedures?. Use the CREATE PROCEDURE statement in the SQL Console. Define a source file .hdbprocedure in the development view of SAP Web IDE.

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

If the current row has a value of 5000 and the three preceding rows have a value (in order) of 1000, 1500, and 3000, which rows would be included in RANGE BETWEEN 3500 PRECEDING AND CURRENT ROW?. 1500, 3000, and 5000. 1000, 1500, 3000, and 5000. 5000. 1000, 1500, and 3000. 3000 and 5000.

Why do you use SQL Hints?. To expose the contents of the internal variables during runtime to help with debugging. To provide the SQL Optimizer with information about recent executions to enable better performance. To add additional parameters to statements to deactivate default runtime behavior or to influence access paths to data.

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

A dimension can have attributes and measures. TRUE. FALSE.

Stored procedures must utilize only scalar parameters, or only table parameters. TRUE. FALSE.

What are temporal tables?. Tables that support time travel queries. Tables that persist only during a session.

Why do we use imperative logic?. To improve performance of data-intensive tasks. To take control of the data flow using conditional logic. To define reusable modules of code.

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

Why do we use MAP_MERGE operators?. To replace sequential FOR-loops and union patterns with a parallel operator to improve performance. To push back complex conditional logic to the source database when using remote data connections.

Why do you use the SQL Code Analyzer?. Identify bottlenecks in the runtime performance of the query. Trace the data flow to expose the contents of internal variables. Scan the source code to look for potential problems.