E_BW4HANA200 – SAP Certified Application Specialist – SAP BW_4HANA 2.0 Delta Exam (48 Questions)

The “SAP Certified Application Specialist – SAP BW/4HANA 2.0 Delta” certification exam verifies that the candidate has the knowledge of implementing and modeling SAP BW/4HANA required by the profile of an SAP BW application consultant. This certificate builds on both the basic knowledge gained in related SAP BW/4HANA training and documentation, as well as on practical experience gained as a member of a SAP BW team where the candidate would apply this knowledge practically in projects

Topic Areas

E_BW4HANA200 – SAP Certified Application Specialist – SAP BW_4HANA 2.0 Delta exam covers the following topics:

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

Exam details:

Here is the List of MCQ’s (Multiple Choice Questions):                         (The correct answers are mentioned with *)

1. You need to combine master data (right table) and transactional data (left table) using a referential join. How will this referential join how will this referential join behave?
Please choose the correct answer.

1. It is executed as an inner join when NO fields from the right table are requested.
2. It always returns all fields from the right table as a data set.
3. It is executed as an inner join when a description mapping is defined between the left table and the right u table.
4. It returns a result data set if the left table has a corresponding entry on the right table*

2. You want to validate your SAP HANA data model, what must you ensure to use the data preview functionality?
Please choose the correct answer.

1. You are connected as SYSTEM User and all objects privileges are assigned to this SYSTEM User.
2. Your content package is assigned with sufficient repository privileges to the _SYS_REPO user*
3. The _SYS_BIC user is created in the system and the runtime information is written to _SYS_STATISTICS.
4. The_SYS_REPO user must have sufficient object privileges assigned to your desired schema.

3. What are the main options to generate predictions based on SAP BW/4HANA data?
Note: There are 2 correct answers to this question.

1. Generate predictions randomly.
2. Generate predictions in real time*
3. Generate predictions accidentally.
4. Generate predictions on a regular basis.*

4. Which of the following are ways in which joins can be made using SAP BW on SAP HANA?

1. A native SAP HANA calculation view can perform inner s and outer joins*
2. BW Composite Provider can provide inner and outerjoins*
3. Transformations can perform joins of multiple DataSources
4. An Advanced DSO can create joins between master data and transaction data*
5. A BW InfoSet can be used to create a temporal join *

5. For which SAP BW/4HANA objects is it possible to create an external SAP HANA view?
There are 2 correct answers to this question.

1. Composite Providers*
2. Characteristics
3. Open ODS views*
4. Key figures

6. Which of the following activities are part of the realization phase of an SAP Business Warehouse (SAP BW) project?
Note: There are 3 correct answers to this question.

1. Create functional and technical documentation*
2. Define a service level agreement.
3. Build SAP HANA views and define their properties*
4. Create and activate SAP BW objects
5. Design the data layer concept based on the LSA++ architecture*

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

1. 322
2. 85
3. 13
4. 233*

8. You identified a variable that is based on time characteristic OCALMONTH and returns the current quarter. Which offset do you need to retrieve the corresponding quarter of the previous year?
Please choose the correct answer.

1. -3
2. -1
3. -4*
4. -12

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

1. Global transfer routines for master data harmonization*
2. ABAP Managed database procedures in an SAP BW/4HANA Transformation*
3. Query settings to read near-line storage data*
4. SAP HANA models as part providers in composite providers
5. Activation of a datastore object (advanced)

10. Which of the following statements are true?

1. InfoSets join more than one target to a logical set for reporting*
2. RDA supports operational reporting*
3. Virtual Providers can cause a load on the OLTP system and BI at the same time*
4. You have more to learn*

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

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

1. SAP HANA dynamic tiering.
2. SAP IQ.
3. SAP IQ, Hadoop storage, and SAP Vora (discengine)*
4. SAP IQ and Hadoop storage.

12. You want to use the SAP HANA Concept of semantic types as part of the currency conversion mechanism. You decide to use semantic type amount with currency code within your SAP HANA Calculation. View which currency reference can be assigned to the measure?
there are 3 correct answers to this question.

1. A currency from another column*
2. A currency from a currency conversion*
3. A currency from SAP BW customizing
4. A currency from an SAP HANA content calculation view*

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

1. ACCESS database files
2. Third-party extraction and load tools*
3. CSV files only
4. Flat files*

14. How many dimension tables can the SAP BW system administrator create perInfocube?

1. 13
2. 233
3. 248
4. 16*

