BW/4HANA Dump Flashcards by Chris Jones

What information is available in the SAP BW/4HANA cockpit?

Note: There are 2 correct answers to this question.

Transformation editor
Source system maintenance
DTP editor
Request maintenance for ADSOs and InfoObjects
Process chain dashboard

Request maintenance for ADSOs and InfoObjects
Process chain dashboard

How well did you know this?

Not at all

Perfectly

On which technology is the SAP BW/4HANA cockpit based?

ABAP
Python
SAP Fiori
SQL

SAP Fiori

How well did you know this?

Not at all

Perfectly

Is it possible to personalize the tiles on the SAP BW/4HANA cockpit?

You can easily personalize the SAP BW/4HANA cockpit to your specific needs, for example by adding a tile showing the logs of “your” process chains.

SAP provides personalization content.

Personalization is done automatically. The system uses machine learning algorithms to fully automate the personalization.

No, personalization is not needed.

You can easily personalize the SAP BW/4HANA cockpit to your specific needs, for example by adding a tile showing the logs of “your” process chains

How well did you know this?

Not at all

Perfectly

Which of the following statements about Open ODS views in SAP BW/4HANA is true? One answer

They provide a rich set of analytical capabilities.
They consume external (and internal) data flexibly without staging
They combine data from SAP BW/4HANA and SAP HANA via join or union.
They are an advanced persistency layer.

They consume external (and internal) data flexibly without staging

How well did you know this?

Not at all

Perfectly

What is the right place to develop transformations in SAP BW/4HANA since SP 08?

SAP Web IDE
BW modeling tools in Eclipse
SAP GUI
SAP Web GUI

BW modeling tools in Eclipse

How well did you know this?

Not at all

Perfectly

For which database(s) is SAP BW/4HANA built?

SAP IQ
Any relational database
SAP HANA
Hadoop

SAP HANA

How well did you know this?

Not at all

Perfectly

Complete the sentence: Data modeling in SAP BW/4HANA is …

based on predefined semantics and modeling patterns (master data, DataStore objects (advanced)) as well as database fields.
not recommended for large data volumes.
based on InfoObjects only.
only possible without persist the data.

based on predefined semantics and modeling patterns (master data, DataStore objects (advanced)) as well as database fields.

How well did you know this?

Not at all

Perfectly

What are the characteristics of DataStore objects (advanced) in SAP BW/4HANA?

Note: There are 2 correct answers to this question.

They are based on “smart” tables and typically used for storing transaction data.
They contain navigational attributes.
They are based on a star schema.
They are modeled based on InfoObjects or field definitions.
They are the successor of the MultiProvider.

They are based on “smart” tables and typically used for storing transaction data.
They are modeled based on InfoObjects or field definitions.

How well did you know this?

Not at all

Perfectly

What are the characteristics of InfoObjects in SAP BW/4HANA?

Note: There are 2 correct answers to this question.

They do not support multiple languages – only English is available.
They are virtualized objects without any persistency.
They provide integrated time dependency (slowly changing dimensions).
They support geospatial.
The number of their characteristics is limited to 128.

They provide integrated time dependency (slowly changing dimensions).
They support geospatial.

How well did you know this?

Not at all

Perfectly

Where do you manage DataStore objects (advanced) in SAP BW/4HANA as of SP 08?

SAP GUI
SAP Web IDE
Request management tool
SAP BW/4HANA administration cockpit

SAP BW/4HANA administration cockpit

How well did you know this?

Not at all

Perfectly

What forms part of the metadata overview for aDSOs and InfoObjects in the SAP BW/4HANA administration cockpit as of SP 08?

Note: There are 2 correct answers to this question.

Field names, associations, and authorization information
Detailed table and sizing information
DDIC tables and general settings
Detailed information about data tiering optimization

DDIC tables and general settings
Detailed information about data tiering optimization

How well did you know this?

Not at all

Perfectly

Which transaction do you use to open the SAP BW/4HANA administration cockpit in the SAP GUI?

RSPCM
BW4WEB
RSA1
RS2HANA_ADMIN

BW4WEB

How well did you know this?

Not at all

Perfectly

Why is partitioning important in SAP BW/4HANA?

Note: There are 2 correct answers to this question.

Partitioning makes it easier to build and maintain aggregates in the SAP HANA database.
The limit of 2 billion records for each partition is no longer valid.
Partitioning improves performance with mass data due to partition pruning.
Partitioning reduces the memory footprint in the SAP HANA database.
Partitioning supports very large column store tables (each partition can be up to 2 billion records).

Partitioning improves performance with mass data due to partition pruning.
Partitioning supports very large column store tables (each partition can be up to 2 billion records).

How well did you know this?

Not at all

Perfectly

What are the main partitioning concepts in SAP BW/4HANA?

Note: There are 2 correct answers to this question.

Horizontal partitioning: Different rows are put into different tables.

Physical table partitioning: The DataStore object (advanced) is divided into several small, equally sized partitions, e.g. a separate partition for each month.

List partitioning: A partition is assigned a list of values. If the partitioning key has one of these values, the partition is chosen.

Conceptional/semantic partitioning: The InfoProvider is split (e.g. by region/calendar year) and the CompositeProvider is used as a virtual layer.

Physical table partitioning: The DataStore object (advanced) is divided into several small, equally sized partitions, e.g. a separate partition for each month.

Conceptional/semantic partitioning: The InfoProvider is split (e.g. by region/calendar year) and the CompositeProvider is used as a virtual layer.

How well did you know this?

Not at all

Perfectly

Which processing types can you define for a formula variable?
There are 3 correct answers to this question.

Response:

manual input

replacement path from another variable

replacement path from an infoobject

replacement path from another query

authorization

manual input

replacement path from another variable

replacement path from an infoobject

How well did you know this?

Not at all

Perfectly

You model a second SAP BW/4HANA Compositeprovider to intergrate tables from an SAP HANA database schema with an existing SAP BW/4HANA CompositeProvider.

What must you do first?
Please choose the correct answer.

Response:

Create an open ODS View with consumption properties to consume the data in the SAP BW/4HANA schema.

Set the CompositeProvider can Be Added to another compositeprovider flag.

Assign consumption properties to the new SAP HANA calculation view.

Connect an export Datasource from the exisiting CompositeProvider to the new compositeprovider.

Set the CompositeProvider can Be Added to another compositeprovider flag.

How well did you know this?

Not at all

Perfectly

What is the purpose of grouping fields in a composite provider?
Please choose the correct answer.

Response:

to improve reporting performance

to define subsets of fields for rule groups

to define subsets of fields for semantic groupings

to improve a logical order for the query designer

To improve a logical order for the query designer

How well did you know this?

Not at all

Perfectly

What is the maximum number of characteristics that can be used for a multi-dimensional exception aggregation in a BW query?
Please choose the correct answer.

Response:

How well did you know this?

Not at all

Perfectly

