|You want to analyze SAP S4/HANA data by selecting a CDS View in SAP Lumira.
Which system component is used for this data retrieval?
SAP Gateway OData Service Analytical Engine SAP Fiori.
You want to check if a customer defined table of the SAP BW System is defined as a row store or columns store. Where do you check the table storage type?
Note there are two corrects answers for this questions SAP GUI transaction SE16 for the SAP BW System SAP GUI transaction SE13 for the SAP BW System The property tab in the SAP BW Modelling Perspective in SAP HANA Studio The Table definition tab in the SAP HANA Administration Console Perspective in SAP HANA Studio.
Which SAP S4/HANA innovations change the way you use datasources to extract data to SAP BW.
Note there are two corrects answers for this question New user experience Simplified data model Cloud deployment SAP HANA Calculation view.
How do you manage Infocube data that is classified WARM according to the multi data temperature management concept of SAP BW powered by SAP HANA. Manage the data in the SAP HANA Extension node Define the data active or not active Move data to the Near Line Storage Move data to corporate memory.
For which existing source systems with the new “SAP HANA source system” in SAP BW Powered by HANA be recommended alternative?
Note there are two corrects answers for this question DB Connect SAP (Service API) ODP – SAP Extractors UD Connect.
You make a SAP HANA Optimized Infocube available for native SAP HANA consumption by enabling the External SAP HANA View flag in the infocube settings.
Which analytic authorization concept is used when you consume the generated SAP HANA view directly? The authorization maintained in S_RS_CUBE in SAP BW only The generated analytic privileges in SAP HANA only The combination of the generated analytic privileges in SAP HANA and the analysis authorization in SAP BW The analysis authorization in SAP BW only.
What is the purpose of SAP HANA Extended nodes in multi temperature data management concept of SAP BW powered by SAP HANA. Provide the WARM tier in a scale up architecture Provide the COLD tier in a scale up architecture Provide the WARM tier in a scale out architecture Provide the COLD tier in a scale out architecture.
You have created a SAP HANA Calculation View that can be consumed in a reporting tool
What are the reason to create a composite provider on top of this SAP HANA calculation view?
Note there are two corrects answers for this question Use referential joins for reporting Use exiting infobjects text Use Analytical Engine capabilities Use analytic privileges for authorization.
You want to extract data from S4HANA cloud to load into SAP BW powered by SAP HANA
Which type of datasource do you need to use? ODP_HANA Datasource ODP_SAP Datasource ODP_CDS Datasource ODP_SLT Datasource.
You run SAP BW on a relational database and manage historical data in SAP Near Line Storage (NLS) on SAP IQ. What is SAP recommendation regarding NLS in the context of preparing a migration to SAP BW Powered by SAP HANA. Compress all NLS requests to the largest extent Enable the delta merge feature in all data archiving processes Empty the NLS and load all data back into the original infoproviders Archive all additional BW data classified as COLD to NLS.
You want to replicate a table from an SAP Business Suite system to an SAP HANA database using SAP Landscape Transformation (SLT). How you can transform data with SAP SLT? Using a SAP HANA Analysis process
Using a parameter based routine Using a SAP HANA store procedure Using a BW transfer routine.
Which the following are the advantages of SAP Near Line Storage (NLS) based on SAP IQ?
Note there are two corrects answers for this questions Archived data on SAP IQ can connect as virtual table to a SAP HANA Schema There is a seamless integration to SAP HANA Extended Nodes The SAP IQ NLS solution can manage the data on Hadoop in order to enhance compression rates SAP HANA e SAP IQ share the same columnar paradigm.
You migrate to SAP BW powered by SAP HANA
By default which table are flagged as not active?
Note there are two corrects answers for this question Active table of the write optimized Datastore object (classic) Active table of the Datastore (Advanced) Infobject text table Persisting Staging Area (PSA) tables.
You would like to implement a mixed scenario for SAP BW powered by SAP HANA.
Which of the following describe the recommended strategy of SAP for mixed scenario?
Note there are two corrects answers for this question Leverage the composite providers to combine data from multiple infoproviders and SAP HANA Views by using unions and joins The SAP BW HANA Analysis process (HAP) enables you to define SAP BW data models for external data such as database tables and database views of any SAP HANA schema Generate external SAP HANA View of SAP BW Infoproviders to consume SAP BW data in SAP HANA The Usage of virtualprovider is highly recommended in case where the SAP HANA View represents a star schema.
You want to use SAP HANA Predictive Analytics Library (PAL) and select a function to classify the customers by the revenues stored in a data store object (advanced) Use the SAP HANA Analysis process (HAP) with the existing ABC analysis process. Implement the ABC classification in a SAP BW transformation Build an SAP HANA Calculation view as a source to use an ABC classification in a SAP HANA Analysis process (HAP) Implement an ABC Classification and use it in the Analysis process Designer (APD).
A business user want to analyze SAP S4/HANA data. Which specification are part of S4/HANA Embedded Analytics? Note there are two corrects answers for this question SAP BusinessObjects Web Intelligence Analytical SAP Fiori Apps SAP Smart Business KPI SAP Lumira.
Which layers are part of SAP HANA optimized layered scalable architecture (LSA++)?
Note there are two corrects answers for this question Virtual data mart layer Corporate Memory Data Acquisition Layer Operational Datastore.
Which of the following are benefits of the database migration option (DMO) of the software update manager (SUM)? Note there are two corrects answers for this question The conversion to Unicode is included A dual stack is automatically split The application server upgrade and database migration to SAP HANA are combined in one tool The infocubes are transformed into HANA Optimized Infocubes by default.
You create a datastore object (advanced) based on the model template infocube. Which of the following tables are when a BW query is executed on this datastore object advanced?
Active data table Inbound and change log table Active data and inbound table Inbound active data and change log table.
How does column base storage enable data to be read faster in SAP HANA?
Individual columns are read optimized by writing into a main store and a delta store Individual columns contain all the information for one record Individual columns can be used in SAP HANA optimized row based format for faster read access Individual columns can be processed at the same time by different cores.
What are some of the advantages using column store table for standard for SAP BW Infobjects?
Note there are 3 corrects answers for this question On the fly calculation of aggregated values is available Decompression is not required for compressed columns Compression Possibilities are offered in case of repeated values in one table field Only a single database process is required the data in case of storing aggregated values Reporting performance is improved by processing the required column only.
You have defined Bex queries based on a multiprovider on top of an infocube which is loaded from a datastore object classic. The transformation under identifies a 1:1 mapping between the datastore object classic and the infocube. Which remodelling approach does SAP recommend as first step to stream line this model based on the Enterprise Data Warehousing (EDW) core concept (LSA++)? Delete the infocube and assign the multiprovider to the datastore object Delete the multiprovider and create a new composite provider instead Convert the infocube in a datastore object advanced Create a composite provider based on the datastore object classic.
Which object can you combine in a composite provider (HCPR)?
Note there are 3 corrects answers for this question SAP HANA Table Multiprovider Open ODS View Composite Provider (HCPR) SAP HANA Information View.
How many physical tables does SAP HANA Optimized Infocube consist of? Five tables: The fact tables for compressed requests, the fact table for uncompressed request and all three standard dimension tables for package time and unit One table: The Fact table only Three table: The fact tables for compressed requests, the fact table for uncompressed request and the dimension table for package Two Tables: The fact table and the dimension table for package.
You want to access a table from another SAP HANA database schema virtually in SAP BW system.
Which of the following SAP BW modelling option can you use?
Note there are 2 corrects answers for this question Define a composite provider built on a SAP HANA Calculation view based on the SAP HANA Table Replicate SAP HANA Table into the SAP BW managed schema with SAP LT Replication Create and Open ODS View directly based on the SAP HANA Table Implement Real Time Streaming into SAP BW based on Smart Data Integration.
You want to migrate a SAP BW to SAP BW on HANA. What can you do in SAP BW Migration cockpit (report ZBW_HANA_MIGRATION_COCKPIT)?
Note there are 2 corrects answers for this question Determine the database size relevant for BW on SAP HANA sizing Convert Multiprovider in Composite Provider Execute a dual stack split Transfer a semantically partitioned object (SPO) into an Advance Datastore Object.
You load data into a SAP HANA optimized Infocube. Which generated ID related to infobjects are written into tables of incube? The surrogate IDs (SID) are written in the fact table The dimension IDs (DIM) are written in a dimension table The dimension IDs (DIM) are written in the fact table The surrogate IDs (SID) are written in a dimension table.
For infobject A you need to provide new master data information which is already available as display attribute C in infobject B. Infobject B is an attribute of infobject A. Which data modeling approach does SAP recommend? Activate the real time access for infobject A to access infobject B Add attribute C as transitive attribute in infobject A Combine infobject A and B in a composite provider to access attribute C Switch attribute C in infobject B from display attribute to navigational attribute.
You want to use some time information like calendar week and or calendar quarter in your SAP BW data model. Which is the best practice to implement this requirement? Use time characteristics as attributes in the new version of infobject Create your own infobjects and use a SQL procedure in your SAP transformation to calculate this time information Use the read access type HANA VIEW to connect the infobject 0DATE to a SAP HANA Calculation view Use the content time characteristic like 0CALWEEK or 0CALQUARTER directly in your data model.
In operation Data Provisioning (ODP) with SAP BW as subscriber, the Operational Delta Queue is normally managed by the providing source system.
In which ODP context is data managed in ODQ of the subscribing SAP BW system? ODP – SAP ABAP Core Data Services ODP – SLT Queue ODP – SAP HANA Information View ODP – SAP Extractors.
You model a Open ODS View based on simple SAP HANA Table.
You would like to persist the data in a SAP BW object based on Generated Dataflow Function.
Which objects are automatically generated?
Note there are 3 corrects answers for this question Infosource Datastore object (Advanced) Infopackage SAP BW transformation Data Transfer Process.
How should you organize data provisioning, data storage and data consumption in SAP BW on HANA? Direct use of SAP HANA table instead of SAP BW Persistence to benefit from SAP BW to benefit from SAP HANA Performance Use SAP BW Aggregates (Cube Based) to increase SAP BW Performance Reduce redundant persistence layer in SAP BW Replace all SAP BW Composite providers with SAP HANA Calculation Views.
You plan to migrate to SAP BW Powered by SAP HANA.
You are looking for a single tool to provide easy access to housekeeping tasks like deletion of CLAPS Statistics, deletion of application logs and archiving for IDOCS. Which tool do you use? SAP BW Migration cockpit Application specific upgrade toolbox Software update manager Software provisioning manager.
You want to enable the consumption of Native SAP HANA Views (calculation VIEW) in a composite provider. Which prerequisites do you have to ensure?
Note there are 3 corrects answers for this questions With a SAP BW User, logon to a BW Project for your BW Connection in BW Modelling tools Add the SAP HANA Database as a system to the sap HANA systems views and log with a database user Attach a SAP BW Project to the SAP HANA System Attach the SAP HANA System to the project with the BW connection With a SAP BW User log on to an ABAP Project for your BW Connection in BW Modelling tools.
You would like to build a SAP HANA Calculation view to combine transaction and master data.
In a new SAP HANA Calculation View you want to sum up measures from a table and leverage hierarchies and text labels from several existing SAP HANA Calculation View (category dimension).
Which type of calculation view do you choose? Data Category Cube marked as Star JOIN Data Category Cube not marked as Star JOIN Data Category Default Data Category Dimension.
Which objects can you use as an ODP Provider in Operation Data Provisioning (ODP)?
Note there are 2 corrects answers for this question SAP HANA Tables OData Providers SAP ERP Extractors SAP HANA Calculation views.
Which of the following process type used in process chains are obsolete in SAP on HANA?
Note there are 3 corrects answers for this question Build Index for SAP BW Infocubes Deletion of request from PSA Refresh Database statistics Compress of SAP BW Infocube Adjust time dependent aggregates for SAP BW infocubes.
What are valid reasons to create an external SAP HANA VIEW based upon on SAP BW Object?
Note there are 2 corrects answers for this question Use SQL script in the definition of calculated column Leverage the SAP BW Analytic Engine Setup compounding relationship Consume the data in a third-party reporting tool.
Which new functions are offered with the SAP HANA XS advanced infrastructure?
Note there are 2 corrects answers for this question Use the new open Github as a repository Maintain SAP HANA analytic views in SAP HANA Modeling Perspective Use an enhanced web based development environment with more node type Model SAP HANA Calculation Views in the SAP BW modeling perspective.
Which steps are essential requirements in order to set up a real time data streaming process based on the sap hana source system in SAP BW on HANA?
Note there are 3 corrects answers for this question Create a SAP BW Process Chain and Set it to Streaming Mode Create a SAP Open ODS View based on the SAP HANA connection Create a datastore advanced with direct update and switch on the “streaming mode for the corresponding DTP” Create an SAP HANA remote connection based on SAP HANA Smart Data Integration adapter Create a datastore object (advanced) and a SAP BW transformation connecting the SAP BW datasource.