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.

Questions and Answers

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?




D - Explorer

Answer : A


IDT is multi source enabled means you can extract the data from different data sources while creating a Universe.

Q 2 - To create multilingual Universe in Information Design tool, which of the following option should be used to determine language of metadata in query panel?

A - Business Layer Editor

B - Check Integrity

C - Repository Resources

D - Show Values

E - Preferred Viewing locale

Answer : E


Go to Information Design Tool → Preferences → Data Foundation Editor → Preferred Viewing Locale determines the language of the metadata and data in the Query Panel.

Q 3 - To connect to SAP NetWeaver BW, Which of the following middleware should be used to provide access to BEx query?

A - Relational Connection

B - OLAP connection


D - All of the above

Answer : C


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?

A - Alias Table

B - Derived Table

C - Context

D - All of the above

Answer : B


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 scenario’s, a fan trap normally doesn’t occur?

A - DW based on Kimball model with direct join on fact tables

B - DW based on Inmom model with data marts design

C - Both of these

D - None of these

Answer : B

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?

A - Property

B - Object Browser

C - Component Browser

D - Query Browser

E - All of the above

Answer : E


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 - You want to specify currency symbol to show before the value, which of the following component property should be used?

A - General

B - Behavior

C - Appearance

D - Alerts

Answer : C


Go to Properties → Appearance → Text

Q 8 - Which of the following is not a template category under Files → Templates in Dashboard designer?

A - Government

B - HR

C - Sales

D - Operations

E - Layout

Answer : D

Q 9 - What is the maximum number of rows that you can embed to a spreadsheet to use as component binding?

A - 256

B - 512

C - 1024

Answer : B


You can select a maximum range of 512 rows in range. Larger the value slower the performance of data model. To change this value, go to File → Preferences → Excel Options.

Q 10 - Using ignore excel formula error options, you can make cells that contain invalid excel formulas as empty cells under Excel option?

A - True

B - False

Answer : A