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.
Q 1 - Which of the following option can be used if you want to transform table and column name to user friendly names?
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?
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 - 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?
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?
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 - In IDT Security editor, which of the following security profile-security policy is applied on Data Foundation objects and connections?
You can define two types of security profiles in IDT −
Data Security Profile −
In data security profile, security policy is applied on Data Foundation objects and connections.
Business Security Profile −
This include objects in Business layer on which security profile is applied.
Q 6 - In SAP Dashboard, which of the following is not a format type to export under Export toolbar?
Export Toolbar −
It contains button for exporting your model to different formats.
Q 7 - Bar and Column charts are used to compare one or more items over specific period of time. Bar and column charts are same and only difference is orientation?
Q 8 - Which of the following is not a template category under Files → Templates in Dashboard designer?
Q 9 - Which of the following preview options is/are not available under SAP Dashboard?
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?
In case you have large amount of data in spreadsheet, you can create multiple tabs.