Knowledge quiz

It's time to put what you've learned to the test, get 8 right to pass this week.

How are input parameter values passed by a SQL query?

Choose the correct answer.

SQL queries pass input parameter values with a WHERE clause.

SQL queries pass input parameter values using placeholder syntax.

It varies. Some analytics tools pass it with a WHERE clause, and some with placeholder syntax.

Input parameter values are never passed by a SQL query because input parameters are a property of the calculation view, with no external interface.

What are the consequences if two developers have developer authorizations in the same Cloud Foundry space?

Choose the correct answer.

The developers essentially have the same privileges because they can use the same services.

Both developers need to use the same namespace.

As soon as one developer logs in, the other developer is notified.

It is not possible for two developers to have developer authorizations for the same Cloud Foundry space.

What does adding a partition column to your modeled Rank window function do?

There are two correct answers.

Each partition will be evaluated and ranked as a set.

Each partition will have a rank = 1.

Each partition will have the same number of records.

Each partition will be written into a separate output table.

Which calculation view nodes can be used to model rank in SAP Business Application Studio?

There are two correct answers.

Rank node

Window Function node

Table Function node

Projection node

Aggregation node

Which type of hierarchy node is optional?

Choose the correct answer.

Navigation Hierarchy node

Generation Hierarchy node

Aggregation Hierarchy node

Projection Hierarchy node

What are the consequences if analytic privileges are assigned to a user?

Choose the correct answer.

Having an analytic privilege for a calculation view is enough to allow reporting on a calculation view.

The user is authorized to report on all analytic views.

Assigning analytic privileges only allows users to see records if they also have SELECT privilege on the calculation view.

Assigning analytic privileges restricts access to records of all existing calculation views and no specific setting is needed in the individual calculation views.

With which view can you monitor existing virtual tables in a system?

Choose the correct answer.

VIRTUAL_TABLES

M_REMOTE_STATEMENTS

REMOTE_STATEMENTS

REMOTE_SOURCES

What does enabling the Multidefinition flag do?

There are two correct answers.

It helps to avoid duplicate values.

It lets you combine two or more columns.

It allows you to model combined columns for level hierarchies.

It allows you to add a definition label to the hierarchy.

What are the options for defining virtual tables?

There are two correct answers.

You can define a virtual table using a design-time description.

You can define virtual tables directly in the catalog without a design-time description.

You always need a design time and catalog definition for virtual tables.

There is no need to define virtual tables because they are automatically created.

You must switch the calculation view to “Virtual Table Construct” so that the virtual table can be defined in the calculation view.

10.

In which of the following scenarios can a user-provided service be used?

Choose the correct answer.

To grant access to objects in a non-HDI container but not in an HDI container

To grant access to objects in an HDI container but not in a non-HDI container

To grant access to all types of database objects for which it is possible to grant privileges

To make sure that the objects are always synchronized using Git