- SAP IDT Tutorial
- SAP IDT – Home
- SAP IDT – Overview & User Interface
- SAP IDT – Resources
- SAP IDT – Creating Universe
- SAP IDT – .unv Universe Introduction
- Dealing With Published Universes
- SAP IDT – Projects
- SAP IDT – Managing Connections
- Managing Resources In Repository
- SAP IDT – Data Foundation Layer
- SAP IDT – Building Data Foundation
- SAP IDT – Qualifiers & Owners
- SAP IDT – Joins In Data Foundation
- SAP IDT – Business Layer
- SAP IDT – Business Layer Properties
- SAP IDT – Folders In Business Layer
- SAP IDT – Business Layer View
- Building Query In Query Panel
- Dependency Among Resources
- SAP IDT – Publishing
- SAP IDT – Security
- Running Query Published Universe
- SAP IDT – Format Editor Overview
- SAP IDT Useful Resources
- SAP IDT - Questions Answers
- SAP IDT - Quick Guide
- SAP IDT - Useful Resources
- SAP IDT - Discussion
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
Explanation
Repository Resources −
Once you connect to Repository, you can retrieve all the objects that are designed and published to that repository.
Q 2 - To build a Universe on ERP, you can create a Single source Data Foundation to support local connections but it doesn’t support Joins and calculated columns between tables inserted from an ERP connection?
Answer : A
Explanation
You can build a universe on SAP ERP by using Data Foundation in IDT. You have to create a Relational connection to ERP data source, Info sets, SAP Queries, and ABAP functions are treated as tables in the connection.
You can create a Single source Data Foundation to support local connections but it doesn’t support Joins and calculated columns between tables inserted from an ERP connection.
To use calculated column, Joins, you need to create a Data foundation that is multisourceenabled on a secured connection.
Q 3 - To connect to SAP NetWeaver BW, Which of the following middleware should be used to provide access to BEx query?
Answer : C
Explanation
BICS client −
To connect to SAP NetWeaver BW, you can use SAP BICS client middleware to provide access to BEx query.
Q 4 - Which of the following can be used to break the loops in Data Foundation when you are not able break loop using an Alias table?
Answer : C
Explanation
Context are also used to break the loops in Data Foundation when you are not able to break loop using an Alias table.
When you have multiple fact tables that are connected to a single dimension table, you create a Context for each fact table in this case.
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
Explanation
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
Explanation
In list view, components are arranged in alphabetical order and they are not grouped based on the category.
Q 7 - You want to specify currency symbol to show before the value, which of the following component property should be used?
Answer : C
Explanation
Go to Properties → Appearance → Text
Q 8 - Which of the following can be used to add user interactivity and output element is used to display value of cells?
Answer : D
Explanation
Single value components are used for adding interactivity to data models. You can use them to add more attention to important parameters.
Single value components can be used in different styles −
- Horizontal Progress Bar
- Vertical Progress Bar
- Dual Slider
- Dual Slider 2
- Dial and many more
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?
A - You can copy paste data from other excel spreadsheet to embedded spreadsheet.
B - You can import a spreadsheet from excel.
C - You can manually enter data in spreadsheet.
D - You can link query objects from a BEX or Universe query to cells in embedded spreadsheet.
Answer : E
Explanation
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 insert huge amount of data in spreadsheet in Dashboard designer. Which of the following option you should use to make it performance optimized and use large dataset?
Answer : C
Explanation
In case you have large amount of data in spreadsheet, you can create multiple tabs.
To Continue Learning Please Login