SAP IDT Online Quiz
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 - In IDT, you want to see the existing connections and already created Universes and published to be consumed in BO tools. Which of the following component in IDT, you can check this?
Answer : D
Repository Resources −
Once you connect to Repository, you can retrieve all the objects that are designed and published to that repository.
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?
Answer : B
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 - When you perform project synchronization, synchronization status- A resource was changed in shared project but not in local project represents?
Answer : C
Different Synchronization status −
- Added Locally − A resource is added in local project but not in shared project.
- Changed Locally − A resource was changed in local project but not in shared project.
- Deleted Locally −A resource was deleted in local project but still exists in shared project.
- Added on server − A resource is not in local project but exists in shared project.
- Changed on server − A resource was changed in shared project but not in local project.
- Deleted on server − A resource exists in local project but was deleted in shared project.
- Synchronize − Both resources are identical.
Q 4 - In IDT Data Foundation, to create a table with columns from other tables that includes complex calculations and function which of the following feature can be used?
Answer : B
Derived table is a virtual table in the data foundation that combines other tables using calculations and functions.
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?
Answer : A
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?
Answer : B
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?
Answer : C
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 text component type allows you to add comments-explanation, help in a Dashboard?
Answer : B
Label component allows you to add comments - explanation, help, etc.
Q 9 - In your data model, you can link your components to cells in the spreadsheet. Which of the following is incorrect about inserting data in spreadsheet in Dashboard?
Answer : E
In your data model, you can link your components to cells in the spreadsheet. It support many features that are supported by Excel files however few of functions like Macros, conditional formatting and function formulas, etc. are not supported.
You can insert data in spreadsheets using different ways −
You can copy paste data from other excel spreadsheet to embedded spreadsheet.
You can import a spreadsheet from excel.
You can manually enter data in spreadsheet.
You can link query objects from a BEX or Universe query to cells in embedded spreadsheet.
Q 10 - You want to import data from WebI or a Crystal Report to Dashboard. Which of the following support this feature?