What are some ofthe variable types in a BW query that can use the processing type SAP HANA Exit?

 Note: There are 2 correct answers to this question.

Whatare the possible ways to fill a pre-calculated value set (bucket)?

Note: There are 3 correct answers to this question.

Which external hierarchy properties can be changed in the query definition?

Note: There are 3 correct answers to this question.

Whatis the maximum numberofreference characteristics that can be used for one key figure with a multi-dimensional exception aggregation in a BW query?

In a BWquery with cells you need to overwrite the initial definition of a cell. Which cell types can you use?

Note: There are 2 correct answers to this question.

You would like to highlight the deviation from predefined threshold values for a key figure visualize it in SAP Analysis for Microsoft Office. Which BW query feature do you use?

You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue. Using key figure properties in the BW query which two scenarios regarding result presentation can be achieved?

Note: There are 2 correct answers to this question.

For a BWquery youwanttohave the firstmonth of the current quarter as a default value for an input-ready BW variable for the characteristic 0CALMONTH. Which processing type do you use?

For which scenarios do you use the SAP HANA model focus? Note: There are 2 correct answers to this question.

For which reasons should you run an SAP HANA delta merge? Note: There are 2 correct answers to this question.

A. To decrease memory consumption B. To combine the query cache from different executions C. To move the mostrecent data from disk to memory D. To improve the read performance of InfoProviders

What are the reasons for implementing Composite Providers?

Note: There are 2 correct answers to this question.

What foundation is necessary to use SAP S/4HANA embedded analytics?

How can the delta merge process be initiated in SAP BW/4HANA?

Note: There are 2 correct answers to this question.

Which SAP BW/4HANA objects support the feature of generating an external SAP HANA View?

Note:There are 2 correct answers to this question.

Which are purposes of the Open Operational Data Store layer in the layered scalable architecture (LSA++) of SAP BW/4HANA?

Note: There are 2 correct answers to this question.

Which layer of the layered scalable architecture (LSA++) of SAP BW/4HANA is designed as the main storage for harmonized consistent data?

Which development object needs to be built to generate an HDI Container?

Which features of an SAP BW/4HANA InfoObject are intended to reduce physical data storage space?

Note: There are 2 correct answers to this question.

For which requirements do you suggest an SAP HANA modeling focus rather than an SAP BW/4HANA modeling focus?

Note: There are 2 correct answers to this question.

In SAP WebIDE for SAP HANA you have imported aproject including an HDB module with calculation views. What do you need to do in the project settings before you can successfully build the HDB module?

Whatare the benefits of separating master data from transactional data in SAP BW/4HANA?

Note: There are 3 correct answers to this question.

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 correct answers to this question.

Whatare some ofthe advantages of using SAP BW/4HANA business content?

Note: There are 2 correct answers to this question.

Which objects in SAP BW/4HANA allow you to use both fields InfoObjects in their definition?

Note: There are 3 correct answers to this question.

Which tasks are part of the Business Blueprint phase in an SAP BW/4HANA project?

Note: There are 2 correct answers to this question.

You need to drive an architecture overview model from a key figure matrix. Which is the first step you need to take?

Where is the button that automatically generates a process chain?

Which request-based deletion is possible in a DataMart DataStore object?

Which source types are available to create a generic DataSource in SAP ERP?

Note: There are 3 correct answers to this question.

Which SAP solutions can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (advanced)?

Note: There are 2 correct answers to this question.

For what reasons is the start process a special type of process in a process chain?

Note: There are 2 correct answers to this question.

What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODPcontext?

Note: There are 2 correct answers to this question.

Which of the following are possible delta-specific fields for a generic DataSource in SAP S/4HANA?

Note: There are 3 correct answers to this question.

The behavior of a modeled dataflow depends on:

• The DataSource with ist Delta Management method

• The type of the DataStoreobject (advanced) used as a target

• The up date method of the key figures in the transformation.

Which of the following combinations provides consistent information for the target?

Note: There are 3 correct answers to this question.

Frage 35 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 correct answers to this question.

You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into the first persistent data layer in SAP BW/4HAN A. Which options do you have to analyze a potential extractor issue?

Note: There are 2 correct answers to this question.

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?

In which ODP context is the operational delta queue (ODQ) managed by the target system?

Frage 39 Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP)?

