BW350 - SAP BW Data Acquisition Flashcards

1
Q

~In a BW/4HANA system, the only source systems are operational data provisioning (ODP), web services and the SAP HANA source
system.~

  • True
  • False
A

(+)True
-False

~In the new BW/4HANA product, the only source systems are ODP. web services and SAP HANA Read more in the
lesson, Explaining the strategy tor SAP BW Powered by SAP HANA, in the course BW35OH~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

~A mixed architecture concept is where the overall data model is implemented in SAP BW and native SAP HANA tools at the same
time.~

  • True
  • False
A

(+)True
-False

~A mixed architecture provides the option of modeling in both BW and SAP HANA at the same time
Read more In the lesson. Explaining the Strategy for SAP BW Powered by SAP HANA, in the course BW350H~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

~Which of the following BW application areas have been redesigned with code push down in SAP HANA?~

  • Analytic manager
  • Data modeling
  • Planning
  • Data management
  • Predictive
A

(+)Analytic manager
-Data modeling
(+)Planning
(+)Data management
(+)Predictive

~All of the application areas listed have been redesigned using code push down to SAP HANA except for data modeling
Data modeling is performed in either SAP BW or SAP HANA without the need to employ code push down Read more
in the lesson Descnbing the New SAP BW Features that Affect Data Acquisition, in the course BW350H~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

~SAP Landscape Transformation Replication Server (SLT) uses a trigger-based replication concept which retrieves data from
application tables of the source system(s) to pass to the target system.~

  • True
  • False
A

(+)True
-False

~SLT stores new and changed data records In tables until the target system needs them Read more in the lesson.
Explaining Data Provisioning into SAP HANA, in the course BW350H~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

~SAP HANA Smart Data Integration (SDI) represents a set of functions that you can use to retrieve data from external systems, transform it. and persist it in SAP SLT database tables.~

  • True
  • False
A

-True
(+)False

~SDI is a set of functions that are used to store data in SAP HANA database tables, not into SLT tables
Read more in the lesson. Using Data Provisioning into SAP HANA via Smart Data Integration (SDI). in the course
BW350H~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

~Using the SAP HANA Studio Data File Import Wizard, you can combine source fields into a table column or split fields into two
table columns.~

  • True
  • False
A

-True
(+)False

~Using the Import Wizard, there is only a 1:1 mapping and fields cannot be combined or split Read more in the lesson,
Explaining Data Provisioning into SAP HANA via Flat Files, in the course BW350H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

~The two main areas of SAP HANA Enterprise Information Management (EIM) are Smart Data Integration (SDI) and SAP Landscape
Transformation (SLT).~

  • True
  • False
A

-True
(+)False

~EIM composes SDI and Smart Data Quality (SDQ) EIM does not Include SLT .Read more in the lesson, Explaining Enterprise Information Management (EIM) and Integration into SAP BW. in the course, BW350H~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

~Using the concept of data federation, the data is not physically moved from the source system but is presented in a unified view
with any updates to the data are effected on the source system without changing the target system.~

  • True
  • False
A

(+)True
-False

~You are correct! In data federation, the data is read from the remote source system using Smart Data Access (SDA)
Read more in the lesson, Explaining Enterprise Information Management (EIM) and Integration into SAP BW. in the
course, BW350H~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

~Which of the following DataSource types can be set up using the SAP BW modeling tools?~

  • Master data attributes
  • Hierarchies
  • Transactional data
  • Master data texts
  • Time dependent calculation views
A

(+)Master data attnbutes
(+)Hierarchies
(+)Transactional data
(+)Master data texts
-Time dependent calculation views

~Datasources can be defined for transaction data and or master data attributes, texts and hierarchies
There Is no such thing as a time dependent calculation view created as a Datasource in BW Read more in the lesson,
Setting Up the Streaming Data Flow with SDI. in the course. BW350H~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

~A process chain can be set to streaming by making settings for it in the Attributes menu.~

  • True
  • False
A

(+)True
-False

~Process chains can be streaming by making settings for the error threshold and the number of logs kept Read more in
the lesson. Maintaining the Streaming Process Chain, in the course. BW350H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

~When streaming data with the insert subscription, the delta process is set to ADD because the view for full extraction i needed.

  • True
  • False
A

-True
(+)False

~Streaming data with insert set the ABR delta process because full extraction is not being performed. ABR provides a before and after images of new or changed records. Read more in the lesson, Streaming with Data Insert, in the course, BW350H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