Which advantages does the SAP Lumira template for generic analysis provide?
There are 2 correct answers to this question.

Response:

You can create a bookmark to a navigation state and link it on any web page.

You can use it for any BW query or SAP HANA calculation view.

You can use visual Basic for applications to improve the design.

You can compare two Datasources in one report

You can create a bookmark to a navigation state and link it on any web page.

You can use it for any BW query or SAP HANA calculation view.

How well did you know this?

Not at all

Perfectly

You have created an SAP HANA Calculation View in SAP Web IDE for SAP HANA and want to integrate it into an SAP BW/4HANA CompositeProvider.

Which “Settings for HANA Consumption in BW” in transaction SPRO can you use in this scenario?
There are 2 correct answers to this question.

Response:

Hybrid Mode

HANA DeploymentInfrastructure (HDI)

External SAP HANA View

SAP HANA Repository

Hybrid Mode

HANA DeploymentInfrastructure (HDI)

How well did you know this?

Not at all

Perfectly

Which of the following are strengths of SAP S/4HANA embedded analytics?
There are 2 correct answers to this question.

Response:

Redundant data is reduced.

Cross-system consistency is generated.

Historical dat for stretegic decisions is stored.

Operational data is accessed in real time.

Redundant data is reduced.

Operational data is accessed in real time.

How well did you know this?

Not at all

Perfectly

When can you NOT use a characteristic with the high cardinality property?
There are 3 correct answers to this question.

Response:

When it will be a navigation attribute

When it will be a time-dependent attribute

When it will be a compound characteristic

When it will be part of a report-to-report interface

When it will be part of a hierarchy

When it will be a navigation attribute

When it will be a compound characteristic

When it will be part of a hierarchy

How well did you know this?

Not at all

Perfectly

You define a temporal condition for a temporal join in a calculation view. Which column data types are suppored?
There are 3 correct answers to this question.

Response:

Decimal

Boolean

Timestamp

Date

Integer

Timestamp

Date

Integer

How well did you know this?

Not at all

Perfectly

You need to combine master data (right table) and transactional data (left table) using a referential join. How will this referential join behave?
Please choose the correct answer.

Response:

It is executed as an inner join when a description mapping is defined between the left table and the right table.

It returns a result data set if the left table has a corresponding entry on the right table.

It is executed as an inner join when NO fields from the right table are requested.

It always returns all fields from the right table as a result data set.

It returns a result data set if the left table has a corresponding entry on the right table.

How well did you know this?

Not at all

Perfectly

You identified a variable that is based on time characteristic OCALMONTH and returns the current quarter. Which offset do you need to retrieve the corresponding quarter of the previous year? Please choose the correct answer. Response: -12 -4 -3 -1

-4

Which transformation options can be executed in an SAP HANA database? There are 2 correct answers to this question. Response: Formulas Read master data ABAP expert routines Transfer routines

Formulas Read master data

Your main BW Query contains a characteristic value variable with a replacement path from a query. When is the pre-query executed? Please choose the correct answer. Response: Directly after data is loaded to the InfoProvider of the pre-query. Each time the main query is executed, after the filter values are applied. Each time the main query is executed, before the filter values are applied. Directly after a predefined broadcasting event was triggered to calculate the pre-query.

Each time the main query is executed, before the filter values are applied.

Which object can you associate with a source field in the characteristic folder of an open ods view type facts? There are 2 correct answers to this question. Response: open ods view type facts open ods view type master data for attribute open ods view type master data for hierarchies sap bw infoobjects

open ods view type facts open ods view type master data for attribute

What must you do if you want to use an object from business content in sap bw/4hana? Please choose the correct answer. Response: convert the object from A version to D version copy the business content object into customer name space activate the object in data warehousing workbench identify the business content object in sap hana studio

activate the object in data warehousing workbench

What are InfoProviders? Choose the correct answer. A Objects that define the fields used for extraction from a source system B Objects that reports are based on C Objects that stage data during loading

B Objects that reports are based on

Which of the following are examples of key figures? Choose the correct answers. A Invoiced quantity B Customer number C Vacation days remaining

A Invoiced quantity C Vacation days remaining

What is a DataStore Object (advanced)? Choose the correct answer. A The central object in SAP BW/4HANA used for data storage and consolidation B A virtual staging object used to combine multiple data sources C An object used to store the results of a query to improve performance

A The central object in SAP BW/4HANA used for data storage and consolidation

What can you find in the Operational Delta Queue? Choose the correct answer. A Data that is waiting to be loaded to SAP BW/4HANA B A list of reports that are scheduled to run offline C A sequence of housekeeping job steps that can be scheduled to ensure that SAP BW/4HANA operated efficiently

A Data that is waiting to be loaded to SAP BW/4HANA

What are the features of a DataStore Object of the type Standard? Choose the correct answers. A A change log to manage the delta process B An activation step to control the release of loaded data to reporting users C Support for loading data using APIs

A A change log to manage the delta process B An activation step to control the release of loaded data to reporting users

What are the modeling features of a CompositeProvider? Choose the correct answers. A Union B Join C Aggregation D Ranking

A Union B Join C Aggregation

Which of the following is the core workflow when working with SAP Analytics Cloud? Please choose the correct answer. Response: Prepare - Explore - Acquire - Visualize - Collaborate Acquire - Prepare - Visualize - Explore - Collaborate Explore - Acquire - Prepare - Visualize - Collaborate Acquire - Prepare - Explore - Visualize - Collaborate

Acquire - Prepare - Visualize - Explore - Collaborate

You created an Open ODS view based on a database table in SAP HANA to virtually display the data in SAP BW/4HANA. Real-time reporting requirements have now changed and you are asked to persist the data in SAP BW/4HANA. Which objects will be created when using the Generate Dataflow function via the Open ODS view? There are 3 correct answers to this question. Response: SAP HANA calculation view Data source Transformation CompositeProvider DataStore object (advanced)

Data source Transformation DataStore object (advanced)

When can you NOT use a characteristic with the high cardinality property? There are 3 correct answers to this question. Response: When it will be a compound characteristic When it will be part of a hierarchy When it will be a time-dependent attribute When it will be part of a report-to-report interface When it will be a navigation attribute

When it will be a compound characteristic When it will be part of a hierarchy When it will be a navigation attribute

What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? There are 2 correct answers to this question. Response: The ABAP CDS views must be released via program RODPS_OS_EXPOSE for BW extraction. An Operational Data Provisioning Framework must be configured in SAP BW/4HANA. The ABAP CDS views must be defined with the appropriate data extraction annotations. An ODP source system with context ODP_CDS must be created in SAP BW/4HANA.

The ABAP CDS views must be defined with the appropriate data extraction annotations. An ODP source system with context ODP_CDS must be created in SAP BW/4HANA.

Which sources types can you select when you create an Open ODS view? There are 3 correct answers to this question. Response: Infosource Characteristic Transformation Virtual table using SAP HANA smart data access SAP BW DataSource

