Data Flow in Data Acquisition

Question 1 of 43

1

Regarding transformation between a source and a target. Which of the following objects serve as source?

Select one or more of the following:

DataSource
InfoSource
DataStore Object
InfoCube
InfoObject
InfoSet
SorceSystem
OpenHub

Explanation

Question 2 of 43

1

Regarding transformation between a source and a target. Which of the following objects serve as target?

Select one or more of the following:

DataSource
InfoSource
DataStore Object
InfoCube
InfoObject
InfoSet

Explanation

Question 3 of 43

1

InfoSources should be used in whicj pof the following scenarios?

Select one or more of the following:

If you want to execute two transformations before data is written to the Infoprovider
If you want to execute two transformations after data is written to the Infoprovider
If you want to update data from more tha one DataSource from one or more sourcesystem
If you want to update data from at leeast one DataSource from one or more sourcesystem
If you want to execute at least one transformation beforer data is written to the Infoprovider

Explanation

Question 4 of 43

1

Which of the following statements are true regarding the transfer routines?

Select one or more of the following:

Local Transfer routines applies locally (source system specific) for the InfoObject
Local and Global Transfer routines apply locally (source system specific) for the InfoObject
A Global Transfer Routine apply across all source system for the characteristic InfoObject and it is inlcuded in one specific transfer rule
A Global Transfer Routine apply across all source system for the characteristic InfoObject and it is inlcuded in all the transfer rules

Explanation

Question 5 of 43

1

Which of the following statements are true regarding transfer rules?

Select one or more of the following:

A local transfer routine applies for one source specific system for the InfoObject but you can included it in all transfer rules
A local transfer routine applies for one source specific system for the InfoObject and included only in the specific transfer rules.
A global transfer routine applies for all source system for the InfoObject and you can included it in all transfer rules
A global transfer routine applies for all source system for the InfoObject and you can included it only in the specific transfer rules.

Explanation

Question 6 of 43

1

Select from the dropdown list to complete the text.

The use of ( global transfer routines, local transfer routines ) is useful if a characteristic InfoObject
is always transformed with the same ABAP routine, as is the case
with key harmonization or conversion checks,

Explanation

Question 7 of 43

1

If you have created a local and a global transfer routine:

Select one or more of the following:

Both are used: First the local and then the global transfer routine.
Both are used: First the global and then the local transfer routine.
Only the local is used
Only the global is used

Explanation

Question 8 of 43

1

Regarding the "start routine", which statements are true?

Select one or more of the following:

if you load the data using the PSA table you have the option of creating a start routine in the maintenance screen for the transfer rules.
if you load the data using I Doc you have the option of creating a start routine in the maintenance screen for the transfer rules.
It is not possible to use start routines for transfer rules for the 'IDoc' transfer method
It is possible to use start routines for transfer rules for both, IDoc and PSA transfer methods

Explanation

Question 9 of 43

1

Which statements are true regarding start routines?

Select one or more of the following:

It is run for each data package after the data is written to the PSA table and before the transfer rules are executed
It is run for all data package after the data is written to the PSA table and after the transfer rules are executed
It is run for all data package before the data is written to the PSA table and before the transfer rules are executed
It is run for all data package before the data is written to the PSA table and after the transfer rules are executed

Explanation

Question 10 of 43

1

Wich statements are true regarding start routines?

Select one or more of the following:

With the start routine you can change (for example, add ordelete data) or check data packages
With the start routine you can not change (for example, add ordelete data) but you can check data packages

Explanation

Question 11 of 43

1

When defining transfer rules you can choose between which transfer methods?
methods

Select one or more of the following:

PSA
IDoc
Ale
Bapi
All are correct

Explanation

Question 12 of 43

1

The transfer method only determines how the data is transferred

Select one of the following:

True
False

Explanation

Question 13 of 43

1

Select from the dropdown lists to complete the text.

( PSA, Idoc ) has a Maximun data record lenght of 1962 bytes and the number of fields per data record is restricted to ( 255, 300, 500 ). However ( IDoc, PSA ) has a maximun data record lenght of 1000 bytes.

Explanation

Question 14 of 43

1

At which transfer methods is referred the next asset:

"It uses tRFC as transfer log and the data loading process triggered by a request IDoc (= special Info IDoc)"

Select one or more of the following:

IDoc
PSA
Ale
Bapi

Explanation

Question 15 of 43

1

At which of the following transfer methods is referred the following statement?

"Uses of data IDoc"

Select one or more of the following:

PSA
IDOC

Explanation

Question 16 of 43

1

What are adventages of PSA transfer method?

Select one or more of the following:

