When loading master data for a material, you want to look at the new values before they are released for reporting. What could you do using modeling features? Note: There are 2 correct answers to this question.

When you define the data transfer process, choose the 'Set Manually' setting for 'Overrall status of request'

When you define the material characteristic, select the 'Enhanced Master data update' setting

When you define the attributes of material, select the 'Time Dependent' setting

When you define the data transfer process, select the 'Load records wit new key only' setting

When you define the data transfer process, choose the 'Set Manually' setting for 'Overrall status of request'

When you define the material characteristic, select the 'Enhanced Master data update' setting

In a DatStore object (advanced) of type Data Mart, which request-based deletion is possibel?

The lastest not-yet-activated reques in the inbound table

The lastest request in the active data table

Any older activated reqeust in the inbound table

The lastest request in the change log table

You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder? Note: There are 2 correct answers to this question.

Open ODS view of type Master Data

InfoObjetc of type Characteristic

Calculation View of type Dimension

Open ODS view of type Master Data

InfoObjetc of type Characteristic

For a BW query, you want to have the first month of the curret quarter as a default value for an input-ready BW variable for the characteristic OCALMONTH. Which processing tyoe do you use?

Manuel Input with default value

Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question

Use fewer drill-down characteristics in the initial view

Use mandatory characteristic value variables

Use include functions in the restricted key figures.

Use fewer drill-down characteristics in the initial view

Use characteristic filters that overlap

Use exclude functions in the restricted key figures

Use mandatory characteristic value variables

Use include functions in the restricted key figures.

You want to run a BW query, but you only have partial authorization for the data selection. What happens related to the BW query in this scenario?

The BW query starts and shows an error message

The BW query does not start running

The BW query starts and the unautohorized values are

The BW query starts and only the authorized data is displayed

You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum) If you keep the default settings of the BW query, what is presented regarding the result rows?

Only one result row with the sales revenue sum of all 100 customers

Only one result row with the sales revenue sum of the top 10 customers

One result row with the saled revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers

One result row with the saled revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 100 customers

What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct answers to this question.

By entering the values manually

By using a transformation and data transfer process

By entering the values manually

By accessing an SAP HANA Calculation View of data category Dimension

You are involved in an SAP BW/4HANA project focusin on General Ledger reporting and want to use the SAP ERP Estandar DataSource oFI_GL_14 (New GL Items). Which transactions can be used to activate this DataSource? Note: There are 2 correct answers to this question.

Transaction RSA1 (BI Content) in the SAP BW/4HANA system

Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system

Transaction RSA1 (BI Content) in the SAP BW/4HANA system

Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system

Transaction RS02 (Maintain Generic DataSource) in the SAP source system

Transaction ODQMON (Monitor Delta Queues) in the SAP Source system

What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?

Request is canceled, records are not tracked, and tarjet 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 tarjet is not updated

Request is set to success, error stack is written, and valid records are updated

Request is canceled, firt incorrect record is tracked, and target is not updated.

Where can you automatically generate a process chain?

Within the process chain editor app

from a streaming enable DataSource

Within the process chain maintance

You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into the first persistent data layer in SAP BW/4HAN

Use the ODQ maintance in SAP BW/4HANA

Check entries in table RSDDSTATEXTRACT in SAP ERP

Which options do you hacve to analyze a potential extractor issue? Note: There are 2 correct answers to this question.

Use the ODQ maintance in SAP BW/4HANA

Use transaction RSA3 (Extractor checker) in SAP ERP

Check entries in table RSDDSTATEXTRACT in SAP ERP

Use program RODPS_REPL_TEST in SAP ERP

What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? Note: There are 2 correct answers to this question.

An ODP source system with contest ODP_CDS must be created in SAP BW/4HANA

The ABAP CDS views must be defined with the appropriate data extraction annotations

An ODP source system with contest ODP_CDS must be created in SAP BW/4HANA

