New Year Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

SAP C_BW4HANA_27 SAP Certified Application Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA 2.x Exam Practice Test

Demo: 12 questions
Total 80 questions

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

Question 1

Where can you automatically generate a process chain?

Options:

A.

Form a data flow objetc

B.

Within the process chain editor app

C.

from a streaming enable DataSource

D.

Within the process chain maintance

Question 2

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 3

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

Question 4

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.

Options:

A.

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

B.

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

C.

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

D.

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

Question 5

With which query considerations can you optimize the query performance? Note: There are 3 correct answers to this question. n/ □ Use include functions in the restricted key figures

Options:

A.

Use exclude functions in the restricted key figures

B.

Use mandatory characteristic value variables

C.

Use fewer drill-down characteristics in the initial view

D.

Use characteristic filters that overlap

Question 6

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

Options:

A.

Changing context menu entries

B.

Dragging measures in and out of the report

C.

Displaying data simultaneously in a table and a chart

D.

Including more than one data source

E.

Creating bookmarks for a navigation state

Question 7

Which SAP BW/4HANA objetcs can be used as sources of a data transfer process (DTP)? Note: There are 3 correct answers to this

question.

Options:

A.

InfoSource

B.

Open Hub Destination

C.

DataStore Objetc (advanced)

D.

CompositeProvider

E.

SAP HANA Analysis Process

Question 8

You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time udate scenario. Which fields are added to the DataSource automatically? Note: There are 3 correct answers to this question.

Options:

A.

SDI_CHANGE_TIME

B.

SDI_CHANGE_SEQUENCE

C.

SDI_RECORD_MODE

D.

SDI_CHANGE_TYPE

E.

SDI_ENTITY_COUNTER

Question 9

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 10

You use a measure with semantic type "Amount with Currency Code" in your SAP HANA calculation view. Which kind of currency reference can be assigned to the measure? Note: There are 2 correct answers to this question.

Options:

A.

A fixed currency from table TCURC

B.

Another column of the same SAP HANA view

C.

A column from another SAP HANA view

D.

A variable in the same SAP HANA view

Question 11

You want to turn a display attribute into a navigation attribute, but it's not possible to do it in the SAP BW/4HANA system. Which setting of this display aatribute could be the reason? Note: There are 2 correct answers to this question.

Options:

A.

Case-Sensitive

B.

Attribute Only

C.

High Cardinality

D.

Useable as InfoProvider

Question 12

You want to combine an existing SAP BW/4HANA Data Model with virtual data from a new non-SAP source system for test purposes. Which approach should you consider fro rapid prototyping?

Options:

A.

Field-based modeling

B.

InfoObject base modeling

C.

Generate Data Flow

D.

Business content activation

Demo: 12 questions
Total 80 questions