Questions
ayuda
option
My Daypo

ERASED TEST, YOU MAY BE INTERESTED ONBW 3

COMMENTS STATISTICS RECORDS
TAKE THE TEST
Title of test:
BW 3

Description:
BW test 3

Author:
Basit304
(Other tests from this author)

Creation Date:
23/01/2022

Category:
Others

Number of questions: 27
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
You need to use SAP Data services for a controlled distribution of SAP Business warehouse (SAP BSD) to legacy systems and application. Which of the following activities must you perform? There are 3 correct answers to this question. Create an SAP BW process chain to control data distribution. Create a Data store in SAP Data services based on the Data source Execute the SAP BW Process chain from SAP Data services. Craete a generic Data source in SAP BW as part of the data flow. Create an SAP BW data flow to an open hub destination.
Why do you create a Semantic group for a data transfer process object? Please choose the correct answer. To flag all relevant data a business rule To create Pit filter to load data into the persistent staging Area(PSA) To sort all independent data in one data package To assign additional customer fields to the loaded data structure.
In accordance with the layered scalable architecture, which layers represent the architected data mart layer? Please choose the correct answer. Harmonization layer.Reporting layer.reporting later.Virtualization layer Harmonization layer.Business transformation layer.Virtualization layer Business transformation layer.reporting layer.Virtualization layer Data propagation layer.reporting layer.Virtualization layer.
You execute an SAP Business warehouse (SAP BW) Source query and jump to a target SAP BW query with the report interface. What information is transferred by default? There are 3 correct answers to this question. Runtime properties Fixed filter values Filters from the selected restricted key figure Default filter values Filters by measure.
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. Additional filter restrictions that apply to a complete column or row of the result set. Help cells thet serve as containers for help selections or help formulas. Formulas and selection conditions for cells to solve formula collision.
Your customer has an existing cube calculation view of global sales in various currencies. What should you do to convert all revenues to th currency? Please choose the correct answer. Add an additional cube calculation view for the currency conversion. Add a calculation view including a calculated column on a measure. Join the cube calculation view to an additional dimension view. Join the cube calculation view to a calculation view a restricted column for each currency.
You use SAP Landscape Transformation Replication sees th operational data provisioning. Which of the following data acquisition features are provided? There are 3 correct answers to this question. Real-time replication to SAP Business warehouse Direct update to SAP Business warehouse info providers Ability to use simple coded mapping rules Ability to use complex coded mapping rules Removal of restrictions for extractors.
Our customer wants to create a composite provider to combine data form two advanced Data store objects(DSO). Which operation does the system propose, by default to combine the data of both advanced DSOs? Please choose the correct answer. Inner join Union Join Left Outer join.
Which activities do you perform when you create a epic data flow for master date? There are 3 correct answers to this question. Create a non-persistent transformation and non-persistent data transfer process to connect both. Add or create persistent info objects, Data source transformation and a data transfer process. Create a non-persistent source system and non-persistent Data source Modify non-persistent info objects and assign them to the date transfer process Add non-persistent infobjects and non-persistent Data source.
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. Execute the query without using the cache Debug the query Maintain the technical info of the query. Change the query definition Maintain the read mode and the cache mode of the query.
Which tool do you use to monitor streaming process chains? Please choose the correct answer. Queued Task manager monitor Operational Delta Queue monitor Subscription monitor Real-time Data acquisition monitor.
You want to copy an SAP Business warehouse query from a source info provider to a target info provider. Which prerequisite must be fulfilled? Please choose the correct answer. The query to be copied must NOT contain reusable query components. The type of the source info provider and the target info provider must be the same The target info provider must contain at least all the info objects.
Where can a characteristic be restricted in the BEx query definition? Please choose the correct answer. in the query properties, in the general tab. In the characteristic's context menu in the info provider section in the query properties, in the Extended tab. In the characteristic's context menu in the default value section.
Which of the following tasks can you perform using the data warehousing workbench? There are 3 correct answers to this question. Manage advanced Data store objects Activate master data. Create advanced Data store objects. Create an info package. Create open ODS views.
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. Reduce the number of persistent InfoProviders. Apply the SAP Business Warehouse workspace layer. Migrate all SAP Business Warehouse objects to SAP HANA optimized objects. Apply the Open ODS layer.
You need to remodel a characteristic infobject and the remodeling toolbox. Which activities can you perform? There are 2 correct answers to this question. Add or delete a compounding charecteristic Add attributes to a characteristic. Change a refernce characteristic. Change the attribute type.
Which the following objects can you create when you use the SAP Business Warehouse modeling tools in the SAP HANA studio? There are 3 correct answers to this question. Local composite providers Restricted key figures Process chains Key figures global filters.
Which of the following objects are available when you activate SAP Business objects Business Intelligence content? There are 3 correct answers to this question. Planning function Aggregation level Calculation view Process chain Data flow.
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 Transformation Data transfer process.
Your customer has a division that sells the same products with different master data. How you can enhance an SAP HANA view to include the division's sales of these products? Please choose the correct answer. Use the SAP HANA studio and add a level or parent-chlid hierarchy based on a join with tables from the subsidiary system in the semantics node. Use the SAP HANA studio and add a level or parent-chlid hierarchy based on eth tables in the semantics node. Use the SAP Business warehouse modelling tools of SAP HANA studio the necessary characteristics to include external hierarchies. Use the SAP HANA studio and add a calculation view of type dimension With two additional hierarchies in the Semantics node.
You create an advanced DataStore object (DSO) and select the standard DSO template. Which of the following settings are applied automatically? There are 2 correct answers to this question. Activate data All characteristics are key Unique data records Write change log.
You want to build a query in the BEx Query Designer to display the ten customers with the highest sales revenue. Which activity do you need to perform? There are 2 correct answers to this question. Define an alert level on the sales revenue. Use an exception aggregation on the customer number. Create a condition using the TOP N ranked list operator. Use the All characteristics in Drilldown independently option.
What are the efforts if you open and the BEx Query Designer query in the SAP Business warehouse query Designer in the SAP HANA Studio? There are 2 correct answers to this question. You CANNOT reopen the query in BEx query Designer you can edit the query without migration you can expect the same result in query exception You can edit the query after migration.
On which of the following objects can you restrict a characteristic? Please choose the correct answer. Formula Exception Condition Hierarchy node.
You want to create a workbook that shows turnover per material group. Materials are organized hierarchically on three levels. Business users want to view the level 3. They also want to be able to aggregate on lower hierarchy levels. How can they do this? There are 2 correct answers to this question. Open the hierarchy options of the material from hore bar and deselect the required level in the show levels option. Open the hierarchy options of the material & the ment bar and select the required level in the show levels option. Open the hierarchy options of the material from the ment bar and expand the hierarchy to the required level. Open the context menu of tee in the analysis and expand the hierarchy of the required level.
You want to fill variables automatically by using the Replacement path more. Which of the following variables types are supported? There are 3 correct answers to this question. Formula Hierarchy node Hierarchy Text Characteristic value.
Which sources are available for a generic SAP Business Warehouse DataSource? There are 3 correct answers to this question. SAP HANA information view Function module SAP HANA remote source table DB view or table SAP query (InfoSet).
Report abuse Consent Terms of use