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.
Q 1 - Which of the following statement is incorrect about Information Design Tool and UDT?
B - To open unv file in IDT, it can be directly opened but you can convert unv file to unx file to open in Information Design tool & You can open an IDT .unx file in Universe Design tool nor you can convert it to unv file.
|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?
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?
Q 4 - In Business Layer under IDT, which of the following state defines an object- not valid and hidden?
An Object in Business Layer can have below three states −
This is default state of an object and objects are available in query panel.
These objects are valid but are hidden in query panel
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?
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?
Q 7 - Which of the following component feature allows users to pick different options at run time?
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?
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?
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?
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