Note: There  are 2 correct answers to this question.

InfoObject "CITY" is defined as a display attribute for InfoObject "CUSTOMER" InfoObject "COUNTRY" is defined as a display attribute for InfoObject "CITY". In a master data report you want to display the "COUNTRY" of a "CUSTOMER".

 Which options do you have to realize this scenario?

Note: There are 3 correct answers to this question.

Why do you set the ReadAccess Type to "SAP HANA View"in an SAP BW/4HANA InfoObject?

What should you consider when you set the High Cardinality flag for a characteristic?

Note: There are 2 correct answers to this question.

For which use case would you need to model a transitive attribute?

You create an SAP HANA HDI Calculation View. Whatare some ofthe reasons to choose the data category Cube with Star Join instead of data category Dimension?

Note: There are 3 correct answers to this question.

You create a Data Store object (advanced) using the "Data Mart DataStore Object" modeling property. Which behaviors are specific to this modeling property?

Note: There are 2 correct answers to this question.

Whatare the prerequisites for deleting business partner attribute master data in SAP BW/4HANA?

 Note: There are 2 correct answers to this question.

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 correct answers to this question.

 A. Open ODSview oftype Master Data

 B. InfoObject of type Characteristic

 C. Open ODSview oftype Facts

 D. HDI Calculation View of data category Dimension

Which join types can you use in a Composite Provider?

Note: There are 3 correct answers to this question.

For InfoObject "ADDRESS" the High Cardinality flag has been set. However "ADDRESS" has an attribute "CITY" without the High Cardinality flag. What is the effect on SID values in this scenario?

Which objects values can be affected by the key date in a BW query?

Note: There are 3 correct answers to this question.

Whatd does a Composite Provider allow you to do in SAP BW/4HANA?

Note: There are 3 correct answers to this question.

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 correct answers to this question.

What are some ofthe benefits of using an InfoSource in a data flow?

Note: There are 2 correct answers to this question.

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?

Frage 55 You consider using the feature Snapshot Support for a Stard DataStore object. Which data management process may be slower with this feature than without it?

Frage 56 Which feature of a DataStore object (advanced) should be made available to improve the performance for data analysis?

You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP BW/4HANA. Real-time reporting requirements have now changed you are asked to persist the data in SAP BW/4HANA.

 Which objects are created when using the "Generate Data Flow" function in the Open ODS View editor?

Note: There are 3 correct answers to this question.

Which recommendations should you follow to optimize BW query performance?

Note: There are 3 correct answers to this question.

Frage 59 An upper-level CompositeProvider compares current values with historic values based on a union operation. The current values are provided by a DataStore object (advanced) that is updated daily. Historic values are provided by a lower-level CompositeProvider that combines different open ODS views from DataSources.

Whatcan you do to improve the performance of the BW queries that use the upper-level CompositeProvider?

Note: There are 2 correct answers to this question.

Which modeling decisions may have side effects on runtime performance?

Note: There are 3 correct answers to this question.

Frage 61 What are prerequisites for S-API Extractors to load data directly into SAP Datasphere core tenant using delta mode?

Note: There are 2 correct answers to this question.

Frage 62 Which of the following factors apply to Model Transfer in the context of Semantic Onboarding?

Note: There are 2 correct answers to this question.

Frage 63 Which type of data builder object can be used to fetch delta data from a remote table located in the SAP BWbridge space?

Frage 64 Whatare valid options when using the Data Flow feature of SAP Datasphere?

Note: There are 3 correct answers to this question.

Frage 65 You have already loaded data from a non-SAP system into SAP Datasphere. 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?

Frage 66 Which are use cases for sharing an object?

Note: There are 3 correct answers to this question.

Frage 67 Which entity can be used as a source of an Analytic Model?

Frage 68 How  does SAP position SAP Datasphere in supporting business users?

Note: There are 3 correct answers to this question.

Frage 69 Which options doyou have to combine data from SAP BW bridge a customer space in SAP Datasphere core?

Note: There are 2 correct answers to this question.

Frage 70 Which source systems are supported in SAP BW bridge?

Note: There are 3 correct answers to this question.

Frage 71 Which options doyou have whenusing the remote table feature in SAP Datasphere?

Note: There are  3 correct answers to this question.

Frage 72 Which tasks require access to the BW bridge cockpit?

