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 - Which of the following connection should be used to create a Universe to be published to resource repository?

A - .cns

B - .cnx

C - .dfx

D - .blx

Answer : A

Explanation

.cns - secured Repository connection

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 - In IDT Data Foundation, each row in table 1 matches one or more rows in table 2 and this properties is defined under Join Editor as?

A - Join

B - Cardinality

C - Expression

D - Aliases

Answer : B

Q 4 - In Business Layer under IDT, which of the following state defines an object- not valid and hidden?

A - Active

B - Hidden

C - Deprecated

D - Invalid

Answer : C

Explanation

An Object in Business Layer can have below three states

Active

This is default state of an object and objects are available in query panel.

Hidden

These objects are valid but are hidden in query panel

Deprecated

These objects are not valid and hidden.

Q 5 - In SAP Business Objects, a derived table is present at Universe level, a view is created at data base level. View is preferred over Derived tables to perform calculations?

A - True

B - False

Answer : A

Explanation

In normal scenario, views are preferred to perform the calculation to remain on the database and it does not load the BO server.

Q 6 - In which of the component view, components are arranged in alphabetical order and are not grouped based on the category?

A - Category

B - List

C - View

D - None of these

Answer : B

Explanation

In list view, components are arranged in alphabetical order and they are not grouped based on the category.

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 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 - 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 - 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

sap_idt_questions_answers.htm
Advertisements