Which disadvantages should you keep in mind when you set the High Cardinality flag for a characteristic? Note: There are 2 correct answers to this question.

You cannot use navigation attributes for this characteristic

SID numbers are created at runtime which might negatively affetct the reporting performance

You cannot use navigation attributes for this characteristic

You cannot load more than 2 billion master data records for this characteristic

SID numbers are created at runtime which might negatively affetct the reporting performance

You cannot use this characteristic as a navigation attribute for another characteristic.

What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA? Note: There are 2 correct answers to this question.

There must be no transaction data referring to the cost centers

There must be no hierarchy for the cost centers

There must be no BW analysis authorizations defined thta use any of the cost centers

There must be no transaction data referring to the cost centers

There must be no hierarchy for the cost centers

There must be no BW query that uses cost cenetr as a free characteristics.

You have created a custom characteristic with the technical name 'COSTOBJ'. Depending on the controlling area, you need to have different atribute values assigned. How do you desing the model?

Compound the characteristic for Controlling Area with the characteristic 'COSTOBJ'

Compound characteristic 'COSTOBJ' with the characteristic for Controlling Area

Compound the characteristic for Controlling Area with the characteristic 'COSTOBJ'

Define Controlling Areas as a navigation attribute for the characteristic 'COSTOBJ'

Define characteristic 'COSTOBJ' as a navigation attribute for Controlling Area

Which data deletion options are offered for a standard DataStore object (advanced)? Note: There are 3 correct answers to this question.

Deletion of all data from active table only

Deletion of data from all tables

Selection deletion incluiding data of subsequent targets

'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?

SID values are not stored for InfoObject ADDRESS

SID values are generated when data for infoObject ADDRESS is loadet

SID values are generated when InfoObject CITY is activated

SID values are generated when InfoObject ADDRESS is activated.

You create a DataStore Object(advanced) using the Data Mart DataStore Object modeling property. Which behaviors are specific to this modelling property? Note: There are 2 correct answers to this question.

Reporting is done based on a union of the inbound and active tables

The records are treated as if all characteristics are in the key.

The change log table will be filled only after data activation

Reporting is done based on a union of the inbound and active tables

Query result are shown only when data has been activated

The records are treated as if all characteristics are in the key.

What are some of advantages of using SAP BW/4HANA business content? Note: There are 2 correct answers to this question.

Accelerated SAP BW/4HANA implementation using ready-made models

Ability to combine business content objects with custom-defined objects.

Automatic generation of Analysis Authorizations during SAP BW/4HANA content activation

Automatic content activation during installation of SAP BW/4HANA

Accelerated SAP BW/4HANA implementation using ready-made models

Ability to combine business content objects with custom-defined objects.

What does a Composite Provider allow you to do in SAP BW/4HANA? Note: There are 3 correct Answers to this question.

Combine Infoprovider using Join and Unions

Define new restricted key figures

SAP HANA HDI calculation views.

Combine Infoprovider using Join and Unions

Define new restricted key figures

Create new calculated fields Integrate

SAP HANA HDI calculation views.

Which interface do you use to create a BW InfoObjet with access type 'SAP HANA view!?

BW moedling perspective in SAP HANA studio

SAP HANA modeler perspective in SAP HANA studio

Embedded SAP GUI in SAP HANA studio

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 nswers to this question.'

High Cardinality is set in InfoObject B

Attribute Only is set in InfoObject B

Conversion Routine 'ALPHA' is set in InfoObject A

High Cardinality is set in InfoObject B

Attribute Only is set in InfoObject B

Data Type 'Character String' is set in InfoObject A

Conversion Routine 'ALPHA' is set in InfoObject A

InfoObject B is defined as a Key Figure.

InfoObject CITY is defined as a display attribute for InfoObject CUSTOMER, and 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 the scenario? Note: There are 3 correct answer to this question.'

Combine CUSTOMER, CITY and COUNTRY in a Open ODS View using a sequence of associations.

Generate external views for CUSTOMER, CITY and COUNTRY, and join them in another calculation view.

Add COUNTRY as a transitive attribute for CUSTOMER in InfoObject definition.

Combine CUSTOMER, CITY and COUNTRY in a Open ODS View using a sequence of associations.

Generate external views for CUSTOMER, CITY and COUNTRY, and join them in another calculation view.

Combine CUSTOMER, CITY and COUNTRY in a Composite Provider using a sequence of left outer join operators.

Include CUSTOMER to rows in the BW Query on CUSTOMER and activate the Universal Display Hierarchy setting.

Add COUNTRY as a transitive attribute for CUSTOMER in InfoObject definition.

For which requirements do you suggest an SAP HANA modeling focus rather that an SAP BW/4HANA modeling focus?? Note: There are 2 correct answers to this question.

Enhance existing SAP HANA content models

Leverage SQL in-house knowledge

Enhance existing SAP HANA content models

Report on a harmonized set of master data

Load snapshots or deltas from different sources on a periodic basis