~Which of the following are subscribers of consumers in the Operational Data Provisioning (ODP) infrastructure~

  • SAP BW
  • SAP DataServices
  • SAP Extractors
  • OData
  • SAP NetWeaver Embedded Analytics
A

(+)SAP BW
(+)SAP DataServices
-SAP Extractors
(+)OData
(+)SAP NetWeaver Embedded Analytics

~All the listed products are consumers of ODP except for SAP Extractors. SAP Extractors are not subscribers; they are an ODP source provider. Read more in the lesson, Describing Data Acquisition with Operational Data Provisioning (ODP), in the course, BW350H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

~The client in an SAP component is always connected as a source system in SAP BW.~

  • True
  • False
A

(+)True
-False

~A connection to an SAP Source system is always to a client. Read more in the lession, Explainig Source Systems, in the course, BW350H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

~Which of the following options are available when creating a BW source system?~

  • SAP BW
  • SAP Source Systems
  • Universal Data Connector (UDC)
  • Web Services
  • SAP NetWeaver Embedded Analytics
A

(+)SAP BW
(+)SAP Source Systems
(+)Universal Data Connector (UDC)
(+)Web Services
-SAP NetWeaver Embedded Analytics

~You are correctl All the listed systems are BW source systems except for Embedded Analytics Embedded Analytics are
a consumer of BW data, they are not a data source Read more in the lesson. Explaining Source Systems. In the
course. BW350H~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

~The services provided by the Persistent Staging Area (PSA) are mostly replaced with the Operational Delta Queue (ODQ), therefore PSA data loads are not recommended in most cases.~

  • True
  • False
A

(+)True
-False

~Largely the ODQ replaces the PSA. except for the web services Datasource which still uses PSA Read more in the
lesson. Explaining Source Systems, in the course. BW350H Read more in the lesson, Explaining Source Systems, in
the course. BW350H~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

~Data Transfer Processes (DTPs) are used to transfer data between SAP BW systems from one persistent object to another object
in accordance with certain transformations and filters.~

  • True
  • False
A

-True
(+)False

~DTPs are used to transfer data WITHIN BW systems; not between different BW systems. Read more in the lesson.
Explaining the OOP Data Transfer Processes (DTPs). In the course. BW350H~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

~The Operational Delta Queue (ODQ) is a data store in the source system where records are either written automatically to the delta
queue using an update process in the source system or retrieved using the extractor interface.~

  • True
  • False
A

(+)True
-False

~You are correct! The ODQ Is a source system based delta mechanism fed automatically from certain ERP applications or updated following an extraction process for other ERP modules Read more In the lesson, Analyzing the Operational
Delta Queue (ODQ) for ODP - SAP. in the course. BW350H~
18
Q

~Which of the following are sources of data when using Generic Data Extraction to create a DataSource?~

  • Extraction from an Operational Delta Queue
  • Extraction from a database view
  • Extraction from a SAP Query
  • Extraction from an SAP HANA calculation view
  • Extraction using a function module
A

-Extraction from an Operational Delta Queue
(+)Extraction from a database view
(+)Extraction from a SAP Query
-Extraction from an SAP HANA calculation view
(+)Extraction using a function module

~Generic Datasources can use data provided from database views, SAP queries and Function Modules. ODQ is not supported for generic Datasources. Calculation Views are not a source for genenc Datasources. Read more in the lesson. Modeling ODP Genenc Datasources on Views, Function Modules, and ABAP Quenes. In the course. BW350H~

19
Q

~The SAP Landscape Transformation (SLT) Replication Server provides the Operational Data Provisioning (ODP) infrastructure with
SAP system source tables as delta queues.~

  • True
  • False
A

(+)True
-False

~The SLT tool can be used with both SAP and non-SAP source systems Read more In the lesson.
Replicating Data with SAP Landscape Transformation (ODP-SLT), in the course. BW350H~

20
Q

~Once the streaming process chain is designed, real time data flows directly into BW each time the process chain is run.~

  • True
  • False
A

-True
(+)False

~For real time streaming, once the process chain is executed, data flows directly Into the data targets automatically
Read more in the lesson. Streaming Data in Real Time with ODP-SLT, in the course. BW350H~

21
Q

~SAP Landscape Transformation (SLT) pushes data to the operational data provisioning (ODQ) and the RDA enabled data transfer
process (DTP) then loads the Classic DataStore object (DSO).~

  • True
  • False
A

(+)True
-False

~This is the process for using RDA-enabled Datasources. Read more in the lesson. Acquiring Data In Real Time with
ODP - SLT and Real Time Data Acquisition (RDA), In the course. BW350H~