15. When can you NOT use a characteristic with the high cardinality property?
there are 3 correct answers to this question.

1. When it will be part of a hierarchy*
2. When it will be a compound characteristic*
3. When it will be part of a report-to-report interface
4. When it will be a time-dependent attribute
5. When it will be a navigation attribute *

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

1. Scheduling*
2. Reporting
3. Modeling*
4. Monitoring*

17. You model a second SAP BW/4HANA Composite Provider to integrate tables from an SAP HANA database schema with an existing SAP BW/4HANA Composite Provider. What must you do first?
Please choose the correct answer.

1. Assign consumption properties to the new SAP HANA calculation view
2. Set “The Composite Provider Can Be Added to Another Composite Provider” flag*
3. Create an Open ODS view with consumption properties to consume the data in the SAP BW/4HANA schema.
4. Connect an export Data Source from the existing Composite Provider to the new Composite Provider.

18. You create a transformation from a Data Source to a standard Data Store object. The Data Source provides an after-image delta. Which key figure aggregation type do you select?

1. Minimum
2. Overwrite*
3. Maximum
4. Summation

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

1. Enterprise Information Management
2. Near Line Storage
3. SAP Data Services*
4. SAP Landscape Transformation Replication Server*
5. Direct Extractor Connection (DHC)*

20. Which of the following sources can you connect to SAP BW/4HANA with the SAP HANA source system?
Note: There are 2 correct answers to this question.

1. SAP BW/4HANA transformations.
2. Remote sources available with SAP HANA smart data integration and smart data access*
3. Local SAP HANA schemas*
4. Web templates

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

1. Composite Provider*
2. DataStore object (advanced) *
3. InfoSet
4. MultiProvider
5. InfoCube

22.How is data security handled for the live connection between SAP Analytics Cloud and SAP BW/4HANA?

1. Data can be secured by allowing or prohibiting access to ADSO partitions.
2. SAP Analytics Cloud performs an authorization check after retrieving the query result from the SAP W/4HANA back end.
3. SAP BW/4HANA analysis authorizations are evaluated on the SAP BW/4HANA back-end side*
4. Data records are filtered according to the settings in the SAP BW/4HANA analysis authorizations.

23. Which kinds of data can you model with Open ODS views?
Note: There are 2 correct answers to this question.

1. Queries
2. Language-dependent texts *
3. Unstructured Data
4. Master data*

24. InfoProviders are technical tables joined in some way. They are constructed using fields in BI that we call . Choose the correct answer(s).
You Options:

1. Business fields.
2. Info Obects*
3. Special fields.
4. Infoltems.

25. For which table type does SAP HANA compress data?
You Options:

1. Virtual table
2. Cluster table
3. Row store table
4. Column store table*

26. For what kind of tasks is SAP Data Hub designed?
Note: There are 2 correct answers to this question.
You Options:

1. For orchestrating Big Data landscapes*
2. For building a data warehouse and persisting the data.
3. For connecting all types of data sources (enterprise systems, data lakes, etc.)*
4. For replicating data from operational systems.

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

1. An SAP Data Hub task workflow creates the underlying data model of the SAP Data Hub.
2. An SAP Data Hub task workflow orchestrates multiple tasks and executes them in a given order*
3. An SAP Data Hub task workflow is responsible for data aging in SAP BW/4HANA.
4. An SAP Data Hub task workflow executes the ETL processes.

28. A Conceptual description of data objects, their attributes, and the relationships between them is :
You Options:

1. A data model*
2. An InfoCatalog
3. An InfoSet
4. An InfoSource

29. Where should queries be modeled when the ADSO is partitioned semantically?

1. Queries should be modeled based on the individual Data Store objects (advanced).
2. Queries should be modeled based on A-tables in an SAP HANA calculation view.
3. Queries should be modeled based on the Composite Provider on top of the semantic group*
4. Queries should be modeled based on the Open ODS view.

30. Which of the following statements are true?

1. InfoSets join more than one target to a logical set for reporting*
2. RDA supports operational reporting*
3. Virtual Providers can cause a load on the OLTP system , and BI at the same time.*
4. You have more to learn.*

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

1. XRF spectroscopy
2. Gaussian normal distribution
3. Classification and regression*
4. Segmentation or clustering *

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

1. Field-based modeling cannot leverage the SAP BW/4HANA authorization concept.
2. Field-based modeling complements InfoObject modeling and is fully integrated with existing SAP BW/4HANA objects/models and SAP BW/4HANA authorizations*
3. Field-based modeling is only available for SAP sources.
4. Field-based modeling is not recommended for mass data loads.