Leverage SQL in-house knowledge

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

Flexible Enterprise Data Warehouse Core layer.

Open operational data store layer

Flexible Enterprise Data Warehouse Core layer.

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

ABAP CDS view based virtual data model.

SAP HANA optimized business content

Generated external SAP HANA Calculation Views

ABAP CDS view based virtual data model.

You have an existing field-based data flow that follows the LSA++ concept. To meet a new urgent business requirement for a 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.

Add the characteristic to the DataStore object (advanced)

Associate the field with the characteristic in the CompositeProvider

Add the characteristic to the DataStore object (advanced)

Associate the field with the characteristic In the Open ODS View

Assign hierarchy properties to the field in the SW Query

'What are benefits of separating master data from transactional data in SAP BW/4HANA? Note: There are 3 correct answer to this question.'

Allowing different data load frequency

Ensuring referential integrity on your transactional data

Providing language dependent master data texts.

Allowing different data load frequency

Reducing the number of data transfer processes

Ensuring referential integrity on your transactional data

Providing language dependent master data texts.

Avoiding generation of SID values.

Which tasks are part of the Business Blueprint and Data Model Definition phase in an SAP BW/4HANA project? Note: There are 3 correct answers to this question.

Specify necessary data conversion

Implement transport routes and layers

Monitor batch jobs and data volume

You are following a top-down method for your SAP BW/4HANA modeling project. What would be your first task?

Check available sources in the SAP ERP system

Determine if physical or logical objetcs will be needed

Determine enhancements of SAP Business Content

What is the purpose of an architecture overview model?

To identify the required data sources.

To identify the user groups and required authorizations

To automatically generate the LSA++ architecture

To determine the sequence of projects

To identify the required data sources.

How can the delta merge process be initiated in SAP BW/4HANA? Note: There are 2 correct answers to this question.

By using a specific process type in a process chain

By setting a specific flag in the data transfer process

By using a specific process type in a process chain

By setting a specific flag in the transformation

By using the SAP BW/4HANA data load monitor.

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

To improve the read performance of InfoProviders

To combine the query cache from different executions

To move the most recent data from disk to memory

To improve the read performance of InfoProviders

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

Apply mapping rules during the replication

Set the reading type and portion sizes

Apply mapping rules during the replication

Set the reading type and portion sizes

Change or enrich the table structure

Apply customizing settings to the database redo logs.

What are the key benefits of using the SAP Landscape Transformation Replication Server for data provisioning into SAP HANA? Note: There are 3 correct answers to this question.

Real-time and scheduled data replication

In an SAP HANA smart data integration flowgraph, which transformation options are available? Note: There are 3 correct answers to this question.

Execute an SAP HANA analysis process

The Database Explorer in the Web IDE for SAP HANA proveides a data file improt wizard to create a table in SAP HANA from a flat file. What are possible actions adter the system suggests the target structure?? Note: There are 3 correct answers to this question.

Change the order of the fields in the target table

Switch the table type between row store and column store

Adjust the suggested data type of the target table fileds

Change the order of the fields in the target table

Switch the table type between row store and column store

Define sorting properties for a target table field

Adjust the suggested data type of the target table fileds

Map InfoObjetcs to fields in the target tavle

SAP provides three data warehouse solutions to provide customers more flexibility. How is SAP Data Warehouse Cloud positioned?

To support business user with a new self-service tool to model their own data flows

To empower business users to generate SQL code that ispushed to SAP BW/4HANA

To empower business users to create an dmaintain process chain from SAP BW/4HANA dataflows

To support business user who want to simplify theris own ABAP routines

To support business user with a new self-service tool to model their own data flows

You want to define a restricted column in an SAP HANA calculation view. What do you need to define? Note: There are 2 correct answers to this question.

A reference to an existing measure

Where is the button that automatically generates a processchain?

In the editor of a data flow object

In the editor of a data transfer process

In the app called Process Chain Editor

In the editor of a data flow object

In the SAP GUI transaction for Process Chain Maintenance

Which tasks are part of the Business Blueprint phase in an SAP BW/4HANA limits? Note: There are 2 correct answers to this question.

Analyze key performance indicators of the business processes

Collect central and individual information requirements

Activate SAP business content objects that comply with the LSA++ architecture u

Associate an InfoObject to a field in an Open ODS view

Analyze key performance indicators of the business processes

Collect central and individual information requirements

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

Report on navigational attributes of navigational attributes

Store time-dependent snapshots of master data attributes

Load attribute using the enhanced master data update

Generate a transient provider for a BW query on master data attribute

SAP C_BW4H_214 Practice Test 2 - Free Online Exam Questions 41-80

What are the reasons for implementing CompositeProviders? Note: There are 2 correct answers to this question.

Become a Premium Member for full access

Unlock Premium Member

SAP C_BW4H_214 Practice Test 2

Question

SAP C_BW4H_214 Practice Tests

Practice Tests