- 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 - Which of the following option can be used if you want to transform table and column name to user friendly names?
Answer : D
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 - 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?
Answer : B
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
Explanation
Derived table is a virtual table in the data foundation that combines other tables using calculations and functions.
Q 5 - To define Query limit options in Business layer, which of the following option you should use?
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 - To use same font for all the components, which of the following font type should be selected under document properties?
Answer : A
Explanation
Different fonts can be set for different components. There is an option to setup the global font if you want to use same font for all the components. This can be used on device fonts or on embedded fonts. When you use machine fonts, exported file is smaller and you can’t rotate text. When embedded fonts are used, you can rotate text and file size is large.
Q 7 - Which of the following property of a component is used to set the Blank cell, visibility, range limit, etc.?
Answer : B
Explanation
Behavior −
It is used to set behavior of component in the model - limits, Blank cell, visibility, etc.
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?
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 - 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 - When you use an alert option with auto color in Dashboard component, which of the following color is used to show a warning or not a desired condition?
Answer : E
Explanation
Alerts are used to bring user attention to specific item that reaches as per pre-established limit. You can set different colors showing level of alerts. In a common scenario, below color represents −
- Green − Represents a desired condition
- Yellow − Represents a warning or not a desired condition
- Red − Represents a critical issue
To Continue Learning Please Login