Improved data load performance as larger data packages can be transferred
Hierarchy upload
Optional PSA tables can be used as inbound storage locations as this allows Error handling in BI to be used
Delete logs created by control record and status record in data IDoc

Explanation

Question 17 of 43

1

What are adventages of IDoc transfer method?

Select one or more of the following:

Improved data load performance as larger data packages can be transferred
Hierarchy upload
Optional PSA tables can be used as inbound storage locations as this allows Error handling in BI to be used
Delete logs created by control record and status record in data IDoc

Explanation

Question 18 of 43

1

Select from the dropdown lists to complete the text.

( PSA, IDoC ) has the disaventage that it has restricted used of hierarchy upload and ( IDoc, PSA ) that is no error handling in BI

Explanation

Question 19 of 43

1

which of the following assestments are true regarding PSA and IDoc?

Select one or more of the following:

With the IDoc transfer method you have to make sure that the data
stores in the ALE inbound and outbound processing is emptied or
reorganized.
With the PSA transfer method you have to make sure that you
manage both the PSA tables (providing these are used), and the
data stores in the ALE inbound and outbound processing for the
Info IDocs.
With
the exception of 'hierarchy' type BI Content DataSources, all the others (including
generic DataSources such as 'hierarchy' type flat file DataSources) support the
PSA transfer method.
The key for a PSA table is made up
of a request, data package and data record number.

Explanation

Question 20 of 43

1

You create update rules in the context menu for the respective InfoProvider in the Data
Warehousing Workbench. Which kind of Infoproviders can be used as data target here?

Select one or more of the following:

Open Hub
Infoset
All InfoObject
InfoObject (Text and Attributes)
All DSO
All Infocubes
Standard DSO
Standard Infocubes

Explanation

Question 21 of 43

1

Which of the following statements are Update Methods?

Select one or more of the following:

Source InfoObject
Splitting Key Figures/ data Fields/ Attributes Texts
Constant
Formula
Reading Master Data Attributes
Initial Value
ABAP Routine

Explanation

Question 22 of 43

1

Which of the following statements are true regarding upadte Method?

Select one or more of the following:

Assigning a constant allows you to fill an InfoObject in the data target
with a fixed value.
Assigning a initial value allows you to fill an InfoObject in the data target
with a fixed value.
If the initial value is selected as the Data Sources, the characteristic
InfoObject (Standard InfoCube) or the key field (DataStore
object/characteristic InfoObject) is updated with the initial value of the
respective Data Sources. This does not mean that a value is omitted in
the update, but that the values 'SPACE' (with alphanumeric field types)
or '0' (with numeric field types) are updated.
If the initial value is selected as the Data Sources, the characteristic
InfoObject (Standard InfoCube) or the key field (DataStore
object/characteristic InfoObject) is updated with the initial value of the
respective Data Sources. This does mean that a value is omitted in
the update.

Explanation

Question 23 of 43

1

A characteristic InfoObject/data field/attribute in the data target is
updated by reading data in the master data table of a characteristic
InfoObject that is part of the InfoSource and has the characteristic InfoObject/data field/attribute as an attribute. If this relationship does not exist, master data can only be read with the help of an ABAP routine.

Select one of the following:

True
False

Explanation

Question 24 of 43

1

Select from the dropdown list to complete the text.

Regarding "Migration to SAP NetWeaver 2004s BI Data Transformation Process":
You have the option to export the 3.x objects, DataSource 3.x, mapping and
transfer structure during the migration so that these objects can be restored. The
collected and serialized objects are stored in a local table (( RSDSEXPORT, LISTCUBE, STARCHEMA, RSRDMEX, RSDSTRANSPORT )). The
migration is now eligible to be transported into the target system

Explanation

Question 25 of 43

1

Select from the dropdown list to complete the text.

You have the option to implement self-defined functions in the transformation library of the formula builder. You can integrate existing function modules in these self-defined functions. The Business Add-In ( RSAR_CONNECTOR, RSDS_CONNECTOR, RMXX_CONNECTOR ) is available for this.

Explanation

Question 26 of 43

1

Which of the following statements are true regarding transformations?

Select one or more of the following:

Do not use formulas for VirtualProviders because inversion is not allowed for them. Use routines in this case.
You can use Formulas for VirtualProviders too since inversion si allowed for them.
Do not use formulas neider routines for VirtualProviders because inversion is not allowed for them.
You can use Formulas for VirtualProviders too since inversion si allowed for them, but not routines in this case

Explanation

Question 27 of 43

1

Regarding transformation of "Reading Master data", which of the following statements are true?

Select one or more of the following:

It is possible to read recursively, that is, to read additional attributes for the attribute of the main characteristic
It is not possible to read recursively, that is, to read additional attributes for the attribute of the main characteristic. You have to use routines for this.

