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

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

Demo: 15 questions
Total 100 questions

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

Question 1

What happens if a query with time-dependent attributes is executed but NO query key date is set?

Options:

A.

The current date is used as key date.

B.

The system displays only NON-time-dependent attributes.

C.

The valid from date of the attribute is used as key date.

D.

The system displays an error message.

Question 2

which advantages can you leveragewhile importing data into a new sap hana table using a flat file? (2 answer)

Options:

A.

adjustement for column, type, lenght, and name is possible

B.

easiness of loading

C.

trasformation capabilities

D.

availability of delta logic

Question 3

You create a DataStore object (advanced) using model template Standard DataStore Object. Which flags are

set?

Note: There are 2 correct answers to this question.

Options:

A.

Activate Data

B.

Write Change Log

C.

All Characteristics are Key

D.

Unique Data Records

Question 4

You need to use an SAP ERP standard DataSource to load data into SAP BW/4HANA. Which prerequisite must be fulfilled to use the DataSource in the Operational Data Provisioning context?

Options:

A.

lt must exist in table ROOSATTR.

B.

It must be delta-enabled.

C.

It must be in-memory-optimized.

D.

It must have a queue entry in transaction ODQMON.

Question 5

Which query property do you set to minimize the initial run time for the query read mode?

Options:

A.

Read all data at once.

B.

Read data individually from InfoProvider.

C.

Cache is inactive.

D.

Read data when you navigate or expand hierarchies.

Question 6

Which SAP tool do you suggest to create a pixel-precise formatted report?

Options:

A.

SAP Lumira, discovery edition

B.

SAP Analysis for OLAP

C.

SAP Crystal Reports for Enterprise

D.

SAP Analytics Cloud

Question 7

You plan to regularly transfer changes from an SAP ERP custom table to SAP BW/4HANA. An additional custom development may NOT be implemented in the source system. Which Operational Data Provisioning (ODP) source system type do you recommend?

Options:

A.

ODP-SLT

B.

ODP-SAP

C.

ODP-BW

D.

ODP-CDS

Question 8

In which sequence can you create a reusable key figure structure? Note: There are 2 correct answers to this question.

Options:

A.

1. Create a new structure in the context menu of a calculated key figure. 2. Save the structure as a global structure.

B.

1. Apply filters to a key figure structure in SAP Analysis for Microsoft Office. 2. Save the structure as a global structure.

C.

1. Create a new structure in the context menu of an InfoProvider. 2. Add key figures, selections, and formulas.

D.

1. Create a new structure with key figures, selections, and formulas in a que 2. Save the structure as a global structure.

Question 9

Which source types can you use for a generic DataSource? Note: There are 2 correct answers to this question.

Options:

A.

Core data service view

B.

Function module

C.

DB view or table

D.

SAP HANA calculation view

Question 10

Which transformation options can be executed in an SAP HANA database? Note: There are 2 correct answers to this question.

Options:

A.

Formulas

B.

Read master data

C.

Transfer routines

D.

ABAP expert routines

Question 11

Your main BW query contains a characteristic value variable with a replacement path from a query. When is the pre-query executed?

Options:

A.

Each time the main query is executed, before the filter values are applied.

B.

Each time the main query is executed, after the filter values are applied.

C.

Directly after a predefined broadcasting event was triggered to calculate the pre-query.

D.

Directly after data is loaded to the InfoProvider of the pre-query.

Question 12

When modeling a characteristic, which SAP BW/4HANA feature are intended to reduce the physical data volume? (2 answer)

Options:

A.

Reference characteristic

B.

Transitive attribute

C.

Compounding

D.

Enhanced master data

Question 13

Your customer is using a pure SAP HANA native data warehouse approach. Which tools should the customer

install?

Note: There are 2 correct answers to this question.

Options:

A.

SAP solutions for enterprise information management

B.

BW Modeling Tools

C.

SAP Information Steward

D.

Process Chain Monitoring app

Question 14

You create a BW query. How can you check the navigational attributes of a basic characteristic?

Options:

A.

Add the basic characteristic to a BW query and check the display properties.

B.

Open the editor for the basic characteristic and check the Attribute tab.

C.

Select Attributes from the context menu of the basic characteristic in the rows section.

D.

Open the InfoProvider view and check the Attribute folder below the basic characteristic.

Question 15

Which actions can you perform with an SAP HANA calculation view that has the DIMENSION data category

assigned?

Note: There are 2 correct answers to this question.

Options:

A.

Join serveral tables.

B.

Define text joins.

C.

Persist master data.

D.

Aggregate measures.

Demo: 15 questions
Total 100 questions