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 connection should be used to create a Universe to be published to resource repository?
.cns - secured Repository connection
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 - In SAP Business Objects, a derived table is present at Universe level, a view is created at data base level. View is preferred over Derived tables to perform calculations?
In normal scenario, views are preferred to perform the calculation to remain on the database and it does not load the BO server.
Q 6 - In which of the component view, components are arranged in alphabetical order and are not grouped based on the category?
In list view, components are arranged in alphabetical order and they are not grouped based on the category.
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 is not a template category under Files → Templates in Dashboard designer?
Q 9 - To configure a query as a Web Service, which of the following option should be used?
Q 10 - Using ignore excel formula error options, you can make cells that contain invalid excel formulas as empty cells under Excel option?