33. You create an advanced DataStore object (DSO) and select the standard DSO template. Which of the following settings are applied automatically?
Note: There are 2 correct answers to this question.

1. Activate data*
2. All characteristics are key
3. Unique data records
4. Write change log *

34. Which functionality does the SAP Landscape Transformation Replication Server support?
Please choose the correct answer

1. Integrated interface for SAP HANA streaming analytics
2. Real-time scenarios using log-based replication functionality
3. Automatic conversion from non-Unicode to Unicode during data load or replication*
4. Data replication to SAP HANA, other RDBMSs, and flat files

35. Is SAP Data Hub already generally available?

1. Yes, SAP Data Hub is already generally available*
2. No, SAP Data Hub is only available to SAP partners.
3. No, SAP Data Hub is currently under development.
4. SAP Data Hub will be available with SAP BW/4HANA 2.0, planned for Q2 2019

Join SAP Learner Community on LinkedIn – https://www.linkedin.com/showcase/sap-learner-community

36. Which statements about process chains are true?

1. Process chains have a graphical design GUI*
2. Process chains have log, checking and planning views*
3. Process chains have many process types to control your BI project*
4. Collector process include AND and OR and EXOR*

37. Requested-based deletion would solve which the following problems?

1. Deleting the last load of bad data*
2. Deleting data for a specific company code and division combination.
3. Deleting the request from both the change log and the active table if the request was already activated, but not in the follow-on target*
4. Targeted deletion of change log data.

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

1. Modeling*
2. Reporting
3. Scheduling*
4. Monitoring*

39. Navigational attributes behave in a query like which of the following?

1. Attributes
2. Variables
3. Characteristics*
4. Filters
5. None of above

40. What is the relationship between SAP Data Hub and SAP Vora?

1. SAP Data Hub is the new data warehouse solution and SAP Vora is designed for archiving mass data.
2. SAP Data Hub is the new data warehouse solution from SAP built on SAP Vora.
3. SAP Vora capabilities are included in SAP Data Hub, however ,SAP DataHub and
4. SAP Vora are designed to address different use cases, based on customers’ specific needs*
5. SAP Vora is an add-on to SAP Data Hub.

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

Please choose the correct answer.

1. The valid from date of the attribute is used as key date.
2. The current date is used as key date*
3. The system displays only NON-time-dependent attributes.
4. The system displays an error message

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

1. It is preconfigured and end-to-end in scope*
2. It speeds implementation*
3. It costs additional millions of dollars.
4. It allows quick prototyping.*

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

1. No, this is not necessary because all existing sources can already be accessed via SAP HANA EIM.
2. Yes, you can use enhancement spots via the ODP framework to extend SAP ERP extractors.
3. No, custom code is a potential security risk and therefore not allowed.
4. Yes, SAP HANA smart data integration offers an adapter API.*

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

1. Error handling*
2. Activation Handling
3. Semantic groups*
4. Data tiering
5. Extraction Mode*

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

1. Overwrite capability*
2. Reporting*
3. Data Compression
4. Store data on the document level*
5. None of the above

46. What happens when you execute the Trigger Delta Merge operation for a given data target?
Please choose the correct answer.

1. Data is transferred from the delta store to the main store*
2. The delta between the new data and the already loaded data is removed.
3. The data from the delta queue is extracted and managed into the data target.
4. The before and after images of the delta queues are merged.

47. If a global element of a query is changed in BW,these changes are automatically passed to the SAP HANA calculation view that was created from the BW query.
Determine Whether this statement is true or false.

1. False*
2. True

48. What you must do to define an inventory infoprovider in SAP BW/4HANA?
there are 3 correct answers to this question.

1. Select the Unique Data Records model property*
2. Assign at least one-cumulative key figure
3. Select the All characteristics are key model property*
4. Assign at least one cumulative key figure
5. Select the Inventory model property*

Hope these MCQ’s will help you with your SAP certification.

Good Luck!!

Get any SAP video course – https://zarantech.teachable.com/courses/category/sap

Join SAP Learner Community on LinkedIn – https://www.linkedin.com/showcase/sap-learner-community

Visit our website – https://www.zarantech.com

Keep learning & innovating!

Here is some other SAP Certification MCQ’s for your reference:

C_ARP2P_2202-SAP Certified Application Associate – SAP Ariba Procurement (Part A) (80 Questions)

C_S4FTR_2020 – SAP Certified Application Associate Treasury with SAP S4HANA (205 Questions)