CREATE TEST

ERASED TEST, YOU MAY BE INTERESTED ON test 1

COMMENTS	STATISTICS	RECORDS

TAKE THE TEST

Title of test: test 1 Description: test for exam Author: nani Other tests from this author Creation Date: 26/11/2024 Category: Competitive Exam Number of questions: 80

Share the Test:

New Comment

No comments about this test.

Content:

You created an Open ODS view based on a database table in SAP HANA to virtual & splay SAP BW/4HANA. Real-time reporting requirements have now changed and you are asked to persist the data in SAP BW/4HANA. Which objects will be created when using the Generate Dataflow function via Open ODS view? (3 correct) CompositeProvider SAP HANA calculation View Datastore Objects (advanced) Transformation Data Source. You create a transformation from a DataSource to a DataStore Object (advanced). The DataSource provides an additive-image delta for data. Which key figure aggregationtype do you select? Overwrite Summation Maximum Minimum. With BW/4HANA 2.0, SAP introduced a new capability called Write Interface for DataStore objects (advanced). Which SAP solution can leverage this interface to push data into the table of a DSOs SAP BW/4HANA 2.0 via HTTP-based connection (REST)? (2 correct) SAP Cloud Platform Integration SAP Data Warehouse Cloud SAP Process Integration SAP Data Services. You developed a BW information model and want to re-use a generated external SAPHANA view. Which objects are supported? (3 correct) Query as InfoProvider CompositeProvider SAP BW/4HANA query Open ODS view Semantic group object. What are the key benefits of using the SAP Landscape Transformation Replication Server for data provisioning into SAP HANA? (2 correct) Support of cluster and pool tables Virtualization capabilities Real-time and scheduled data replication Log-based replication. With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework. Which technical namespace is assigned to identify new SAP ERP related business content? /IMO/ /0SAP/ /BW4/ /SFA/. Which features does SAP Analysis for Microsoft Office provide? (3 correct) Dragging measures in and out of the report Including more than one data source Creating bookmarks for a navigation state Changing context menu entries Displaying data simultaneously in a table and a chart. Which user group is the Digital Boardroom designed for? IT users Business executives BI architects Business users. Which of the following are possible error handding settings in a data transfer process (DTP) SAP BW/4HANA? (3 correct) Request Red. Do Not Track Records. No Update Request Red. Write Error Stack. Update Valid Records Request Green. Write Error Stack, update Valid Records Cancel Request TrackFirst Incorrect Record. No Update Cancel Request. Write Error Stack, No Update. Where can you automatically generate a process chain? From a data flow object From a Composite Provider Within the process chain maintenance Within the Process Chain Editor app. Your company decided to use a Hadoop cluster as a data storage location. Which components can be used to consume remote Hadoop data in your SAP HANA native app? (3 correct) SAP HANA smart data access SAP HANA smart data integration SAP HANA SQL controller Spark SQL adapter SAP Vora ODBC adapter. When loading master data for a material you want to have a look at the new values before they are released for reporting. What could you do using modeling features? (2 correct) When you define attributes of material, select the "Time Dependent" Setting When you define the material characteristic, select "Enhanced Master data update" setting When you define the data transfer process. select the "Loadrecords with new key only" setting When you define the data transfer process, choose "Set manually" setting for "Overall status of request". You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? (2 correct) Components Design Rules Analysis Information. What are some of the possible variable types for the processing type in SAP HANA Exit? (2 correct) Formula Text Hierarchy node Characteristic value. Which of the following are valid data deletion options for a standard DataStore Object (advanced)? (3 correct) Selection deletion including subsequent targets Selective deletion of data Deletion of all data from active table only Request-based data deletion Deletion of data from all tables. You define a remote subscription of type INSERT in an SAP RANA Smart Data Integration (SOI) real-tine updatescenario. Which fields are added to the DataSource automatically? (3) SDI_CHANGE_SEQUENCE SDI_RECORD_SEQUENCE SDI_RECORD_MODE SDI_CHANGE_TYPE SDI_CHANGE_TIME. In which ODP context is the operational delta queue (ODQ) managed by the target system? ODP_BW ODP_SAP DP_HANA ODP _CDS. You would like to highlight the deviations between budget and actual revenue in query. Which BW feature do you use? Conditions Calculated key figures Formula variable Exceptions. What is the benefit of using an InfoSource in a data flow? Provide an interface for extracting data aquery Persist intermediate results Avoid using a DataSource Connect multiple sequential transformations. Which Of the following are possible Source types for an Open ODS view? (3 correct) Transformations Composite Provider Open hub destination Database table Or view Datastore Object (advanced). Which interface do you use to create a BW InfoObject access "SAP HANA view"? BW modeling perspective in SAP HANA studio Embedded SAP GUI in SAP HANA studio SAP web forSAP HANA SAP HANA modeler perspective in SAP HANA studio. You use a measure with semantic type "Amount Currency Code" in your SAP HANA calculation view. Which kind of currency reference can be assigned to measure? (2 correct) Another column of the same SAP HANA view A column from another SAP HANA view A fixed currency from table TCURC A variable in the same SAP HANA view. You created a generic DataSource. ZWEATHER_DATA in SAP ERP using a function module. You tried to replicate the DataSource in SAP BW/4HANA, but it is not available in the ODP_SAP context. Which prerequisite must be fulfilled for this DataSource before you can use it in SAP BW/4HANA? It must be defined with a delta-specific field through data source creation. It must have a delta queue entry transaction ODQMON It must be released for OOP with program RODPS_OS_EXPOSE It must be released for ODP with program BS_ANLY_DS_RELEASE_ODP. Which features prevent the SAP HANA-optimization of transformations in the SAP HANA database? (2 correct) Transfer routine on the characteristic level ABAP expert routine in the transformation ABAP end routine in the transformation Lookup master data in the transformation. You need to combine attributes data (left table) and the data language-dependent texts (right table) using a text join. You want to restrict the result set to the logon language. What do you need to select? The logon language the left table The join cardinality between both tables The language column in the right table The language column in the left table. You create a Datastore Object (advanced) using the "data mart DataStore object" modeling property. Which behaviors are specific to this modeling property? (2) Reporting is done based on a union of the inbound and active tables The change log table will only be filled after activation Query results are only shown when data has been activated All characteristics are automatically defined as key. To achieve an urgent business requirement, you choose the field-based approach because no complex harmonization is needed. Assuming the LSA++ architecture is considered, and you want to leverage a characteristic hierarchy, on which level do you have to assign an InfoObject last? In the SAP BW Datastore Object (advanced) In the SAP BW Open ODS view In the SAP HANA calculation view In the SAP BW Composite Provider. For which business requirements do you suggest an SAP HANA modeling focus rather than an SAP BW/4HANA modelins focus? (2 correct) Load snapshots or deltas from different Sources on a periodic basis Report on a harmonized set of master data Enhance existing SAP HANA content models Leverage SQL in-house knowledge. You have created a Custom Characteristic with technical name "COSTOBJ". Depending on the controlling area, you need to have different attribute values assigned. How do you design the model? Compound the characteristic for Controling Area with the characteristic "COSTOBJ" Join the characteristic "COSTOBJ" and the Controlling Area in a BW query Define Controlling Area as a navigation attrbute for the characteristic "COSTOBJ" Compound characteristic "COSTOBJ" the characteristic for Controlling Area. You want to execute a query, but do not have the authorization for selection defined in the query for authorization-relevant characteristics. What would occur in this scenario? (2 correct) You get an error message You get only the authorized data You cannot run the query You will not get a query result. You want to get insights about the structure and content of your source data. Which approach you shoud consider for prototyping? Business content activation Flat file generation InfoObject based modeling Field-based modeling. You can NOT turn a display attribute into a navigation attribute. Which setting of this attribute could be the reason? (2 correct) Case-Sensitive High Cardinality Attribute Only Useable InfoProvider. Which objects can be affected by the key date in a BW query? (3) Key figures Navigation attributes Display attributes Hierarchies Conditions. You want to define a restricted column in an SAP HANA calculation view. What do you need to define?(2) A condition criteria An SAP HANA data type An aggregation method A referente to an existing measure. You are involved in an SAP BW/4HANA project focusing on General Ledger reporting and want to use the SAP ERP Standard DataSource 0FI_GL_ 14 (New GL Items). Which transaction can be used to activate this DataSource? (2 correct) Transaction RSA1 (BI Content) in the SAP BW/4HANA system Transaction RSA5 (Installation ofDataSource from Business Content) SAP source system Transaction RS02 (Maintain Generic DataSource) in the SAP source system. Transaction ODQMON (Monitor Delta Queues) in SAP source system. Which layers offer the virilization approach for layered scalabie archRecWre (LSA++) of SAP BW/4HANA? (3 correct) Virtual data mart layer Data acquisition layer Open hub layer Agile data mart Open operational data Store layer. What can you leverage using the live data connections of SAP Analytics Cloud SAP BW/4HANA? (2 correct) BW data models for planning scenarios Existing authorization concepts BW data models for analysis Process chain streaming functionality. Which features can be leveraged using a Composite Provider in SAP BW/4HANA? (3 correct) Combine InfoProviders using Joins and Unions Integrate SAP HANA calculation views Define new restricted key figures Define new calculated fields Integrate a BW query as an InfoProvider. In a Datastore Object (advanced) of type Data Mart, which request can be deleted? The latest request in the active data table Any older activated request in the inbound table Any older request the active data table The latest request the inbound. What is the maximum number of objects that can be used for a multi-dimensional exception aggregation? 10 3 7 5. Why should you run an SAP HANA delta merge? (2 correct) To move most recent data from disk to memory To improve the read performance of InfoProviders To clear the BW query cache To decrease memory consumption. What are the possible ways to fill a pre-calculated value set (bucket)? (3 correct) By referencing a table By entering the values manually By using a query By using a transformation and data transfer process (DTP) By accessing a calculation view of data category Dimension. Which join types can you use in a CompositeProvider? (3 correct) Referential join Full Outer join Text join Hierarchy join Inner join. You have created an SAP HANA calculation view of the SAP HANA extended appication services, advanced model (XSA) and want to integrate into an SAP BW/4HANA model. Which "Settings for HANA Consumption" in transaction SPRO can you use? (2 correct) Hybrid Mode HANA Deployment Infrastructure External SAP HANA View SAP HANA Repository. You want to integrate an SAP HANA information view for master data into another one for transaction data. What do you need to do before you can integrate the master data view? Activate the design time version of the master data view to turn it into a CompositeProvider Integrate the design time version of the transaction data view into a CompositeProvider Activate the design time version of the master data view to generate a run time version Integrate the design time version of the master data view into a CompositeProvider. What are some of the reasons to choose the CUBE data category instead of DIMENSION data category for an SAP HANA calculation view? (3 correct) Persist transactional data Create restricted columns Provide default time characteristics Aggregate measuresas a sum Combine master data and transactional data. SAP provides three data warehousing solutions to provide customers more flexibility. How is SAP Data Warehouse Cloud positioned? To support business users with a new self-service tool To support clients usng this cloud-based successor Of SAP BW/4HANA To empower business users to create and maintain authorization To empower business users to create and maintah users. What are some of the advantages of using SAP BW/HANA business content? (2 correct) Ability to modify activated business content objects Adjustments to activated content objects will be delivered by SAP a new namespace Automatic activation during installation of SAP BW/4HANA Accelerated implementation using ready-made models. In SAP BW/4HANA Modeling, You want to integrate data from different sources using SAP HANA Solutions for Enterprise Information Management. Which other object type would you use to continue with the same modeling focus? Stored procedures AMDP (ABAP Managed Database Procedures) BAPIs (Business Application Programming Interface) Function modules. With SAP HANA 2.x. you can model information views in the SAP Web IDE for SAP HANA with SAP HANA extended application services, advanced model (XSA). Which node types for a native SAP HANA information view are ONLY available in this framework? (2) Rank Intersect Graph Aggregation. You expect to have more than 2 billion records as master data references for a characteristic your data model and want to use the high cardinality option. What do you need to Consider in reporting? The SID table reference is vald for navigational attributes Local SID values are created automatically durng reporting, which can impact the response time. The High Cardinality property needs to be defined the Composite Provider Using a hierarchy of this characteristic for navigation with impact response tine. What are the benefits of separating master data from transactional data in SAP BW/4HANA? (2 correct) Improve runtime of staging processes Avoid generation of SID values Ensure referential integrity on your data Ensure high cardinality on your data. Which SAP BW4HANA Objects are possible sources for data load processes? (3 correct) Datastore Objects (advanced) Characteristics Composite providers Info Sources Open ODS Views. Which features of an SAP BW/4HANA InfoObject are intended to reduce the physical data volume? Transitive attribute Compounding Reference characteristic Enhanced master data update. Which of the following are features of the Start process in a chain? (2 correct) It is the only process that can be scheduled without a predecessor Only one start process is allowed for each process chain It can be a successor of another process It can be re-used in other process chains. The SAP S/4HANA virtual data model (VDM) is buit with ABAP-managed COS views. What are some of the prerequisites for using these SAP S4HANA ABAP COS views for extraction into SAP BW/4HANA in an ODP context? (2 correct) ABAP CDS Views must be released via program for BW extraction An ODP source system with type ODP_CDS must be created in SAP BW/4HANA ABAP CDS views must be defined with the appropriate data annotations The Operational Data Provisioning Framework must be configured SAP BW/4HANA. In an SAP HANA smart data integration flowgraph, which transformation options are available? (2 correct) Data flow object generation SAP HANA analysis process Advanced SQL Code execution. In a query with cells you need to override some of the automatically created cell values with other values. Which cell types do you use instead of automatically-created cell? (2) Selection cells Reference cells Formula cells Help cells. How can you ensure that the delta merge process will be initiated? (3 correct) By setting a specific flag in the transformation By using a specific process type a process Chain By using SAP HANA smart merge technology By using the SAP BW/4HANA data load monitor By setting a specific flag in the delta data transfer process. You are required to provide an analysis allowing selections among specific months (for seasonal reasons). Therefore you want to prefil a variable for processing this request. Which processing type should you use? Authorization Replacement Path Manual Entry with default value Customer Exit. You want to build Web-based dashboards with interactive visualizations. Which SAP tool do you suggest? SAP Lumira, designer edition SAP Analysis for Microsoft Office SAP Analysis for OLAP SAP Crystal Reports for Enterprise. With which query considerations can you optimize the query performance? (3 correct) Use characteristic filters that overlap Use include functions in the restricted key figures Use mandatory characteristics value variables Use fewer drill-down characteristics in the initial view Use exclude functions in the restricted key figures. Which of the following are the possible delta-relevant field types for a delta process with a generic DataSource? (3) Amount Quantity Numeric pointer Time stamp Calendar day. In SAP BW/4HANA, you realize that standard content data Source (New GL Balances) is delivering incorrect values into the first persistent data layer in SAP BW/4HANA. Which options do you have to analyze a potential extractor issue in the SAP ERP source system? (2 correct) Check entries in table RSDDSTATEEXTRACT in SAP ERP Use program RODPS_REPL_TEST in SAP ERP Use PSA maintenance in SAP BVW'HANA Usetransaction RSA3 (Extractor checker) SAP ERP. You create a report with SAP Crystal Reports for Enterprise and need analysis view as a data source. Which tool can you use to create this analysis view? SAP Crystal Reports for Enterprise SAP Analysis for Microsoft Office SAPLumira, designer edition SAP BusinessObjects Web Intelligence. You want to activate an SAP HANA calculation view of data category CUBE, but you get the "no measure defined" error. For the business requirement a measure does not make sense. Besides changing the category to DIMENSION, what do vou have to do? Switch from an aggregation node to a star join node Switch from a projection node to an aggregation node Switch from an aggregation node to a projection node Switch from an aggregation node to a rank node. Your company is using SAP S/4HANA as a business operational system and you have to provide operational anatytical reports. Why might you consider SAP SAHANA embedded analytcs? Make use of the SAP HANA Live content Make use of the virtual data model Make use of the SAP HANA optimized business content Make use of the SAP HANA Deployment Infrastrutture. Which external hierarchy properties can be changed in the query definition? (3 correct) Time dependency Expand to level Position of child nodes Sort direction Suppress unassigned node. SAP HANA studio provides a data file import wizard to create and fill tables in SAP HANA from flat files. What is an advantage of using the file wizard? Option to adjust the suggested column type, length, and name Automatic field mappings to InfoObjects Immediate assignment of delta logic Combining different source fields into a single table. Which Objects can you associate with a Source field in the Characteristics folder of an Open ODS view type "Facts"? (2) Open ODS view type Master Data for Hierarchies Open ODS view type Master Data for Attrbutes SAP BW Info Objects type Characteristic SAP BW InfoObjects type Key Figure. Which Objects can be used in the BW query "Fixed Values" area to restrict the data? (2) Characteristics Key figures Navigation attributes of a characteristic Display attributes of a characteristic. Considering the mixed modeling approach, what can you do an SAP HANA calculation view exclusively? Compress datasets by Aggregation Generate a Rank column Combine datasets by Union Select a dataset by Projection. What kind of cold data tiering options do you have with SAP BW/4HANA? (2 correct) Hadoop cluster SAP HANA extension node SAP IQ database SAP Data Warehouse Cloud. What is the purpose of an initial architeture overview model? To identify the required data sources To prepare the required key figure matrix To identify the user groups and required autorizations To present the technical overview of the SAP landscape. Which file types are Supported for an upload into SAP BW/4HANA using source system FILE? (3 correct) HTML xlsx csv XML asc11. Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP) ? (3 correct) SAP HANA Analysis Process CompositeProvider InfoSource Open Hub Destination DataStore Object (advanced). You need to defne an SAPHANA calculation view with numbers that represent codes instead of aggregated values. Which Settings should you choose? Choose the DIMENSION data category and use the numbers as attributes Choose the DIMENSION data category and use the numbers as measures Choose the CUBE data category and use the numbers as measures Choose the CUBE data category and use the number as attributes. You defined a condition in a query for the top 10 customers based on sales revenue (key figure of type Sum). If you keep the default settings of the query, what is the total of the sales revenue on the result line? Sales revenue total of all customers Sales revenue total of the 10 customers Sales revenue value of the 1stcustomer Sales revenue value of the 10th customer. What are the reasons for implementing CompositeProviders? (2 correct) To load data into the Composite provider for report To use the Rank functionality To provide a virtual datamart layer To provide an interface for the queries. What are the prerequisites for deleting master data (for example, cost centers) SAP BW4HANA? (2 correct) There must be no hierarchy for the cost centers There must be no BW analysis authorizations defined that use any of the cost centers. There must be no transaction data referring to cost centers There must be no BW query that uses cost center as a free characteristic.

Report abuse