Transformation Virtual table using SAP HANA smart data access SAP BW DataSource

Which type of BW variable do you use as a dynamic threshold for an exception in a BW query? Please choose the correct answer. Response: Characteristic value variable Formula variable Text variable Hierarchy variable

Formula variable

How can the delta merge process be initiated? There are 3 correct answers to this question. Response: By setting a specific flag in the transformation By using a specific process type in a process chain By using SAP HANA smart merge technology By setting a specific flag in the data transfer process By using the SAP BW/4HANA data load monitor

By using a specific process type in a process chain By using SAP HANA smart merge technology By setting a specific flag in the data transfer process

Which properties determine the delta process within the operational Data provisioning (ODP) delta management for Datasources? There are 3 correct answers to this question. Response: Serialization Paralleization Delta type Recors type Record mode

Serialization Delta type Record mode

You need to view the SAP HANA Calculation views, SAP BW Datasources, and infoareas in the same SAP HANA Studio perspective. what should you do? Please choose the correct answer. Response: Attach an ABAP Project to an SAP BW project. Attach an SAP BW project to an ABAP Project Attach an SAP HANA System to an SAP BW project Attach an SAP BW Project to an SAP HANA System.

Attach an SAP HANA System to an SAP BW project

You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder? There are 2 correct answers to this question. Response: Open ODS view of type Facts Open ODS view of type Master Data InfoObject of type Characteristic Calculation View of type Dimension

Open ODS view of type Master Data Calculation View of type Dimension

You want to validate your sap data model. To use the data preview functionality, what must you ensure? Please choose the correct answer. Response: you must provide the key date in the view properties the _SYS_BIC user is created in the system and the runtime information is written to schema _SYS_STATISTICS the design time version must be saved and successfully activated you are connected as SYSTEM user and all object privileges are assigned to this SYSTEM user

the design time version must be saved and successfully activated

What can you achieve with rule groups in an SAP BW transformation? There are 2 correct answers to this question. Response: One record in the source creates a record in the target for each rule group. Key figures with the same characteristic mapping are grouped. Records of the source are grouped to decrease the number of records in the target. Characteristics with the same key figure mapping are grouped.

One record in the source creates a record in the target for each rule group. Key figures with the same characteristic mapping are grouped.

You load a Datastore object (advanced) every night. where can you delete the request you loaded two nights ago without deleting the last request? Please choose the correct answer. Response: From a Datastore object (advanced) based on the model template standard Datastore object if the request is activated. From a Datastore object (advanced) based on the model template standard Datastore object if the request is activated you execute a full load. From a Datastore object (advanced) based on the model template Infocube if the request is activated. From a Datastore object (advanced) based on the model template Infocube if the request is NOT activated

From a Datastore object (advanced) based on the model template Infocube if the request is NOT activated

Which join types can you use in a CompositeProvider? There are 3 correct answers to this question. Response: Referential join Text join Full Outer join Hierarchy join Inner join

Referential join Full Outer join Inner join

-4

You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time update scenario. Which fields are added to the DataSource automatically? There are 3 correct answers to this question. Response: SDI_CHANGE_SEQUENCE SDI_CHANGE_TIME SDI_RECORD_MODE SDI_RECORD_SEQUENCE SDI_CHANGE_TYPE

SDI_RECORD_MODE SDI_CHANGE_TYPE SDI_CHANGE_TIME

What is the purpose of grouping fields in a composite provider? Please choose the correct answer. Response: to define subsets of fields for semantic groupings to improve a logical order for the query designer to improve reporting performance to define subsets of fields for rule groups

to improve a logical order for the query designer

You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum). If you keep the default settings of the BW query, what is presented regarding the result rows? Please choose the correct answer. Response: One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of all 100 customers Only one result row with the sales revenue sum of the top 10 customers One result row with the sales revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers Only one result row with the sales revenue sum of all 100 customers

Only one result row with the sales revenue sum of the top 10 customers

You create a DataStore object (advanced) using the "Data Mart DataStore Object" modeling property. Which behaviors are specific to this modeling property? There are 2 correct answers to this question. Response: All characteristics are automatically defined as key. The change log table will only be filled after data activation. Query results are only shown when data has been activated. Reporting is done based on a union of the inbound and active tables.

All characteristics are automatically defined as key. Reporting is done based on a union of the inbound and active tables.

What are the possible ways to fill a pre-calculated value set (bucket)? There are 3 correct answers to this question. Response: By using a query By using a transformation and data transfer process(DTP) By entering the values manually By accessing an SAP HANA Calculation View of data category Dimension By referencing a table

By using a query By entering the values manually By referencing a table

You expect to have more than 2 billion records as master data references for a characteristic in your data model and want to use the high cardinality option. What do you need to consider in reporting? Please choose the correct answer. Response: Using this characteristic as a navigational attribute will impact response time. The local SID values are created automatically during reporting, which will impact the response time. Using a hierarchy of this characteristic for navigation will impact response time. The High Cardinality property needs to be defined in the Composite Provider.

Using a hierarchy of this characteristic for navigation will impact response time.

From which SAP BW/4HANA objects can you start generating an external View? There are 2 correct answers to this question. Response: Semantic group object BW query CompositeProvider Open ODS view

BW query CompositeProvider

Where can you integrate an analysis view from SAP Analysis for microsoft office? there are 3 correct answers to this question. Response: In a projection node of an SAP HANA calculation view In an SAP BusinessObjects web intelligence report In an SAP Crystal reports for Enterprise report In another SAP Analysis for microsoft office workbook In a BW query

In an SAP BusinessObjects web intelligence report In an SAP Crystal reports for Enterprise report In another SAP Analysis for microsoft office workbook

Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP)? There are 3 correct answers to this question. Response: Open Hub Destination CompositeProvider InfoSource DataStore Object (advanced) SAP HANA Analysis Process

Open Hub Destination InfoSource DataStore Object (advanced)

What are desired outcomes of an SAP BW/4HANA pilot project? There are 3 correct answers to this question. A. Identify customizing and configuration areas to be applied to future projects. B. Confirm increased database size using SAP BW/4HANA instead of a common RDBMS. C. Identify objects from SAP BI content that will be leveraged in subsequent projects. D. Identify required changes for the business processes to comply with SAP BW/4HANA standard software. E. Transfer experience of the pilot project to future projects.

A. Identify customizing and configuration areas to be applied to future projects. C. Identify objects from SAP BI content that will be leveraged in subsequent projects. E. Transfer experience of the pilot project to future projects.

What are some of the key characteristics of SAP BW/4HANA? SAP BW/4HANA is not part of SAP NetWeaver anymore and is a separate new product. SAP BW/4HANA does not support BEx Queries anymore. SAP BW/4HANA only runs on SAP HANA. SAP BW/4HANA is built natively in the SAP HANA platform and does not support ABAP as a programming language anymore.

