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

A - SAP ERP 6

B - MaxDB 7.7

C - SAP HANA database 1.0

D - mySAP ERP 2004

Answer : C

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 - Which of the following feature can be used to facilitate custom drill down between objects from same or different classes according to user requirement?

A - Custom Hierarchies

B - Linked Universe

C - List of Values

D - Aggregate Awareness

Answer : A

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

Explanation

Go to Properties → Appearance → Text

Q 8 - Which of the following option allows user to select values from BEX or Universe at run time and user can select a single value to use as filter parameter or can choose selection objects?

A - Query Refresh

B - Query Prompt

C - Filters

D - Single Value Component

E - Selectors

Answer : B

Explanation

Query Prompt Selector

This allows user to select values from BEX or Universe query prompts at run time. As per prompt type, user can select a single value to use as filter parameter or can choose selection objects.

To add a query prompt, you can add it from components list and select a source query prompt or preconfigured query prompt by dragging a query prompt to canvas.

Q 9 - You can export models in Dashboard designer in different formats. When you complete the configuration of data model, it can be exported to flash file (SWF)?

A - True

B - False

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