TEST BORRADO, QUIZÁS LE INTERESE:
BW405 SAP BW/4HANA
COMENTARIOS |
ESTADÍSTICAS |
RÉCORDS
|
|---|
REALIZAR TEST
|
Título del Test:
BW405 SAP BW/4HANA Descripción: Introduction to SAP HANA and SAP BW/4HANA Autor: LUIS RODRIGUEZ OTROS TESTS DEL AUTOR Fecha de Creación: 16/01/2020 Categoría: Otros Número Preguntas: 68 |
COMPARTE EL TEST
COMENTAR
No hay ningún comentario sobre este test.
Temario:
|
The virtualization layer is one of the three layers of SAP BW/4HANA. True Falce. The Column Store is one of the four main concepts of the SAP HANA database. True Falce. The CompositeProvider stores no data. True Falce. The SAP BusinessObjects Business Intelligence solution consists of different client tools for specific use cases and the SAP BusinessObjects BI platform server that provides functionality including a central repository, user management, security, and reports scheduling. True Falce. Which tabs do you find in the design panel of SAP BusinessObjects Analysis for Microsoft Excel? choose the correct answer(s) Components Information Data Source Workbook Analysis. How can you navigate in SAP BusinessObjects Analysis for Microsoft Excel? Choose the correct answer(s). Use drag and drop within the crosstab. Use drag and drop between the design panel and the crosstab. Use drag and drop within the design panel. Use double-click. Use the context menu. Use the standard Microsoft Excel menu functions and icons. Use the Analysis menu functions and icons. Which of the following statements regarding the main differences between Analysis views and Analysis workbooks are correct? Choose the correct answer(s). An Analysis view contains one analysis (data source) while an Analysis workbook can contain several analyses (data sources) An Analysis view contains the navigation state of the data source, but a workbook contains the design elements in Microsoft Excel as well as the navigation state of the data sources. An Analysis view contains data while an Analysis workbook does not. In the SAP BusinessObjects Lumira Generic Analysis application, for which of the following components is a context menu for navigation available? Choose the correct answer(s). Crosstab Navigation panel Filter line Chart. By selecting and combining the InfoObjects in a query, you determine the way in which data from an InfoProvider is evaluated. True Falce. When you make changes to an InfoProvider level filter, it affects all queries in which this filter is re-used. True Falce. In which sections of the query can key figures be inserted? Choose the correct answer(s). Filter: Default Value Free Rows Columns. Which of the following statements regarding filters are true? Choose the correct answer(s). Filter values in the Filter: Fixed Values section affect the whole query and can be overwritten via navigation in the executed report. A reusable filter can contain fixed values and default values. Filter values in the Filter: Default Values section affect the whole query and can be overwritten via navigation in the executed report. Filter values in the Filter: Fixed Values section affect the whole query and can be narrowed via navigation in the executed report. Which of the following statements are true? Choose the correct answer(s). For time-dependent master data such as attributes, texts, or hierarchies, the key date determines the date for which time validity the data is selected. The key date acts as a static temporal filter for the whole query. The key date is a mandatory field in the query definition. The key date determines the temporal validity of the query definition. For the key date you can also use a variable instead of a specific value. A filter is defined to apply to the whole query but a restricted key figure only filters a single key figure value. True Falce. When you apply a navigation filter, the restricted key figure value remains the same in the result. True Falce. You use the key figure Sales Order Amount in the Columns section of a BW query and restrict it to the months January and February 2016. How many columns will be displayed in the report? One column with Sales Order Amount January and February 2016. Two columns, one for Sales Order Amount January 2016 and one for Sales Order Amount February 2016. Which of the following statements regarding InfoProvider level calculated key figures are correct? Choose the correct answer(s). You can include formula variables. You can include basic key figures, restricted key figures, and calculated key figures that have been defined at the query level. You must drag the calculated key figure to the section where it should be used in your query. You can include basic key figures, restricted key figures, and calculated key figures that have been defined at the InfoProvider level. When you make changes to an InfoProvider level calculated key figure, it affects all queries in which it is re-used. Which one of the following are percentage functions that are available as an operator in BW Query Designer? Choose the correct answer(s). Percentage Share of Result Percentage Share of Overall Result Percentage Share of Report Result Percentage Share of InfoProvider Result. Which one of these values does a Boolean operator deliver in a BW query formula when it is true? 0 1 True Then. Which of the following aggregation options must you define as an exception aggregation? Choose the correct answer(s). Summation Average Minimum Maximum Counter Last Value. Which of the following statements regarding key figure structures are correct? Choose the correct answer(s). To create a key figure structure, right-click on the key figure to open its context menu and choose Create Structure. Formulas can only be defined within key figure structures. You can only use one key figure structure in a query. Each component of a key figure structure must contain a key figure. What do you have to consider when you create a query with multiple structures? Choose the correct answer(s). You must use a maximum of two structures. You must use one structure in the report columns and one structure the report rows. You can only use one structure without key figures in a query. By using both the structures in the rows or in the columns you can avoid formula collision. You can only use one structure with key figures in a query. By default, the formula that was created first will be used when there is a formula collision. True Falce. Which of the following can you do in the BW Query Designer Cell Editor? Choose the correct answer(s). Use a cell as a reference cell so that it can be referenced in calculations. Define help cells that contain comments for formulas in the report. Apply cell formulas or selection conditions to any cell in your Analysis report. Define formulas and selection conditions for cells to override the automatically created cell values. You need to create a report that shows non-selling materials. With which option in BW Query Designer can you display characteristic values without transaction data in the report? Change the access type for Result Values to Posted Values. Change the access type for Result Values to Master Data. Choose Always for the setting Show Result Rows. Set the document link for master data in the query properties. Choose Values in Master Data Table for the Filter Value Selection. Which two steps do you need to perform to make a display attribute available as a navigation attribute in a query? Choose the correct answer(s). Activate the navigation attribute in the characteristic properties in BW Query Designer. Drag and drop the display attribute to the Free section or the BW Query Designer. Activate the navigation attribute in the SAP BW data flow transformation. Change the attribute type from Display to Navigation in the InfoObject maintenance. Activate the navigation attribute in the respective InfoProvider. Which of the following statements regarding row and column hierarchies are correct? Choose the correct answer(s). Characteristics and display attributes can be included in the hierarchical display. Characteristics and navigation attributes can be included in the hierarchical display. Structures can be included in the hierarchical display. Characteristics with an assigned external hierarchy can be included in the hierarchical display. Hierarchical display can be chosen either for the rows or for the columns. Which of the following statements regarding hierarchical structure display are correct? Choose the correct answer(s). In a structure, drag the structure members that you want to display as subitems directly over the structure member that you want to display as the parent node for the subitems. The hierarchical structure display only works for structures with key figures. The number of levels for a hierarchical structure display is limited to 2. You can use the node status to determine whether the node displays collapsed or expanded in the report. Which one of the following statements regarding external hierarchies are correct? Choose the correct answer(s). An external hierarchy belongs to exactly one characteristic. A characteristic can only possess one external hierarchy. An external hierarchy cannot be created and maintained in BW. An external hierarchy represents master data which is not part of the InfoProvider on which the query is based. External hierarchies can be loaded from source systems. You can sort the members of an external hierarchy in ascending or descending order. True Falce. How can you restrict a characteristic with an external hierarchy in a query? Choose the correct answer(s). Use one or multiple hierarchy nodes. Use one or multiple characteristic values (leaves of the hierarchy). Use combinations of hierarchy nodes and characteristic values. Variables may be used as placeholders for which of the following values? Choose the correct answer(s). Characteristic values Structures Hierarchy nodes Formula elements. Match the processing types with the use case examples. Select a box on the left and then the matching one on the rigth. Manual Entry Replacement Path SAP Exit Authorization. How can text variables be processed? Choose the correct answer(s). Manual Entry Replacement Path Authorization Customer Exit. What do you have to consider when working with variables? Choose the correct answer(s). You cannot use hierarchy variables in combination with hierarchy node variables. Text variables must be with mandatory input. In order to display the lower and upper limit of an interval you need two different text variables. In order to be able to use the same dynamic selection twice in one query without entering the values twice, you use the same variable twice in the query. Which of the following statements regarding variables are correct? Choose the correct answer(s). SAP Exit is a variable processing type that is only available in SAP BI Content variables. The only processing type for SAP BI content variables is SAP Exit. Characteristic value variables can be used in all queries where the characteristic is used. A hierarchy variable can get only one single value. Variables always must get values so that the query can be executed. A characteristic value variable for the characteristic 0CALQUARTER that shows the current quarter, will show the same quarter of the last year if you enter an offset of -12. True Falce. How can you use formula variables? Choose the correct answer(s). As operands for local calculations in reports. As operands in formulas that are retrieved via replacement path. As threshold values in exceptions and conditions. As key values for characteristic restrictions. What happens if no value is chosen for the hierarchy variable in the variable prompt? Choose the correct answer(s). The characteristic is removed from the drilldown. An error occurs if the variable is one for mandatory input. The characteristic values are displayed as flat presentation. The system automatically chooses the first hierarchy according to the technical name. No data at all is displayed. In SAP BusinessObjects Analysis for Microsoft Office, exceptions should be used instead of conditional formatting in Microsoft Excel to highlight values because exceptions are defined for a key figure and not individual cells. True Falce. An exception can only be applied to a single key figure in a query. True Falce. Match each cell restriction operator with its result when the exception is applied. Select a box on the left and then the matching one on the rigth. Everything Except Totals Everything Fixed Value Totals Only. A condition is technically a filter that is applied to key figure values. True Falce. You have created a condition that should show the customers for Top 10 Sales Revenue. You can activate the condition in Analysis but do not see a result. What is the reason? Conditions are not supported in Analysis. You must reset the query in Analysis. You must add the customer characteristic to the drill-down. How can you implement within the query definition an ascending sorting by key figure values? Use a Bottom …. condition. Use a Top …. condition. Use the sorting property for the key figure. For which of the following scenarios can conditions be used? Choose the correct answer(s). Filter for business partner numbers beginning with “1”. Filter for business partners located in Germany. Filter for business partners for which the number of the open order items is greater than 100. Filter for business partners which contribute to the upper 75 % of sales revenue. Using the RRI, you can jump from a report to another report or to a different destination, as long as it is within the SAP BW system. True Falce. Where do you define the sender/receiver assignment for a jump target? In the BW Query Designer Properties pane. In SAP BW, using transaction RSBBS. In the context menu of a report cell in Analysis. In the InfoProvider properties both of the sender and the receiver query. Which of these settings must you enter when creating a jump target in the RRI? Choose the correct answer(s). Target System Report Type Receiver Variable Goto. Which of the following are jump targets within the RRI? Choose the correct answer(s). BW query Analysis workbook Transaction in SAP source system Web address. The target query needs a variable to be able to receive the filter values from the sender query. True Falce. Users create reports for customers and their sales volumes. Sometimes, they need to drill down to the material level to analyze what exactly customers have bought. With which query layout can you optimize the query performance? Choose the correct answer(s). Customer and material in the rows Customer and material in the free characteristics Customer in the rows and material in the free characteristics Material in the rows and customer in the free characteristics Customer and material in the rows with rows hierarchy expanded initially to customer. What are some functions of the query monitor? Choose the correct answer(s). Test and check for SAP BW queries. Regenerate SAP BW queries. Change SAP BW query definitions. Check and monitor performance. Change performance-relevant SAP BW query properties. View technical information about SAP BW queries. Delete SAP BW queries. Which of the following are query read modes for SAP BW queries? Choose the correct answer(s). Query to read all data at once. Query to read data on refresh. Query to read only aggregated data. Query to read data during navigation. Where can you the set the property Operations in SAP HANA in order to define the runtime push-down of Queries in SAP BW/4HANA? Choose the correct answer(s). CompositeProviders InfoObject Characteristics BW Queries DataStore-Objects (advanced). Before you can delete a variable in the BW Query Designer or in the transaction RSZDELETE, you must find all places where this object is used and remove it from there first. True Falce. How can you delete queries and query components? Choose the correct answer(s). Use the transaction RSZDELETE. Use the Query Monitor (transaction RSRT1). Use the BW Query Designer. Use the Data Warehousing Workbench (transaction RSA1). When you select a query for translation in the Data Warehousing Workbench, you must also manually select the query objects for translation. True Falce. An authorization object provides up to 10 fields in which the authorized values have to be inserted. True Falce. Users who execute queries need authorizations in the authorization objects S_RS_COMP and S_RS_COMP1. True Falce. Which of the following statements regarding analysis authorizations are correct? Choose the correct answer(s). Authorization-relevant characteristics are characteristics for which the data are protected. Authorizations for the authorization objects S_RS_COMP and S_RS_COMP1 are sufficient for users who want to display data from authorization-relevant characteristics. When a query is executed, all authorization-relevant characteristics that are contained in the InfoProvider on which the query is based on are checked. Using the transaction RSECADMIN, you can create analysis authorizations for a group of authorization relevant characteristics and restrict the values for these characteristics. Which of these reporting tools can you use to visualize the results of a BW query? Choose the correct answer(s). SAP Crystal Reports for Enterprise Data Warehousing Workbench SAP BusinessObjects BI Platform SAP BusinessObjects Analysis for Microsoft Office. SAP BusinessObjects Analysis for Microsoft Office is the reporting tool of choice for executives because it allows the use of sophisticated graphical elements to visualize highly aggregated data. True Falce. SAP BusinessObjects Web Intelligence allows all information consumers in the company to build individual applications for their reporting needs. True Falce. A practical use case for formatted reporting is an annual report that is centrally created and managed, and distributed to all executives in the company. True Falce. SAP Lumira Discovery is used to prepare data from multiple sources, visualize it, and then compose stories from those visualizations that can be shared with other decision makers. True Falce. SAP Lumira Designer is the tool of choice for graphical visualizations of aggregated data. Dashboards are often built on queries with a very small result set. True Falce. Which are the core functional use cases of SAP Analytics Cloud? Choose the correct answer(s). Providing flexible self-service reporting Modeling planning applications Defining predictive scenarios Modeling SAP BW/4HANA objects Uploading local data into a SAP BW Workspace Modeling and sharing visualizations and dashboards Setting up analytic applications with individual custom scripts. |
Denunciar Test