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 option can be used if you want to transform table and column name to user friendly names?

A - Appearance

B - Check Integrity

C - Data Foundation Editor

D - Business Layer Editor

Answer : D

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

C - BICS

D - All of the above

Answer : C

Explanation

BICS client

To connect to SAP NetWeaver BW, you can use SAP BICS client middleware to provide access to BEx query.

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?

A - Context

B - Aggregate Awareness

C - Alias

D - Derived table

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 - To define Query limit options in Business layer, which of the following option you should use?

A - Connection Parameters

B - Query Options

C - Security Profile

D - Properties

E - Custom Properties

Answer : B

Explanation

Query Options

This defines query execution properties - limit number of rows, number of minutes to limit the time passed for query execution, etc.

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 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 - You want to insert huge amount of data in spreadsheet in Dashboard designer. Which of the following option you should use to make it performance optimized and use large dataset?

A - Avoid using Macros

B - Avoid using Excel Function formulas

C - Create Multiple tabs

D - All of the above

Answer : C

Explanation

In case you have large amount of data in spreadsheet, you can create multiple tabs.

sap_idt_questions_answers.htm
Advertisements