Which advanced Datastore object modeling templates are available in SAP Business Warehouse?
There are 2 correct answers to this question.
Open ODS view Data acquisition layer
Compositeprovider
Corporate memory with compression.
You create a transformation from a DataSource to a standard DataStore object. The DataSource provides an after-image delta. Which key figure aggregation type do you select?
Please choose the correct answer.
Summation
Maximum Minimum
Overwrite.
Which query element contains the OR operator?
Please choose the correct answer. Default value filter Characteristic restriction filter Calculated key figure
Re stricted key figure.
A report based on a query shows a list of months with the sales volume. How can you enhance the query to include the number of contributed to the monthly sales Volume?
Please choose the correct answer.
Insert a formula with the sales volume key figure as operand.in the formula properties, select the counter for all detailed values option from calculate single value setting. Insert a formula with sales volume key figure as operand.in the key formula properties, choose the counter (ALL Values) exception aggregation option with the customer reference characteristic. Insert the sales volume key figure once more into the query in the key figure properties, select the counter for all detailed values option from calculate agers
Insert the sales volume key figure, once more into the query. in the key figure properties, choose the counter (ALL Values) exception aggregation with the customer reference characteristic.
Your customer wants to activate SAP HANA-Optimized business content to store historical data. Which layer do you use?
Please choose the correct answer.
Corporate memory layer
ODS layer
Virtual data mart layer.
Your customer's sales department wants to combine spins warehouse (SAP BW) data with from a flat file in an SAP BW workspace. Which tool do you used?
Please choose the correct answer. SAP BW designer
SAP Business objects Analysis for Microsoft office
SAP HANA Studio SAP Lumira.
You need to generate SAP HANA views SAP based on Business Warehouse (SAP BW) infoproviders. Which activities do you perform to consume the
There are 2 correct answers to this question. Migrate the SAP BW user roles in the HANA user.
Create an SAP HANA user with the identical name as the SAP BW user. Assign the SAP HANA user in SAP BW user administration
Create an SAP HANA role on the SAP BW role.
Before you can use a DB connect data flow in SAP Business warehouse (SAP BW), which of the following tasks must you perform?
There are 3 correct answers to this question.
Create a Data source on database tables and views with technical names in uppercase letters.
Install a date base-specific client for the source RDBMS on the SAP BW application server.
Create a Data source on database tables and views with technical names in lowercase letters. Install an SAP-specific Database shared library on the SAP BW application server. Load the RDBMS meta base into a table in SAP BW that the data source can access.
You need to create an SAP Business Warehouse data flow that combines data from two sources in an advanced Datastore object (DSO) There are different and value for the same entry in the source.
Which approach does SAP recommend?
Please choose the correct answer. Create an open ODS as a non-persistent intermediate layer to perform a join from the source dependent parts need to be implemented in the same transformation.
Create an infoset as a non-persistent intermediate layer.the source-dependent parts of the transformation need to be implemented before the info set. Create a composite provider as a non-persistent intermediate layer to perform a join from the source the source-dependent parts need to be implemented in the same transformation. Create an infosource as a non-persistent intermediate layer.the source-dependent parts of the a transformation need to be implemented before the info source.
You create an advanced Data store (aDSO) Based on a standard DSO template to store consolidation data. Which options do you have to define the object model?
There are 3 correct answers to this question.
Aggregate Data Unique Data Records
Write change log Activate/compress Data
Delete change log.
You need to transfer delta data and ensure Full Quality of Service. You are using an SAP Business Warehouse Web service. Which SAP Process Integration (SAP PI) adapter do you use?
Please choose the correct answer.
SAP PI File Transfer Protocol adapter SAP PI ABAP proxy communication adapter SAP PI Simple Object Access Protocol Call adapter SAP PI Remote Function Call adapter.
Which of the following statements are true regarding the differences between compounding and concatenation?
There are 4 correct answers to this question.
Compounding is easier to filter in queries because the objects are seperate whereas with concatenation, the key string needs to be marked
Compounding is easier for users to understanding because it is based on a 1:1 object mapping but concatenation is more complex for users to understand and decipher
Concatenation uses a single key value but compounding uses more than one Adding key fields in concatenation is easier because only the transformation needs to be changed but in compounding structres need to be changed and date re-loaded
Concatenation is supported in the definition of the InfoObject whereas compoubding is only relevant for transectional data.
Which infoprovider do you use for SAP Business waclonsé7.s Powered by SAP HANA to replace the multi providers for reporting?
Please choose the correct answer. Advanced Data store object
Virtual provider Composite provider Info object as info provider.
In an SAP Business warehouse query, you have two structures with intersecting with interacting formulas. What is the default behavior when you run the query?
Please choose the correct answer.
The formula contained in the structure that was saved first is used. The formula contained in the structure that was saved last is used
Both formulas are ignored and the cell shows an error
The formula contained in the structure in the rows is Used.
What is the maximum number of key fields that an advanced data store objects can contain?
Please choose the correct answer.
120 key fields 64 Key fields 16 Key fields
256 Key fields.
Your customer wants to link a query to an external URL. Which of the following steps are required for a report-report interface setting?
There are 3 correct answers to this question.
Insert the parameter for the Web address in the assignment details Select the Web address from the list of report types.
Select Receiver Object and enter the Web address.
Select a system from the Source Systems tab.
Insert the Web address in the assignment details.
What objects must you create when you load external appar aged fo SAP Business warehouse with a web service Data source?
There are 2 correct answers to this question.
A daemon background process
A PSA table after the web service Data source An info package for the web service Data source
A web service after the web service Data soured.
Which of the following data provisioning tools are provided by SAP HANA smart integration?
There are 2 correct answers to this question. Data provisioning Agent configuration SAP Data services software
SAP Business warehouse Data source adapter
Adapter software development kit.
Your customer needs views of data, defined by multiple conditions you create multiple conditions in a query and activate multiple conditions in the report. What is the effect on the report result?
Please choose the correct answer. The report result depends on the application of a logical AND between the conditions.
The report result depends on the activation sequence of the conditions. The report result depends on the application of a logical OR between the conditions.
The report result is independent of the report drilldown.
Where can you set a variable offset to a time-based characteristic?
Please choose the correct answer
In the characteristic definition in the data warehousing workbench in the SAP A studio In the key figure's characteristic variable restrictions in the SAP business warehouse query Designer in the SAP HANA studio.
In the calculated key figure dialog in the SAP business warehouse query Designer in the HANA studio
In the info provider definition in the data warehousing workbench in the SAP HANA.
What can you do with a condition?
There are 2 correct answers to this question.
Restrict combinations of characteristics using a structure Define filter restrictions. Define value limits.
Analyze combinations of characteristics using ranked lists.
Your customer wants to integrated streaming data into SAP HANA. What do you need to create?
Please choose the correct answer.
An SAP smart data integration remote source in the administration console of the SAP HANA studio. An SAP Business warehous dats ource for smart data integration in the administration console of the SAP HANA studio. An SAP HANA Source system in the SAP HANA modeler of the SAP HANA studio.
A database connect Data source SAP Business warehouse modeling tools of the SAP HANA studio.
What are some of the advantages of SAP HANA smart data integration?
There are 3 correct answers to this question.
A Methodology for streaming data into SAP Business warehouse A Methodology to efficiently integrate external data into SAP Business warehouse
A replacement for the Universal Data connect and database connect data a on technologies
A Methodology to bypass the use of SAP Business Warehouse data transfer processes
A Methodology to efficiently transform data in SAP Business warehouse.
You use an API to trigger a process chain in streaming mode. Which process type do you use?
Please choose the correct answer. Data transfer process on SAP HANA Data source Data transfer process on advanced Data store object Data transfer process on standard Data store object Data transfer process on operational data provisioning Data source.
What do Database connect, universal date connect, and the SAP business warehouse service API have in common?
Please choose the correct answer.
The delta queue exists
The direct access is available The Data source must be created directly in SAP Business warehouse. Using the persistent staging Area is mandatory.
Which combination of database tables is used when you model an nee data store object like an info cube?
Please choose the correct answer.
Active data and inbound Table
Change log and inbound Table Active data and change log
Active data,inbound table,and change log.
Which of the following activities are part of the realization phase of an SAP Business Warehouse (SAP BW) project?
There are 3 correct answers to this question. Define a service level agreement.
Create and activate SAP BW objects. Design the data layer concept based on the LSA++ architecture. Create functional and technical documentation.
Build SAP HANA views and define their properties.
Which technology do you use to load data from Microsoft Analysis Services to SAP Business Warehouse?
Please choose the correct answer.
File interface
Universal Data Connect
Database Connect Web service.
Which objects can you use to trigger delta merge?
There are 2 correct answers to this question.
Transformation Infopackage
Data transfer process
Process chain.
Your customer needs to link two queries with a report-report interface (RQ transaction RSBBS which parameters do you set in the query sender to jump to the query receiver.
There are 3 correct answers to this question.
Sender system RFC Destination Report type Receiver object Target system.
Which tool do you use to monitor streaming process chains?
Please choose the correct answer.
Real-time Data acquisition monitor
Queued Task manager monitor Subscription monitor
Operational Delta Queue monitor.
You entire data model for SP easiness warehouse (SAP BW) Project consists of SAP BW data models and SAP HANA data models. How can you attain SAP HANA views directly from the SAP BW project?
Please choose the correct answer.
Attach the SAP HANA system to the SAP BW project.
Use the External SAP HANA view option.
Use the link with editor function.
Drag SAP HANA views to the SAP BW repository tree.
You need to define an authorization that allows the analyst to save and changed queries. Which authorization objects do you need to assign and configure?
Please choose the correct answer. S_RS_DS andS_RS_IOBJ
S_RS_AUTH and S_RS_COMP
S_RS_CUBE and S_RS_10BJ S_RS_Comp and S_RS_CoMP1.
What can you define in the BEx Query Designer cell editior?
There are 3 correct answers to this question.
Variables with the replacement path option to pass values to reference cells. Help cells thet serve as containers for help selections or help formulas. Formulas and selection conditions for cells to solve formula collision. Additional filter restrictions that apply to a complete column or row of the result set.
You use the query monitor transaction (RSRTI) to investigate the poor performance of a query. Which actions do you perform when you use this transaction?
There are 3 correct answers to this question.
Maintain the technical info of the query. Change the query definition
Execute the query without using the cache
Maintain the read mode and the cache mode of the query. Debug the query.
Which activities do you perform when you create a epic data flow for master date?
There are 3 correct answers to this question.
Modify non-persistent info objects and assign them to the date transfer process Create a non-persistent source system and non-persistent Data source Add non-persistent infobjects and non-persistent Data source. Add or create persistent info objects, Data source transformation and a data transfer process. Create a non-persistent transformation and non-persistent data transfer process to connect both.
Your customer uses a flat file data source to load data into an advanced (infocube-like) data store object (aDSO) transfer process is having loading data what might be the cause?
There are 2 correct answers to this question.
The data source's delta process is set to FiL1 Data flow objects is NOT set to active.
The datasource's delta process is set to FILO.
The data source's delta process is set to delta only using full upload.
Which objects are mandatory when you create a transactional data flow in operational data provisioning?
There are 2 correct answers to this question.
InfoPackage Real-time daemon Data transfer process
Transformation.
Why is graphical date flow modeling preferred over classical data flow modeling?
There are 2 correct answers to this question.
It provides a better overview of the data flows. it helps you define your own templates to set standards for your customer. You can execute it to load date you can view it using the SAP Business warehouse modelling tools of the SAP HANA Studio.
Which advantage you have if you use universal Data connect(UD Connect)instead of Database connect(DB Connect)
Please choose the correct answer.
UD connect is based on SAP Netweaver Application server for ABAP. UD connect uses the SAP Specific Database shared Library(DBSL) UD connect provides the ABAP software development kit(SDK) UD connect provides connectivity to external multidimensional data sources.
|
