Test bw sap questions

TEST BORRADO, QUIZÁS LE INTERESE: BW SAP Questions

COMENTARIOS	ESTADÍSTICAS	RÉCORDS

REALIZAR TEST

Título del Test:
BW SAP Questions

Descripción:
BW SAP Questions

Autor:

FMH

Fecha de Creación:
28/10/2021

Categoría: Otros

Número Preguntas: 70

COMPARTE EL TEST

COMENTAR

No hay ningún comentario sobre este test.

Temario:

Which of the following statements refer to a Remote Cube? InfoCube that gathers data from several Basic Cubes Transaction data that are not managed in SAP BW but are available to SAP BW users Remote Cubes do not contain data A cube built in a non-BW data warehouse None of the above.
If product price is a slowly changing dimension, how do you model product price if you want to report on the price at the time of the query? As a characteristic on the material dimension As a time-dependent navigational attribute As a time-dependent hierarchy of material As a time-independent navigational attribute of material None of the above.
Which of the following refer to pointer tables that provide the technical link to the master data outside of the InfoCube? This question has only one answer. Dimension tables Set IDs M tables SID tables ODS transparent tables.
Which of the following Dimensions are delivered by SAP BW for each InfoCube? This question has more than one answer. Unit Time Transfer package Currency unit Info packet (Info package) GIS.
Which of the following statements describes a categorical dimension? This question has only one answer. An artificial dimension used to describe the status of another dimension An artificial dimension/attribute used to categorize another dimension An artificial dimension used in a reporting scenario where the comparison of the same key figure is needed A dimension that is used across all cubes None of the above.
Which of the following is an example of a slowly changing dimension? This question has only one answer. Customer on a sales order Date Person responsible for a cost center Value of a purchase order None of the above.
Fact tables may be partitioned by which of the following characteristics? This question has only one answer. 0CALDAY 0CALMONTH 0CALYEAR 0CALPERIOD 0CALWEEK.
Which of the following statements are correct concerning the operational data store (ODS)? This question has more than one answer. The data in the ODS are compressed and do not have a Request ID attached ODS can consolidate data from different source systems Data in the ODS cannot be reported upon The ODS is the inbound layer of the SAP BW system and data are written directly to it from the source system The ODS generally holds transaction data only.
A Fact table consists of which of the following elements? This questions has more than one answer. Characteristic InfoObjects Key figures InfoObjects Calculated key figures InfoObjects Hierarchies DIM IDs.
If you worked for a retail company that changed prices on a very frequent basis, how would you model the price? In the master data table as an attribute In the transaction table as a new characteristic In the ODS to enhance performance In the fact table None of the above.
Which of the following occurs as a result of degenerating dimensions? This question has more than one answer The grain of the fact table represents actual working documents like order number or invoice number All descriptive attributes of the grain are located in other dimensions The InfoCube becomes very weak and performs poorly when it is run The degenerating dimensions cannot be modeled using normal star schema None of the above.
What values can a key figure retain? This question has only one answer. Last value Average value First value Sum All of the above None of the above.
Which of the following describes an unbalanced hierarchy? This question has only one answer. A hierarchy with too many leaves within one branch A hierarchy with fewer nodes within one or more branches Hierarchy without leaves The term used for data that are delivered from two or more sources on different aggregation levels None of the above.
How many hierarchies can be created for a key figure? This question has only one answer. 10 2 5 More than 1 None.
Which of the following represents a characteristic that spans an entire data model and upon which all other entities are dependent? This question has only one answer. Many-to-many relationship A degenerated characteristic A strong entity An attribute A data model characteristic.
Navigational attributes behave in a query like which of the following? This question has only one answer. Attributes Variables Characteristics Filters None of the above.
When should an attribute be placed in a separate dimension? This question has only one answer. Always If the attribute changes frequently If the attributes have a large number of distinct values Never None of the above.
Which of the following objects is not provided in business content? This question has only one answer. InfoCube InfoSource KPIs Queries SAP R/3 extractor program None of the above.
Which of the following objects keeps the aggregate and InfoCube in sync? This question has only one answer. Dim pointer Read pointer SID pointers Surrogate pointer None of the above All of the above.
A MultiCube joins numerous other InfoCubes via which of the following? This question has only one answer. A common set of characteristics A common set of key figures A common set of InfoSources A common set of DataSource None of the above.
Why do we want to normalize a data model? This question has only one answer. To avoid redundancy To make it look good To increase performance To comply with the multidimensional data modeling rules None of the above.
Hierarchy can be which of the following? This question has more than one answer. Time-dependent name Version dependent With intervals Time-dependent structure Used by multiple InfoCube None of the above.
If product price is a slowly changing dimension, how do you model product price if you want to report the price at any point in time? This question has more than one answer. As a time-dependent navigational attribute As a time-dependent navigational attribute of material As a time-independent navigational attribute of material As a characteristic on the material dimension As a time-dependent hierarchy of material.
Name the three differences between OLAP and OLTP systems? This question has more than one answer. Software used Current data versus history required One to two months of data versus two to seven years of data Detailed transaction data versus summarized data None of the above.
Sometimes we have to combine unrelated characteristics into one dimension, due to which of the following facts? This question has more than one answer. We run out of dimensions and we have to include the data in the same InfoCube We are running out of space on the database We are looking for higher performance Lower number of dimensions is a way to optimize data staging To reduce the number of joins All of the above.
Which of the following items refer to InfoObjects? This question has more than one answer. Characteristics Key figures Queries Attributes None of the above.
What are the three predefined dimensions in SAP BW? This question has more than one answer. Date InfoPackage Time Unit None of the above.
What are the advantages of a smaller dimension? This question has more than one answer. Available immediately after transaction data load Improves query performance Overhead during load time It is not an advantage but a liability None of the above.
What are the limitations of a Remote Cube? This question has more than one answer. Additional requirements for extractors Slow System dependent Only for transaction data Small volume.
Which of the following are examples of characteristics? This question has more than one answer. Monthly sales Products Cost centers Company codes Sales person.
Which of the following objects are connected by update rules? This question has more than one answer. Communication structures Extract structure InfoCube InfoStructure Transfer structure None of the above.
How can the business content be extended? This question has more than one answer. SAP BW provides function exits Extend the standard extraction structures Function exit must be programmed to enrich data New fields must be assigned None of the above.
Which of the following is correct about Profile Generator? This question has only one answer. It is a tool to automatically generate Authorization Profile It is a tool existing in OLTP systems only Complete the Administrator work with extra tasks to set up authorization A tool that can be used by end users to modify their authorizations None of the above.
Which of the following applications in SAP support delta update? This question has more than one answer. CO/PA (time stamp) MM LIS (based on separate delta tables) FI/SL None of the above.
Which of the following describes a Result Set query? This question has only one answer. A nested query where the results of a first query are used as entry values for a second query A query using flat tables (ODS object or InfoObject) A prequery There is no such thing in SAP BW None of the above.
Which of the following can be extended in SAP BW? This question has more than one answer. Transaction data Master data Texts Metadata All of the above.
What do the SAP BW content extractors provide? This question has only one answer. Generic extractors Custom extractors There is no such thing in SAP BW content Data sources that can be activated for all applications None of the above.
Which of the following is usually the largest table in the star schema? This question has only one answer. None—they are all equal The fact table The first dimension table The metadata table The SID table.
For which of the following objects can authorization be created? This question has more than one answer. Characteristic values Hierarchy leaves Hierarchy levels Hierarchy modes None of the above.
Where are customer-specific documents stored? This question has only one answer. DNS BDS ITS AWB None of the above.
What does an extract structure represent? This question has only one answer. Data from the target system Data from the source system Transport process Communication process None of the above.
What method is used in CO/PA (SAP R/3 side) to manage delta updating? This question has only one answer. Several new tables are created to manage the delta upload A V3 delta management setup table is created A person manually monitors the data as they come to SAP BW Based on the time stamp that is attached to each line item None of the above.
Where can data be filtered in BEx Analyzer? This question has only one answer. By the end user in a report During query execution In the query builder When checking users’ authorizations None of the above.
Using PSA as a loading process, which of the following methodologies can be used? This question has only one answer. To PSA, then to the data target To PSA only To data target only To PSA and data target in parallel All of the above.
Which of the following is correct about Request ID (RNSID)? This question has more than one answer. It represents the chronological update history A unique key is created by the system Administrator can use RNSIDs to identify certain upload sequences in case of wrong data Only requests that have “green traffic lights” will update the related InfoCube Once an InfoCube is compressed, the SAP BW Administrator loses the capability of deleting a single request.
What is a MultiCube query? This question has only one answer. A query using flat tables (ODS object or InfoObject) A nested query where the results of a first query are used as entry values for a second query It is a query divided using the relevant Basic Cubes into several queries that can be processed in parallel All of the above None of the above.
Which of the following objects contains transactional data? This question has only one answer. Query InfoSources InfoCube Report Templates None of the above.
Which of the following objects keeps the aggregate and InfoCube in sync? This question has only one answer. DIM pointer Read pointer SID pointers Surrogate pointer None of the above All of the above.
What is the scheduler? This question has more than one answer. A tool that manages data requests to the source system A tool that provides a view of data loading activities and their status A tool that automates the data transfer using InfoPackages and InfoPackages groups A tool to display all SAP BW elements (source system, DataSources, transfer rules, InfoSource, update rules, and InfoCubes) from the source system up None of the above.
Which of the following data extractions is possible with SAP BW? This question has only one answer. Provider SAP R/3 Flat file SAP R/2 All of the above None of the above.
Which of the following statements are true regarding authorization in BW? This question has more than one answer. Each authorization refers to one InfoCube Authorization is data concerning the user that remain unchanged over a reasonably long period of time Each authorization refers to an authorization object Each authorization defines one or more values for each field that is contained in the authorization object None of the above.
Which of the following elements refers to objects that deliver data in a Web report? This question has only one answer. Data deliverers Data providers Data suppliers Web providers Web suppliers.
Which of the following characterize a Remote Cube? This question has more than one answer. All of the characteristics are in one dimension It is attached to an InfoSource It has a physical table It stores OLAP data You can see updated data immediately from the source system.
Which of the following is a supply of workbooks in SAP BW arranged according to topic areas? This question has only one answer. An InfoSource A channel An InfoArea An InfoCatalog An InfoObject.
Which of the following are correct concerning SAP BW InfoSources? This question has more than one answer. An InfoSource is comprised of InfoObjects Each time an InfoSource is generated a new extract structure is created on the OLTP system Only key figures are contained in the Info Source The InfoSource allows the system to transfer data to the communication structure The InfoSource helps prepare data to be stored in InfoCubes.
What tables do ODS objects consist of? This question has more than one answer. Active table Extended table Change log table Modified and new table None of the above.
How can the business content be activated in SAP BW? This question has more than one answer. No need to activate—it is automatically activated on installation of SAP BW The business content for one SAP module can be activated in one step Single business content objects can be activated After the activation a complete scenario can be used None of the above.
What step do CO/PA, LO extraction, and LIS extraction methods have in common when setting up delta management of uploads? This question has only one answer. On the scheduler you activate a full upload On the scheduler you initialize the delta upload Setup of delta tables The delta is managed in the service API The InfoStructure tables are used VBDATA and ARFCSDATA tables.
In which of the following objects can data transformation take place? This question has more than one answer. Extract structures ODS Transfer routines Transfer rules Update rules None of the above.
When translating the ERM to MDM/star schema, which of the following guidelines apply? This question has more than one answer. N:M relationships are broken into smaller 1:N relationships The central intersection entity becomes the fact table The ERM is divided over BSIP rollout schedule The foreign-primary key relationship becomes the dimensions Dimensions are summarized into aggregates.
Which of the following are InfoCube types in SAP BW? This question has more than one answer. Aggregate B—Basic R—Remote T—Temp V—Virtual All of the above.
What is the recommended way to increase the speed of loading? This question has only one answer. Increase the size of number range buffer Delete secondary indexes Load master data before transaction data Create multiple jobs to run in parallel All of the above.
What extractor types are available in SAP BW 2.0? This question has more than one answer. Application specific Object specific Cross application InfoCube specific None of the above.
On top of which of the following objects can an InfoSet query be built? This question has more than one answer. Tables Logical database Views Transaction data ABAP programs.
What is the maximum number of key figures in an InfoCube? This question has only one answer. 13 85 322 233 None of the above.
In order to report on data without any key figure (e.g., employee names), which of the following would one introduce? This question has only one answer. An ABAP program to count the master data table entries An artificial key figure (counter) filled with a “1” for each employee Reports that count with Visual Basic functions the number of records A categorical dimension None of the above.
What is a reporting object? This question has only one answer. A folder used to store related InfoObjects A generic term for business evaluation objects A record layout of InfoObjects An authorization object with an additional relationship to InfoCubes None of the above.
How does SAP BW support geocoding? This question has more than one answer. SAP BW does not support geocoding Choose geo-info objects to be geocoded Generate geocoordinates with external tool Upload geocoordinates via SAP BW InfoSource None of the above.
here are data stored during the execution of a query? This question has only one answer. An aggregate cube A cache (temp) cube in the application server A virtual cube A view cube None of the above.
What are the characteristics of the ODS? This question has only one answer. Data available for reporting Denormalized data structure Merge data from different InfoSources Potential to create external files Technical and data changes Transaction data only All of the above.

Denunciar Test

▲