MAECOM JJANG MAECOM JJANG

NO.44 What are the main challenges companies face that want to make data-driven decisions?Note: There are 3 correctanswers to this question. Simplify the data landscape to reduce costs and accelerate insights. Uncever the hidden potential in their business by unlocking seamless access to critical insights. Harness the power of fragmented, unstructured data sources to turn them into valuable business insights. Boost confidence in the quality of their data. Unlock a new dimension of insights, advanced analytics, and Al capabilities.

NO.45 Which data deletion options are offered for a Standard DataStore Object (advanced)?Note: There are 3 correctanswers to this question. Selective deletion of data. Selective deletion including data of subsequent targets. Request-based data deletion. Deletion of data from all tables. Deletion of all data from active table only.

You have an existing field-based data flow that follows the layered scalable architecture (LSA++) concept. To meet a new urgent business requirement for field you want to leverage a hierarchy of an existing characteristic without changing the transformation.How can you achieve this? Note: There are 2 correctanswers to this question. Assign hierarchy properties to the field in the BW Query. Add the characteristic to the DataStore object (advanced). Associate the field with the characteristic in the Open ODS View. Associate the field with the characteristic in the CompositeProvider.

You use a measure with semantic type "Amount with Currency Code" in your SAP HANA HDI calculation view.Which kind of currency reference can be assigned to the measure?Note: There are 2 correctanswers to this question. Acolumn from another SAP HANA view. A fixed currency from table TCURC. Another column of the same SAP HANA view. A variable in the same SAP HANA view.

What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correctanswers to this question. By using a BW query (update value set by query). By accessing an SAP HANA HDI Calculation View of data category Dimension. By using a transformation data transfer process (DTP). By entering the values manually. By referencing a table.

NO.49 Which recommendations should you follow to optimize BW query performance? Note: There are 3 correctanswers to this question. Create linked components. Include fewer drill-down characteristics in the initial view. Use matory characteristic value variables. Use the include mode within filter restrictions. Use the dereference option for reusable filters.

NO.50 You want to build a web-based dashboard with interactive visualizations using scripting. Which SAP tool can you use to create this?. SAP Crystal Reports. SAP Analytics Cloud. SAP Smart Business Cockpits. SAP BusinessObjects Web Intelligence.

NO.51 What are the main challenges companies face that want to make data-driven decisions?Note: There are 3 correctanswers to this question. Simplify the data landscape to reduce costs and accelerate insights. Harness the power of fragmented, unstructured data sources to turn them into valuable business insights. Boost confidence in the quality of their data. Unlock a new dimension of insights, advanced analytics, and Al capabilities. Uncever the hidden potential in their business by unlocking seamless access to critical insights.

NO.52 You want to access data from a table residing in an external database using an SAP HANA SDA remote source.Which other SAP HANA element is required to access its data?. Flowgraph. Virtual Table. Table Function. Replication Task.

NO.53 What foundation is necessary to use SAP S/4HANA embedded analytics?. SAP HANA optimized business content. ABAP CDS view based virtual data model. Generated external SAP HANA Calculation Views. SAP Agile Data Preparation.

NO.54 In an SAP HANA HDI Calculation View, you need to combine attributes data (left table) and the data's language-dependent texts (right table) using a text join.What should you select to restrict the result set to the logon language?. The logon language in the left table. The join cardinality between both tables. The language column in the left table. The language column in the right table.

NO.55 In which ODP context is the operational delta queue (ODQ) managed by the target system?. ODP_BW. ODP SAP. ODP_CDS. ODP_HANA.

NO.56 Which join types can you use in a CompositeProvider?Note: There are 3 correctanswers to this question. Inner join. Temporal hierarchy join. Text join. Referentiajolin. Full Outer join.

NO.57 You are allowed to run a BW query, but the data selection is only partially covered by your authorizations. What happens related to the BW query in this scenario?. The BW query starts and the unauthorized values are 0. The BW query starts and only the authorized data is displayed. The BW query does not start running. The BW query starts and shows an error message.

NO.58 Which layer of the layered scalable architecture (LSA++) of SAP BW/4HANA is designed as the main storage for harmonized consistent data?. Open Operational Data Store layer. Data Acquisition layer. Flexible Enterprise Data Warehouse Core layer. Virtual Data Mart layer.

NO.59 Which SAP BW/4HANA objects support the feature of generating an external SAP HANA View? Note: There are 2 correctanswers to this question. BW query. Open ODS view. Composite Provider. Semantic group object.

NO.60 You want to set up the replication process for the SAP Landscape Transformation Replication Server.Which actions can you define for a specific table?Note: There are 3 correctanswers to this question. Set the reading type and portion sizes. Apply mapping rules during the replication. Convert Unicode to non-Unicode. Apply customizing settings to the database redo logs. Change or enrich the table structure.

NO.61 You created an Open ODS view of type Facts.With which object types can you associate a field in the Characteristics folder? Note: There are 2 correctanswers to this question. Open ODS view of type Master Data. InfoObject of type Characteristic. Open ODS view of type Facts. HDI Calculation View of data category Dimension.

NO.62 In a BW query with cells, you need to overwrite the initial definition of a cell.Which cell types can you use? Note: There are 2 correctanswers to this question. Formula cell. Help cell. Selection cell. Reference cell.

NO.63 What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW /4HANA?. Request is set to success, error stack is written, and valid records are updated. Request is canceled, first incorrect record is tracked, and target is not updated. Request is set to failed, error stack is written, and valid records are updated. Request is canceled, records are not tracked, and target is not updated.

