How is data security handled for the live connection between SAP Analytics Cloud and SAP BW/4HANA?
- A . Data records are filtered according to the settings in the SAP BW/4HANA analysis authorizations.
- B . SAP BW/4HANA analysis authorizations are evaluated on the SAP BW/4HANA back-end side.
- C . Data can be secured by allowing or prohibiting access to ADSO partitions.
- D . SAP Analytics Cloud performs an authorization check after retrieving the query result from the SAP U BW/4HANA back end.
On which of the following devices does the SAP BW/4HANA cockpit run? Note: There are 2 correct answers to this question
- A . On traditional laptops
- B . On Apple devices only
- C . Only on machines with Windows OS
- D . On smartphones or touchscreen displays
Which of the following objects is not provided in business content?
- A . InfoSource
- B . KPIs
- C . Infocube
- D . SAP ECC Extractor program
- E . None of the above
- F . Queries
Which of the following are external tools used for Data Provisioning?
- A . Near Line Storage
- B . SAP Data Services
- C . Enterprise Information Management
- D . SAP Landscape Transformation Replication Server
- E . Direct Extractor Connection (DHC)
What functions has Data Warehousing Workbench (DWWB)?
- A . Modeling
- B . Scheduling
- C . Monitoring
- D . Reporting
What skills are required to use SAP SQL Data Warehousing?
- A . SQL and database skills.
- B . C++ to debug the SAP HANA source code Machine learning, because this is a prerequisite in all modern data warehouse implementations.
- C . SAP BW/4HANA skills, because you can only access data in SAP SQL Data Warehousing through the SAP BW/4HANA query.
How can you use formula variables? Choose the correct answers.
- A . As operands in formulas that are retrieved via replacement path.
- B . As operands for local calculations in reports.
- C . As key values for characteristic restrictions
- D . As threshold values in exceptions and conditions.
As part of currency translation, a quantity conversion type can be defined to convert the quantity of a currency into the new currency. Determine whether this statement is true or false.
- A . False
- B . True
What is the definition of a task workflow in SAP Data Hub?
- A . An SAP Data Hub task workflow executes the ETL processes
- 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 creates the underlying data model of the SAP Data Hub.
What is the maximum number of key figure in an Infocube?
- A . 322
- B . 85
- C . 13
- D . 233
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.
- A . Connect an export DataSource from the existing CompositeProvider to the new CompositeProvider.
- B . Create an Open ODS view with consumption properties to consume the data in U the SAP BW/4HANA schema.
- C . Assign consumption properties to the new SAP HANA calculation view
- D . Set "The CompositeProvider Can Be Added to Another CompositeProvider" flag.
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.
- A . Create functional and technical documentation.
- B . Design the data layer concept based on the LSA++ architecture.
- C . Build SAP HANA views and define their properties.
- D . Create and activate SAP BW objects
- E . Define a service level agreement.
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.
- A . True
- B . False
Which kinds of data can you model with Open ODS views? Note: There are 2 correct answers to this question.
- A . Unstructured data
- B . Master data
- C . Queries
- D . Language-dependent texts
How are virtual tables created in SAP HANA by SAP BW/4HANA.
- A . The administrator has to create them manually.
- B . They are created by the SAP HANA DataSource in SAP BW/4HANA.
- C . Virtual tables are not necessary because data always resides in memory.
- D . They are transported automatically.
By default, the formula that was created first will be used when there is a formula collision.
Determine whether this statement is true or false.
- A . False
- B . True
Which statements about the BI ETL process (NetWeaver 2004s) are true?
- A . A DTP loads data to a PSA.
- B . A transformation loads data to a PSA
- C . None of the above.
- D . An InfoPackage loads data directly to the BI InfoProvider.
- E . A transformation occurs on the data before it leaves the source system.
Which technology do you use to load data from Microsoft Analysis Services to SAP Business Warehouse?
- A . Universal Data Connect
- B . Database Connect
- C . File interface
- D . Web service
What is used to develop BW queries in SAP BW/4HANA?
- A . BEx Query Designer
- B . Eclipse-based Query Designer
- C . SAP Analysis for Microsoft Office
- D . BEx Web Application Designer
A Conceptual description of data objects, their attributes, and the relationships between them is:
- A . An InfoSource
- B . An InfoCatalog
- C . An InfoSet
- D . A data model
Identify issue affecting query performance that you, as a BI administrator, are responsible for.
- A . Read mode
- B . Web page design and Java scripting
- C . Data model
- D . Compression
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 . InfoObjects
- B . SAP HANA calculation views
- C . DataStore objects (advanced
- D . InfoCubes
- E . Open ODS views
Where should you develop process chains in SAP BW/4HANA as of SP 08?
- A . Transaction RSPC in the SAP GUI
- B . Standalone process chain designer
- C . Process chain modeler in the SAP BW/4HANA web administration tools.
- D . SAP Web IDE
What are the characteristics of a data warehouse? Note: There are 2 correct answers to this question.
- A . It typically contains massive amounts of "raw" and unstructured/non-relational data.
- B . It is mainly built for "new" data types like sensor, web, and social media data.
- C . It has an active archive for historical data. It contains standardized data models and harmonized D data.
- D . It contains predominantly structured data from enterprise systems.
What can you achieve with rule groups in an SAP BW transformation? Note: There are 2 correct answers to this question.
- A . Characteristics with the same key figure mapping are grouped.
- B . Keep the number of records in the source and in the target identical.
- C . Key figures with the same characteristic mapping are grouped
- D . One record in the source creates a record in the target for each rule group.
The InfoCube stores transaction data on a detailed level. Determine whether this statement is true or false.
- A . True
- B . False
Which functionality does the SAP Landscape Transformation Replication Server support? Please choose the correct answer.
- A . Real-time scenarios using log-based replication functionality
- B . Data replication to SAP HANA, other RDBMSs, and flat files
- C . Integrated interface for SAP HANA streaming analytics
- D . Automatic conversion from non-Unicode to Unicode during data load or replication
Which of the following are types of SAP BW Infocubes?
- A . Inverted cube
- B . Basic cube
- C . Relational cube
- D . Multicube
- E . Virtual cube
In which sequence can you create a reusable key figure structure? There are 2 correct answers to this question.
- A . Apply filters to a key figure structure in SAP Analysis for Microsoft Office. 2. Save the structure as a global structure.
- B . Create a new structure in the context menu of an InfoProvider. 2. Add key figures, selections, and formulas.
- C . Create a new structure in the context menu of a calculated key figure. 2. Save the structure as a global structure.
- D . Create a new structure with key figures, selections, and formulas in a query, 2. Save the structure as a global structure.
Which of the following are advantages of column tables?
- A . Elimination of additional indexe
- B . Elimination of parallel execution
- C . Elimination of materialized aggregates
- D . Higher data compression rates
Identify issue affecting query performance that you, as a BI administrator, are responsible for officially.
- A . Memory utilization and availability
- B . Aggregates
- C . Query design
- D . CPU selection
Which of the following is required to perform currency conversion in an SAP HANA information model?
- A . An innerjoin is required between the Open ODS View measures and the exchange rate table
- B . Setting a semantic type to a measure so the amount always includes a currency
- C . Storing the currency and the exchange rate on the day of the transaction will improve performance
- D . An interface to define how the currency conversion should be processed
- E . A set of technical tables are required to store currencies and exchange rate types and rates
What is the relationship between SAP Data Hub and SAP Vora?
- A . 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.
- B . SAP Vora is an add-on to SAP Data Hub.
- C . SAP Data Hub is the new data warehouse solution from SAP built on SAP Vora.
- D . SAP Data Hub is the new data warehouse solution and SAP Vora is designed for archiving mass data.
For which table type does SAP HANA compress data?
- A . Row store table
- B . Column store table
- C . Virtual table
- D . Cluster table
What is the in-app help for the SAP BW/4HANA cockpit?
- A . A new SAP interface for help applications
- B . A browser-based information management system
- C . An SAP content management system to personalize help pages.
- D . An embedded help within SAP Fiori apps, including context-sensitive information and guided tours
Which of the following items are part of an InfoObject definition?
- A . Attributes
- B . Transaction codes
- C . Text Information
- D . Dimension
- E . Hierarchies
After you imported data into SAP Analytics Cloud, you create a new formula.
Where is the request processed?
- A . SAP BW OLAP engine
- B . SAP HANA SQL engine
- C . SAP HANA XS engine
- D . SAP HANA calculation engine
Is SAP Data Hub already generally available?
- A . No, SAP Data Hub is currently under development.
- B . SAP Data Hub will be available with SAP BW/4HANA 2.0, planned for Q2 2019
- C . Yes, SAP Data Hub is already generally available.
- D . No, SAP Data Hub is only available to SAP partners.
Which statements about process chains are true?
- A . Process chains have many process types to control your BI project.
- B . Process chains have a graphical design GUI.
- C . Collector process include AND and OR and EXOR
- D . Process chains have log, checking and planning views.
What are the SAP BW/4HANA modeling tools?
- A . An add-on to the traditional SAP GUI
- B . A desktop installation based on Eclipse
- C . A new SAP GUI
- D . Web-based modeling tools
Which statements are true about DB connect?
- A . It is the slowest one of all these choices.
- B . It is faster than the file interface.
- C . It is faster than UD Connect.
- D . It is slower than UD Connect.
What are the three predefined dimensions in SAP BW?
- A . Time
- B . Date
- C . Unit
- D . DataPackage
In Design Studio Generic Analysis application, for which of the following components is a context menu for navigation available?
- A . Actions button
- B . Crosstab
- C . Information button
- D . Filter line
- E . Chart
- F . Navigation panel
A navigational attribute: Choose the correct answer(s):
- A . Provides a different view of "history" compared to the same InfoObject in the DIM.
- B . Must be enabled for all providers where it should be used.
- C . Is a field on a dimension table.
- D . Must be allowed on the InfoObject
For which of the following objects in SAP BW/4HANA can you create an SAP HANA calculation view? Note: There are 2 correct answers to this question.
- A . Data transfer processes.
- B . SAP BW/4HANA queries.
- C . Open hub destinations.
- D . Analysis Process Designer.
- E . CompositeProviders and DataStore objects (advanced).
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 authorization variable for the company code
- B . An InfoObject for the company code and assign it to a user profile.
- C . An InfoObject for the company code with the Query Read Mode property.
- D . An InfoObject for the company code as authorization-relevant.
Your customer converts LSA to LSA++ and needs to streamline the enterprise data warehouse layer.
What action do you take?
- A . Migrate all SAP Business Warehouse objects to SAP HANA optimized objects
- B . Reduce the number of persistent InfoProvider.
- C . Apply the SAP Business Warehouse workspace layer
- D . Apply the Open ODS layer.
For which scenario do you recommend an InfoSource?
- A . Allow the creation of delta records.
- B . Use it as a source for the data transfer process.
- C . Connect multiple sources and targets.
- D . Store intermediate results
What is a Hadoop Distributed File System (HDFS) typically used for?
- A . ERP systems
- B . Data warehouses
- C . Operational systems and transactional data
- D . Data lakes
Which of the following documents can be created with SAP Lumira, designer edition? Note: There are 2 correct answers to this question.
- A . Crystal Reports
- B . Dashboards
- C . BEx Web templates
- D . Analytical applications that are focused on slice-and-dice analysis