SAP E_BW4HANA200 Online Free Questions

Posted by: Pdfprep Category: SAP Online Questions Tags: E_BW4HANA200 Online Questions Post Date: January 5, 2021

Pdfprep2021-01-05T17:49:21+00:00

With our E_BW4HANA200 practice test, you don’t need to look for other online testing engine that are often obsolete. In most of the cases, people looking for E_BW4HANA200 prep questions online from us for their certification prep requirements. Our top ranked E_BW4HANA200 prep questions usually searched on the internet using different search terms like specified below.

Page 1 of 5

1. Which cold data storage locations for Data Tiering Optimization are available with SAP BW/4HANA SP08?

SAP IQ, Hadoop storage, and SAP Vora (disc engine).

SAP HANA dynamic tiering.

SAP IQ and Hadoop storage.

SAP I

2. Which sources are available for a generic SAP Business Warehouse DataSource? Note: There are 3 correct answers to this question.

SAP HANA information view

Function module

SAP HANA remote source table

DB view or table

SAP query (InfoSet)

3. What is the role of the Composite Provider in SAP BW/4HANA?

It is the core object for persistency in SAP BW/4HAN

It is a virtual object to combine data from SAP BW/4HANA and SAP HANA via join or union.

It is the planning engine in SAP BW/4HAN

It is the successor of the BW InfoCube.

4. What key functionality does SAP Data Hub include? Note: There are 2 correct answers to this question.

Orchestration of complex processes and workflows across system boundaries.

New ETL tools for building a data warehouse solution

State-of-the-art deep learning algorithms for data scientists.

Data pipelines across data lakes.

5. For which SAP BW/4HANA objects can you generate SAP HANA calculation views?

Characteristics

Open ODS views

Key figures

Composite Providers

6. Which applications are available in SAP Data Hub to run the solution? Note: There are 2 correct answers to this question.

SAP Data Hub Connection Management.

SAP BW/4HANA Web Administration cockpit.

SAP BW/4HANA Process Chain Modeler.

SAP HANA Data Management Suite.

SAP Data Hub Metadata Explorer

7. On which of the following objects can you restrict a characteristic?

Formula

Exception

Condition

Hierarchy node

8. What is the SAP BW/4HANA cockpit?

The single point of entry for administration and monitoring in SAP BW/4HANA since SP 08.

An additional monitoring tool for 3rd-party sources

A comprehensive ETL tool.

The single point of entry for data modeling in SAP BW/4HAN

9. What are the modeling objects for persistency in SAP BW/4HANA? Note: There are 2 correct answers to this question.

HybridProvider

InfoObject

PSA table

InfoCube

DataStore object (advanced)

10. Which statements about process chains are true?

Process chains have a graphical design GU

Process chains have log, checking and planning views.

Process chains have many process types to control your BI project.

Collector process include AND and OR and EXO

Page 2 of 5

11. 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? Please choose the correct answer.

Assign consumption properties to the new SAP HANA calculation view

Set "The CompositeProvider Can Be Added to Another CompositeProvider" flag.

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

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

12. On which of the following devices does the SAP BW/4HANA cockpit run? Note: There are 2 correct answers to this question.

On smartphones or touchscreen displays

Only on machines with Windows OS

On Apple devices only

On traditional laptops

13. What are the core predictive functions to answer business questions? Note: There are 2 correct answers to this question.

XRF spectroscopy

Gaussian normal distribution

Classification and regression

Segmentation or clustering

14. Which of the following objects in SAP BW/4HANA can be modeled using fields? Note: There are 2 correct answers to this question.

Open ODS views

Data transfer processes

DataStore objects (advanced)

Process chains

15. Identify issue affecting query performance that you, as a BI administrator, are responsible for officially.

Query design

CPU selection

Aggregates

Memory utilization and availability

16. What are the modeling objects for visualization in SAP BW/4HANA? Note: There are 2 correct answers to this question.

MultiProvider

VirtualProvider

CompositeProvider

InfoSet

Open ODS view

17. Which of the following statements are not correct about the PSA?

Created for each communication structure.

Transfer rules have been applied.

You can load from the PSA to an Infocube.

Queries can be generated from the PS

None of the above.

18. Some advantages of BI Content are: Choose the correct answer(s):

It is preconfigured and end-to-end in scope.

It speeds implementation.

It costs additional millions of dollars.

It allows quick prototyping.

19. The goal of implementing SAP Business Warehouse is to move the reporting burden from the ERP system? Determine whether this statement is true or false.

True

False

20. Non-SAP data sources can load data into SAP BW via which of the following elements?

Flat files

Third-party extraction and load tools

ACCESS database files

CSV files only

Page 3 of 5

21. Save the structure as a global structure.

22. Which of the following are benefits of the DSO?

Overwrite capability

Reporting.

Data Compression

Store data on the document level.

None of the above

23. Exception aggregation has no effect on the saving of data in the fact table because it is only effective for reporting. Determine whether this statement is true or false.

True

False

24. Implementation in support of a targeted business process?

IT practices

Scenarios

Scenario Variants

Usage types

25. What are the characteristics of a data warehouse? Note: There are 2 correct answers to this question.

It is mainly built for "new" data types like sensor, web, and social media data.

It has an active archive for historical data. It contains standardized data models and harmonized data.

It typically contains massive amounts of "raw" and unstructured/non-relational data.

It contains predominantly structured data from enterprise systems.

26. What are the three predefined dimensions in SAP BW?

Date

DataPackage

Time

Unit

27. What is the definition of a task workflow in SAP Data Hub?

An SAP Data Hub task workflow creates the underlying data model of the SAP Data Hub.