The ABAP CDS views must be defined with the appropriate data extraction annotations

THE ABAP CDS views must be released via program RODPS_OS_EXPOSE for BW extraction

An Operational Data Provisioning Framework must be configured in SAP BW/4HANA

Which SAP solutions can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (Advanced)?There are 2 correct answers to this question.

SAP Landscape Transformation Replication Server

You create a generic DataSource in SAP ERP. 'How can you enable your generic DataSource to be used as an ODP_SAP DataSource in SAP BW/4HANA in casa it is not available by default?'

Run the program RODPS_OS_EXPOSE in SAP ERP for the DataSource

Release the DataSource in SAP BW/4HANA for ODP

Run the program RODPS_OS_EXPOSE in SAP ERP for the DataSource

Generate the PSA table of the DataSource in SAP BW/4HANA

Add a subscription in SAP ERP using the program RODPS_REPL_TEST.

What can you leverage using the live data connectyions of SAP Analytics Cloud with SAP BW/4HANA? Note: There are 2 correct answers to this question.

Existing authorization concepts

BW data models for planning scenarios

Process chain streaming functionally

You create a report with SAP Crystal Reports for Enteprise and need an analysis view as a data source. Which tool can you use to create this analysis view?

SAP Analysis for Microsoft Office

SAP BusinessObjetc Web Intelligence

SAP Crustal Reportis for Enterprise

SAP Analysis for Microsoft Office

Which features does SAP Analysis for Microsoft Office provide? Note: There are 3 correct answers to this question.

Dragging measures in and out of the report

Displaying data simultaneously in a table and a chart

Including more than one data source

Dragging measures in and out of the report

Displaying data simultaneously in a table and a chart

Including more than one data source

Creating bookmarks for a navigation state

You want build a web-based dashboard with interactive visualizations using Javascript. Which SAP tool can you use to create this?

SAP Analytics Cloud analytics designer

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

Combine master data and transactional data

Provide default time characteristics

Combine master data and transactional data

You want to build an SAP HANA HDI 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 data category to DIMENSION, what do you have to do?

Switch from an aggregation node to a projection node

Switch from an aggregation node to a star join node

Switch from an aggregation node to a projection node

Switch form a projection node to an aggregation node

Switch from a projection node to a star join node

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

A fixed currency from table TCURC

Another column of the same SAP HANA view

A fixed currency from table TCURC

Another column of the same SAP HANA view

A column from another SAP HANA view

A variable in the same SAP HANA view

In an SAP HANA HDI Calculation View, you need to combine attributes data (left table) and the data's language-dependent text (right table) using a text join. What should you select to restrict the result set to the logon language?

the language column in the right table

the language column in the left table

the language column in the right table

The logon language in the left table

The join cardinality between both tables

Why is the start process a special type of process in a process chain? Note: There are 2 correct answers to this question.

Open ODS view of type Master Data

InfoObjetc of type Characteristic

Calculation View of type Dimension

Open ODS view of type Master Data

InfoObjetc of type Characteristic

What are benefits of using an InfoSource in a data flow? Note: There are 2 correct answers to this question.

Reducing the numer od data transfer processes (DTP)

Storing the extraction delta information of the data source file

Reducing the numer of transformations for scenarios with many sources and targets

Connecting sequetial trnsformartions in the data flow without storing the data again

Reducing the numer od data transfer processes (DTP)

Storing the extraction delta information of the data source file

SAP C_BW4H_214 Practice Test 1 - Free Online Exam Questions 1-40

Question 1 / 40

Using SAP HANA as modeling focus, you want to combine data from different sources. Which techniques can you use? Note: There are 2 correct answers to this question.

BAPIs (Business Application Programming Inetrface)

Calculation views

AMDPs (ABAP Manged Database Procedures)

Stored procedures

Comment (0)

SAP C_BW4H_214 Practice Test 1

Question

SAP C_BW4H_214 Practice Tests

Practice Tests