- 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 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 - 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 - While defining a connection in IDT, which of the following is not an option under connection parameters?
Answer : E
Explanation
You can define connection parameters like - Time out, Array fetch size, Array Bind size, etc.
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 which of the following Data warehousing scenario’s, a fan trap normally doesn’t occur?
A - DW based on Kimball model with direct join on fact tables
Answer : B
Q 6 - In which of the component view, components are arranged in alphabetical order and are not grouped based on the category?
Answer : B
Explanation
In list view, components are arranged in alphabetical order and they are not grouped based on the category.
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 text component type allows you to add comments-explanation, help in a Dashboard?
Answer : B
Explanation
Label component allows you to add comments - explanation, help, etc.
Q 9 - To configure a query as a Web Service, which of the following option should be used?
Answer : A
Q 10 - Consider Reporting and Dashboard tools, Web Intelligence and Crystal Reports can hold huge data, but Dashboard can’t 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