B_W_207

Which steps are required to set up a real-time data streaming process based on the ""SAP HANA Smart Data Access (HANA_SDA)"" source system in SAP BW/4HANA? Note: There are 3 correct answers to this question. Set upan Open ODS view based on the SAP HANA remote source and associate InfoObjects to U each field. Create a CompositeProvider on top of the DataStore object (advanced) and define a BW Query on top of it. Create a DataStore obhet (advanced) and a Transformation including DTP connecting the BW DataSource. Create n SAP HANA remote source based on an SAP HANA Smart Data Integration adapter and a 1- 1 BW DataSource related to it. Create a Process Chain that executes the DTP, set it to "Streaming mode", and schedule it.

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 correct answers to 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 SDI. 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.

You create a DataStore object (advanced)with only the setting ""Staging 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 table. Inbound table only. Active Data table only.

You use an Open Hub Destination to distribute SAP BW/4HANA data to a table managed by an SAP database. Which technologies can be used? Note: There are 2 correct answers to this question. Operational Data Provisioning (ODP). Database Connection (DBCON). Smart Data Access (SDA). Remote Function Call (RFC).

Which operations can you perform in the SAP BW/4HANA Cockpit? Note: there are 3 correct answers to this question. Monitor Process Chains. Manage requests of DataStore objects (advanced). Create and maintain BW Query variables. Create and maintain indicesfor DataStore objects (advanced). Create and maintain Analysis Authorizations.

You use the SAP BW/4HANA Transfer Cockpit to prepare your SAP BW system for an in-place conversion to SAP BW/4HANA. Which functions are provided by this cockpit? Note: There are 2 correct answers to this question. Execute Pre-Checks. Transfer 3.x DataFlow into 7.x DataFlows. Transfer Bex Queries into BW Queries. Transfer Standard Authorizations.

What is a valid reason to run the program RODPS_OS_EXPOSE?. To use an SAP ABAP CDS View for ODP. To have an overview of ODP Consumers of a DataSource. To release a customer developed DataSource for ODP. To investigate extractor logic in an SAP delivered DataSource For ODP.

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

Which of the following SAP BW/4HANA objects support the automatic generation of external SAP HANA views? Note: There are 2 correct answers to this question. Open ODS View. BW Query. InfoObject Characteristic. DataSource.

Which BW object type do you need to create a Badl Provider?. DataStore object (advance) in Planning Mode. InfoObject. DataStore object (advance) with Direct Update. CompositeProvider.

You use a customer master data table as a left table and a transactional sales data table as a right table within a graphical SAP HANA Calculation View. You want to focus in your report on transactional data showing both: customers with sales volume and without. Which join type should be used?. Full Outer Join. Referential Join. Left Outer Join. Right Outer Join.

In an SAP BW/4HANA system you olan to leverage Data Tiering Optimization (DTO) for a DataStore object (advanced). Which activities are required to set up the HOT tier as well as the COLD tier for this object properly? Note: there are 2 correct answers to this question. Define partitions for the DataStore object (advanced). Choose between Temperature Maintencance "On Partition Level" or "On Object Level". Create a Data ArchivingProcess (DAP) for the DataStore object (advanced). Define the planned temperature for each partition.

A customer wants to know the difference between LSA and LSA++ to define a layered scalable architecture. Which layers are only presented in LSA+ + ? Note: There are 2 correct answers to this question. Open Operational Data Store Layer. EDW Propagation Layer. Corporate Memory. BW Workspace Layer.

You enable a DataStore object(advanced) for reporting by switching on the ""External SAP HANA view"" flag in the settings. Which authorizations are used when you consume the generated SAP HANA view directly?. The generated analytic privileges in SAP HANA. The authorizations forthe HDI container access in SAP HANA. The combination of the generated analytic privileges in SAP HANA and the analysis authorizations in SAP BW/4HANA. The analysis authorizations in SAP BW/4HANA.

What is a valid data target in an SAP HANA Analysis Process without using a Data Trasfer Process?. DataStore object (advanced). InfoObject with Attributes. SAP HANA Database Table. CompositeProvider.

