SAP IDT Online Quiz


Advertisements

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 - In IDT, you want to see the existing connections and already created Universes and published to be consumed in BO tools. Which of the following component in IDT, you can check this?

A - Local Project

B - Data Foundation

C - Business Layer

D - Repository Resources

Answer : D

Explanation

Repository Resources

Once you connect to Repository, you can retrieve all the objects that are designed and published to that repository.

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?

A - True

B - False

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 - While defining a connection in IDT, which of the following is not an option under connection parameters?

A - Pool time Out

B - Array fetch size

C - Array Bind size

D - Login Timeout

E - Authentication Mode

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 break the loops in Data Foundation when you are not able break loop using an Alias table?

A - Alias Table

B - Derived Table

C - Context

D - Joins

Answer : C

Explanation

Context are also used to break the loops in Data Foundation when you are not able to break loop using an Alias table.

When you have multiple fact tables that are connected to a single dimension table, you create a Context for each fact table in this case.

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 - To use same font for all the components, which of the following font type should be selected under document properties?

A - Global Font

B - Device Font

C - Embedded Font

D - None of these

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?

A - Container Component

B - Tab Set

C - Selector Component

D - Single Value component

E - None

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 text component type allows you to add comments-explanation, help in a Dashboard?

A - Label

B - Input text

C - Map

D - None

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?

A - Data Manager

B - Export Settings

C - Preferences

D - Import Wizard

Answer : A

Q 10 - You want to import data from WebI or a Crystal Report to Dashboard. Which of the following support this feature?

A - Explorer

B - BICS

C - Live Office

D - IDT

Answer : C

sap_idt_questions_answers.htm
Advertisements