Knowledge quiz

It’s time to put what you’ve learned to the test, get 4 questions right to pass this unit.

Which of the following statements regarding the advanced features of Custom Analytical Queries are correct?

There are two correct answers.

The user can select a hierarchy for a dimension in the report at any time of execution.

To get a list of all derivation functions and their definitions you can use the Query Browser.

To avoid formula collision you can prioritize the relevant formulas.

Which of the following statements is correct?

Choose the correct answer.

The View Browser enables users to explore thousands of Virtual Data Model (VDM) Views without requiring technical skills.

The View Browser requires advanced technical skills to navigate and explore the available Virtual Data Model (VDM) Views.

The View Browser provides access to a limited number of Virtual Data Model (VDM) Views, but only for users with technical expertise.

Which of the following statements is correct?

Choose the correct answer.

If the annotation of a view shows only the SQL view name, it indicates to the business user that they are examining an interface view.

The annotation of a view displaying only the SQL view name signifies that the user is reviewing a consumption view.

When the annotation of a view includes only the SQL view name, it automatically informs the business user that they are dealing with a transactional view.

Which of the following statements using the Custom Analytical Query are correct?

There are three correct answers.

To change the position of a field, you must deselect the field and select it again.

The Dimension Format option enables you to set the dimension format from Key to Text or Key and Text or Text and Key.

The Expand Level option is available only if you have enabled the Hierarchy option.

When a measure is only needed to calculate another measure, this measure could be hidden.

Which of the following statements regarding the basic features of the Custom Analytical Queries application are correct?

There are three correct answers.

The Custom Analytical Queries application is a tool aimed for key users.

To create structured queries using the Custom Analytical Queries it is necessary to understand the query language.

When you create a new Analytical Query, it is automatically prefixed with ZZ1 or ZZ9.

As the Data Source for which the query will be defined, an Interface View must be used.