SAP BW/4HANA is not part of SAP NetWeaver anymore and is a separate new product. SAP BW/4HANA only runs on SAP HANA.

What functions does the SAP BW/4HANA Cockpit provide? Modeling process chains Monitoring process chains Modeling process chain variants Modeling HANA analysis processes Administration of data loading requests for InfoObjects and DataStore objects (advanced) Administration of external SAP HANA Views Administration of Analysis Authorizations

Modeling process chains Monitoring process chains Modeling process chain variants Administration of data loading requests for InfoObjects and DataStore objects (advanced) Administration of external SAP HANA Views Administration of Analysis Authorizations

What are key characteristics of SAP Data Warehouse Cloud ? Collaboration: Enablement of both enterprise IT and line of business users Performance: Leverage the power of SAP HANA End-to-End Integration: Consumption of data from any source in SAP Analytics Cloud Elasticity: Pay for what you use concept Deployment: Free choice between on premise or private cloud

Collaboration: Enablement of both enterprise IT and line of business users Performance: Leverage the power of SAP HANA End-to-End Integration: Consumption of data from any source in SAP Analytics Cloud Elasticity: Pay for what you use concept

Sequence of activities for Remote conversion Data transfer scope selection in sending system conversion into new obj in receiving transport selected to receiving

scope selection in sending system transport selected to receiving conversion into new obj in receiving Data transfer

Which statement represents transitive attributes in SAP BW/4HANA in the best way? Transitive attributes are the new name for InfoObject display attributes. Transitive attributes are navigation attributes of existing InfoObject attributes. Transitive attributes are a new type of InfoObject attributes to manage comments on certain attribute values. Transitive attributes are a new type of InfoObject attributes that are populated from SAP HANA Calculation Views.

Transitive attributes are navigation attributes of existing InfoObject attributes.

Which source types can you use to model an Open ODS View? 4 Database table or view Virtual table using SAP HANA smart data access BW DataSource DataStore-Object (advanced)

Database table or view Virtual table using SAP HANA smart data access BW DataSource DataStore-Object (advanced)

which connection types are available when you define a new Open Hub Destination with target type Database table in SAP BW/4HANA 2.0 SP04 or higher? Table in local Database SAP HANA Smart Data Access (SDA) SAP Data Services Database Connection (DBCON) OData Operational Data Provisioning (ODP)

Table in local Database SAP HANA Smart Data Access (SDA) Database Connection (DBCON)

In which exceptional case should you use the BAdI provider as preferred data model in SAP BW/4HANA? Your license does not allow you to use HANA Script. You implement a planning application based on SAP BPC, add-on for SAP BW/4HANA. You implement a customer-specific virtual scenario and SAP ABAP logic is unavoidable there. Your requirements contain key figures with exception aggregation.

You implement a customer-specific virtual scenario and SAP ABAP logic is unavoidable there.

Which are recommended approaches for modeling virtual mixed scenarios? 2 correct Generation of external SAP HANA Views for BW/4HANA objects Provisioning of BW/4HANA data to SAP HANA based on the Open Hub interface Modeling CompositeProviders based on SAP HANA Views Loading of SAP HANA data into SAP BW/4HANA based on the ODP_HANA interface

Generation of external SAP HANA Views for BW/4HANA objects Modeling CompositeProviders based on SAP HANA Views

Where can you the set the Operations in SAP HANA property to define the runtime pushdown of BW Queries in SAP BW/4HANA? CompositeProviders InfoObject characteristics BW Queries DataStore Objects (advanced)

CompositeProviders InfoObject characteristics BW Queries

You would like to implement a Data Tiering Optimization concept for a DataStore Object (advanced) that contains data from several years. Schedule a job that executes the data displacement. Define the ADSO tiers you would like to manage the data in. Define ADSO partitions on the InfoObject that represents the calendar year. Define the planned temperature for each of the partitions.

Define ADSO partitions on the InfoObject that represents the calendar year. Define the ADSO tiers you would like to manage the data in. Define the planned temperature for each of the partitions Schedule a job that executes the data displacement.

What interfaces does Operational Data Provisioning (ODP) provide for SAP BW/4HANA as a consumer? Interface to objects of other BW systems Interface to third-party databases Interface to SAP HANA Calculation Views Interface to SAP HANA HDI Calculation Views Interface to SAP ABAP CDS Views Interface to SAP HANA CDS Views Interface to SAP systems based on SAP BW DataSources (Extractors) Interface to Hadoop file clusters.

Interface to objects of other BW systems Interface to SAP HANA Calculation Views Interface to SAP ABAP CDS Views Interface to SAP systems based on SAP BW DataSources (Extractors)

Which of the following statements regarding connecting SAP Cloud applications to SAP BW/4HANA is correct? SAP S/4HANA Cloud can be connected based on Operational Data Provisioning (ODP) in the context of ODP_BYD. SAP S/4HANA Cloud can be connected based on Operational Data Provisioning (ODP) in the context of ODP_CDS. SAP SuccessFactors can be connected based on Operational Data Provisioning (ODP) in the context of ODP_BYD. SAP SuccessFactors can be connected based on SAP HANA Smart Data Integration (SDI) and its OData adapter.

SAP S/4HANA Cloud can be connected based on Operational Data Prov SAP SuccessFactors can be connected based on SAP HANA Smart Data Integration (SDI) and its OData adapter.

In BW/HANA it is possible to consume a SAP ABAP CDS View which is enabled for extraction virtually as well (that is, without loading the data)? No. You have to load the data into advanced DSOs or InfoObjects first. Yes. Model a CompositeProvider which consumes the SAP HANA Calculation View created by the ABAP CDS View. Yes. Model an Open ODS view which is based on a BW DataSource of type SAP HANA Smart Data Access (HANA_SDA). Yes. Model an Open ODS View which is based on a BW DataSource of type ODP_CDS.

Yes. Model an Open ODS View which is based on a BW DataSource of type ODP_CDS.

SAP BW/4HANA, there is a new solution for statistical analysis of data management processes and query execution. Which technology is it based on? SAP ABAP-Managed Database Procedures SAP HANA Calculation Views SAP HANA HDI Calculation Views SAP ABAP Core Data Services SAP BW/4HANA Open ODS Views

SAP ABAP Core Data Services

Which delta-mechanism(s) is (are) available to load data from SAP S/4HANA Cloud to SAP BW/4HANA? 3 answers SAP S/4HANA Cloud does not provide any delta mechanism for this scenario. SAP S/4HANA Cloud supports Generic Delta based on a UTC Time Stamp. SAP S/4HANA Cloud supports Change Data Capture (CDC) based on a database trigger. SAP S/4HANA Cloud supports Generic Delta based on a Calendar Date.

SAP S/4HANA Cloud supports Generic Delta based on a UTC Time Stamp. SAP S/4HANA Cloud supports Change Data Capture (CDC) based on a database trigger. SAP S/4HANA Cloud supports Generic Delta based on a Calendar Date.