22
Q

~You can use ODP to connect the SAP HANA database of your SAP BW on HANA system and Analytical Views, Calculation Views
and associated Attribute Views are provided for loading into SAP BW this way.~

  • True
  • False
A

(+)True
-False

~ ODP connections to SAP BW on HANA deliver analytical, calculation and attribute views Read more in
the lesson, Extracting from ODP - SAP HANA Information Views. In the course. BW350H~

23
Q

~The S/4HANA Virtual Data Model (VDM) consists of which of the following Core Data Services (CDS) views?~

  • Consumption Views
  • OLAP Views
  • Interface Views
  • ODQ Views
  • Private Views
A

(+)Consumption Views
-OLAP Views
(+)Interface Views
-ODQ Views
(+)Private Views

~CDS views consist of Consumption. Interface and Private views OLAP Views and ODQ Views do not exist Read more
in the lesson. Describing ABAP CDS View - ODP Source Systems, in the course, BW350H~

24
Q

~If you need to replicate ECC data to SAP BW and there is no delta DataSource. the ODP-SLT solution should be used.~

  • True
  • False
A

(+)True
-False

~You are correct! The ODP-SLT tools can be used to provide a delta mechanism when the data is being replicated Read
more in the lesson, Comparing SAP BW Data Acquisition Options, in the course, BW350H~

25
Q

~Delta management is the ability to extract only new or changed data records into SAP BW In a separate data request which is
technically a full update for a DataSource.~

  • True
  • False
A

-True
(+)False

~To load new or changed records from the source system, the Datasource will technically send a DELTA request and
not a full update Read more in the lesson. Describing Delta Management, In the course. BW350H~

26
Q

~Which of the following are delta processes available in an SAP source system?~

  • The creation of deltas with after, before, and reverse images that are updated directly to the operational delta queue
  • The extractor provides additional deltas that are serialized on a request basis
  • The creation of deltas with after images that are updated directly to the operational delta queue
  • The creation of delta queue entries using SLT
  • The SAP HANA calculation view determines the delta quantities and adds them to the ODQ
A

(+)The creation of deltas with after, before, and reverse images that are updated directly to the operational delta queue
(+)The extractor provides additional deltas that are serialized on a request basis
(+)The creation of deltas with after images that are updated directly to the operational delta queue
-The creation of delta queue entries using SLT
-The SAP HANA calculation view determines the delta quantities and adds them to the ODQ

~The delta processes In an SAP source system are before, after and reverse images, extractor determined deltas and
after image deltas. SLT is not a tool for creating delta record entries in a source system. SAP HANA calculation views
are not used to calculate delta values. Read more in the lesson. Explaining Terms and Basic Processes of Delta
Enabled Datasources, in the course. BW350H~

27
Q

~The record mode in the DTP determines if the data requested is a full update, an initialization of delta or a delta update.~

  • True
  • False
A

-True
(+)False

~The update mode determines whether or not the data is a full update, delta update or a delta Initialization. Record mode
is a flag in the ODQ defining the type of record being sent by the DataSource. Things like a deleted record, a changed
record or a new record are determined using the record mode. Read more in the lesson, Explaining Terms and Basic
Processes of Delta Enabled Datasources, in the course. BW350H~

28
Q

~A DataSource that uses a delta process can only provide characteristic values in the extracted records for the record mode that is
specified in the delta process. Determine whether this statement is true or false.~

  • True
  • False
A

(+)True
-False

~The record mode defined in the DataSource definition in the source system will determine what characteristic values are

transferred. Read more in the lesson. Explaining Terms and Basic Processes of Delta Enabled Datasources, in the
course. BW350H~

29
Q

~Which of the following are the update mode options available in the Logistics Data Extraction Cockpit?~

  • Direct update
  • Serialized V3 update
  • Queued delta
  • Unserialized V3 update
  • Indirect update
A

(+)Direct update
-Serialized V3 update
(+)Queued delta
(+)Unserialized V3 update
-Indirect update

~The Logistics Extraction Cockpit supports update modes of direct, queued and unserialized V3 updates. serialized V3
update is no longer supported Indirect update does not exist Read more In the lesson. Configuring the Logistics Data
Extraction (LON Cockpit). In me course. BW350H~

30
Q

~With delta processes that use generic DataSources, the delta options are additive or new.~

  • True
  • False
A

(+)True
-False

~You are correct! A generic Datasource can only provide an additive image or a new image Read more in the lesson.
Configuring Generic Delta DataSources, in the course, BW350H~

