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

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

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

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Question 1

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 2

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

Options:

A.

ODP_BW

B.

ODP_CDS

C.

ODP_SAP

D.

ODPJHANA

Question 3

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

Options:

A.

Check available sources in the SAP ERP system

B.

Collect reporting requirements

C.

Determine if physical or logical objetcs will be needed

D.

Determine enhancements of SAP Business Content

Question 4

You would like to highlight the deviation from predefined threshold values for key figures actual revenue. Which BW feature do you use?

Options:

A.

Structure

B.

Conditions

C.

Exceptions

D.

Calculated key figures

Question 5

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

Real-time and scheduled data replication

Field type mapping

Virtualization capabilities

All databases are supported

Transformations using ABAP

Options:

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

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 8

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.

Options:

A.

Create restricted columns

B.

Provide default time characteristics

C.

Persist transactional data

D.

Combine master data and transactional data

E.

Aggregate measures as a sum

Question 9

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.

Options:

A.

A reference to an existing measure

B.

An aggregation method

C.

A condition criterium

D.

An SAP HANA data type

Question 10

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 11

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.

Options:

A.

Existing authorization concepts

B.

BW data models for analysis

C.

BW data models for planning scenarios

D.

Process chain streaming functionally

Question 12

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 13

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 14

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?

Options:

A.

Switch from an aggregation node to a star join node

B.

Switch from an aggregation node to a projection node

C.

Switch form a projection node to an aggregation node

D.

Switch from a projection node to a star join node

Question 15

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.

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 16

Which features of an SAP BW/4HANA InfoObjet are intended to reduce the physical data volume? Note; There are 2 correct answers to this question.

Options:

A.

Reference charateristic

B.

Transitive attribute

C.

Compounding charateristic

D.

Enhanced master data update

Question 17

Why is the start process a special type of process in a process chain? 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 18

In a BW query with cells, you need to overwrite the initial definition of a cell. With which cell tupes can this be achieved?? Note: There are 2 correct answers to this question.

Options:

A.

Selection cell

B.

Reference cell

C.

Formula cell

D.

Help cell

Question 19

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.

Options:

A.

Enhance existing SAP HANA content models

B.

Report on a harmonized set of master data

C.

Load snapshots or deltas from different sources on a periodic basis

D.

Leverage SQL in-house knowledge

Question 20

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

Options:

A.

Package

B.

HDB module

C.

SQL script procedure

D.

Space

Question 21

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?

Options:

A.

the language column in the left table

B.

the language column in the righttable

C.

The logon language in the left table

D.

The join cardinality between both tables

Question 22

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 23

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.

Options:

A.

The change log table will be filled only after data activation

B.

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

C.

Query result are shown only when data has been activated

D.

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

Question 24

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.

Page: 1 / 8
Total 83 questions