Which tool(s) can you leverage to evaluate CDS Extractors in SAP S/4HANA? 1 answer Business Content DataSource Browser in the general customizing (Tr. SPRO). View Browser app in the SAP S/4HANA Fiori Launchpad. BW Extraction app in the SAP S/4HANA Fiori Launchpad. There is no such tool available. But the CDS Extractors are listed and documented in detail in the SAP help for SAP S/4HANA. CDS Extraction app in the SAP BW/4HANA Cockpit.

View Browser app in the SAP S/4HANA Fiori Launchpad.

Which tool(s) can you leverage to evaluate CDS Extractors in SAP S/4HANA? Business Content DataSource Browser in the general customizing (Tr. SPRO). View Browser app in the SAP S/4HANA Fiori Launchpad. BW Extraction app in the SAP S/4HANA Fiori Launchpad. There is no such tool available. But the CDS Extractors are listed and documented in detail in the SAP help for SAP S/4HANA. CDS View I_DataExtractionEnabledView

View Browser app in the SAP S/4HANA Fiori Launchpad. CDS View I_DataExtractionEnabledView

What is the impact of SAP S/4HANA on an existing SAP BW system? 2 answers After implementation of SAP S/4HANA embedded analytics, some applications in the SAP BW system might become obsolete. SAP S/4HANA embedded analytics fully takes over the role of existing SAP BW environments. SAP BW systems can be decommissioned. Extraction to the existing SAP BW system might change because not all extractors (DataSources) are available in SAP S/4HANA in the same way. Conversion of the existing SAP BW system to SAP BW/4HANA is a precondition for an SAP S/4HANA implementation.

After implementation of SAP S/4HANA embedded analytics, some applications in the SAP BW system might become obsolete. Extraction to the existing SAP BW system might change because not all extractors (DataSources) are available in SAP S/4HANA in the same way.

What are the tools available to model individual ad-hoc scenarios in a BW/4HANA Workspace? 3 answers SAP Analysis for MS Office SAP BW/4HANA Modeling Tools SAP BW Workspace Designer App in SAP BW/4HANA Cockpit SAP BW Workspace Query Designer (Tr. RSWQD)

SAP Analysis for MS Office SAP BW Workspace Designer App in SAP BW/4HANA Cockpit SAP BW Workspace Query Designer (Tr. RSWQD)

Which statement represents transitive attributes in SAP BW/4HANA in the best way? Choose the correct answer. A Transitive attributes are the new name for InfoObject display attributes. B Transitive attributes are navigation attributes of existing InfoObject attributes. C Transitive attributes are a new type of InfoObject attributes to manage comments on certain attribute values. D Transitive attributes are a new type of InfoObject attributes that are populated from SAP HANA Calculation Views.

B Transitive attributes are navigation attributes of existing InfoObject attributes.

Advanced DataStore objects are the central data model to manage transactional data in SAP BW/4HANA. They provide all services that were provided by InfoCubes and DataStore objects (classic) in SAP NetWeaver BW. Determine whether this statement is true or false. True False

True

CompositeProviders do not allow you to model temporal joins and SAP recommends using BW InfoSets for such scenarios in SAP BW/4HANA. Determine whether this statement is true or false. True False

False CompositeProviders cover these scenarios and therefore fully replace InfoSets of SAP NetWeaver BW.

Which source types can you use to model an Open ODS View? Choose the correct answers. 4 answers A Database table or view B Virtual table using SAP HANA smart data access C BW DataSource D DataStore-Object (advanced)

A Database table or view B Virtual table using SAP HANA smart data access C BW DataSource D DataStore-Object (advanced)

Which connection types are available when you define a new Open Hub Destination with target type Database table in SAP BW/4HANA 2.0 SP04 or higher? Choose the correct answers. A Table in local Database B SAP HANA Smart Data Access (SDA) C SAP Data Services D Database Connection (DBCON) E OData F Operational Data Provisioning (ODP)

A Table in local Database B SAP HANA Smart Data Access (SDA) D Database Connection (DBCON)

In which exceptional case should you use the BAdI provider as preferred data model in SAP BW/4HANA? Choose the correct answer. A Your license does not allow you to use HANA Script. B You implement a planning application based on SAP BPC, add-on for SAP BW/4HANA. C You implement a customer-specific virtual scenario and SAP ABAP logic is unavoidable there. D Your requirements contain key figures with exception aggregation.

C You implement a customer-specific virtual scenario and SAP ABAP logic is unavoidable there.

Which are recommended approaches for modeling virtual mixed scenarios? 2 answers Generation of external SAP HANA Views for BW/4HANA objects Provisioning of BW/4HANA data to SAP HANA based on the Open Hub interface Modeling CompositeProviders based on SAP HANA Views Loading of SAP HANA data into SAP BW/4HANA based on the ODP_HANA interface

Generation of external SAP HANA Views for BW/4HANA objects Modeling CompositeProviders based on SAP HANA Views

In SAP BW/4HANA, there is a new solution for statistical analysis of data management processes and query execution. Which technology is it based on? SAP ABAP-Managed Database Procedures SAP HANA Calculation Views SAP HANA HDI Calculation Views SAP ABAP Core Data Services SAP BW/4HANA Open ODS Views

SAP ABAP Core Data Services

View Browser app in the SAP S/4HANA Fiori Launchpad.

Which technology does SAP S/4HANA embedded analytics leverage? SAP HANA Calculation Views SAP ABAP Core Data Services Embedded SAP BW with real-time InfoCubes SAP HANA Core Data Services

SAP ABAP Core Data Services

SAP Analysis for MS Office SAP BW Workspace Designer App in SAP BW/4HANA Cockpit SAP BW Workspace Query Designer (Tr. RSWQD)

Which are the core functional use cases of SAP Analytics Cloud? 5 answers Providing flexible self-service reporting Modeling planning applications Defining predictive scenarios Modeling SAP BW/4HANA objects Uploading local data into a SAP BW Workspace Modeling and sharing visualizations and dashboards Setting up analytic applications with individual custom scripts.

Providing flexible self-service reporting Modeling planning applications Defining predictive scenarios Modeling and sharing visualizations and dashboards Setting up analytic applications with individual custom scripts.

Which of the following statements regarding connecting SAP Cloud applications to SAP BW/4HANA is correct? 2 answers SAP S/4HANA Cloud can be connected based on Operational Data Provisioning (ODP) in the context of ODP_BYD. SAP S/4HANA Cloud can be connected based on Operational Data Provisioning (ODP) in the context of ODP_CDS. SAP SuccessFactors can be connected based on Operational Data Provisioning (ODP) in the context of ODP_BYD. SAP SuccessFactors can be connected based on SAP HANA Smart Data Integration (SDI) and its OData adapter.

SAP S/4HANA Cloud can be connected based on Operational Data Provisioning (ODP) in the context of ODP_CDS. SAP SuccessFactors can be connected based on SAP HANA Smart Data Integration (SDI) and its OData adapter.

