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 - In IDT, you want to see the existing connections and already created Universes and published to be consumed in BO tools. Which of the following component in IDT, you can check this?

A - Local Project

B - Data Foundation

C - Business Layer

D - Repository Resources

Answer : D

Explanation

Repository Resources

Once you connect to Repository, you can retrieve all the objects that are designed and published to that repository.

Q 2 - To use .unv Universes in IDT, you first need to convert them. Which of the following can be converted in Information Design Tool?

A - Relational Universes created using SAP BusinessObjects 4 UDT tool or Desktop edition

B - Relational Universes designed in SAP BusinessObjects Enterprise XI3 design tool

C - Both of the above

D - None

Answer : C

Explanation

To use .unv Universes in IDT, you first need to convert them. You can convert below unv Universes in Information Design Tool −

Relational Universes created using SAP BusinessObjects 4 UDT tool or Desktop edition.

Relational Universes designed in SAP BusinessObjects Enterprise XI3 design tool.

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 break the loops in Data Foundation when you are not able break loop using an Alias table?

A - Alias Table

B - Derived Table

C - Context

D - Joins

Answer : C

Explanation

Context are also used to break the loops in Data Foundation when you are not able to break loop using an Alias table.

When you have multiple fact tables that are connected to a single dimension table, you create a Context for each fact table in this case.

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 - To set the notifications for data values, values are acceptable or require attention for a Dashboard component, which of the following component property has to be set?

A - General

B - Behavior

C - Appearance

D - Alerts

Answer : D

Explanation

Alerts are used to set notifications for data values, if values are acceptable or require attention. To enable alerts, click the check box.

You can set Alert Thresholds, enable auto color, etc.

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

Answer : E

Explanation

In your data model, you can link your components to cells in the spreadsheet. It support many features that are supported by Excel files however few of functions like Macros, conditional formatting and function formulas, etc. are not supported.

You can insert data in spreadsheets using different ways

  • You can copy paste data from other excel spreadsheet to embedded spreadsheet.

  • You can import a spreadsheet from excel.

  • You can manually enter data in spreadsheet.

  • You can link query objects from a BEX or Universe query to cells in embedded spreadsheet.

Q 10 - Consider Reporting and Dashboard tools, Web Intelligence and Crystal Reports can hold huge data, but Dashboard can’t hold bulk data as at runtime it shows the performance?

A - True

B - False

Answer : A

Explanation

Dashboard holds some buffered data. The advantage of this feature is to avoid unnecessary hits to the server but sloe performance if data size is large

sap_idt_questions_answers.htm
Advertisements