- 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 - Which of the following pane in Data Foundation editor allows you to create Aliases and Contexts, LOVs and parameters?
Answer : C
Explanation
Using browsing pane, you can work on different elements in data foundation like connections, Data Foundation, Aliases and Contexts, LOVs and parameters.
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 - 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 - Bar and Column charts are used to compare one or more items over specific period of time. Bar and column charts are same and only difference is orientation?
Answer : A
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 - Using ignore excel formula error options, you can make cells that contain invalid excel formulas as empty cells under Excel option?