Explanation

Question 28 of 43

1

Which of the following statments are true regarding "Reading master data" in transformation?

Select one or more of the following:

If you have changed master data, you have to execute the change run. By reading the master data, the active version is read. If this is not avalaible, an error is raised.
If an attribute is time dependent, you also have to define when it should be read: at the current (system date), at the beginning or end of a period (defined by a time characteristic of the InfoSource), or at a constant date that you enter dirtectly. System date is used as the default
If an attribute is time dependent, you also have to define when it should be read: at the current (system date), at the beginning or end of a period (defined by a time characteristic of the InfoSource), or at a constant date that you enter dirtectly. End of a period date is used as the default
If an attribute is time dependent, you also have to define when it should be read: at the current (system date), at the beginning or end of a period (defined by a time characteristic of the InfoSource), or at a constant date that you enter dirtectly. A constant date is used as the default

Explanation

Question 29 of 43

1

Which of the following statements are true regarding "routines"?

Select one or more of the following:

Transformation rules generally only have one returns value, but If you select "Return Table", you can then generate any number of values from data records
Transformation rules only have one returns value.
For DSO and IO you cannot use the return code in the routine for data fields that are updated by being overwriitten. If you don't want to update specific records, you can delete these form the start routine.
For DSO and IO you cannot use the return code in the routine for data fields that are updated by being "Adittiion". If you don't want to update specific records, you can delete these form the start routine.

Explanation

Question 30 of 43

1

When performing a time update, automatic time conversion and time
distribution are available in transformation process. Which of the following statements are true?

Select one or more of the following:

Time Conversion is not available for DataStore objects, since time characteristics are treated
as normal data fields. The system only presents you with the time characteristics for which an automatic time conversion routine exists.
Time Conversion is not available for InfCubes, since time characteristics are treated
as normal data fields. The system only presents you with the time characteristics for which an automatic time conversion routine exists.
Time Conversion is not available for InfoObject, since time characteristics are treated
as normal data fields. The system only presents you with the time characteristics for which an automatic time conversion routine exists.

Explanation

Question 31 of 43

1

Which of the following statements are true regarding "Start Rutine"?

Select one or more of the following:

The start routine does not have a return value.
It is used to perform preliminary calculations and store these in a global data structure or in a
table
The start routine does not have a table or structure value.
It is used to perform preliminary calculations and store these in a return value

Explanation

Question 32 of 43

1

Which of the following statements are true regarding "Start Rutine"?

Select one or more of the following:

It is used to prepare data before transformation
It is used to prepare data after transformation
package -based, semantic packaging possible
package -based, semantic packaging not possible

Explanation

Question 33 of 43

1

Which routine is necessary if you want " delete records that are not required for updating before transformation?

Select one or more of the following:

Start Routine
End Routine
Expert Routine
start and End Routine

Explanation

Question 34 of 43

1

Which routine is necessary if you want " delete records that are not required for updating after transformation?

Select one or more of the following:

Start Routine
End Routine
Expert Routine
Start and End Routine

Explanation

Question 35 of 43

1

Which routine is the appropiate to use buffering tables into internal tables that can be used for the transformation rules (rather than reading the database tables one by one) for performance reasons.

Select one or more of the following:

Start Routine
End Routine
Expert Routine
Global Routine

Explanation

Question 36 of 43

1

Select from the dropdown list to complete the text.

An ( end routine, start routine, expert routine ) is a routine with a table in the target structure format as an input parameter and an output parameter.

Explanation

Question 37 of 43

1

Which routine type is necessary if you want to delete a particular type of material "refund" after transformation?

Select one or more of the following:

Start Routine
End Routine
Expert Routine

Explanation

Question 38 of 43

1

Which type of routine is necessary to validate records after transformation like "Sales value > Purchase Values"?

Select one or more of the following:

Start Routine
End Routine
Expert Routine

Explanation

Question 39 of 43

1

Select from the dropdown list to complete the text.

You can use the ( expert routine, start routine, end routine ) if there are not sufficient functions to perform a
transformation. You can use it as an interim solution until the
necessary functions are available in the standard routine. You can use this to
program the transformation yourself without using the available rule types. You
must implement the message transfer to the monitor yourself.

Explanation

Question 40 of 43

1

Which type of routine is necessary when we need to use for "transformations that cannot be expressed declaratively for functional or performance reasons"

Select one or more of the following:

expert routine
start routine
end routine

Explanation

Question 41 of 43

1

Which type of routine you need to use when, for performance reason, reading several database tables can be implemented faster when knowing the application logic (rather than using the generic transformation framework )

Select one or more of the following:

Start Routine
End Routine
Expert Routine

Explanation

Question 42 of 43

1

