Black Friday Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  1. Home
  2. SAP
  3. NCCSA
  4. C_BW4H_214 - SAP Certified Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA

SAP C_BW4H_214 SAP Certified Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA Exam Practice Test

Page: 1 / 8
Total 83 questions
Get C_BW4H_214 Full Access Download C_BW4H_214 PDF

SAP Certified Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA Questions and Answers

Question 1

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?

Options:

A.

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

B.

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

C.

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

D.

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

Question 2

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.

Options:

A.

Change the order of the fields in the target table

B.

Switch the table type between row store and column store

C.

Define sorting properties for a target table field

D.

Adjust the suggested data type of the target table fileds

E.

Map InfoObjetcs to fields in the target tavle

Question 3

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

Options:

A.

Use fewer drill-down characteristics in the initial view

B.

Use characteristic filters that overlap

C.

Use exclude functions in the restricted key figures

D.

Use mandatory characteristic value variables

E.

Use include functions in the restricted key figures.

Question 4

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."

Options:

A.

High Cardinality is set in InfoObject B

B.

Attribute Only is set in InfoObject B

C.

Data Type "Character String" is set in InfoObject A

D.

Conversion Routine "ALPHA" is set in InfoObject A

E.

InfoObject B is defined as a Key Figure.

Question 5

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.

Options:

A.

Apply mapping rules during the replication

B.

Set the reading type and portion sizes

C.

Change or enrich the table structure

D.

Convert Unicode to non-Unicode

E.

Apply customizing settings to the database redo logs.

Question 6

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?

Options:

A.

Compound characteristic "COSTOBJ" with the characteristic for Controlling Area

B.

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

C.

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

D.

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

Question 7

What is the purpose of an architecture overview model?

Options:

A.

To identify the user groups and required authorizations

B.

To automatically generate the LSA++ architecture

C.

To determine the sequence of projects

D.

To identify the required data sources.

Question 8

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

Options:

A.

To combine the query cache from different executions

B.

To move the most recent data from disk to memory

C.

To decrease memory consumption

D.

To improve the readperformanceof InfoProviders

Question 9

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

Options:

A.

Report on navigational attributes of navigational attributes

B.

Store time-dependent snapshots of master data attributes

C.

Load attribute using the enhanced master data update

D.

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

Question 10

You want to add a Source System of type Big Data in SAP BW/4HANA. Which adapters can you use to reference the remote source system? Note: There are 2 correct answers to this question.

Options:

A.

IQ (ODBC) adapter

B.

SAP HANA Adapter

C.

Spark SQL Adapter

D.

SAP Vora ODBC adapter

Question 11

Which source types are available to create a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question.

Options:

A.

ABAP class method

B.

Database view

C.

HDI Calculation View

D.

ABAP function module

E.

SAP query

Question 12

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

Options:

A.

SID values are not stored for InfoObject ADDRESS

B.

SID values are generated when data for infoObject ADDRESS is loadet

C.

SID values are generated when InfoObject CITY is activated

D.

SID values are generated when InfoObject ADDRESS is activated.

Question 13

You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? Note: There are 2 correct answers to this question.

Options:

A.

Analysis

B.

Components

C.

Information

D.

Design Rules

Question 14

With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework. Which tecnical namespace is assigned to identify the new SAP ERP-related business content?

Options:

A.

/BW4/

B.

/IMO/

C.

/SFA/

D.

/0SAP/

Question 15

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?

Options:

A.

The BW query starts and shows an error message

B.

The BW query does not start running

C.

The BW query starts and the unautohorized values are

D.

The BW query starts and only the authorized data is displayed

Question 16

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?

Options:

A.

SAP BusinessObjetc Web Intelligence

B.

SAP Lumira, designer edition

C.

SAP Crustal Reportis for Enterprise

D.

SAP Analysis for Microsoft Office

Question 17

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

Options:

A.

Combine Infoprovider using Join and Unions

B.

Join two ABAP CDS views

C.

Define new restricted key figures

D.

Create new calculated fields Integrate

E.

SAP HANA HDI calculation views.

Question 18

What are some of the variable types n a BW query that can use the processing tupe SAP HANA Exit. Note: There are 2 correct answers to this question.

Options:

A.

Formula

B.

Text

C.

Charateristic value

D.

Hierarchy node

Question 19

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.

Options:

A.

Open ODS view of type Facts

B.

Calculation View of type Dimension

C.

Open ODS view of type Master Data

D.

InfoObjetc of type Characteristic

Question 20

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.

Options:

A.

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

B.

There must be no transaction data referring to the cost centers

C.

There must be no hierarchy for the cost centers

D.

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

Question 21

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."

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 22

You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into the first persistent data layer in SAP BW/4HANA. Which options do you hacve to analyze a potential extractor issue? Note: There are 2 correct answers to this question.

Options:

A.

Use the ODQ maintance in SAP BW/4HANA

B.

Use transaction RSA3 (Extractor checker) in SAP ERP

C.

Check entries in table RSDDSTATEXTRACT in SAP ERP

D.

Use program RODPS_REPL_TEST in SAP ERP

Question 23

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?

Options:

A.

Customer Exit

B.

Manual Input with offset value

C.

Replacement Path

D.

Manuel Input with default value

Question 24

Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question.

Options:

A.

Position of child nodes

B.

Expand to level

C.

Time dependency

D.

Sort direction

E.

Allow temporal hierarchy join

Load More C_BW4H_214 Questions 
Page: 1 / 8
Total 83 questions
Get C_BW4H_214 Full Access Download C_BW4H_214 PDF