- 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 - Which of the following allows you to create a data model as multisource enabled that extracts data from one or more data sources using multiple connections?
Answer : A
Explanation
IDT is multi source enabled means you can extract the data from different data sources while creating a Universe.
Q 2 - To use .unv Universes in IDT, you first need to convert them. Which of the following can be converted in Information Design Tool?
A - Relational Universes created using SAP BusinessObjects 4 UDT tool or Desktop edition
B - Relational Universes designed in SAP BusinessObjects Enterprise XI3 design tool
Answer : C
Explanation
To use .unv Universes in IDT, you first need to convert them. You can convert below unv Universes in Information Design Tool −
Relational Universes created using SAP BusinessObjects 4 UDT tool or Desktop edition.
Relational Universes designed in SAP BusinessObjects Enterprise XI3 design tool.
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 - 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 - In which of the following Data warehousing scenarios, a fan trap normally doesnt occur?
A - DW based on Kimball model with direct join on fact tables
Answer : B
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 - In SAP Dashboards, you can apply same layout, appearance and formatting to data models when you need all models with same look?
Answer : A
Explanation
Using themes, you can apply same layout, appearance and formatting to data models when you need all models with same look. Theme provides you with a color scheme but you can customize it as per requirement.
To apply a theme, go to Format → Theme
Q 9 - Which of the following preview options is/are not available under SAP Dashboard?
Answer : D
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.