- 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
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 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 - 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 improve the query performance and query generator retrieves the data from table with highest aggregation level?
Answer : B
Explanation
Using aggregate awareness, you can use pre-aggregated data in tables in the database. It is used to improve query performance by processing less number of rows.
When you add an aggregate aware object in query, query generator retrieves the data from table with highest aggregation level.
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 component feature allows users to pick different options at run time?
Answer : C
Explanation
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 is not a template category under Files → Templates in Dashboard designer?
Answer : D
Q 9 - To configure a query as a Web Service, which of the following option should be used?
Answer : A
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.