NO.64 In a DataStore object (advanced) of type Data Mart, which request-based deletion is possible?. Any not activated request in the inbound table. Only the most recent request in the active data table. Any request in the active data table. Only the most recent not activated request in the inbound table.

NO.65 Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP)? Note: There are 2 correctanswers to this question. DataStore Object (advanced). InfoSource. CompositeProvider. Open ODS view.

NO.66 With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework.Which technical namespace is assigned to identify the new SAP ERP-related business content?. /BW4. /SFA/. /IMO. /CPMB.

NO.67 You created a generic DataSource in SAP ERP, but did not release the DataSource for Operational Data Provisioning (ODP).What is the effect in SAP BW/4HANA?. The ODP DataSource has to be created using the ODP_HANA source system type. The ODP DataSource has to be created using the ODP_SAP source system type. The ODP DataSource cannot be replicated using the ODP_SAP source system type. The ODP DataSource can be generated using the DataFlow generation feature.

NO.68 Your company manufactures products with country-specific serial numbers.For this scenario you have created 3 custom characteristics with the technical names "PRODUCT" "COUNTRY" "SERIAL_NO".How do you need to model the characteristic "PRODUCT" to store different attribute values for serial numbers?. Use "COUNTRY" as a navigation attribute for "PRODUCT". Use "SERIAL_NO" as a transitive attribute for "PRODUCT". Use "COUNTRY" as a compounding characteristic for "PRODUCT". Use "SERIAL_NO" as a compounding characteristic for "PRODUCT".

NO.69 Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates multi-tabbed stories with Overview, Key Influencers, Unexpected Values,and Simula-tion tabs?. Search to Insight. Predictive Forecast. Smart Discovery. Smart Predict.

NO.70 You are involved in an SAP BW/4HANA project focusing on General Ledger reporting want to use the SAP ERP stard DataSource OFI_GL_14 (New GL Items) which is not active in your SAP ERP system.Which transactions can be used to activate this DataSource? Note: There are 2 correctanswers to this question. Transaction RSORBCT (Data Warehousing Workbench: BI Content) in the SAP BW/4HANA system. Transaction RSA5 (Installation of DataSource from Business Content) in the SAP ERP system. Transaction RSA2 (DataSource Repository) in the SAP ERP system. Transaction RSDS (DataSource Repository) in the SAP BW/4HANA system.

NO.71 You need to derive an architecture overview model from a key figure matrix. Which is the first step you need to take?. Identify transformations. Identify sources. Analyze storage requirements. Define data marts.

NO.72 For which scenarios do you use the SAP HANA model focus? Note: There are 2 correctanswers to this question. Load snapshots using ABAP CDS Views. Build views procedures using SQL script. Define ABAP Managed Database Procedures in data flows. Define calculations using geospatial functions.

NO.73 You use InfoObject B as a display attribute for InfoObject A.Which object properties prevent you from changing InfoObject B into a navigational attribute for InfoObject A? Note: There are 3 correctanswers to this question. Data Type "Character String" is set in InfoObject A. Attribute Only is set in InfoObject B. High Cardinality is set in InfoObject B. InfoObject B is defined as a Key Figur. Conversion Routine "ALPHA" is set in InfoObject A.

NO.74 You want to build an SAP HANA HDI calculation view of data category CUBE, but you get a "no measure defined" error.For the business requirement, a measure does not make sense.Besides changing the data category to DIMENSION, what do you have to do?. Switch from an aggregation node to a projection node. Switch from a projection node to a star join node. Switch from a projection node to an aggregation node. Switch from an aggregation node to a star join node.

NO.75 You create an SAP HANA HDI Calculation View.What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correctanswers to this question. You can combine master data transactional data. You can persist transactional data. You can provide default time characteristics. You can create restricted columns. You can aggregate measures as a sum.

NO.76 What are some of the variable types in a BW query that can use the processing type SAP HANA Exit? Note: There are 2 correctanswers to this question. Hierarchy node. Formula. Text. Characteristic value.

NO.77 Which of the following are possible delta-specific fields for a generic DataSource in SAP S/4HANA? Note: There are 3 correctanswers to this question. Calendar day. Request ID. Numeric pointer. Record mode. Time stamp.

NO.78 Which features of an SAP BW/4HANA InfoObject are intended to reduce physical data storage space? Note: There are 2 correctanswers to this question. Reference characteristic. Transitive attribute. Compounding characteristic. Enhanced master data updatee.

NO.79 You open an SAP Analysis for Microsoft Office workbook.On which Design Panel tabs can you verify the filter values? Note: There are 2 correctanswers to this question. Information. Design Rules. Components. Analysis.

NO.80 You have already loaded data from a non-SAP system into . You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA. What do you need to use to combine the data?. SAP ABAP Connection. SAP BW Shell Migration. SAP BW Remote Migration. SAP BW/4HANA Model Transfer.

NO.81 You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time update scenario.Which fields are added to the DataSource automatically? Note: There are 3 correctanswers to this question. SDI_LENTITY_COUNTER. SDILCHANGE_SEQUENCE. SDILCHANGE_TIME. SDILCHANGE_TYPE. SDILRECORD_MODE.

NO.82 What should you consider when you set the High Cardinality flag for a characteristic? Note: There are 2 correctanswers to this question. You cannot use this characteristic as a navigation attribute for another characteristic. You cannot use navigation attributes for this characteristic. You cannot load more than 2 billion master data records for this characteristic. You cannot use this characteristic as an external characteristic in hierarchies.

NO.83 Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP)? Note: There are 2 correctanswers to this question. DataStore Object (advanced). Open ODS view. InfoSource. CompositeProvider.