- 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 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 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
Explanation
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?
Answer : B
Q 4 - Which of the following allows you to add the objects in the query and to preview the results to be used in BO tool?
Answer : C
Explanation
You can use query panel to create or preview queries on a Business Layer or on the top of Universe published in repository.
Q 5 - In IDT Security editor, which of the following security profile-security policy is applied on Data Foundation objects and connections?
Answer : B
Explanation
You can define two types of security profiles in IDT −
Data Security Profile −
In data security profile, security policy is applied on Data Foundation objects and connections.
Business Security Profile −
This include objects in Business layer on which security profile is applied.
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 cant rotate text. When embedded fonts are used, you can rotate text and file size is large.
Q 7 - To set the notifications for data values, values are acceptable or require attention for a Dashboard component, which of the following component property has to be set?
Answer : D
Explanation
Alerts are used to set notifications for data values, if values are acceptable or require attention. To enable alerts, click the check box.
You can set Alert Thresholds, enable auto color, etc.
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 - What is the maximum number of rows that you can embed to a spreadsheet to use as component binding?
Answer : B
Explanation
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 - 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.