You want to load data from an SAP BW/4HANA system into another SAP BW/4HANA system using Operational Data Provisioning (ODP) of type ODP_BW. Which objects can be used as a source? Note: There are 3 correct answers to this question. DataStore object (advanced). ABAP CDS View. InfoObject Characteristic. CompositeProvider. Open ODS View.

You want to create an SAP BW Query showing data loading statistics provided by the SAP BW/4HANA statistical 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).

How does column-based storage enable data to be read faster in SAP HANA?. Individual columns contain all of the information for ine record. Individual columns are read-optimized by writing into a main store and a delta store. Individual columns can be transferred to an SAP HANA optimized row-based format for faster access. Individual columns can be processed at the same time by different CPU cores.

You want to load datafrom SAP Ariba to SAP BW/4HANA. Which object in SAP BW/4HANA does SAP recommend to use for this scenario?. DataStore of type ODP_CDS. Write Interface-Enabled DataStore Object. Direct Update DataStore Object. DataStore of type ODP_HANA.

Which objects can be used as components in a CompositeProvicler in SAP BW/4HANA? Note: There are 3 correct answers to this question. CompositeProvider. Open ODS View. SAP HANA Calculation View. BW Query. SAP ABAP CDS View.

Which effects do you expect for a BW Query if youset the SAP HANA runtime mode, called ""Operations in SAP HANA"", to the value ""[^(Standard)""? Note: There are 2 correct answers to this question. A cluster of InfoProviders with a homogenous mapping is created (expert mode 3). The user can manually choose the expert mode 3,8 or 9 by himself. The system supports the calculation of condition (expert mode 9). The system supports formulas with a complex currency or unite (expert mode 8).

You want to use a referential join for a combination of transactional data (left table) and master data (right table). How will this referential join be processed? Note: there are 2 correct answers to this question. It is executed only when columns from both tables are requested. It shows all transactional data with an existing master data record. It shows all master data to assure the referential integrity. It is an inner join that assumes that referential integrity is given.

Which features have been removed from SAP BW/4HANA compared to SAP BW powered by SAP HANA? Note: there are 2 correct answers to this question. Execute Analysis Process (APD). Execute Data Archiving Process (DAO). Trigger Delta Merge. Attribute Change Run.

What is a valid scenario using the External Tier (COLD Store) in the SAP BW/4HANA Data Tiering Optimization (DTO) concept?. To move a large amount of historical data needs to be read occasionally in SAP BW Queries. To improve the qery performance of an SAPBW Query for aggregated year-to-date values. To reduce the TCO bases on the implementation of the Active/ Non-Active Data Concept. To create an offline archive for transactional data to ensure legal requirements are fulfilled.

What do the Remote Conversion approach and the Shell Conversion approach have in common? Note: There are 3 correct answers to this question. Both approaches uninstall the unsupported BW Add-ons from the sending BW system as the first activity. Both approaches convert unsupported object types during import into the new SAP BW/4HANA system. Both approaches result in a SAP BW/4HANAsystem which has a new system ID. Both approaches require the SAP BW/4HANA Starter Add-on to be installed on the sending system. Both approaches are setup by installing required SAP notes via the SAP BW Notes Analyzer.

You are running SAP S/4HANA On-Premise. You would like to extract data to SAP BW/4HANA. Which tool does SAP recommend to evaluate the metadata of CDS-based extractors?. SAP S/4HANA Query Browser. SAP BW/4HANA Cockpit. SAP BW/4HANA Modeling Tools. SAP S/4HANA View Browser.

Which transformation rules do support SAP HANA Runtime? Note: There are 3 correct answers to this question. ABAP end routine. SQL procedure in an SAP HANA FlowGraph. ABAP Field rountine. SQL script field routine. Lookup from DataStore object (advanced).

You would like to implement a virtual scenario in your SAP BW/4HANA system. Which approach does SAP recommend for this kind of scenario? Note: There are 3 correct answer to this question. Integrate external data into SAP BW/4HANA based on the Write Interface-ebabledDataStore 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 HANA. Define an Open ODS View which integrates an SAP HANA table into SAP BW/4HANA. Load SAP HANA data into SAP BW/4HANA InfoProviders based on the Operational Data Provisioning (ODP) framework.

You want to load a customer table to SAP BW/4HANA in delta mode. The customer table is managed in SAP S/4HANA Cloud. Each record has an UTC time stamp. What is recommended approach to implement this extraction?. Create a DataSource in SAP S/4HANA which leverages the generic delta based on the time stamp. Create an ABAP CDS View in SAP S/4HANA which is enabled for extraction and model the Change Delta Capture (CDC) logic based on the time stamp. Create an ABAP CDS View in SAP S/4HANA which is enabled for extraction and generates the delta based on the time stamp. Create an SAP HANA CDS View in SAP SS/4HANA which leverages a procedure to generate the delta based on the time stamp.

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 SuccessFactors. SAP S/4HANA Cloud. SAP Ariba.

Why do you use the ' "Enhanced Master Data Update"" setting inthe definition of an InfoObject? Note: there are 2 correct answers to this question. To enable parallel loading. To enable transitive attributes. To enable delta capability. To enable XXL attributes.

Which SAP HANA XS classic information view can you convert directly into an SAP HANA HDI Calculation View?. SAP HANA Calculation View (scripted). SAP HANA Analytic View. SAP HANA Attribute View. SAP HANA Calculation View (graphical).

In SAP BW/4HANA you decide to switch on the External Tier (COLD Store) for a DataStore object (advanced) based on the Data Tiering Optimization (DTO)concept. Where can the data be managed? Note: there are 2 correct answers to this question. In an SAP IQ database. In SAP HANA on an extension node. In SAP HANA Native Storage Extension. In the file system of a Hadoop cluster.

A customers wants to convert from SAP BW powered by SAPHANA to SAP BW/4HANA. What additional value is offered by SAP BW/4HANA compared to SAP BW powered by SAP HANA?. Storing data of DaraStore objects (advanced) in Extended Tables. Creating HANA Analysis Processes (HAP). Generating external SAP HANA Views for SAP BW Queries. Leveraging the Data Tiering Optimization (DTO) concept.

The SAP BW/4HANA StarterAdd-on is installed and set to the Compatibility mode. How is the SAP BW system affected? Note: There are 2 correct answers o this question. New InfoCubes can be created after getting approval by a whitelist. The SAP BEx Analyzer is decommisioned. Virtual InfoProviders for Planning are still allowed. All objects can be changed after getting approval by a whitelist.

A customer uses an SAP BW 7.5 system powered by SAP HANA with the SAP BW/4HANA Starter Addon. The system mode is set to ""B4H mode"". How will the system be affected?. 3.x Data Flows can still be used if they are registered in the whitelist. Semantically Partitioned Objects (SPOs)can be maintainedwith the SAP BW/4HANA Modeling U Tools. SAP BW/4HANA Modeling Tools are needed to maintain BW Queries. MultiProviders are automatically converted into Composite Providers.

You model an Open ODS View on an SAP HANA table. You would like to persist the data in a SAP BW/4HANA object based on the 'Generate Dataflow...' function. Which objects are created automatically? Note: there are 3 correct answers to thi s question. DataStore object (advanced). DataSource. InfoPackage. InfoSource. Transformation.

What is the recommended and supported way to virtually consume data in SAP BW/4HANA based on SAP ABAP CDS View?. Model a Composite Provider which consumes an SAP HANA Calculation View which refers to the u SAP ABAP CDS View. Model a Composite Provide which directly consumes the SAO ABAP CDS View. Model an Open View of source type "Dattabase Table or View" which refers to the SAP ABAP CDS U View. Model an Open ODS View of source type "DataSource (BW)"which refers to the SAP ABAP CDS U View.

What are valid reason to generate external SAP HANA View for SAP BW/4HANA objects? Note: there are 2 correct answers to this question. To consume SAP BW/4HANA data and manage access with native SAP HANA concepts. To apply SAP HANA transformational logic instead of SAO ABAP logic. To leverage the SAP HANA-optimezed Analytic Manager to process BW Query. To create an additional persistent layer of data in SAP HANA.

Which features have been removed from SAP BW/4HANA compared to SAP BW powered by SAP HANA? Note: There are 2 correct answers to this question. Analysis Process Designer (TC: RSANWB). Analysis Authorizations (TC: RSECADMIN). Customer Exit variable using RSR00001 (TC: CMOD). Modeling option of secondary indices for DataStore objects (advanced).

Which statements about the table structure of the Data Store object (advanced) are correct? 3 Answers. SAP provides a database view for reporting purposes (/BIC/A<technical name>7). SAP creates compatibility views for Data Store object (advanced) to keep existing custom coding safe. SAP recommends using the generated external SAP HANA view if the Data Store object (advanced) serves as a source for data extraction. SAP provides a database view for external SQL access (/BIC/A<technical name>8). When data is loaded to a Direct Update Data Store object (advanced), the inbound table is loaded first.

A customer wants to convert from SAP BW powered by SAP HANA to SAP BW/4HANA. Which strategy does SAP recommend based on successor object types? (3 Answers). Use Open ODS Views to establish virtual access for master and transactiona data. Use ODP_SAP source system type instead of a DB-connect. Use Composite Providers instead of InfoSet. Use Write Interface-Enabled Data Store object (advanced) instead of Virtual Providers. Use Semantic Group to organize big data volumes in Data Store object (advanced).

You want to create SAP HANA HDI Calculation View that consumes an External SAP HANA view representing a Data Store object (advanced). What needs to be defined? (2 Answers). Cross-schema Service. Delivery Unit. Package. Synonym.

Which of the following statements describe the benefits of the SAP BW/4HANA Content Add-on? (3 Answers). The content follows the LSA++ recommendation and delivers an LSA++ aligned structure. The content delivers Transformations that are optimized to enable push-down to SAP HANA. The content leverages new navigational attributes of the SAP standard time Characteristics. The content delivers predefined settings for SAP BW/4HANA Data Tiering Optimization (DTO). The content delivers optimized process chain to load LSA++ structured data models.

Which statement describes the “Intelligent PULL Run Mode” of Streaming Process Chain property?. SAP BW/4HANA receives a trigger from a Daemon in the source system. This event runs the Process Chain immediately. SAP BW/4HANA checks once a minute if a new record is generated in the source system. If this check is successful, the Process Chain starts immediately. The concept is obsolete in SAP BW/4HANA. SAP recommends leveraging the new “PUSH Run Mode” for Streaming Process Chain instead. An SAP BW/4HANA Process Chain is scheduled as a periodic job with high frequency up to each minutes. The Process Chain runs accordingly.

What are key results provided by the SAP BW/4HANA Readiness Check? (3 Answers). List of all BW/4HANA incompatible BW objects in the system. List of all missing SAP notes for installing the SAP BW/4HANA Transfer Cockpit. List of all BW/4HANA incompatible SAP ERP DataSource. List of largest database table and additional sizing information. List of all BW/4HANA incompatible add-ons in the system.

You plan to virtually consume data form an ABAP CDS View in SAP BW/4HANA and decide to use an Open ODS View. Which source type does SAP recommend?. Datasource (BW). Database Table View. Transformation. Virtual table using SAP HANA Smart Data Access).