If you traspose a wide data records into several smaller records (Pivoting), which routine do you need to implement?

Select one or more of the following:

Start Routine
End Routine
Expert Routine

Explanation

Question 43 of 43

1

Which of the following statements are true regarding routines?

Select one or more of the following:

If you have already created transformation rules, the system deletes them once you have created an expert routine.
If you have already created transformation rules, the system deletes them once you have created a start routine
If you have already created transformation rules, the system deletes them once you have created an end routine.

	Created by David Marcuno Placeres about 9 years ago

Quiz on Data Flow in Data Acquisition, created by David Marcuno Placeres on 19/11/2015.

Data Flow in Data Acquisition

Question 1 of 43

Regarding transformation between a source and a target. Which of the following objects serve as source?

Select one or more of the following:

Explanation

Question 2 of 43

Regarding transformation between a source and a target. Which of the following objects serve as target?

Select one or more of the following:

Explanation

Question 3 of 43

InfoSources should be used in whicj pof the following scenarios?

Select one or more of the following:

Explanation

Question 4 of 43

Which of the following statements are true regarding the transfer routines?

Select one or more of the following:

Explanation

Question 5 of 43

Which of the following statements are true regarding transfer rules?

Select one or more of the following:

Explanation

Question 6 of 43

Select from the dropdown list to complete the text.

The use of global transfer routines local transfer routines( global transfer routines, local transfer routines ) is useful if a characteristic InfoObject is always transformed with the same ABAP routine, as is the case with key harmonization or conversion checks,

Explanation

Question 7 of 43

If you have created a local and a global transfer routine:

Select one or more of the following:

Explanation

Question 8 of 43

Regarding the "start routine", which statements are true?

Select one or more of the following:

Explanation

Question 9 of 43

Which statements are true regarding start routines?

Select one or more of the following:

Explanation

Question 10 of 43

Wich statements are true regarding start routines?

Select one or more of the following:

Explanation

Question 11 of 43

When defining transfer rules you can choose between which transfer methods? methods

Select one or more of the following:

Explanation

Question 12 of 43

The transfer method only determines how the data is transferred

Select one of the following:

Explanation

Question 13 of 43

Select from the dropdown lists to complete the text.

PSA Idoc( PSA, Idoc ) has a Maximun data record lenght of 1962 bytes and the number of fields per data record is restricted to 255 300 500( 255, 300, 500 ). However IDoc PSA( IDoc, PSA ) has a maximun data record lenght of 1000 bytes.

Explanation

Question 14 of 43

At which transfer methods is referred the next asset: "It uses tRFC as transfer log and the data loading process triggered by a request IDoc (= special Info IDoc)"

Select one or more of the following:

Explanation

Question 15 of 43

At which of the following transfer methods is referred the following statement? "Uses of data IDoc"

Select one or more of the following:

Explanation

Question 16 of 43

What are adventages of PSA transfer method?

Select one or more of the following:

Explanation

Question 17 of 43

What are adventages of IDoc transfer method?

Select one or more of the following:

Explanation

Question 18 of 43

Select from the dropdown lists to complete the text.

PSA IDoC( PSA, IDoC ) has the disaventage that it has restricted used of hierarchy upload and IDoc PSA( IDoc, PSA ) that is no error handling in BI

Explanation

Question 19 of 43

which of the following assestments are true regarding PSA and IDoc?

Select one or more of the following:

Explanation

Question 20 of 43

You create update rules in the context menu for the respective InfoProvider in the Data Warehousing Workbench. Which kind of Infoproviders can be used as data target here?

The use of ( global transfer routines, local transfer routines ) is useful if a characteristic InfoObject
is always transformed with the same ABAP routine, as is the case
with key harmonization or conversion checks,

When defining transfer rules you can choose between which transfer methods?
methods

( PSA, Idoc ) has a Maximun data record lenght of 1962 bytes and the number of fields per data record is restricted to ( 255, 300, 500 ). However ( IDoc, PSA ) has a maximun data record lenght of 1000 bytes.

At which transfer methods is referred the next asset:

"It uses tRFC as transfer log and the data loading process triggered by a request IDoc (= special Info IDoc)"

At which of the following transfer methods is referred the following statement?

"Uses of data IDoc"

( PSA, IDoC ) has the disaventage that it has restricted used of hierarchy upload and ( IDoc, PSA ) that is no error handling in BI

You create update rules in the context menu for the respective InfoProvider in the Data
Warehousing Workbench. Which kind of Infoproviders can be used as data target here?

When performing a time update, automatic time conversion and time
distribution are available in transformation process. Which of the following statements are true?

An ( end routine, start routine, expert routine ) is a routine with a table in the target structure format as an input parameter and an output parameter.