C_BW4HANA_27 SAP Certified Application Associate Exam Questions

dumps2022-03-28T02:24:57+08:00

C_BW4HANA_27 SAP Certified Application Associate exam questions are useful in the preparation. In real SAP Certification C_BW4HANA_27 exam, there are 80 questions, and you have 180 minutes to take the test. The required cut score of C_BW4HANA_27 exam is 65%. The test language is English. Free SAP Certified Application Associate C_BW4HANA_27 exam questions are below.

Page 1 of 4

1. Which sources types can you select when you create an Open ODS view? Note: There are 3 correct answers to this question.

SAP BW DataSource

Characteristic

Virtual table using SAP HANA smart data access

Transformation

InfoSource

2. You create a BW query.

How can you check the navigational attributes of a basic characteristic?

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

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

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

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

3. Which objects can you use as components in a CompositeProvider in SAP BW/4HANA? Note: There are 2 correct answers to this question.

BW query

Open ODS view

CompositeProvider

Semantic group

4. You set up the 2LIS_02_ITM (Purchasing Line Item) data source in SAP ERP using the logistics cockpit. Afterward, you successfully run the initialization into SAP BW/4HANA. Your delta load into SAP BW/4HANA shows zero records even though new purchase orders were created.

How do you explain that the delta records do NOT appear in SAPBW/4HANA?

A reinitialization for sales orders in SAP ERP was triggered using the logistics cockpit, which deleted the purchase order item initialization.

All old purchase orders in SAP ERP were archived overnight before the delta loads.

Purchasing extractors in SAP ERP were set up with Queued Delta update mode and the collective run job was NOT scheduled.

Another SAP BW/4HANA system already picked up the new purchase orders using a delta load

5. Which properties determine the delta process within the Operational Data Provisioning (ODP) delta management for Data Sources? Note: There are 2 correct answers to this question.

Serialization

Delta type

Record mode

Parallelization

Record type

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

Read all data at once.

Read data individually from InfoProvider.

Cache is inactive.

Read data when you navigate or expand hierarchies.

7. You model a second SAP BW/4HANA CompositeProvider to integrate tables from an SAP HANA database schema with an existing SAP BW/4HANA CompositeProvider.

What must you do first?

Set The CompositeProvider Can Be Added to Another CompositeProvider flag.

Assign consumption properties to the new SAP HANA calculation view.

Connect an export DataSource from the exisiting CompositeProvider to the new CompositeProvider.

Create an Open ODS view with consumption properties to consume the data in theSAP BW/4HANA schema.

8. Which of the following methods supports the SAP HANA data virtualization approach with OBDC technology?

SAP HANA smart data access

SAP HANA smart data integration

SAP Landscape Transformation Replication Server

SAP Data Services

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

ActivateData

Write Change Log

All Characteristics are Key

Unique Data Records

10. How can you persist data from any SAP HANA database table to a table in the SAP BW schema? Note: There are 3 correct answers to this question.

Create an Open ODS view.

Consume the view using aCompositeProvider.

Create an SAP HANA calculation view.

Consume the view using a CompositeProvider.

Create an Open ODS view. Generate a data flow.

Create a DataSource.

Load the data to a DataStore object (advanced).

Page 2 of 4

11. You use the wizard to create an SAP BW/4HANA Big Data source system.

Which activities are mandatory? Note: There are 3 correct answers to this question.

Specify connection type Big Data.

Select a database object schema.

Specify business content type.

Specify release type.

Select a remote source.

12. You create a transformation from a DataSource to a DataStore object (advanced). The DataSource provides an after-image delta.

Which key figure aggregation type do you select?

Summation

Minimum

Maximum

Overwrite

13. Which condition must you ensure if you want to replicate data based on a view with SAP Landscape Transformation Replication Server?

View-based data result sets must be kept persistent first until data replication can take place.

An SAP HANA source system must be defined to consume the view.

Each table of the view requires a defined trigger to enable data replication.

One table as part of the view has to be defined as primary table and is used to trigger data replication.

14. Which layers are part of the layered scalable architecture for SAP BW/4HANA (LSA++)? Note: There are 2 correct answers to this question.

Open Operational Data Store

Native SAP HANA data mart

Virtual data mart

Sourcesystem

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

SAP Lumira, discovery edition

