Scalar function

Table function

Anonymous block

Procedure

When a delta merge is triggered

When the table is created

When partitions are regenerated

When a backup is started

Question

To ensure semantic correctness

To hide columns that are not required

To avoid duplicate rows in the output

To force filters to apply at the lowest node

To develop a series of linked joins

To define conditions for potential data source pruning

To reuse the settings of an existing join

To automate the setting of cardinality rules

Enable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Deploy the conversion rule

Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type/Assign the conversion rule to your calculation view

Assign semantic type/Choose client, source, and target currencies/Choose conversion date and rate type/Define an expression in a calculated column

Assign semantic type Enable the measure for conversion/Choose client, source, and target currencies/Choose conversion date and rate type

Generate an optimized run-time model based on a calling query

Identify potential performance issues

Trace of the run-time of a calculation view

Deploy a calculation view to a production system

Deploy the folder that contained the deleted design-time file.

Execute a DROP statement in an SQL Console connected to the HDI container.

Deploy the project that contained the deleted design-time file.

Execute the refactor function for the calculation view.

Individual source file

Entire workspace

Sub-folder of a database module

Individual container

Control the flow logic using IF-THEN-ELSE conditions.

Break up large statements by using variables.

Choose declarative language instead of imperative language.

Use dynamic SQL.

The cache data retention period has expired.

You did not define any columns in the cache setting.

You did not define a filter in the cache setting.

The query requests only a subset of the cached results.

The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

The imported calculation view and its data source have different namespaces.

An .hdinamespace file is defined in the SRC folder that specifies a different namespace property than the one in the identifier of the calculation view.

The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.

Define an expression to determine a parent.

Generate additional root nodes.

Assign them to a level below the root.

Assign them to a node at the root level.

Implement a union node and map each country as a separate column.

Create a restricted column for each country.

Create a filter expression that uses an OR operator.

Create 3 calculated columns.

WHERE

PLACEHOLDER

HINT

SET

To modify the content of a table

To process input parameters

To implement SQLScript syntax

To develop a dynamic analytic privilege

To generate multiple tabular output data sets

Projection

Join

Union

Aggregation

A table function that returns a list of allowed values.

A scalar function that returns a list of the allowed values for each attribute.

A procedure that returns the data access condition as an SQL expression.

An organization hierarchy that provides role-based access to data.

Query processing time improves

Results are read from static cache

SQL compilation time increases

Count-distinct results are incorrect

Pre-calculated aggregates

Indexes

Stored procedures

Table partitions

It must appear in the last DIMENSION in the star join node.

It is restricted to one DIMENSION in a star join node.

It CANNOT be mixed in the same star join node with other join types.

Only one column can be included in the join condition.

You previewed the data with the technical user in SAP Business Application Studio.

You did not define masking in calculation view A.

The UNMASKED privilege has NOT been granted at the schema level.

The type of the Account_Number column is VARCHAR.