Which technology does SAP S/4HANA embedded analytics leverage? Choose 1 SAP HANA Calculation Views SAP ABAP Core Data Services Embedded SAP BW with real-time InfoCubes SAP HANA Core Data Services

SAP ABAP Core Data Services

Which of the following are tools of SAP BW/4HANA? Data Warehousing Workbench BW Modeling Tool in Eclipse Bex Analyzer SAP BW/4HANA Cockpit

Data Warehousing Workbench BW Modeling Tool in Eclipse SAP BW/4HANA Cockpit

What is a DataSource? A flat structure of logically related fields that contain data to be transferred into SAP BW/4HANA An object that defines master data modeling rules, such as compounding A store of data used for staging A structure used to define transformation rules

A flat structure of logically related fields that contain data to be transferred into SAP BW/4HANA

What is replication? Copying data from one layer to another Making the source system fields used in an extraction available to SAP BW/4HANA Moving data from the source system to SAP BW/4HANA

Making the source system fields used in an extraction available to SAP BW/4HANA

What are InfoProviders? Objects that define the fields used for extraction from a source system Objects that reports are based on Objects that stage data during loading

Objects that reports are based on

What additional objects can be generated from an Open ODS view? 3 options DataSource Transformation DataStore Object (advanced) CompositeProvider

DataSource Transformation DataStore Object (advanced)

Which of the following are Best Practice options for storing data in a BW system running on SAP HANA? Store the bulk of the data on disk for retrieval when required (warm data) Store the most relevant data in a compressed column store in memory (hot data) Split the most relevant data by date and store between an uncompressed column store and tables stored on disk (warm data) Store all data in compressed column stores to maximize performance (hot data) Move less important data into an external storage system (cool data)

Store the bulk of the data on disk for retrieval when required (warm data) Store the most relevant data in a compressed column store in memory (hot data) Move less important data into an external storage system (cool data)

Based on BW/4HANA focus, which of the following should be considered when modeling master data and transaction data? If master data does not need to be replicated, an Open ODS View for texts and attributes could be used. If transaction data should be stored, a DataStore Object (advanced) (aDSO) should be used To load transaction data efficiently, an Open ODS View of type facts should be used Without additional data load, combine data from existing InfoProviders using a CompositeProvider. If master data is to be persisted, then characteristics should be used

If master data does not need to be replicated, an Open ODS View for texts and attributes could be used. If transaction data should be stored, a DataStore Object (advanced) (aDSO) should be used Without additional data load, combine data from existing InfoProviders using a CompositeProvider. If master data is to be persisted, then characteristics should be used

What is the purpose of the Virtual Data Mart Layer? 3 Agile Extension: Allow business users to upload files and directly report on them. Enhancing master data: Add navigational attributes as required for a specific business scenario. Flexibility: If you need to exchange the physical InfoProvider below, all BW queries can remain unchanged. Support the Unknown: Store data that is currently not needed in case it is needed later. Virtual Combination: Filter and join data from existing InfoProviders without uploading already available records.

Enhancing master data: Add navigational attributes as required for a specific business scenario. Flexibility: If you need to exchange the physical InfoProvider below, all BW queries can remain unchanged. Virtual Combination: Filter and join data from existing InfoProviders without uploading already available records.

Which of the following guidelines should be considered in an enterprise-wide implementation of BW on HANA? How will the different data models be incorporated Utilize the LSA++ layers in the design of the EDW Which languages and currencies will need to be considered What will the system and transport landscape be comprised of Which users will be logging onto the system

How will the different data models be incorporated Utilize the LSA++ layers in the design of the EDW Which languages and currencies will need to be considered What will the system and transport landscape be comprised of

Which BW/4HANA objects can be modeled as a purely field-based model? 3 correct InfoObjects with Hierarchies Open ODS Views ADSOs CompositeProviders

Open ODS Views ADSOs CompositeProviders

Which of the following statements regarding internal and external hierarchies are true? Internal hierarchies have no link to Master Data tables Internal hierarchies are used to display characteristics without using an external hierarchy External hierarchies are defined in Business Explorer Query Designer on the Hierarchy tab External hierarchies are defined as “external” because the data is stored outside of BW on the OLAP server External hierarchies are stored in BW Master Data tables

Internal hierarchies have no link to Master Data tables Internal hierarchies are used to display characteristics without using an external hierarchy External hierarchies are stored in BW Master Data tables

Which of the following contain the correct terminology about hierarchies? An entity in a hierarchy is called a node Nodes that have no parents are called orphan nodes Nodes that have no children nodes are called leaf nodes or leaves A relationship between a node and its parent node is called a family tree A hierarchy with leaves on different levels is an unbalanced hierarchy

An entity in a hierarchy is called a node Nodes that have no children nodes are called leaf nodes or leaves A hierarchy with leaves on different levels is an unbalanced hierarchy

What are typical examples of Mixed Scenarios? 3 correct Data Acquisition in SAP BW/4HANA and applying SQL logic in modeled SAP HANA Views on top of generated SAP HANA Views Data Acquisition in SAP HANA and applying BW logic in CompositeProviders which contain only SAP HANA Calculation Views Data Acquisition in SAP BW/4HANA and applying BW logic in CompositeProviders which contain only aDSOs and InfoObjects. Data Acquisition in SAP BW/4HANA and SAP HANA and applying BW logic in CompositeProviders which contain only aDSOs and SAP HANA Calculation Views

Data Acquisition in SAP BW/4HANA and applying SQL logic in modeled SAP HANA Views on top of generated SAP HANA Views Data Acquisition in SAP HANA and applying BW logic in CompositeProviders which contain only SAP HANA Calculation Views Data Acquisition in SAP BW/4HANA and SAP HANA and applying BW logic in CompositeProviders which contain only aDSOs and SAP HANA Calculation Views

Which are properties of Live Data Connectivity of SAP Analytics Cloud? Live Data Connectivity is the only method to provide data from a BW/4HANA system. Live Data Connectivity is limited regarding the amount of data. With Live Data Connectivity, the authorizations of the connected system are considered. With Live Data Connectivity, analysis is performed without data replication.

With Live Data Connectivity, the authorizations of the connected system are considered. With Live Data Connectivity, analysis is performed without data replication.

For which infoprovider types can you select navigation attributes? There are 2 correct answers to this question. Response: open ODS Views Datastore object (advanced) of type infocube Datastore object (advanced) of type standard datastore object. Composite provider

open ODS Views Composite provider

What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA? There are 2 correct answers to this question. Response: There must be no BW analysis authorizations defined that use any of the cost centers. There must be no hierarchy for the cost centers. There must be no BW query that uses cost center as a free characteristic. There must be no transaction data referring to the cost centers.

There must be no hierarchy for the cost centers. There must be no transaction data referring to the cost centers.