SAP Analysis for OLAP

SAP Crystal Reports for Enterprise

SAP Analytics Cloud

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

Formulas

Read master data

Transfer routines

ABAP expert routines

17. What can you create within the SAP BW data flow object? Note: There are 2 correct answers to this question.

InfoAreas

Key figures

InfoProviders

Transformations

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

SAP solutions for enterprise information management

BW Modeling Tools

SAP Information Steward

Process Chain Monitoring app

19. You need to enable real-time streaming using SAP HANA smart data integration (SDI) to load data into a DataStore object (advanced).

What are prerequisites for this requirement? Note: There are 2 correct answers to this question.

The source system is pulling data into SAP BW/4HAN

The process chain is running in streaming mode.

The data target is a DataStore object (advanced) of the InfoCube model template.

The adapter is real-time enabled.

20. Which of the following use cases is classified as operational reporting?

Year-to-date comparison reports containing prior and actual year numbers

Evaluation of trends over several years

Reporting requirements with monthly data refreshes

Near-real-time access to original transactional values

Page 3 of 4

21. What must you do to define an Inventory InfoProvider in SAP BW/4HANA? Note: There are 3 correct answers to this question.

Select the All Characteristics are Key model property.

Select the Unique Data Records model property.

Assign at least one non-cumulative key figure.

Assign at least one cumulative key figure.

Select the Inventory model property.

22. Which SAP BW/4HANA features support the code-to-data principle? Note: There are 3 correct answers to this question.

SAP HANA models as part providers in CompositeProviders

ABAP Managed Database Procedures in an SAP BW/4HANA transformation

Query settings fo read near-line storage data

Activation of a DataStore object (advanced)

Global transfer routines for master data harmonization

23. When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question.

The hierarchical structure will be time-dependent.

The structure will contain formulas.

The structure will depend on the order of the row characteristics.

The structure exists in the source system.

The query data will be restricted to a hierarchy node.

24. Why do you recommend modeling a data layer in SAP BW/4HANA? Note: There are 2 correct answers to this question.

To pre-define a data layout

To fulfill snapshot requirements

To immediately display changed entries

To homogenize and cleanse data from different sources

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

Core data service view

Function module

DB view or table

SAP HANA calculation view

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

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

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

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

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

27. For which activity do you use the key figure matrix?

Structure the information from the requirement analysis.

Provide information on the relations between characteristics.

List properties of the data sources.

Allocate project resources.

28. Which settings can you define in a data transfer process (DTP) if you load data into a DataStore object (advanced)? Note: There are 3 correct answers to this question.

Extraction mode

Error handling

Activation handling

Data tiering

Semantic groups

29. How do you enable streaming mode for a process chain?

Navigate to Process Chain Maintenance (RSPC). Select Streaming Mode in the process chain attributes.

Navigate to Customizing (SPRO). Change the general settings for SAP BW/4HAN

Navigate to Modeling DW Workbench (RSA1). Activate streaming mode on the Current Settings Folder tab.

Navigate to Process Chain Maintenance (RSPC). Add a new process variant for streaming mode.

30. What must you do first if you need to define help cells for formulas in the cell editor?

Define two formulas in a structure.

Define two structures in a query.

Define two selections in a structure.

Reuse a structure in a second query.

Page 4 of 4

31. You need to integrate data from several SAP systems and non-SAP systems to support real-time analytics.

Why do you recommend the SAP Landscape Transformation (SLT) Replication Server for real-time data replication into SAP HANA?

The SLT Replication Server provides flexible multisystem support to manage data replication from SAP and non-SAP source systems.

The SLT Replication Server provides log reader adapters for SAP and non-SAP sources.

The SLT Replication Server installed on a productive SAP BW/4HANA system improves the data transfer process.

Replication Server installation and configuration is always identical for SAP and non-SAP source systems.

32. When can you NOT use a characteristic with the High Cardinality property? Note: There are 3 correct answers to this question.

When it will be a navigation attribute

When it will be a time-dependent attribute

When it will be part of a report-to-report interface

When it will be part of a hierarchy

When it will be a compound characteristic

C_BW4HANA_27 SAP Certified Application Associate Exam Questions

C_BW4HANA_27 SAP Certified Application Associate Exam Questions

Share this post

Leave a Reply Cancel reply

Related Posts