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

Question # 4

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

SAP HANA optimized business content

SAP Agile Data Preparation

Generated external SAP HANA Calculation Views

ABAP CDS view based virtual data model.

Full Access

Question # 5

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.

Analysis

Components

Information

Design Rules

Full Access

Question # 6

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

SAP Web IDE for SAP HANA

Full Access

Question # 7

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 Facts

Calculation View of type Dimension

Open ODS view of type Master Data

InfoObjetc of type Characteristic

Full Access

Question # 8

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

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

Full Access

Question # 9

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

Full Access

Question # 10

Where is the button that automatically generates a processchain?

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

Full Access

Question # 11

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

Open operational data store layer

Data acquisition layer

Virtual data mart layer

Flexible Enterprise Data Warehouse Core layer.

Full Access

Question # 12

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

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

Full Access

Question # 13

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

Full Access

Question # 14

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

Package

HDB module

SQL script procedure

Space

Full Access

Question # 15

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 analysis

BW data models for planning scenarios

Process chain streaming functionally

Full Access

Question # 16

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 for rapid prototyping?

Field-based modeling

InfoObject base modeling

Generate Data Flow

Business content activation

Full Access

Question # 17

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

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.

Full Access

Question # 18

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 left table

the language column in the righttable

The logon language in the left table

The join cardinality between both tables

Full Access

Question # 19

Where can you automatically generate a process chain?

Form a data flow objetc

Within the process chain editor app

from a streaming enable DataSource

Within the process chain maintance

Full Access

Question # 20

Which join types can you use in a CompositeProvider? Note: There are 3 correct answers to this question.

Full outer join

Referential join

Hierarchy join

Text join

Inner join

Full Access

Question # 21

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?

/BW4/

/IMO/

/SFA/

/0SAP/

Full Access

Question # 22

"How does SAP position SAP Data Warehouse Cloud in supporting business users?"

Business users can maintain process chains from SAP BW/4HANA dataflows

Business users can create agile models from different sources

Business users can allocate system resources without IT involvement

Business users can generate SQL code that is pushed to SAP BW/4HANA.

Full Access

Question # 23

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

Full Access

Question # 24

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 Facts

Calculation View of type Dimension

Open ODS view of type Master Data

InfoObjetc of type Characteristic

Full Access