31
Q

~When code is pushed down to the SAP HANA database, the data does not have to be transferred back and forth between
application server and database server so the transformation logic can leverage the full CPU power and parallelism of the SAP
HANA database.~

  • True
  • False
A

(+)True
-False

~You are correct! Pushing code down to the SAP HANA layer is acknowledged as a performance Improvement from the
original ABAP-based scenarios Read more in the lesson. Working with SAP HANA Optimized Transformations, in the
course, BW350H~

32
Q

~You should use an Info Source if you want to connect a number of different DataSources to a target and the different DataSources
have the same data conversion requirements.~

  • True
  • False
A

(+)True
-False

~You are correct! SAP Best Practice is to use InfoSources if you need to connect different DataSources to a target which
have the same data conversion requirements Read more in the lesson. Positioning InfoSources. in the course,
BW350H~

33
Q

~When a DTP is run, any incorrect data records are sorted and written to an error stack. Subsequently, a special error ODQ further
updates the data records from the error stack into the target.~

  • True
  • False
A

-True
(+)False

~Error stack records can be updated to the target by running the special error DTP. not an error ODQ Read more in the
lesson. Debugging DTPS, In the course. BW350H~

34
Q

~To debug the ECC source system DataSources, the Extractor Checker is used.~

  • True
  • False
A

(+)True
-False

~The extractor checker in ECC is used to debug source system DataSources Read more in the lesson, Debugging an
SAP ECC Datasource, in the course. BW350H~

35
Q

~Which of the following are the functions available in the SAP BW Service API?~

  • Customizing DataSources
  • Acting as the test tool using Extractor Checker
  • Connecting to the SAP HANA database
  • Configuring of source system connections
  • Controlling parameters for data transfer
A

(+)Customizing DataSources
(+)Acting as the test tool using Extractor Checker
-Connecting to the SAP HANA database
(+)Configuring of source system connections
(+)Controlling parameters for data transfer

~The BW SAPI offers all the features except for SAP HANA connections The BW SAPl has no functionality to connect to the SAP HANA database Read more in the lesson, Describing the SAP ECC Plug In, in the course. BW350H~

36
Q

~The SAP ECC Application Component hierarchy is used to group together InfoSources in ECC that are replicated to SAP BW~

  • True
  • False
A

-True
(+)False

~You are correct! The SAP ECC Application Component hierarchy is used to group tohether DataSources (not InfoSources) that can be replicated to BW. Read more in the lesson, Work with the Application Component Hierarchy, in the course, BW350H.~

37
Q

~Standard Business Content DataSources can be modified using customer exit code.

  • True
  • False
A

(+)True
-False

~You are correct! Customers exits are designed to help customers to modify the standart extractors. Read more in the lesson, Appending BI Content DataSources, in the course, BW350H.~

38
Q

~Which of the following are components of Data Services?~

  • Data Profiling
  • Data Quality
  • Data Smoothing
  • Metadata Management
  • Data Integration (ETL)
A

(+)Data Profiling
(+)Data Quality
-Data Smoothing
(+)Metadata Management
(+)Data Integration (ETL)

~Data Services is comprised of all of the components listed except for data smoothing Data smoothing is not a
component of Data Services Read more in the lesson. Descnbing SAP Data Services for SAP HANA, in the course.
BW350H~

39
Q
~When a Web Service DataSource is generated, in addition to the normal objects, the system will create an RFC-capable function
module to load PSA and also a SOAP-compatible web service.~
  • True
  • False
A

(+)True
-False

~You are correct! A web service is always created with extra objects - a function module to load PSA and a SOAP web
service. Read more in the lesson. Acquiring Data Using an XML Based Web Service, in the course. BW350H~
40
Q

~Business Content Hierarchies can be loaded from the ECC source system and non-SAP hierarchies can be loaded using flat files.~

  • True
  • False
A

(+)True
-False

~You are correct! Hierarchies can be loaded from the ECC source system and non-SAP ones can be loaded from flat
files Read more in the lessons, Loading Hierarchies from ECC and Loading Hierarchies from Flat Fites, in the course,
BW350H~

41
Q

~OpenHub destinations allow you to distribute data from an SAP Business Warehouse (BW) system to non-SAP data marts,
analytical applications, and other applications.~

  • True
  • False
A

(+)True
-False

~You are correct! Open Hub is designed to facilitate the distribution of SAP BW to other systems Read more in the
lesson. Implementing Open Hub Destinations, in the course. BW350H~