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 - 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 IDT Data Foundation, to create a table with columns from other tables that includes complex calculations and function which of the following feature can be used?

A - Alias Table

B - Derived Table

C - Context

D - All of the above

Answer : B

Explanation

Derived table is a virtual table in the data foundation that combines other tables using calculations and functions.

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 Dashboard designer, which of the following is a part of component browser?

A - Category

B - List

C - Tree

D - All of the above

Answer : D

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 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 - 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
E-Books Store