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 build a Universe on ERP, you can create a Single source Data Foundation to support local connections but it doesn’t support Joins and calculated columns between tables inserted from an ERP connection?

A - True

B - False

Answer : A

Explanation

You can build a universe on SAP ERP by using Data Foundation in IDT. You have to create a Relational connection to ERP data source, Info sets, SAP Queries, and ABAP functions are treated as tables in the connection.

You can create a Single source Data Foundation to support local connections but it doesn’t support Joins and calculated columns between tables inserted from an ERP connection.

To use calculated column, Joins, you need to create a Data foundation that is multisourceenabled on a secured connection.

Q 3 - Which of the following pane in Data Foundation editor allows you to create Aliases and Contexts, LOV’s and parameters?

A - View Pane

B - Properties Pane

C - Browsing Pane

D - All of the above

Answer : C

Explanation

Using browsing pane, you can work on different elements in data foundation like connections, Data Foundation, Aliases and Contexts, LOV’s and parameters.

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 - 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 - In SAP Dashboard, which of the following is not a format type to export under Export toolbar?

A - PDF

B - MS Word

C - Power Point

D - Text File

Answer : D

Explanation

Export Toolbar

It contains button for exporting your model to different formats.

Different Formats

Q 7 - Which of the following property of a component is used to set the Blank cell, visibility, range limit, etc.?

A - Insertion

B - Behavior

C - Appearance

D - General

Answer : B

Explanation

Behavior

It is used to set behavior of component in the model - limits, Blank cell, visibility, etc.

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