Test sap

TEST BORRADO, QUIZÁS LE INTERESE: SAP_BOWI

COMENTARIOS	ESTADÍSTICAS	RÉCORDS

REALIZAR TEST

Título del Test:
SAP_BOWI

Descripción:
Test Prof

Autor:

prof

OTROS TESTS DEL AUTOR

Fecha de Creación:
28/01/2021

Categoría: Otros

Número Preguntas: 80

COMPARTE EL TEST

COMENTAR

ISEhi ( hace 2 años )

Ciao Queste domande sono per BOWI_42 o BOWI_43?

Responder

MarianoI ( hace 1 año )

BOWI_42

Temario:

1) How do you remove a custom sort that has been applied to an object? • Choose the Remove button in the Manage Sorts dialog. • Right click the object, select Sort and then select None. • Delete the column containing the object. • Choose the Reset button in the Manage Sorts dialog.
2) What happens when you create a section in a report? (2 answers) • Free-standing cells are created to label each section value. • Page breaks are created to divide each section value. • Header and footer cells are created for each section value. • Blocks in the report are repeated for each section value.
10) You have applied report filters to your document. How do you ensure that end users are aware of this when viewing a document in Reading mode? • Display prompt values in free-standing cells. • Display the Query Summery in a free-standing cell. • Display predefined filters in free-standing cells. • Display the Report filters in free-standing cells.
11) You are asked to create a table to display revenue data in three distinct colors. What must you create in a single conditional formatting rule? • A single formula using the WHERE operator • Multiple predefined filters • Multiple Else conditions • A single formula using the IF function.
16) You want to subtotal the data by year in a table but you do not have a location for the subtotal in the table. What must you do to create the location for the subtotal in the table? • Apply a break. • Format the table • Section the report • Insert a blank cell.
22) Why is the subtotal missing from the bottom of each break in the attached diagram? • The report is NOT sectioned by year. • The calculation was applied to the table before the break. • The break footers display option is NOT selected. • The default aggregation on the measure is delegated.
23) When using the ranking feature on a table, which expression allows you to display the total of all values (both ranked and unranked) in the footer of the block? • Sum([measure]) In Block • Sum([measure) For Each [dimension]) • RefValue(Sum([measure])) • NoFilter(Sum([measure])).
47) Which of these actions clear stored data when tracking data changes? (3 answers) • Enable query stripping • Use the query drill • Modify SQL • Drill out of scope • Start the drill on a duplicate report.
55) To what can you apply conditional formatting rules (2 answers) • Data in a section header cell • Data in a table • Data in a chart • Data in a query filter.
67) Which analysis function adds a column to a vertical table? • Sum • Percentage • Default aggregation • Count.
72) What does the ranking calculation mode Cumulative Percentage keep in the block? • The top/bottom percentage of the number of rows based on the dimension. • The top/bottom values until the sum reaches a specified percentage of the total. • The top/bottom values until the sum reaches a specified value. • The top/bottom number of rows based on the measure.
3) What is the input context of a calculation? • The aggregate function of the calculation • The measure being calculated • The dimension used to define the calculation • The prompt values used in query.
15) In which of the following can you use If( ) function in Web Intelligence? • Prompts • Input control • Drill filters • Variables.
19) How does the ForEach operator affect the default calculation context? • Filters dimension(s). • Add dimension(s). • Replaces dimension(s). • Removes dimension(s).
20) What is the correct formula for the RunningSum column (shown in the attached graphic)? • RunningSum([Sales revenues] in [Quarter]) • RunningSum([Sales revenues];([Year];[Quarter])) • RunningSum([Sales revenues];[Year];[Quarter]) • RunningSum([Sales revenues];([Year])).
21) In the Annual Revenue column, what formula calculates the total annual revenue in each row (shown in the attached graphic)? • =sum([Sales revenues] In([Year];[Quarter])) • =sum([Sales revenues] In([Year];[Quarter])) In ([Quarter]) • =sum([Sales revenues] In([Year])) In ([Quarter]) • =sum([Sales revenues] In([Year];[Quarter])) In ([Year]).
29) A table contains a dimension [CITY] and a measure [SALES]. You insert a column to display the formula AVERAGE([SALES]). Which operator do you add to the formula so that it displays the average for the table in every row? (2 answers) • ForAll ([CITY]) • In Block • In Body • ForEach ([CITY]).
30) What is a Web Intelligence variable? • A property that allows the user to change application mode. • A formula that is saved with a name. • A function that merges multiples queries. • An option that enhances performance when a query is refreshed.
36) Where is a variable saved? • In a category • In the universe • In a query • In the document.
43) What option do you select to change the Total Revenue to a currency (shown in the attached graphic)? • 1. Right click the Total Revenue column name. 2. Select Format Number. • 1. Right click a number in the Total Revenue column. 2. Select Format Cell. • 1. Right click on the edge of the table. 2. Select Format Table. • 1. Right click a number in the Total Revenue column. 2. Select Format Number.
49) Which of the following are extended syntax keywords? (2 answers) • Document • Report • Section • Table.
61) What is the output of the following expression when the CurrentDate is January 31, 2014? If (MonthNumberOfYear(CurrentDate())=1; Year(CurrentDate())-1; Year(CurrentDate())) • 01/31/2014 • 01/31/2013 • 2013 • 2014.
62) What does the RefValue() function return if there is no reference data? • An error • A null • A blank • A zero.
63) How does WHERE operator affect a formula? • It restricts the dimension used to calculate a measure. • It determines the order of the results. • It adds the dimension to the default context. • It removes the dimension from the default context.
77) You have two columns: order date and ship date. How do you calculate the processing time from the order date to the ship date? • Use the “daysbetween” function with order date and ship date. • Use the “isdate” function on both dates and subtract the dates. • Use the “currentdate” function and subtract the ship date. • Use the “daynumberofyear” function after subtracting both dates.
79) What is the required argument of the UserResponse( ) function? • Dimension • Prompt_string • Measure • Report name.
4) You have added additional query to a document. What happens when you choose “Include the result objects in the document without generating a table”? • Existing blocks remain intact. • New result objects are added to the existing query. • Existing blocks are updated with the new objects. • New result objects are projected into a new report.
9) How do you duplicate an existing query? (2 answers) • In the report, right click the report tab and select Duplicate Report. • In the design mode, right click the block and select Publish as Web Service. • In the query panel, right click the query tab and select Duplicate. • In the data mode, right click the query and copy and paste the query.
32) How can you change the data source of a document with multiple queries? • Use the Change Source Wizard to change the queries all at once. • Use the query panel to duplicate the queries and map them to a new data source. • Use the Change Source Wizard to change the queries one at a time. • Use the query panel to remap the objects to a new data source.
51) What object type is represented by the icon shown below? • Filter • Measure • Dimension • Attribute.
53) What does the Change Source Wizard use to remap existing objects to a new data source? (2 answers) • Data type • Object name • Cluster Unique Identifier (CUID) • Description.
54) Which of the following query types can you use for combined queries? (3 answers) • Subquery • Where • Intersection • Union • Minus.
57) You add a new object to a query and run the query. How do you display the new object in the document? • Drag the new object from the Available Objects pane onto the report. • Select “Insert a table in a new report” option. • Select “Insert a table in the current report” option. • Choose “Refresh All” in the report.
60) How can you combine Microsoft Excel spreadsheet data with universe query data? • Filter the universe query using subqueries. • Merge dimensions from two data sources. • Combine the data using a minus query. • Extend the universe query using a scope of analysis.
70) You have a document that includes a shared element. How do you ensure that the document includes the most current version of the shared element? • Update the shared element in the document. • Set the document to “Refresh on open”. • Schedule the document. • Enable the “Check for Shared Element update on open”.
71) You have a measure with different names coming from two queries. How you determine which query each measure comes from? • Select the Visual Difference option in the Central Management Console (CMC). • Select the View Lineage option in the BI launch pad. • Select the Arrange by Alphabetical Order option in the Available Objects pane. • Select the Arrange by Query option in the Available Objects pane.
74) You want to know which other stores’ revenues match to exceed your store’s revenue. You build a query using the sales revenue. What is the next step? • Add a second query displaying all stores and revenues and merge the store name dimensions. • Add a combine query displaying all stores and revenues using intersection operator. • Add a combine query displaying all stores and revenues using the union operator. • Add a subquery displaying all stores and revenues with the operator “Greater than or equal to” your store’s revenue.
80) What actions can you perform in the Web Intelligence query panel? (3 answers) • Remove objects from the query. • Publish as a web service. • Rearrange objects in the query. • Change custom filters. • Change table to chart.
5) What options are available when linking to another document? (2 answers) • Combine queries • Refresh on open • Change data source • Target an area within the document.
33) When creating a hyperlink, what BI Launchpad Preferences view includes the Link to Document option? • PDF • Applet • HTML • Desktop.
45) Which of the following can you use to filter results dynamically? (2 answers) • Input control • Element linking • Report map • Results Object pane.
58) What can you use to create hyperlinks between Web Intelligence documents? • Element linking • The document summery • The report map • OpenDocument.
6) Which of the following make up a semantic layer for a rational data source? (3 answers) • Block • Universe • Section • Measure • Dimension.
28) What are the benefits of using SAP Business Objects Web Intelligence? (2 answers) • You can drill, slice-and-dice, format information based on business needs. • You can dynamically refresh and update information directly in your MS Office documents. • You can centrally manage, control and configure your BI deployment. • You can use simple drag-and-drop features to create interactive reports.
68) What data source can you select when creating a document using the Web Intelligence Rich Client? (2 answers) • BEx Query • Lumira Dataset • Analysis view • XML files.
7) How do you determine if a formula or a variable is used in a block? (2 answers) • Change the application mode to Design and select Structure Only • Select the cell and view the formula toolbar • Select the block, right click and select Format Table • Change the application mode to Reading.
14) What tasks can you perform in the data application mode? (2 answers) • Merge objects • Add a report filter • Create a new data provider • Assign chart series data.
17) A document displays a data in the format: MM/DD/YY. What option allow you to change the format to DD/MM/YY? (2 answers) • Preferred viewing locale • Format number • Auto detect • Product locale.
34) Where can you use a free-standing cell? • In a table • In the query panel • In a chart • In a section.
37) How can you make the pie chart (shown in the attached graphic) display correctly? • Drag a dimension or attribute on to the chart • Change to the Design – With Data application mode. • Drag a measure on to the chart • Change to the Reading application mode.
39) Why do you use the “Turn into” functionality? • To change the data source of a document • To change the table into a chart • To change the object of a section • To change the data type of an object.
42) What items can be presented in a free-standing cell? (2 answers) • Last refresh date • Vertical tables • Page numbers • Bar charts.
73) Which table type looks most similar to a Microsoft Excel pivot table? • Form • Horizontal table • Cross table • Vertical table.
8) What is required to use the Comments feature? (2 answers) • The data source of the document must be an SAP HANA view. • The Webi document must be assigned to the Mobile category. • The Webi document must be saved to the BI platform. • Rights must be granted by an Administrator to manage comments.
24) What operator do you select to use a wildcard character in a Web Intelligence query? • Matches pattern • Equal to • Except • In list.
25) Which operator allows you to enter more than one operand value? • Equal to • In list • Except • Less than.
26) What property prevents free-form entry in response of a prompt? • Keep last value selected • Set default values • Optional prompt • Select only from list.
27) Where is a predefined query filter created? • In the query panel • In the universe • In the Input Controls pane • In the filter bar.
35) Your data source has the following values: SMITH, SMYTH, SMALL, SMOOTH, SMART, SMILEY. What syntax do you use to show only the names SMITH and SMYTH? • SM%TH • SM*TH • SM_TH • SM&.
38) Which operator allows you to select exactly one value as the operand for a query filter? • Between • Equal to • Different from pattern • Is null.
44) In the query panel, you modify the script and no errors occur. You remove an object and add a different object to the Result Object pane. What happens to the script? • The script remains unchanged because the script was changed manually. • The script includes both the manual change and the new result objects. • The script fails to parse. • The script is regenerated because the result object list is changed.
56) What happens if an operational prompt is blank when you execute a query? • The query filter is ignored. • The query returns an empty record set. • The query is filtered by the default value of the prompt. • The query is filtered by the last value selected.
66) How do you allow a user to type a value for a prompt? (2 answers) • Select the “Optional prompt” property. • Deselect the “Select only from list” property. • Deselect the “Prompt with list of values” property. • Deselect the “Set default values” property.
75) Which of the following filter components are used to restrict data? (3 answers) • An object • An operator • A universe connection • An operand • A SELECT statement.
12) In which application do you schedule documents? • Central Configuration Management (CCM) • BI launch pad • Web Intelligence Applet • Web Intelligence Desktop.
13) When scheduling Web Intelligence document, what output formats are available? (2 answers) • Plain Text (TXT) • HyperText Markup Language (HTML) • Adobe Acrobat (PDF) • Microsoft PowerPoint (PPT).
18) Why should you always log off the BI lunch pad rather than just closing your browser session? • To protect corporate data • To clear the browser cache • To improve system performance • To allow data refreshes.
31) How does SAP recommend you print a Web Intelligence document to ensure the document layout is preserved? • Use the Print Screen button on your keyboard • Use the print option in the browser • Export the document to a PDF file and print the PDF file. • Export data to a CSV file and print the CSV file.
40) What do you use to search for content in multiple documents? • BI launch pad • Central Management Console (CMC) • Central Configuration Manager (CCM) • Report map.
46) How do you share a Web Intelligence document with another user in the BI launch pad? (2 answers) • Send it to the user’s inbox • Schedule it to a public folder • Save it to the user’s “My Favorites” folder • Save it to your “My Favorite” folder.
50) How do you make changes to a document that has been published in the BI Launch pad? (2 answers) • Right click the document and select Properties. • Select the document, select More Actions and select Modify. • Right click the document and select Document Link. • Double click the document and select Design Mode.
52) Why purge data in a document before saving to the BI platform? (2 answers) • To ensure that data security restrictions are applied when the document is viewed. • To allow other users to view the document in their preferred viewing locale. • To reduce document file size. • To enable data tracking on a subsequent refresh.
41) How do you change the dimension on which a section is based? • 1. Right click in a blank area of the section. 2. Select Edit Selection. 3. Choose the new dimension. • 1. Right click in a blank area of the section. 2. Select Format Selection. 3. Modify dimension after “Section on”. • 1. Right click the section cell. 2. Select Edit Formula. 3. Choose the new dimension. • 1. Right click the section cell. 2. Select Sort. 3. Select Advanced. 4. Remove existing dimension. 5. Add the new dimension.
48) How do you access the Format Table option? • Right click the border of the table • Right click the footer of the table • Right click the column header of the table • Right click the data of the table.
64) What do you use to conditionally hide a report element? • A formula • A formatting rule • A query filter • A report filter.
65) What chart elements can use a formula? (2 answers) • Legend labels • Axis titles • Chart title • Data labels.
59) After starting a drill, where are the objects that were selected in the drill interaction shown? • In the Report Map pane • In the filter bar • In the formula bar • In the Document Structure and Filters pane.
69) Which report element can you drill on? (3 answers) • Page numbers • Cross tables • Charts • Vertical tables • Free-standing cells.
76) What object type is found in navigation paths? • Attribute • Dimension • Filter • Filter.
78) What can you do with a scope of analysis? (2 answers) • Provide further detail on data. • Restrict the data retrieved from the database only to the objects on the report. • Perform calculation. • Request the data from the database for drilling.

Denunciar Test

▲