Your company is using SAP S/4HANA as a business operational system and you have to provide operational analytical reports. Why might you consider SAP S/4HANA embedded analytics? Please choose the correct answer. Response: To use the ABAP CDS view based virtual data model. To use the SAP HANA optimized business content. To use the generated external SAP HANA Calculation Views. To use the SAP HANA Deployment Infrastructure.

To use the ABAP CDS view based virtual data model.

How can you persist data from any SAP HANA database table to a table in the SAP BW Schema? There are 3 correct answers to this question. Response: Create an Open ODS view. Consume the view using a CompositeProvider. Load the data to a DataStore object (advanced). Create a DataSource. Create an SAP HANA calculation view. Create an Open ODS view. Generate a data flow.

Load the data to a DataStore object (advanced). Create a DataSource. Create an Open ODS view. Generate a data flow.

You want to run a BW query, but you only have partial authorization for the data selection. What happens related to the BW query in this scenario? Please choose the correct answer. Response: The BW query starts and the unauthorized values are 0. The BW query does notstart running. The BW query starts and shows an error message. The BW query starts and only the authorized data is displayed.

The BW query starts and only the authorized data is displayed.

When loading master data for a material, you want to look at the new values before they are released for reporting. What could you do using modeling features? There are 2 correct answers to this question. Response: When you define the material characteristic, select the “Enhanced Master data update” setting. When you define the data transfer process, choose the “Set manually” setting for “Overall status of request”. When you define the attributes of material, select the “Time Dependent” setting. When you define the data transfer process, select the “Load records with new key only” setting.

When you define the material characteristic, select the “Enhanced Master data update” setting. When you define the data transfer process, choose the “Set manually” setting for “Overall status of request”.

Which features can be leveraged using a CompositeProvider in SAP BW/4HANA? There are 3 correct answers to this question. Response: Define new restricted key figures Integrate SAP HANA calculation views Combine InfoProviders using Joins and Unions Create new calculated fields Join two ABAP CDS views

Integrate SAP HANA calculation views Combine InfoProviders using Joins and Unions Join two ABAP CDS views

You want to use the SAP HANA concept of semantic types as part of the currency conversion mechanism. You decide to use semantic type Amount with Currency Code within your SAP HANA calculation view. Which currency reference can be assigned to the measure? There are 3 correct answers to this question. Response: A currency from SAP BW customizing A currency from another column A currency from an SAP HANA content calculation view A fixed currency A currency from a currency conversion

A fixed currency A currency from a currency conversion A currency from another column

Which of the following is the core workflow when working with SAP Analytics Cloud? Please choose the correct answer. Response: Explore - Acquire - Prepare - Visualize - Collaborate Acquire - Prepare - Visualize - Explore - Collaborate Acquire - Prepare - Explore - Visualize - Collaborate Prepare - Explore - Acquire - Visualize - Collaborate

Acquire - Prepare - Visualize - Explore - Collaborate

You use the wizard to create an SAP BW/4HANA Big data source system. Which activities are mandatory? There are 3 correct answers to this question. Response: Select a database objectschema. Specify connection type BigData. Specify release type. Select a remote source. Specify business content type.

Select a database objectschema. Specify connection type BigData. Select a remote source.

You need to use an SAP ERP standard DataSource to load data into SAP BW/4HANA. Which prerequisite must be fulfilled to use the DataSource in the Operational Data Provisioning context? Please choose the correct answer. Response: It must be in-memory-optimized. It must exist in table ROOSATTR. It must have a queue entry in transaction ODQMON. It must be delta-enabled.

It must exist in table ROOSATTR.

What are benefits of separating master data from transactional data in SAP BW/4HANA? There are 2 correct answers to this question. Response: Distinguish between changeable and non-changeable data Avoid generation of SID values Ensure referential integrity on your transactional data Provide language-dependent texts

Distinguish between changeable and non-changeable data Ensure referential integrity on your transactional data

Which reporting object do you use to combine data from different SAP BW InfoProviders? Please choose the correct answer. Response: Dataprovider BW query Analysis workbook Analysis view

Analysis workbook

You create an SAP HANA HDI Calculation View. What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? There are 3 correct answers to this question. Response: Create restricted columns. Provide default time characteristics. Aggregate measures as a sum. Persist transactional data. Combine master data and transactional data.

Create restricted columns. Provide default time characteristics. Aggregate measures as a sum.

What can you leverage using the live data connections of SAP Analytics Cloud with SAP BW/4HANA? There are 2 correct answers to this question. Response: Existing authorization concepts Process chain streaming functionality BW data models for analysis BW data models for planning scenarios

Existing authorization concepts BW data models for analysis

What must you do to define an inventory infoprovider in SAP BW/4HANA? There are 3 correct answers to this question. Response: Assign at least one non-cumulative key figure. Select the Unique Data Records model property. Select the All characteristics are key model property. Assign at least one cumulative key figure. Select the Inventory model property.

Assign at least one non-cumulative key figure. Select the All characteristics are key model property. Select the Inventory model property.

You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder? There are 2 correct answers to this question. Response: Open ODS view of type Facts InfoObject of type Characteristic Calculation View of type Dimension Open ODS view of type Master Data

Calculation View of type Dimension Open ODS view of type Master Data

Which condition must you ensure if you want to replicate data based on a view with SAP Landscape transformation replication server? Please choose the correct answer. Response: View-based data result sets must be kept persistent first until data replication can take place. One table as part of the view has to be defined as primary table and is used to trigger data replication. Each table of the view requires a defined trigger to enable data replication. An SAP HANA source system must be defined to consume the view.

Each table of the view requires a defined trigger to enable data replication.

What can you do in the sap bw/4hana cockpit? There are 3 correct answers to this question. Response: manage request in infoobjects and datastore object model, schedule and monitor process chain model and transport data flow maintain data tiering setting model and schedule replication task

manage request in infoobjects and datastore object model, schedule and monitor process chain model and transport data flow

Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generatesfully populated, multi-tabbed stories? Please choose the correct answer. Response: Search to Insight Smart Predict Smart Discovery Forecasting

Smart Discovery

You edit an SAP BW/4HANA object. In which SAP HANA studio views can you view the last modifier and modification time? There are 2 correct answers to this question. Response: Properties view Problems view Reporting preview History view

Properties view History view

In which sequence can you create a reusable key figure structure? There are 2 correct answers to this question. Response: A. 1. Apply filters to a key figure structure in SAP Analysis for Microsoft Office. A . 2. Save the structure as a global structure. B. 1. Create a new structure in the context menu of an InfoProvider. B. 2. Add key figures, selections, and formulas. C. 1. Create a new structure with key figures, selections, and formulas in a query. C. 2. Save the structure as a global structure. D. 1. Create a new structure in the context menu of a calculated key figure. D. 2. Save the structure as a global structure.

B. 1. Create a new structure in the context menu of an InfoProvider. B. 2. Add key figures, selections, and formulas. C. 1. Create a new structure with key figures, selections, and formulas in a query. C. 2. Save the structure as a global structure.