In SAP BW/4HANA you decide to switch on the External Tier (COLD Store) for a DataStore object (advanced) based on the Data Tiering Optimization (DTO) concept. Where can data be managed?. SAP ASE Database. SAP HANA Extension Node. SAP IQ Database. SAP HANA Native Storage Extension.

What is a valid reason to leveraging SAP HANA Native Storage Extension (NSE) in the SAP BW/4HANA Data Tiering Optimization (DTO) concept?. To create an offline archive for data, to ensure legal requirement are fulfilled. To move historical data that only needs to be read exceptionally to an external storage. To aggregate data and improve the reporting performance for year-to-date values. To reduce the SAP HANA memory consumption of data that is only used infrequently".

You create an SAP HANA HDI Calculation View in SAP Web IDE for SAP HANA and have to select a data category. Which data category can only use attributes in the Semantic nodes?. Cube with Star Join. Cube. Dimension. SQL Access Only.

What are characteristics of SAP HANA modelling in XS Advanced? (2 Answers). Import of SAP HANA HDI Calculation View as a file in a project. Use of SAP HANA Studio as a user interface. Deployment of external SAP HANA views generated from BW objects. Potential use of GitHub as a source code repository.

You imported a project into SAP Web Ide for SAP HANA to develop an SAP HANA HDI Calculation View. At which level do you have to assign a space?. Package. HDB Module. Project. Workspace.