- 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 connection should be used to create a Universe to be published to resource repository?
Answer : A
Explanation
.cns - secured Repository connection
Q 2 - You want to create a Relational connection in IDT that points to SAP HANA database, which of the following database middleware drivers you should select?
Answer : C
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 - Auto hide feature is used to automatically hide the panels when they are not in use. This function is available for which of the following components?
Answer : E
Explanation
This auto hide feature is used to automatically hide the panels when they are not in used. This function is available for below components −
- Property
- Object Browser
- Component Browser
- Query Browser
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 items row, value, position and label into embedded spreadsheet.
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 - Consider Reporting and Dashboard tools, Web Intelligence and Crystal Reports can hold huge data, but Dashboard cant hold bulk data as at runtime it shows the performance?
Answer : A
Explanation
Dashboard holds some buffered data. The advantage of this feature is to avoid unnecessary hits to the server but sloe performance if data size is large