Which objects can you use as components in a compositeprovider in SAP BW/4HANA? There are 2 correct answers to this question. Response: Open ODS view Compositeprovider Semantic group BW query

Open ODS view Compositeprovider

You want to define a restricted column in an SAP HANA calculation view. What do you need to define? There are 2 correct answers to this question. Response: An aggregation method An SAP HANA data type A condition criterium A reference to an existing measure

A condition criterium A reference to an existing measure

Which processing types can you define for a formula variable? There are 3 correct answers to this question. Response: replacement path from an infoobject replacement path from another variable authorization manual input replacement path from another query

manual input replacement path from an infoobject replacement path from another variable

You create a DataStore object (advanced) using model template Standard DataStore Object. Which flags are set? There are 2 correct answers to this question. Response: Unique data records All characteristic are key Activate Data Write change log

Activate Data Write change log

You want to model an SAP HANA calculation view by combining the sales orders with the corresponding customer status, which was assigned to the customer when the order was issued. Which join properties do you assign to the required join type? Please choose the correct answer. Response: Referential join with temporal join properties Inner join with Dynamic join properties Referential join with Dynamic join properties Inner join with temporal join properties

Referential join with temporal join properties

What is the effect of using the RODPS_REPL_TEST program to test sap erp operational data provisioning (ODP) data source? There are 2 correct answers to this question. Response: the reset delta function affects all ODP delta queues the program behaves like the sap rsa3 extractor checker the application data is physically written to the queue the program behaves as an additional subscriber

the application data is physically written to the queue the program behaves as an additional subscriber

You created a generic DataSource in SAP ERP using a function module. Which manual activity could you perform to enable your generic DataSource to use as an ODP_SAP DataSource in SAP BW/4HANA? Please choose the correct answer. Response: Generate the PSA table of the DataSource in SAP BW/4HANA Release the DataSource in SAP BW/4HANA for ODP Adapt the function module using transaction ODQMON Run program RODPS_OS_EXPOSE in SAP ERP for the DataSource

Run program RODPS_OS_EXPOSE in SAP ERP for the DataSource

What is the purpose of an architecture overview model? Please choose the correct answer. Response: To automatically generate the LSA++ architecture To determine the sequence of projects To identify the user groups and required authorizations To identify the required data sources

To automatically generate the LSA++ architecture

Your customer converts LSA to LSA++ and needs to streamline the enterprise data warehouse layer.What action do you take?Please choose the correct answer. Response: A. Migrate all SAP Business Warehouse objects to SAP HANA optimized objects. B. Apply the SAP Business Warehouse workspace layer. C. Reduce the number of persistent InfoProviders. D. Apply the Open ODS layer.

C. Reduce the number of persistent InfoProviders.

Which objects are mandatory when you create a transactional data flow in operational data provisioning? Note: There are 2 correct answers to this question. a) O Data transfer process b) O Real-time daemon c) O InfoPackage d) O Transformation

a) O Data transfer process d) O Transformation

Which of the following activities are part of the realization phase of an SAP Business Warehouse (SAP BW) project? Note: There are 3 correct answers to this question. a) O Design the data layer concept based on the LSA++ architecture. b) O Create functional and technical documentation. c) O Define a service level agreement. d) O Build SAP HANA views and define their properties. e) O Create and activate SAP BW objects.

b) O Create functional and technical documentation. d) O Build SAP HANA views and define their properties. e) O Create and activate SAP BW objects.

Which sources are available for a generic SAP Business Warehouse DataSource? Note: There are 3 correct answers to this question. a) O SAP HANA information view b) O Function module c) O SAP HANA remote source table d) O DB view or table e) O SAP query (InfoSet)

b) O Function module d) O DB view or table e) O SAP query (InfoSet)

Which technology do you use to load data from Microsoft Analysis Services to SAP Business Warehouse? Please choose the correct answer. a) Web service b) Universal Data Connect c) Database Connect d) File interface

b) Universal Data Connect

You would like to implement a virtual scenario in yur SAP BW/4HANA system. Which approach does SAP recommend for this kind of scenario? Note: There are 3 correctanswerto this question. Integrate external data into SAP BW/4HANA based on the Write Interface-ebabled DataStore object. Model a CompositeProvider which combines data from multiple SAP BW/4HANA InfoProviders and SAP HANA Views. Generate external SAP HANA view of SAP BW/4HANA InfoProviders to consume SAP BW/4HANA data in SAP HAN Define an Open ODS View which integrates an SAP HANA table into SAP BW/4HAN Load SAP HANA dat into SAP BW/4HANA InfoProviders based on the Operational Data Provisioning (ODP) framework.

Model a CompositeProvider which combines data from multiple SAP BW/4HANA InfoProviders and SAP HANA Views. Generate external SAP HANA view of SAP BW/4HANA InfoProviders to consume SAP BW/4HANA data in SAP HANA Integrate external data into SAP BW/4HANA based on the Write Interface-ebabled DataStore object.

You want to create an SAP BW Query showing data loading statistics provided by the SAP BW/4HANA statisical analysis. Which object does SAP deliver to provide data for your SAP BW Query? Open ODS View ABAP CDS View Badl Provider DataStore object (advanced)

ABAP CDS View

From an SAP BW/4HANA perspective, what is the difference between SAP HANA Smart Data Access (SDA) and SAP HANA Smart Data Integration (SID)? Note: There are 2 correctanswersto this question. SDI provides options for data replication in real-time, while SDA does NOT provide this capability. SDA is integrates into the SAP HANA Indexserver while you need to setup an additional SAP 1-1 HANA Data Provisioning server for SDIcorrect SAP BW/4HANA DataSources of source system type "SAP HANA" can connect to SDA sources, U but NOT to SDI sources. SAP BW/4HANA Open ODS View can be modelled on SDI sources, but NOT on SDA sources.

SDA is integrates into the SAP HANA Indexserver while you need to setup an additional SAP 1-1 HANA Data Provisioning server for SDI SAP BW/4HANA Open ODS View can be modelled on SDI sources, but NOT on SDA sources.

For which SAP Cloud system does SAP recommend using the SAP HANA SDI and its Odata adapter to load data into SAP BW/4HANA? SAP C/4HANA SAP SuccessFactorswrong SAP S/4HANA Cloud SAP Ariba

SAP Ariba

Why do you create a Semantic Group? To create folders for SAP BW Query elements To load InfoObject attribute with Enhanced Master Data Update To generate multiple similar DataStore objects (advanced) To define settings for Data Tiering Optimization (DTO)

To define settings for Data Tiering Optimization (DTO)

ou create a DataStore object (advanced) with only the setting ""Sraging DataStore Object"" and ""Reporting-Enabled"" selected. Which table or combination of tables is used when data is extracted from this DataStore object (advanced) in a data flow? The union of the Inbound table and the Changelog table The union of the Inbound table and the Active Data tablewrong Inbound table only Active Data table only

Active Data table only