An SAP Data Hub task workflow orchestrates multiple tasks and executes them in a given order.

An SAP Data Hub task workflow is responsible for data aging in SAP BW/4HAN

An SAP Data Hub task workflow executes the ETL processes.

28. Is it possible to extend SAP HANA EIM with custom adapters?

No, this is not necessary because all existing sources can already be accessed via SAP HANA EI

Yes, you can use enhancement spots via the ODP framework to extend SAP ERP extractors.

No, custom code is a potential security risk and therefore not allowed.

Yes, SAP HANA smart data integration offers an adapter AP

29. Which of the following are types of SAP BW Infocubes?

Multicube

Inverted cube

Virtual cube

Relational cube

Basic cube

30. InfoProviders are technical tables joined in some way. They are constructed using fields in BI that we call________. Choose the correct answer(s).

Business fields.

InfoObects.

Special fields.

Infoltems.

Page 4 of 5

31. After you imported data into SAP Analytics Cloud, you create a new formula.

Where is the request processed?

SAP HANA SQL engine

SAP HANA calculation engine

SAP HANA XS engine

SAP BW OLAP engine

32. What is the in-app help for the SAP BW/4HANA cockpit?

A browser-based information management system.

An SAP content management system to personalize help pages.

An embedded help within SAP Fiori apps, including context-sensitive information and guided tours.

A new SAP interface for help applications.

33. Which statement for field-based modeling in SAP BW/4HANA is true?

Field-based modeling cannot leverage the SAP BW/4HANA authorization concept.

Field-based modeling complements InfoObject modeling and is fully integrated with existing SAP BW/4HANA objects/models and SAP BW/4HANA authorizations.

Field-based modeling is only available for SAP sources.

Field-based modeling is not recommended for mass data loads.

34. For which table type does SAP HANA compress data?

Virtual table

Cluster table

Row store table

Column store table

35. The InfoCube stores transaction data on a detailed level. Determine whether this statement is true or false.

False

True

36. How do you manage data access security in a mixed scenario?

You must maintain SAP HANA privileges manually.

You must use SAP HANA data anonymization features like differential privacy to obscure the data.

You can create SAP HANA privileges out of SAP BW/4HANA authorization objects.

You must maintain authorizations in the analytic clients.

37. What functions has Data Warehousing Workbench (DWWB)?

Modeling

Reporting

Scheduling

Monitoring

38. Which of the following are external tools used for Data Provisioning?

Enterprise Information Management

Near Line Storage

SAP Data Services

SAP Landscape Transformation Replication Server

Direct Extractor Connection (DHC)

39. How are virtual tables created in SAP HANA by SAP BW/4HANA.

They are created by the SAP HANA DataSource in SAP BW/4HAN

The administrator has to create them manually.

They are transported automatically.

Virtual tables are not necessary because data always resides in memory.

40. Which of the following are characteristics of the DevOps methodology? Note: There are 2 correct answers to this question.

SAP HANA data warehousing foundation.

Shortened lead time between fixes.

A clear separation of development and operations tasks on an organizational level.

Automation of repetitive tasks.

Page 5 of 5

41. What are some typical administration tasks?

Remodeling

Request Archiving

Document indexing

System settings

42. Which technology do you use to load data from Microsoft Analysis Services to SAP Business Warehouse?

Web service

Universal Data Connect

Database Connect

File interface

43. Which of the following is required to perform currency conversion in an SAP HANA information model?

A set of technical tables are required to store currencies and exchange rate types and rates

An innerjoin is required between the Open ODS View measures and the exchange rate table

An interface to define how the currency conversion should be processed

Setting a semantic type to a measure so the amount always includes a currency

Storing the currency and the exchange rate on the day of the transaction will improve performance

44. Which of the following objects are supported in SAP BW/4HANA? Note: There are 2 correct answers to this question.

CompositeProvider

DataStore object (advanced)

InfoSet

MultiProvider

InfoCube

45. For what can you use the simple management and maintenance functions in the SAP BW/4HANA administration cockpit? Note: There are 2 correct answers to this question.

Open ODS views

InfoObjects

InfoCubes

SAP HANA calculation views

DataStore objects (advanced)

46. Which of the following statements about the LSA architecture are true? Note: There are 2 correct answers to this question.

LSA describes a blueprint for data flows which can be applied throughout the data warehouse.

LSA is designed for high flexibility and little governance.

LSA was designed with the technologies of traditional databases and classic SAP BW in mind.

LSA defines mostly virtual structures to avoid redundant copies of data.

47. Which of the following settings can you define in a data transfer process (DTP) if you load data into a DataStore object (advanced)?

There are 2 correct answers to this question.

Data tiering

Activation handling

Parallel processing

Extraction Mode

48. Where are the partitions for Data Tiering Optimization (DTO) with SAP BW/4HANA created?

Under Partitions on the Settings tab of the DataStore object (advanced).

In the SAP BW/4HANA Web Administration cockpit.

On the General tab of the DataStore object (advanced).

In the Maintain Temperatures SAP GUI transaction.

49. What is the maximum number of key figure in an Infocube?

322

233

50. Is SAP Data Hub yet another ETL or streaming tool?

Yes, SAP Data Hub is the new SAP ETL offering in combination with Kubernetes.

No, SAP Data Hub goes beyond classical batch ETL or real-time streaming.

Yes, SAP Data Hub is the new tool for ETL processes for Hadoop Cluster and public cloud storages.

Yes, SAP Data Hub is the new integrated toolset for ETL or real-time streaming.

SAP E_BW4HANA200 Online Free Questions

Author