SAP IDT Online Quiz


Advertisements

Following quiz provides Multiple Choice Questions (MCQs) related to SAP IDT. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Questions and Answers

Answer : B

Explanation

Universe Design Tool (UDT) Information Design Tool (IDT)
Universe file extension - .unv Universe file extension - .unx
You can’t open .unx file and also it can’t be converted to unv to open in UDT. You can open unv fileby converting unv file to unx file extension.
It is single source enabled. It is multisource enabled.
It can’t be directly connected to Dashboard designer and Crystal Reports latest version. It can be directly connected to Dashboard designer and Crystal Reports latest version.

Q 2 - To design a Universe on SAP BW, you should use a data foundation based on single source enabled structure. All the tables and Joins in SAP BW are automatically imported to Data Foundation?

A - True

B - False

Answer : B

Explanation

If you want to use SAP BW to design a Universe, you should use a data foundation based on multi source enabled structure. All the tables and Joins in SAP BW are automatically imported to Data Foundation. When a Business Layer is created on Data Foundation, all objects are automatically moved to Business Layer.

Q 3 - In IDT Data Foundation, each row in table 1 matches one or more rows in table 2 and this properties is defined under Join Editor as?

A - Join

B - Cardinality

C - Expression

D - Aliases

Answer : B

Q 4 - In Business Layer under IDT, which of the following state defines an object- not valid and hidden?

A - Active

B - Hidden

C - Deprecated

D - Invalid

Answer : C

Explanation

An Object in Business Layer can have below three states

Active

This is default state of an object and objects are available in query panel.

Hidden

These objects are valid but are hidden in query panel

Deprecated

These objects are not valid and hidden.

Q 5 - To define Query limit options in Business layer, which of the following option you should use?

A - Connection Parameters

B - Query Options

C - Security Profile

D - Properties

E - Custom Properties

Answer : B

Explanation

Query Options

This defines query execution properties - limit number of rows, number of minutes to limit the time passed for query execution, etc.

Q 6 - In Dashboard designer, which of the following is a part of component browser?

A - Category

B - List

C - Tree

D - All of the above

Answer : D

Q 7 - Which of the following component feature allows users to pick different options at run time?

A - Container Component

B - Tab Set

C - Selector Component

D - Single Value component

E - None

Answer : C

Explanation

Selector component allows users to pick different options at run time. Selector can be used to configure item’s row, value, position and label into embedded spreadsheet.

Q 8 - Which of the following option allows user to select values from BEX or Universe at run time and user can select a single value to use as filter parameter or can choose selection objects?

A - Query Refresh

B - Query Prompt

C - Filters

D - Single Value Component

E - Selectors

Answer : B

Explanation

Query Prompt Selector

This allows user to select values from BEX or Universe query prompts at run time. As per prompt type, user can select a single value to use as filter parameter or can choose selection objects.

To add a query prompt, you can add it from components list and select a source query prompt or preconfigured query prompt by dragging a query prompt to canvas.

Q 9 - What is the maximum number of rows that you can embed to a spreadsheet to use as component binding?

A - 256

B - 512

C - 1024

Answer : B

Explanation

You can select a maximum range of 512 rows in range. Larger the value slower the performance of data model. To change this value, go to File → Preferences → Excel Options.

Q 10 - Consider Reporting and Dashboard tools, Web Intelligence and Crystal Reports can hold huge data, but Dashboard can’t hold bulk data as at runtime it shows the performance?

A - True

B - False

Answer : A

Explanation

Dashboard holds some buffered data. The advantage of this feature is to avoid unnecessary hits to the server but sloe performance if data size is large

sap_idt_questions_answers.htm
Advertisements