What are the three predefined dimensions in SAP BW?
- A . Date
- B . DataPackage
- C . Time
- D . Unit
What is the definition of a task workflow in SAP Data Hub?
- A . An SAP Data Hub task workflow creates the underlying data model of the SAP Data Hub.
- B . An SAP Data Hub task workflow orchestrates multiple tasks and executes them in a given order.
- C . An SAP Data Hub task workflow is responsible for data aging in SAP BW/4HANA.
- D . An SAP Data Hub task workflow executes the ETL processes.
Is it possible to extend SAP HANA EIM with custom adapters?
- A . No, this is not necessary because all existing sources can already be accessed via SAP HANA EIM.
- B . Yes, you can use enhancement spots via the ODP framework to extend SAP ERP extractors.
- C . No, custom code is a potential security risk and therefore not allowed.
- D . Yes, SAP HANA smart data integration offers an adapter API.
Which of the following are types of SAP BW Infocubes?
- A . Multicube
- B . Inverted cube
- C . Virtual cube
- D . Relational cube
- E . Basic cube
InfoProviders are technical tables joined in some way. They are constructed using fields in BI that we call________. Choose the correct answer(s).
- A . Business fields.
- B . InfoObects.
- C . Special fields.
- D . Infoltems.
After you imported data into SAP Analytics Cloud, you create a new formula.
Where is the request processed?
- A . SAP HANA SQL engine
- B . SAP HANA calculation engine
- C . SAP HANA XS engine
- D . SAP BW OLAP engine
What is the in-app help for the SAP BW/4HANA cockpit?
- A . A browser-based information management system.
- B . An SAP content management system to personalize help pages.
- C . An embedded help within SAP Fiori apps, including context-sensitive information and guided tours.
- D . A new SAP interface for help applications.
Which statement for field-based modeling in SAP BW/4HANA is true?
- A . Field-based modeling cannot leverage the SAP BW/4HANA authorization concept.
- B . Field-based modeling complements InfoObject modeling and is fully integrated with existing SAP BW/4HANA objects/models and SAP BW/4HANA authorizations.
- C . Field-based modeling is only available for SAP sources.
- D . Field-based modeling is not recommended for mass data loads.
For which table type does SAP HANA compress data?
- A . Virtual table
- B . Cluster table
- C . Row store table
- D . Column store table
The InfoCube stores transaction data on a detailed level. Determine whether this statement is true or false.
- A . False
- B . True
How do you manage data access security in a mixed scenario?
- A . You must maintain SAP HANA privileges manually.
- B . You must use SAP HANA data anonymization features like differential privacy to obscure the data.
- C . You can create SAP HANA privileges out of SAP BW/4HANA authorization objects.
- D . You must maintain authorizations in the analytic clients.
What functions has Data Warehousing Workbench (DWWB)?
- A . Modeling
- B . Reporting
- C . Scheduling
- D . Monitoring
Which of the following are external tools used for Data Provisioning?
- A . Enterprise Information Management
- B . Near Line Storage
- C . SAP Data Services
- D . SAP Landscape Transformation Replication Server
- E . Direct Extractor Connection (DHC)
How are virtual tables created in SAP HANA by SAP BW/4HANA.
- A . They are created by the SAP HANA DataSource in SAP BW/4HANA.
- B . The administrator has to create them manually.
- C . They are transported automatically.
- D . Virtual tables are not necessary because data always resides in memory.
Which of the following are characteristics of the DevOps methodology? Note: There are 2 correct answers to this question.
- A . SAP HANA data warehousing foundation.
- B . Shortened lead time between fixes.
- C . A clear separation of development and operations tasks on an organizational level.
- D . Automation of repetitive tasks.
What are some typical administration tasks?
- A . Remodeling
- B . Request Archiving
- C . Document indexing
- D . System settings
Which technology do you use to load data from Microsoft Analysis Services to SAP Business Warehouse?
- A . Web service
- B . Universal Data Connect
- C . Database Connect
- D . File interface
Which of the following is required to perform currency conversion in an SAP HANA information model?
- A . A set of technical tables are required to store currencies and exchange rate types and rates
- B . An innerjoin is required between the Open ODS View measures and the exchange rate table
- C . An interface to define how the currency conversion should be processed
- D . Setting a semantic type to a measure so the amount always includes a currency
- E . Storing the currency and the exchange rate on the day of the transaction will improve performance
Which of the following objects are supported in SAP BW/4HANA? Note: There are 2 correct answers to this question.
- A . CompositeProvider
- B . DataStore object (advanced)
- C . InfoSet
- D . MultiProvider
- E . InfoCube
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.
- A . Open ODS views
- B . InfoObjects
- C . InfoCubes
- D . SAP HANA calculation views
- E . DataStore objects (advanced)
Which of the following statements about the LSA architecture are true? Note: There are 2 correct answers to this question.
- A . LSA describes a blueprint for data flows which can be applied throughout the data warehouse.
- B . LSA is designed for high flexibility and little governance.
- C . LSA was designed with the technologies of traditional databases and classic SAP BW in mind.
- D . LSA defines mostly virtual structures to avoid redundant copies of data.
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.
- A . Data tiering
- B . Activation handling
- C . Parallel processing
- D . Extraction Mode
Where are the partitions for Data Tiering Optimization (DTO) with SAP BW/4HANA created?
- A . Under Partitions on the Settings tab of the DataStore object (advanced).
- B . In the SAP BW/4HANA Web Administration cockpit.
- C . On the General tab of the DataStore object (advanced).
- D . In the Maintain Temperatures SAP GUI transaction.
What is the maximum number of key figure in an Infocube?
- A . 13
- B . 85
- C . 322
- D . 233
Is SAP Data Hub yet another ETL or streaming tool?
- A . Yes, SAP Data Hub is the new SAP ETL offering in combination with Kubernetes.
- B . No, SAP Data Hub goes beyond classical batch ETL or real-time streaming.
- C . Yes, SAP Data Hub is the new tool for ETL processes for Hadoop Cluster and public cloud storages.
- D . Yes, SAP Data Hub is the new integrated toolset for ETL or real-time streaming.
Which of the following is a key consideration when implementing a modern data warehouse with SAP BW/4HANA?
- A . Technology alone will solve all your problems.
- B . Query performance is the most important consideration in a data warehouse
implementation. - C . A suitable combination of technology, architecture, and development process is essential.
- D . You should avoid agile development approaches as they come with the risk of insufficient up-front performance optimization.
Where does monitoring and scheduling take place in SAP BW/4HANA as of SP 08?
- A . In the SAP BW/4HANA administration cockpit
- B . In the standalone process chain monitoring tool
- C . In the SAP GUI
- D . In SAP Web IDE
You create a transformation from a DataSource to a standard DataStore object.
The DataSource provides an after-image delta.
Which key figure aggregation type do you select?
- A . Summation
- B . Maximum
- C . Minimum
- D . Overwrite
Where should queries be modeled when the ADSO is partitioned semantically?
- A . Queries should be modeled based on the individual DataStore objects (advanced).
- B . Queries should be modeled based on A-tables in an SAP HANA calculation view.
- C . Queries should be modeled based on the CompositeProvider on top of the semantic group.
- D . Queries should be modeled based on the Open ODS view.
Which statements are true about DB connect?
- A . It is faster than UD Connect.
- B . It is faster than the file interface.
- C . It is slower than UD Connect.
- D . It is the slowest one of all these choices.
Identify issue affecting query performance that you, as a BI administrator, are responsible for.
- A . Compression
- B . Data model
- C . Web page design and Java scripting
- D . Read mode
What do you have to consider when you create a query with multiple structures?
- A . By using both the structures in the rows or in the columns you can avoid formula collision.
- B . You must use one structure in the report columns and one structure the report rows.
- C . You must use a maximum of two structures.
- D . You can only use one structure with key figures in a query.
- E . You can only use one structure without key figures in a query.
Which of the following are components of SAP SQL Data Warehousing? Note: There are 2 correct answers to this question.
- A . SAP Analytics Cloud
- B . SAP HANA calculation views
- C . Flowgraphs
- D . SAP cloud applications
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.
- A . SAP BW/4HANA transformations.
- B . Remote sources available with SAP HANA smart data integration and smart data access.
- C . Local SAP HANA schemas.
- D . Web templates
You need to ensure that authorizations for the characteristic company code are checked before data from a BW query is displayed.
What must you define?
- A . An InfoObject for the company code and assign it to a user profile.
- B . An InfoObject for the company code as authorization-relevant.
- C . An InfoObject for the company code with the Query Read Mode property.
- D . An authorization variable for the company code
How many hierarchies can be created for a key figure?
- A . 10
- B . 2
- C . 5
- D . More than 1
- E . And it is not
A Conceptual description of data objects, their attributes, and the relationships between them is :
- A . A data model
- B . An InfoCatalog
- C . An InfoSet
- D . An InfoSource
What is the relationship between SAP Data Hub and SAP Vora?
- A . SAP Data Hub is the new data warehouse solution and SAP Vora is designed for archiving mass data.
- B . SAP Data Hub is the new data warehouse solution from SAP built on SAP Vora.
- C . SAP Vora capabilities are included in SAP Data Hub, however SAP Data Hub and SAP Vora are designed to address different use cases, based on customers’ specific needs.
- D . SAP Vora is an add-on to SAP Data Hub.
Which of the following is the core workflow when working with SAP Analytics Cloud? Please choose the correct answer.
- A . Acquire – Prepare – Explore – Visualize – Collaborate
- B . Prepare – Explore – Acquire – Visualize – Collaborate
- C . Acquire – Prepare – Visualize – Explore – Collaborate
- D . Explore – Acquire – Prepare – Visualize – Collaborate
Which of the following statements about the native DataStore object in SAP SQL Data Warehousing is true?
- A . Native DataStore objects require InfoObjects in SAP BW/4HANA.
- B . Native DataStore objects will replace SAP HANA calculation views over time.
- C . A native DataStore object can be accessed from SAP BW/4HANA.
- D . A native DataStore object is generated when a DataStore object (advanced) is activated in SAP BW/4HANA.