Test sap bw4

TEST BORRADO, QUIZÁS LE INTERESE: SAP BW4_14

COMENTARIOS	ESTADÍSTICAS	RÉCORDS

REALIZAR TEST

Título del Test:
SAP BW4_14

Descripción:
SAP BW4_14

Autor:
Io
OTROS TESTS DEL AUTOR

Fecha de Creación:
25/02/2020

Categoría: Otros

Número Preguntas: 80

COMPARTE EL TEST

COMENTAR

No hay ningún comentario sobre este test.

Temario:

In which sequence does SAP recommend collecting the information for the data model design concept? 1. Transformations 2. Reporting requirements 3. Sources of data 4. Storage requirements 1. Transformations 2. Sources of data 3. Reporting requirements 4. Storage requirements 1. Reporting requirements 2. Sources of data 3. Transformations 4. Storage requirements 1. Storage requirements 2. Transformations 3. Sources of data 4. Reporting requirements.
Where can you apply a currency conversion? Note: There are 3 correct answers to this question. In an SAP BW/4HANA transformation In an SAP BW/4HANA InfoSource In an SAP HANA calculation view In a BW query In an SAP BW/4HANA data transfer process (DTP).
Which of the following use cases is classified as operational reporting? Near-real-time access to original transactional values Reporting requirements with monthly data refreshes Evaluation of trends over several years Year-to-date comparison reports containing prior and actual year numbers.
For which activity do you use the key figure matrix? List properties of the data sources. Allocate project resources. Provide information on the relations between characteristics. Structure the information from the requirement analysis.
Which objects of an SAP HANA calculation view of DIMENSION data category can you re-use if you define an SAP calculation view of CUBE data category with star join? Note: There are 2 correct answers to this question. Hierarchy assignment Attribute assignment Aggregation method Measure assignment.
You need to consume remote HADOOP data in your SAP HANA Native App. Which components can you use? Note: There are 3 correct answers to this question. SAP Vora ODBC adapter SAP HANA smart data access Spark SQL adapter SAP HANA smart data integration SAP HANA SQL Controller.
Which of the following methods supports the SAP HANA data virtualization approach with OBDC technology? SAP Data Services SAP HANA smart data integration SAP HANA smart data access SAP Landscape Transformation Replication Server.
Which SAP Landscape Transformation Replication Server cockpit operation removes all data from the trigger table? Stop Replication and Resume Replication Stop Replication and Start Replication Suspend Replication and Start Replication Suspend Replication and Resume Replication.
You need to integrate data from several SAP systems and non-SAP systems to support real-time analytics. Why do you recommend the SAP Landscape Transformation (SLT) Replication Server for real-time data replication into SAP HANA? Replication Server installation and configuration is always identical for SAP and non-SAP source systems. The SLT Replication Server provides flexible multisystem support to manage data replication from SAP and non-SAP source systems. The SLT Replication Server provides log reader adapters for SAP and non-SAP sources. The SLT Replication Server installed on a productive SAP BW/4HANA system improves the data transfer process.
What are key capabilities of SAP Agile Data Preparation? Note: There are 3 correct answers to this question. Data exporting Data retention Data acquisition Data cleansing Data compliance.
You set up the 2LIS_02_ITM (Purchasing Line Item) data source in SAP ERP using the logistics cockpit. Afterward, you successfully run the initialization into SAP BW/4HANA. Your delta load into SAP BW/4HANA shows zero records even though new purchase orders were created. How do you explain that the delta records do NOT appear in SAP BW/4HANA? A reinitialization for sales orders in SAP ERP was triggered using the logistics cockpit, which deleted the purchase order item initialization. Purchasing extractors in SAP ERP were set up with Queued Delta update mode and the collective run job was NOT scheduled. All old purchase orders in SAP ERP were archived overnight before the delta loads. Another SAP BW/4HANA system already picked up the new purchase orders using a delta load.
You define a new generic DataSource in SAP ERP with Atime stamp as the delta characteristic A value for the Safety interval Lower Limit A new status for changed records. How does this impact how you model the data target in SAP BW/4HANA? Note: There are 2 correct answers to this question. The data target can be a DataStore object (advanced) of the InfoCube model template. The data target can be a DataStore object (advanced) of the Standard DataStore Object model template. The data target must be modeled with a characteristic for the safety interval. The data target must be able to manage duplicate records.
Which properties determine the delta process within the Operational Data Provisioning (ODP) delta management for DataSources? Note: There are 2 correct answers to this question. Serialization Parallelization Record type Record mode Delta type.
You need to enable real-time streaming using SAP HANA smart data integration (SDI) to load data into a DataStore object (advanced). What are prerequisites for this requirement? Note: There are 2 correct answers to this question. The adapter is real-time enabled. The data target is a DataStore object (advanced) of the InfoCube model template. The process chain is running in streaming mode. The source system is pulling data into SAP BW/4HANA.
You plan to regularly transfer changes from an SAP ERP custom table to SAP BW/4HANA. An additional custom development may NOT be implemented in the source system. Which Operational Data Provisioning (ODP) source system type do you recommend? ODP-SLT ODP-CDS ODP-SAP ODP-BW.
You use the wizard to create an SAP BW/4HANA Big Data source system. Which activities are mandatory? Note: There are 3 correct answers to this question. Select a database object schema. Select a remote source. Specify connection type Big Data. Specify business content type. Specify release type.
Which settings can you define in a data transfer process (DTP) if you load data into a DataStore object (advanced)? Note: There are 3 correct answers to this question. Data tiering Extraction mode Semantic groups Activation handling Error handling.
Which condition must you ensure if you want to replicate data based on a view with SAP Landscape Transformation Replication Server? An SAP HANA source system must be defined to consume the view. View-based data result sets must be kept persistent first until data replication can take place. Each tabte of the view requires a defined trigger to enable data replication. One table as part of the view has to be defined as primary table and is used to trigger data replication.
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? It must be delta-enabled. It must have a queue entry in transaction ODQMON. It must exist in table ROOSATTR. It must be in-memory-optimized.
How do you enable streaming mode for a procéss chain? Navigate to Modeling DW Workbench (RSA1). Activate streaming mode on the Current Settings Folder tab. Navigate to Process Chain Maintenance (RSPC). Add a new process variant for streaming mode. Navigate to Process Chain Maintenance (RSPC). Select Streaming Mode in the process chain attributes. Navigate to Customizing (SPRO). Change the general settings for SAP BW/4HANA.
Why do you recommend the virtual data mart layer? Note: There are 2 correct answers to this question. To combine centrally managed data with local files To combine different InfoProviders using Join operations or Union operations To build an interface for queries and reports To build corporate memory for reconstructions.
What must you do to define an Inventory InfoProvider in SAP BW/4HANA? Note: There are 3 correct answers to this question. Select the Inventory model property. Select the All Characteristics are Key model property. Assign at least one non-cumulative key figure. Select the Unique Data Records model property. Assign at least one cumulative key figure.
When can you NOT usé a characteristic with the High Cardinality property? Note: There are 3 correct answers to this question. When it will be a time-dependent attribute When it will be part of a hierarchy When it will be a compound characteristic When it will be part of a report-to-report interface When it will be a navigation attribute.
Which tables belong to the hierarchy for characteristic 0COUNTRY? Note: There are 3 correct answers to this question. /BIC/HCOUNTRY /BIC/PCOUNTRY /BIC/ICOUNTRY /BIC/QCOUNTRY /BIC/KCOUNTRY.
Which objects can you associate with a source field that is defined as a characteristic within an Open ODS view? Note: There are 2 correct answers to this question. Open ODS view type Facts Open ODS view type Master Data for Attributes Open ODS view type Master Data for Hierarchies SAP BW InfoObject.
For which business requirements do you suggest an SAP BW/4HANA modeling focus rather than an SAP HANA modeling focus? Note: There are 2 correct answers to this question. Report on a harmonized set of master data. Use existing HANA content models. Leverage SQL in-house knowledge. Load snapshots or deltas on a periodic basis.
You need to create a CompositeProvider to combine data from an SAP HANA calculation view with a DataStore object (advanced). Which of the following Eclipse perspectives do you use? JavaScript perspective SAP HANA modeler perspective ABAP perspective BW modeling perspective.
Which layers are part of the layered scalable architecture for SAP BW/4HANA (LSA++)? Note: There are 2 correct answers to this question. Native SAP HANA data mart Open Operational Data Store Source system Virtual data mart.
Which property settings can you assign for a characteristic? Note: There are 3 correct answers to this question. Stock Coverage Attribute Only Useable as InfoProvider Authorization-Relevant High Precision.
Which objects can be affected by the key date in a BW query? Note: There are 2 correct answers to this question. Hierarchies Attributes Text variables Key figures.
You load a DataStore object (advanced) every night. Where can you delete the request you loaded two nights ago without deleting the last request? 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 Standard DataStore object if the request is activated. 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 Standard DataStore object if the request is activated and you execute a full load.
Which sources types can you select when you create an Open ODS view? Note: There are 3 correct answers to this question. Characteristic SAP BW DataSource Transformation Virtual table using SAP HANA smart data access InfoSource.
For which InfoProvider types can you select navigation attributes? Note: There are 2 correct answers to this question. DataStore object (advanced) of type standard DataStore object DataStore object (advanced) of type InfoCube Open ODS views CompositeProvider.
Which objects can you combine using a CompositeProvider? Note: There are 2 correct answers to this question. InfoSources CompositeProvider SAP HANA calculation views Key figures.
You create a DataStore object (advanced) using model template Standard DataStore Object. Which flags are set? Note: There are 2 correct answers to this question. Activate Data Unique Data Records Write Change Log All Characteristics are Key.
What happens when you execute the Trigger Delta Merge operation for a given data target? The delta between the new data and the already loaded data is removed. The before and after images of the delta queues are merged. The data from the delta queue is extracted and merged into the data target. Data is transferred from the delta store to the main store.
What must you do if you want to use an object from BI Content? Copy the BI Content object into the customer name space. Activate the object in the Data Warehousing Workbench. Convert the object from A version to D version. Identify the BI Content objects in SAP HANA studio.
How do you model plant-specific attributes for the characteristic material? Compound the material and the plant. Define navigation attributes for the characteristic material. Define time-dependent attributes for the characteristic material. Join the material and the plant.
Why can tasks be executed faster if the application uses SAP HANA as a database? The application layer takes over tasks of the database layer. The user interface layer takes over tasks of the application layer. The application layer takes over tasks of the user interface layer. The database layer takes over tasks of the application layer.
You loaded a 5 MB table from a source system to SAP BW/4HANA. How do you explain that the size of the table is reduced to 1 MB? The target is defined as column store and a delta merge job was executed. The target is defined as coiumn store without delta merge execution. The target is defined as row store and a delta merge job was executed. The target is defined as row store without delta merge execution.
Which SAP BW/4HANA objects can keep persistent data? Note: There are 2 correct answers to this question. Characteristics InfoObjects InfoSource DataStore object (advanced) Key figure InfoObjects.
Why do you define a custom table as a row store table? Note: There are 2 correct answers to this question. The table will be integrated into a native SAP HANA calculation view. When the table is accessed, all columns of a single record are processed. The values in the columns are different. Therefore, data compression would NOT have much effect. Aggregation and fast search is required for query execution.
Which SAP BW/4HANA features support the code-to-data principle? Note: There are 3 correct answers to this question. Global transfer routines for master data harmonization Activation of a DataStore object (advanced) ABAP Managed Database Procedures in an SAP BW/4HANA transformation Query settings fo read near-line storage data SAP HANA models as part providers in CompositeProviders.
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? Attach an SAP HANA system to an SAP BW project. Attach an ABAP project to an SAP BW project. Attach an SAP BW project to an SAP HANA system. Attach an SAP BW project to an ABAP project.
Your customer is using a pure SAP HANA native data warehouse approach. Which tools should the customer install? Note: There are 2 correct answers to this question. BW Modeling Tools SAP solutions for enterprise information management Process Chain Monitoring app SAP Information Steward.
Which of the following are strengths of SAP S/4HANA embedded analytics? Note: There are 2 correct answers to this question. Redundant data is reduced. Operational data is accessed in real time. Historical data for strategic decisions is stored. Cross-system consistency is generated.
Why do you recommend modeling a data layer in SAP BW/4HANA? Note: There are 2 correct answers to this question. To immediately display changed entries To homogenize and cleanse data from different sources To pre-define a data layout To fulfill snapshot requirements.
Which SAP tool do you suggest to create a pixel-precise formatted report? SAP Crystal Reports for Enterprise SAP Analysis for OLAP SAP Lumira, discovery edition SAP Analytics Cloud.
Which reporting object do you use to combine data from different SAP BW InfoProviders? BW query DataProvider Analysis workbook Analysis view.
Where can you integrate an analysis view from SAP Analysis for Microsoft Office? Note: There are 3 correct answers to this question. In another SAP Analysis for Microsoft Office workbook In an SAP BusinessObjects Web Intelligence report In a Projection node of an SAP HANA calculation view In a BW query In an SAP Crystal Reports for Enterprise report.
Which advantages does the SAP Lumira template for generic analysis provide? Note: There are 2 correct answers to this question. 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.
For which of the following revenue reporting requirements do you create restricted key figures? Determine the average revenue per customer. Convert revenue into a number without currency. Compare this year’s planned revenue with last year’s actual revenue. Identify the top five countries by revenue for each month.
What must you do first if you need to define help cells for formulas in the cell editor? Define two selections in a structure. Define two structures in a query. Define two formulas in a structure. Reuse a structure in a second query.
Which query property do you set to minimize the initial run time for the query read mode? Read data when you navigate or expand hierarchies. Read all data at once. Cache is inactive. Read data individually from InfoProvider.
Which variables types allow filter values to be determined based on the user's authorizations? Note: There are 2 correct answers to this question. Formula variable Characteristic value variable Hierarchy node variable Hierarchy variable.
You identified a variable that is based on time characteristic 0CALMONTH and returns the current quarter. Which offset do you need to retrieve the corresponding quarter of the previous year? -1 -3 -4 -12.
You need to determine the number of customers in each country that have revenue in 2018. What is the reference InfoObject in an exception aggregation? Year Counter Customer Country.
What happens if a query with time-dependent attributes is executed but NO query key date is set? The current date is used as key date. The system displays only NON-time-dependent attributes. The valid from date of the attribute is used as key date. The system displays an error message.
Your main BW query contains a characteristic value variable with a replacement path from a query. When is the pre-query executed? 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, after the filter values are applied. Directly after data is loaded to the InfoProvider of the pre-query.
When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question. The structure exists in the source system. The structure will contain formulas. The hierarchical structure will be time-dependent. The query data will be restricted to a hierarchy node. The structure will depend on the order of the row characteristics.
You create a BW query. How can you check the navigational attributes of a basic characteristic? Add the basic characteristic to a BW query and check the display properties. Select Attributes from the context menu of the basic characteristic in the rows section. Open the editor for the basic characteristic and check the Attribute tab. Open the InfoProvider view and check the Attribute folder below the basic characteristic.
In which sequence can you create a reusable key figure structure? Note: There are 2 correct answers to this question. 1. Create a new structure in the context menu of an InfoProvider. 2. Add key figures, selections, and formulas. 1. Create a new structure in the context menu of a calculated key figure. 2. Save the structure as a global structure. 1. Create a new structure with key figures, selections, and formulas in a query. 2. Save the structure as a global structure. 1. Apply filters to a key figure structure in SAP Analysis for Microsoft Office. 2. Save the structure as a global structure.
You need to restrict a sales report to the products that make up 50% of the total revenue. Which BW query feature do you use? Condition Calculated key figure Restricted key figure Exception.
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? Note: There are 3 correct answers to this question. A currency from SAP BW customizing A currency from another column A currency from a currency conversion A fixed currency Acurrency from an SAP HANA content calculation view.
Which actions can you perform with an SAP HANA calculation view that has the DIMENSION data category assigned? Note: There are 2 correct answers to this question. Join serveral tables. Define text joins. Aggregate measures. Persist master data.
You need to combine master data (right table) and transactional data (left table) using a referential join. How will this referential join behave? It returns a result data set if the left table has a corresponding entry on the right table. It always returns all fields from the right table as a result data set. It is executed as an inner join when a description mapping is defined between the left table and the right table. It is executed as an inner join when NO fields from the right table are requested.
Which objects can you use as components in a CompositeProvider in SAP BW/4HANA? Note: There are 2 correct answers to this question. BW query Semantic group Open ODS view CompositeProvider.
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? Inner join with Dynamic Join properties Referential join with Temporal Join properties Referential join with Dynamic Join properties Inner join with Temporal Join properties.
You model a second SAP BW/4HANA CompositeProvider to integrate tables from an SAP HANA database schema with an existing SAP BW/4HANA CompositeProvider. What must you do first? Connect an export DataSource from the exisiting CompositeProvider to the new CompositeProvider. Create an Open ODS view with consumption properties to consume the data in the SAP BW/4HANA schema. Assign consumption properties to the new SAP HANA calculation view. Set The CompositeProvider Can Be Added to Another CompositeProvider flag.
You want to validate your SAP HANA data model. What must you ensure to use the data preview functionality? You are connected as SYSTEM user and all object privileges are assigned to this SYSTEM user. The _SYS_BIC user is created in the system and the runtime information is written to_SYS STATISTICS. Your content package is assigned with sufficient repository privileges to the SYS REPO user. The _SYS_REPO user must have sufficient object privileges assigned to your desired schema.
Which SAP HANA objects are automatically generated if you set the External SAP HANA Calculation View flag for an SAP BW/4HANA object? Note: There are 2 correct answers to this question. SAP HANA analytic views SAP HANA attribute views SAP HANA privileges SAP HANA calculation views.
You define a temporal condition for a temporal join in a calculation view. Which column data types are supported? Note: There are 3 correct answers to this question. Integer Decimal Timestamp Date Boolean.
Which object is a target of an SAP BW transformation? InfoObject of type Characteristic CompositeProvider InfoObject of type Key Figure Open ODS view.
You create a transformation from a DataSource to a DataStore object (advanced). The DataSource provides an after-image delta. Which key figure aggregation type do you select? Maximurn Minimum Overwrite Summation.
You need to load data from a generic DataSource using Operational Data Provisioning (ODP). In which sequence do you perform the activities? 1. Create a DataSource. 2. Replicate the DataSource. 3. Run job RODPS_OS_ EXPOSE. 4. Activate the DataSource. 1. Create a DataSource. 2. Replicate the DataSource. 3. Activate the DataSource. 4. Run job RODPS_OS_EXPOSE. 1. Create a DataSource. 2. Activate the DataSource. 3. Run job RODPS_OS_EXPOSE. 4. Replicate the DataSource. 1. Create a DataSource. 2. Run job RODPS_OS_EXPOSE. . 3. Replicate the DataSource. 4. Activate the DataSource.
Which source types can you use for a generic DataSource? Note: There are 2 correct answers to this question. DB view or table SAP HANA calculation view Core data service view Function module.
What can you do when you use process chains? Note: There are 2 correct answers to this question. Trigger delta merge. Activate requests in DataStore objects (advanced). Generate transformations. Activate data transfer processes (DTPs).
How can you persist data from any SAP HANA database table to a table in the SAP BW schema? Note: There are 2 correct answers to this question. Create an Open ODS view. Generate a data flow. Create a DataSource. Load the data to a DataStore object (advanced). Create an Open ODS view. Consume the view using a CompositeProvider. Create an SAP HANA calculation view. Consume the view using a CompositeProvider.
Which transformation options can be executed in an SAP HANA database? Note: There are 2 correct answers to this question. ABAP expert routines Formulas Read master data Transfer routines.
What can you create within the SAP BW data flow object? Note: There are 2 correct answers to this question. Key figures InfoAreas Transformations InfoProviders.

Denunciar Test

▲