Note: There are 2 correct answers to thisquestion.

Frage 73 In SAP BW/4HANA aquery hasbeendefinedonaDatastore Object(advanced). Which authorizations does an SAP BW/4HANA user need atminimum to change the query definition?

Note: There are 2 correct answers to this question.

Frage 74 Where can you assign analysis authorizations?

Note: There are 2 correct answers to this question.

Frage 75 Where can you use an authorization variable?

Note: There are 2 correct answers to this question.

Frage 76 A user has the analysis authorization for the Controlling Areas 1000 2000. In the InfoProvider there are records for Controlling Areas 1000 2000 3000 4000. The user starts a data preview on the InfoProvider. Which data will be displayed?

Frage 77 Which types of values can be protected by analysis authorizations?

Note: There are 2 correct answers to this question.

Frage 78 How can you protect all InfoProviders against displaying their data?

Frage 79 Why do you use an authorization variable?

Frage 80 While running a query insufficient analysis authorization causes an error message. Which transaction can be used to trace the missing authorization for the specific characteristic values?

Which of the following tasks might an SAP BW/4HANA modeler perform?

There are two correct answers.

Will the security settings for securing by business area in SAP S/4HANA be automatically applied in SAP BW/4HANA

Choose the correct answer.

Fields in S_RS_COMP can protect query elements by InfoArea, InfoProvider, and query name.

Choose the correct answer.

What authorization does a reporting user require to execute a query?

There are two correct answers.

Analysis Authorization 0BI_ALL grants access to all values of all characteristics flagged as authorization-relevant.

Choose the correct answer.

Which of the following statements regarding Queries and SAP Analysis for Excel workbooks are correct?

There are two correct answers.

All reporting users should be authorized to save Analysis workbooks to roles.

Choose the correct answer.

What authorization does a reporting user require to execute a query and to display data?

There are three correct answers.

Which object types can be included in Analysis Authorizations?

There are two correct answers.

Which of the following InfoObjects grants authorization to specific key figures?

Choose the correct answer.

Without having # authorization for InfoObjects that are authorization-relevant, users may not see all of a company’s sales.

Choose the correct answer.

To implement hierarchy authorizations, do not make the InfoObject on which the hierarchy is based authorization-relevant. For example, if the hierarchy is based on cost centers, then characteristic 0COSTCENTER must not be marked authorization-relevant.

Choose the correct answer.

Which processing type for a variable can you use to design a dynamic Analysis Authorization?

Choose the correct answer.

When is it best to use the # in an analysis authorization?

Choose the correct answer.

You want to allow users to display the phone number (0PHONE) as display attribute of the customer (0CUSTOMER) in the query result. Which of the following steps are necessary?

There are two correct answers.

Key figure authorization is enabled by selecting the appropriate checkbox in the InfoObject maintenance of the relevant key figure.

Choose the correct answer.

Why is it recommended that you do not define too many characteristics as authorization-relevant?

There are two correct answers.

How can Analysis Authorizations be created?

There are two correct answers.

Which of the following authorization objects are checked when loading data into a DataStore Object (advanced)?

There are two correct answers.

A reporting user only requires Analysis Authorizations, a data load administrator only requires standard authorizations.

Choose the correct answer.

In SAP BW/4HANA, you can use SAP HANA-based source system types for sources that are accessed using the underlying SAP HANA platform.

Choose the correct answer.

ETL means that data is transformed before it is saved (loaded).

Choose the correct answer.

Which object contains information about the Delta Process?

Choose the correct answer.

Filter conditions for different Delta DTPs may overlap.

Choose the correct answer.

Can you change the data in the ODQ?

Choose the correct answer.

Table ROOSATTR can be used to check if a DataSource is released for use with ODP.

Choose the correct answer.

The delta field for generic delta must be a timestamp field.

Choose the correct answer.

The name of an append structure is proposed by the system.

Choose the correct answer.

The Extractor Checker (RSA3) can be used to open a DataSource in debug mode.

Choose the correct answer.

You can define an Open ODS View directly on an ABAP CDS View.

Choose the correct answer.

Which technology is used to create the virtual data model in SAP S/4HANA?

Choose the correct answer.

Which extraction methods require an @Analytics.dataExtraction.delta annotation in the ABAP CDS view of the source system?

There are two correct answers.