TBI15

Descrição

Prep Questions
Hannylou Celestial
Quiz por Hannylou Celestial, atualizado more than 1 year ago
Hannylou Celestial
Criado por Hannylou Celestial mais de 6 anos atrás
28
1

Resumo de Recurso

Questão 1

Questão
Who are the target users for BOAO, MS Powerpoint?
Responda
  • Business Users
  • Data Analyst
  • SAP BW Consultants

Questão 2

Questão
Use Cases for Analysis for Powerpoint
Responda
  • Distribution of Analysis (Slide deck building)
  • Distribution of Analysis (Workbookbuilding)
  • Analysis

Questão 3

Questão
Analysis for Powerpoint have the same functionality as Analysis for Excel
Responda
  • True
  • False

Questão 4

Questão
Analysis Powerpoint does not have a Design Panel
Responda
  • True
  • False

Questão 5

Questão
Available features in Analysis for Powerpoint ribbon
Responda
  • Insert Data Source, Refresh All, Prompts, Filter, Sort, Hierarchy, Measures, Members, Totals, Chart, Info field, Fit Table, Move to, Smart Copy/ Smart Paste, Properties
  • Insert Data Source, Refresh All, Prompts, Filter, Sort, Hierarchy, Measures, Members, Totals, Chart, Info field, Move to, Smart Copy/ Smart Paste, Properties
  • Insert Data Source, Refresh All, Prompts, Filter, Sort, Hierarchy, Measures, Members, Totals, Chart, Info field, Fit Table, Move to, Design Panel, Smart Copy/ Smart Paste, Properties
  • Insert Data Source, Refresh All, Prompts, Filter, Sort, Hierarchy, Measures, Members, Totals, Chart, Info field, Fit Table, Move to, Copy/ Paste, Properties

Questão 6

Questão
Which Settings are available in Analysis for Powerpoint?
Responda
  • User Settings (Maximum number of Entries in Recent List, Maximum number of Members displayed in Filter Dialog)
  • User Settings (Maximum number of Entries in Data source List, Maximum number of Members displayed in Filter Dialog)
  • Advanced Settings (Show Access Mode for Member Display, Allow client and Language Selection for SSO Logon)
  • Advanced Settings (Show Access Mode for Member Display, Allow all time-dependent hierarchies to be displayed in Design panel)
  • Platform Settings (Preferred Platform, Show Access Mode for Member Display, Replace system)
  • Platform Settings (Preferred Platform, Replace system)
  • Support Settings (Folder for Log file, Log Severity, Enable BW Server Tracing, Enable Workbook Profiling, Enable Client Profiling, Display Technical Name, Enable NCO Tracing, Show suppressed Messages)

Questão 7

Questão
Available Properties to configure for the entire presentation
Responda
  • Refresh Workbook on Opening
  • Refresh Presentation on Opening
  • Force Prompt for Initial Refresh
  • Store Prompts with Presentation
  • Store Prompts with Workbook
  • Remove Data before Saving
  • Merge Variables

Questão 8

Questão
When you smart paste a crosstab or a chart from a current navigation state in Excel to Analysis for Powerpoint, the objects paste in Powerpoint exist dependently to the objects in Excel
Responda
  • True
  • False

Questão 9

Questão
What are the options available in using Fit Table feature?
Responda
  • Split Table
  • Fit Table
  • Abbreviate Table
  • Hide Table

Questão 10

Questão
What is the maximum number of rows per slide in Analysis for Powerpoint?
Responda
  • 65
  • 75
  • 99
  • 1,000,000

Questão 11

Questão
If the number of total rows has changed, slides are created and/or deleted based on the changes when it is data refreshed.
Responda
  • True
  • False

Questão 12

Questão
Which options of Fit table would you use if you want to truncate data from the Dimension at row N and display "..." indicating the users that there is more data but they are hidden.
Responda
  • Fit Table
  • Split Table
  • Abbreviate Table

Questão 13

Questão
In Abbreviating table, Sorting will not affect the display of data
Responda
  • True
  • False

Questão 14

Questão
If you turn a split table into an abbreviation table, one or more slides are added.
Responda
  • True
  • False

Questão 15

Questão
You have the option to delete existing slides via Fit Table Dialog
Responda
  • True
  • False

Questão 16

Questão
If a table is split across multiple slides and one or more slides is manually deleted, the lost slides are replaced on refresh.
Responda
  • True
  • False

Questão 17

Questão
You may change the display order of the slides from a split table. But when you refresh the data it will be back from the initial order
Responda
  • True
  • False

Questão 18

Questão
What are the following available options for info field in Analysis for Powerpoint?
Responda
  • Presentation name
  • Key date
  • Data Source name
  • Last Data update
  • Effective Filters
  • Variables

Questão 19

Questão
Which of the following are true statements about Info field in Analysis for Powerpoint?
Responda
  • Any manual user edits are overwritten when refreshed
  • Any manual user edits are retained when refreshed
  • Info fields are language-independent
  • Info fields are refreshed when the slide deck is refreshed
  • Info Fields are inserted into the slide as groups
  • Info Fields consist of a label and a value which can be broken if you choose
  • Info Fields consist of a label and a value which cannot be broken

Questão 20

Questão
Available Platforms in Saving Platforms
Responda
  • SAP BI Platform
  • SAP Netweaver Platform
  • SAP Lumira Cloud
  • SAP BW Server

Questão 21

Questão
When you have a data source with numerous rows you can use the Fit Table feature to break the result into multiple slides
Responda
  • True
  • False

Questão 22

Questão
If a table is split across multiple slides and one or more of the slides is manually deleted, the lost slides cannot be recovered.
Responda
  • True
  • False

Questão 23

Questão
It enables application designers to create analysis applications and dashboards based on SAP Netweaver BW, SAP Hana, and Universe data sources, for web and mobile devices
Responda
  • Crystal Reports 2016
  • Dashboards
  • Lumira
  • Design Studio
  • Information Designer Tool

Questão 24

Questão
Which of the following are the true statements about Design Studio?
Responda
  • Drag & Drop Visualizations and Controls: Tables, Charts, Geo Map, Filters etc.
  • Personalized Online Composition for End-Users
  • Standard Apps for Analysis, Planning, Data Exploration, Self-Service
  • State of the Art HTML5 Rendering & Mobile Support
  • Rapid Prototyping with Offline Data (CSV)
  • Full OLAP & Planning Support, Dashboards
  • Access Enterprise Data Sources: BW, HANA, UNX, ESP Event Streaming
  • Ad hoc analysis and reporting tool for business users with or without access to BI platform
  • Windows based report design tool used to create powerful stuctured reports
  • Statistical Analysis and data mining solution that enables you to build predictive models to discover hidden insights and relationships

Questão 25

Questão
Deployment Options for Design Studio Applications
Responda
  • BI Platform
  • SAP Netweaver
  • HANA Native
  • Universe

Questão 26

Questão
Which of the following are true about Deploying Design Studio Application on BI Platform?
Responda
  • Available as of Design Studio 1.1
  • Available as of Design Studio 1.0
  • BI 4.0 SP5 or BI 4.1 SP0 as the prerequisite
  • BI 4.4 SP1 or BI 4.7 SP0 as the prerequisite
  • Applications are stored on BI Platform
  • Applications are stored on BI Platform then transported to SAP Netweaver
  • Transportation via Promotion
  • Transpoted through TLOGO
  • Connections through CMC, able to connect to multiple SAP BW and SAP HANA systems

Questão 27

Questão
Which of the following are true statements about Deploment Options for SAP Netweaver?
Responda
  • Available as of Design studio 1.1
  • Available as of Design studio 1.0
  • BW 7.3 SP9, BW 7.31 SP7 or BW 7.4 SP2 as the pre-requisite
  • BW 4.0 SP5, BW 4.1 SP0 or BW 7.31 SP7 as the pre-requisite
  • Applications are stored on SAP BW
  • Applications are stored on BI Platform
  • Can only connect to one BW System
  • Can connect to multiple BW System and HANA systems
  • Mobile Solution: Portal on Device

Questão 28

Questão
Which of the following are true about Deploying Design Studio Application on HANA Native?
Responda
  • Available as of Design Studio 1.5
  • Available as of Design Studio 1.3
  • HANA 1.0 revision 90+
  • HANA 1.1 revision 90+
  • Applications are stored in HANA repository
  • Applications are stored in BW repository
  • Direct native connectivity to HANA's Information Access Service (INA) via Firefly
  • Direct native connectivity to HANA's Data Access Service (INA) via Firefly

Questão 29

Questão
Which of the following are true statements about the Local Mode in Design Studio?
Responda
  • This option can be used for end-user use and for demo or quick prototyping
  • Only for demo or quick prototyping
  • Direct Connection to backend data sources. Uses local SAP logon.ini file & ODBC HANA connection info
  • Direct Connection to backend data sources and to HANA's Information Access Service (INA)
  • Design Studio Java Application runtime runs locally on laptop or PC

Questão 30

Questão
Which of the following Platform strategy is recommended by SAP?
Responda
  • SAP recommends to deploy Design Studio on the BW Platform
  • SAP recommends to deploy Design Studio on the BI Platform
  • SAP recommends deploying Design Studio on the SAP Netweaver
  • SAP recommends deploying Design Studio on HANA Native

Questão 31

Questão
How would you change the the startup mode from a Local mode to BI Platform?
Responda
  • Choose tools → Preferences → Select SAP BusinessObjects BI Platform
  • Choose Settings→ Preferences → Select SAP BusinessObjects BI Platform
  • Choose Application→ Preferences → Select SAP BusinessObjects BI Platform

Questão 32

Questão
In choosing BI platform or Netweaver as the startup mode, you can still decide to log on locally by clicking the SKIP. The design tool starts in local mode.
Responda
  • True
  • False

Questão 33

Questão
Which of the following can you do on the Welcome page of Design Studio?
Responda
  • Watch most recent tutorials
  • Create new application
  • Delete an existing application
  • Open an existing application through Recently-used Analysis application
  • Open Useful Links
  • Create Tutorials

Questão 34

Questão
You can create a new Design Studio Application via
Responda
  • Application menu
  • Toolbar
  • Layout
  • Edit
  • View

Questão 35

Questão
Storage location of Design Studio Application deployed on BI Platform
Responda
  • Favorites or Public Folder on BI Platform Server
  • BW -ABAP Server
  • HANA Repository
  • C:\Users\<YourUser>\Analysis-workspace\com.sap.ip.bi.zen\repository

Questão 36

Questão
How to use the "New Application" Dialog
Responda
  • Enter a unique name for your application → Choose rendering type: SAPUI5 or SAPUI5m → Choose template → Create
  • Enter a unique name for your application → Choose rendering type: SAPUI5 or SAPUI5m → Choose template → Add
  • Enter a unique name for your application → Choose rendering type: SAPUI5 or SAPUI5m → Choose template → Choose Query → Create
  • Enter a unique name for our application → Choose rendering type: SAPUI5 or SAPUI5m → Choose template → Create → Query Panel → Choose Query → Add

Questão 37

Questão
Which of the following are main screen elements of Design Studio?
Responda
  • Components
  • Analysis
  • Information
  • Layout
  • Outline
  • Properties

Questão 38

Questão
Which of the following are the possible additional views on Design Studio?
Responda
  • Additional Properties
  • Properties
  • Script problems
  • Script Editor
  • Search Results
  • ERROR Log
  • Conversion Log

Questão 39

Questão
Design Studio Sources for a Data Source Object
Responda
  • SAP BW (Query, Query view, InfoProvider)
  • SAP HANA (Analytic View, Calculation View)
  • CSV
  • Universe (Relational and OLAP)
  • Universe (Relational)
  • SAP BW (Query, Query view)

Questão 40

Questão
Restrictions for Universes as Data Source of a Design Studio Application
Responda
  • Must be BI Platform 4.1 to access universe as data source
  • Must be BI Platform 4.2 to access universe as data source
  • Universe should be relational universe, single-source universe, or multi-source relational universes
  • The result set has a fixed limit of 20,000 rows or 200,000 data cells
  • The result set has a fixed limit of 200,000 rows or 200,000 data cells

Questão 41

Questão
Ways on how to create a new Data Source
Responda
  • Application menu → Add Data Source
  • Right-click Data Sources in the Outline tab of the design tool → New
  • Copy and Paste from another Design Studio Application or within Application
  • Copy and Paste from another Reporting tool
  • Use of interoperability features of Analysis Office or Analysis OLAP

Questão 42

Questão
Which of the following allows you to modify initial state of any data source?
Responda
  • Initial View dialog box
  • Data Source settings dialog box
  • Components settings dialog box
  • Layout dialog box

Questão 43

Questão
Which of the following are the options to add components to an Application?
Responda
  • Drag and Drop into preview area
  • Drag and Drop into Layout folder of the Outline view
  • Drag and Drop into Components area
  • Right-click to a component → add to Layout folder

Questão 44

Questão
Which of the following are not true about Layout Properties and Docking behavior in Design Studio?
Responda
  • Each component is always bound to its surrounding borders, borders of application or a surrounding object
  • Each component is sometimes bound to its surrounding borders, borders of application or a surrounding object depending on the settings
  • For each axis, three values have to be specified, and one of these three values is always defined as auto
  • For each axis, three values have to be specified, and one of these three values is always defined as 0
  • Use Maximize Component button to define width/height as auto and the margins as auto
  • Use Maximize Component button to define width/height as auto and the margins as 0

Questão 45

Questão
Which of the following are true about Aligning and Distributing components in layout?
Responda
  • Only the Analytic components can be aligned and distributed
  • All type of components can be aligned and distributed
  • Components within the same container or under the same root can be aligned and distributed
  • Components can be automatically maximized
  • Alignment and Distribution can be done via context menu in layout or per buttons on the Design studio menu

Questão 46

Questão
Ways on how to assign Data source to a component
Responda
  • Drag the data source from the Data Sources folder and drop it into the corresponding component in the Layout Folder in the Outline view
  • Drag the data source from the Data Sources folder and drop it into the corresponding component in the Layout Folder in the Properties view
  • Drag the data source from the Data Sources folder and drop it into the corresponding component in the design area of the tool
  • Select Data Source in the Data Source property of the component
  • Select Data Source in the Application property

Questão 47

Questão
Basic Components includes
Responda
  • Button
  • Chart Type Picker
  • Checkbox and Checkbox Group
  • Filter Line
  • Date Field
  • Geo Map
  • Dropdown box
  • Chart
  • Crosstab
  • Fromatted Text view

Questão 48

Questão
Analytic Components includes
Responda
  • Dimension Filter
  • Filter Panel
  • Spreadsheet
  • Scorecard
  • Filter Line
  • Chart Type Picker
  • Tabstrip
  • Info field
  • Crosstab
  • Geo Map

Questão 49

Questão
Container Components include
Responda
  • Grid Layout
  • Page number
  • Pagebook
  • Panel
  • Navigation Panel
  • Popup
  • Split Cell Container
  • Tabstrip
  • Merge Cell Container

Questão 50

Questão
This type of component is used to optimize an application for a mobile device and enable specific motion gestures in mobile applications
Responda
  • Components
  • Container
  • Basic
  • Analytic

Questão 51

Questão
This type of component is used to enable navigation and user interaction at runtime, enhance the design and layout of the application
Responda
  • Components
  • Container
  • Basic
  • Analytic

Questão 52

Questão
The [blank_start]Crosstab[blank_end] displays multi-dimensional data in a grid with analytic functions.
Responda
  • Crosstab
  • Tablestrip
  • Geo map

Questão 53

Questão
Which of the following is not true about Crosstab component in Design studio?
Responda
  • You can enable/disable navigation functions like hierarchical navigation, sorting, column resizing function
  • Exceptions defined in SAP BW backend or in Analysis Office can be activated in crosstab setting
  • Exceptions are not supported in Design Studio
  • Context Menu available and can be adjusted
  • RRI is supported

Questão 54

Questão
Feeding Panel is not compatible with Charts, only with Info Charts.
Responda
  • True
  • False

Questão 55

Questão
With the info Chart component, you could assign only crosstab rows and columns. With Chart component, each dimension can be assigned a different axis independently.
Responda
  • True
  • False

Questão 56

Questão
Which of the following can you do with the Navigational Panel?
Responda
  • Configure whether key figures should be included in filter line
  • You let end-users navigate via drag and drop (dimensions and measures)
  • Quick access to dimension and measures via search bar
  • Option to pause refresh
  • Measures and Dimension are shown in one area only to simplify view
  • Measures can be shown separately

Questão 57

Questão
The order of dimensions in a Navigational Panel can be determined in runtime
Responda
  • True
  • False

Questão 58

Questão
Drag and Drop from Navigational Panel to Crosstab is a default setting in Application property
Responda
  • True
  • False

Questão 59

Questão
The Filter Panel component can be used for [blank_start]Filtering and Navigation[blank_end]
Responda
  • Filtering and Navigation
  • Selecting dimension and measures
  • Choosing filter options
  • Configuring data on a crosstab

Questão 60

Questão
Which of the following are true about Filter Line component
Responda
  • Horizontal filter area
  • Vertical filter area
  • End-users can easily select filter criteria and filter values
  • Application designers can configure whether key figures should be included in filter line
  • Configuration by properties, no scripting is required
  • Application designers can configure whether dimensions should be included in filter line

Questão 61

Questão
Which of the following is true about Dimension Filter?
Responda
  • Horizontal filter area
  • Application designer can decide to enable "Filter only", "Navigation only" or both
  • Member display could be defined as text, key, or both
  • Dimension name could be shown or hidden
  • Ranges are able to be defined in addition to multiple selection of members
  • Specify other data sources as target
  • Specifies the dimension to be filtered

Questão 62

Questão
Design studio generates a generic prompt screen if prompts are defined [blank_start]as mandatory[blank_end] and do not have a valid default value in the Data source or the Application is set to "Force prompts on Startup"
Responda
  • as mandatory
  • as optional
  • as variable
  • as mandatory variable

Questão 63

Questão
Grid layout is used to group and order the content of an application and is displayed at runtime
Responda
  • True
  • False

Questão 64

Questão
The [blank_start]Pagebook[blank_end] component enables the user to switch between different views of an application.
Responda
  • Pagebook
  • Tabstrip
  • Panel
  • Popup
  • Image
  • Text

Questão 65

Questão
Pages are shown in the outline view
Responda
  • True
  • False

Questão 66

Questão
If you use Pagebook component in the layout editor, the system automatically creates one page for the Pagebook.
Responda
  • True
  • False

Questão 67

Questão
If you want to add further pages on a Pagebook component, use the content menu of the Pagebook in the Outline view and [blank_start]click Create Child → Page[blank_end]
Responda
  • click Create Child → Page
  • click Pagebook → Choose Page
  • click Create Pagebook → Page
  • click Create Child → Page N

Questão 68

Questão
Pagebook component are compatible with any browser types/versions and capable to display the transition effects correctly.
Responda
  • True
  • False

Questão 69

Questão
[blank_start]Tabstrip component[blank_end] is used to group and order the content of your application in tabs. You can also use it to enable user interaction within the application.
Responda
  • Tabstrip component
  • Pagebook component
  • Filter Line component
  • Filter Panel component
  • Navigational Panel

Questão 70

Questão
Application designer must add a script to the tabstrip to enable interaction within the application. The script is triggered when the user selects one of the tabs on the tabstrip
Responda
  • True
  • False

Questão 71

Questão
With the [blank_start]Selected Tab Index Property[blank_end], you can specify which tab should be displayed initially. The Index starts with 0, which means the first tab is Index = 0.
Responda
  • Selected Tab Index Property
  • On Select Property
  • On Select Index Property
  • Select Index Property

Questão 72

Questão
[blank_start]Panel component[blank_end] is used to group other components in your application. This is a very simple container component.
Responda
  • Panel component
  • Pagebook component
  • Tabstrip component
  • Popup component

Questão 73

Questão
The components nested in the Panel are positioned [blank_start]relative[blank_end] to the Panel and not to the Application border.
Responda
  • relative
  • linear
  • beside
  • 10 pixels to the left

Questão 74

Questão
[blank_start]Popup component[blank_end] helps users to quickly enter information, perform configurations or make selections. In addition, it can also be useful for displaying more specific data for a selected item.
Responda
  • Popup component
  • Panel component
  • Pagebook component
  • Tabstrip component
  • Navigational component

Questão 75

Questão
You can only put texts component into a popup
Responda
  • True
  • False

Questão 76

Questão
Which of the following are the restrictions of using Popup component?
Responda
  • Popup can only be nested in the root layout and not within another container
  • Popup can only be nested in the container and not within root layout
  • Popup can only be positioned relative to the root layout
  • Popup can only be positioned relative to another container
  • Popup can only be positioned linear to another container

Questão 77

Questão
Popup component is set to visible by default
Responda
  • True
  • False

Questão 78

Questão
Working with Design Studio Applications provides Multi language support
Responda
  • True
  • False

Questão 79

Questão
[blank_start]Text pool[blank_end] to add translations centrally
Responda
  • Text pool
  • Translation component
  • Translation pool
  • Text Translation

Questão 80

Questão
This component is used to add text to your application. Text can be formatted with Style Property and use of one the predefined styles out of the selected theme
Responda
  • Formatted Text View
  • Text Component
  • Text pool

Questão 81

Questão
This component is used to enable the user to apply text formatting within one control.
Responda
  • Formatted Text View
  • Formatted Text Pool
  • Text pool
  • Text Component

Questão 82

Questão
Which of the following is true about Data Bound Component Properties
Responda
  • You can bind dropdown, List boxes to master data
  • You can bind text elements to measure values
  • Scripting is required to trigger functions when the user selects the component
  • No scripting is required
  • Bind CSS style to measure value conditions (e.g. for conditional highlighting)

Questão 83

Questão
How would you bind a text component to a cell value?
Responda
  • Select the text property → Click on the Binding Icon → Choose the Select Data icon → Select the Data Source → Click in the cell you want to use as source → OK
  • Select the text property → Click on the Binding Icon → Choose the Select Data icon → Select the Data Source → OK
  • Select the text property → Click on the text Icon → Choose the Select Data icon → Select the Data Source → Click in the cell you want to use as source → OK

Questão 84

Questão
How would you bind Listbox and Define Filtering?
Responda
  • Enable the Source settings → Define the Data Binding → Define the Target settings
  • Enable the Data Binding → Define the Source settings → Define the Target settings
  • Enable the Data Binding → Define the Target settings → Define the Source settings

Questão 85

Questão
Scorecard is recommended to be used with dynamic data sources and data sources with free multidimensional navigation (slice and dice)
Responda
  • True
  • False

Questão 86

Questão
The [blank_start]Scorecard Component[blank_end] is designed for use in dashboards and reports with controlled visualization content and restricted navigation possibilities.
Responda
  • Scorecard Component
  • Scoreboard Component
  • Info Chart Component
  • Info field Component

Questão 87

Questão
Auto Generation of Scorecard analyzes fully any specialties of the data source.
Responda
  • True
  • False

Questão 88

Questão
Steps to create a Scoreboard
Responda
  • Add Scoreboard to the Application → Assign a Data source → Define the row scope → Define Columns and Group Headers
  • Add Scoreboard to the Application → Assign a Crosstab → Define the row scope → Define Columns and Group Headers
  • Add Scorecard to the Application → Assign a Data source → Define the row scope → Define Columns and Group Headers
  • Add Scorecard to the Application → Assign a Crosstab → Define the row scope → Define Columns and Group Headers

Questão 89

Questão
The [blank_start]Row Scope property[blank_end] define how many or how detailed your data is presented in the Scorecard
Responda
  • Row Scope property
  • Columns and Group Headers
  • Data Source property
  • Column Scope property

Questão 90

Questão
Interoperability between Analysis Office and Design studio
Responda
  • Smart Copy/Smart Paste
  • Create Web Application
  • Create Design Studio Application
  • Copy/Paste

Questão 91

Questão
Which of the following are true statements about Smart Copy ?
Responda
  • It copies the navigation state of a single or multiple Data Sources into the clipboard
  • It copies the navigation state of a single Data Sources into the clipboard
  • Data Source is added in Design Studio via Smart Copy
  • Data Source is added in Design Studio via Smart Paste
  • Visualization is created automatically
  • No Visualization is created in Design Studio automatically

Questão 92

Questão
If you want to use the "Create Web Application" Function in Analysis, the button needs to be activated in the [blank_start]Settings → Advanced Settings[blank_end]
Responda
  • Settings → Advanced Settings
  • Options → Advanced Settings
  • Settings → Platform Settings
  • Settings → User Settings

Questão 93

Questão
Which of the following Analysis components can be transferred to Design studio?
Responda
  • Crosstab
  • Data Source
  • Charts such as Pie, Line, Column, Bar, Surface, Radar, Bubble and Scatter
  • Charts such as Pie, Line, Column, Bar, Waterfall, Radar, Bubble and Scatter
  • Filter Panel
  • Filter

Questão 94

Questão
You can used Create Web Application even when the Design Studio is open
Responda
  • True
  • False

Questão 95

Questão
Script to manually add Export to Lumira option to any application: DS_1.export([blank_start]DataSourceExportType.LUMIRA_lums[blank_end]);
Responda
  • DataSourceExportType.LUMIRA_lums
  • ExportType.LUMIRA_lums
  • DataSourceExportType.LUMIRA
  • DataFileExportType.LUMIRA_lums

Questão 96

Questão
The Generic Analysis Template has no data source assigned by default. The users execute it and then assign a data source at runtime. This means the template remains generic and independent of the data source.
Responda
  • True
  • False

Questão 97

Questão
Which features are available in Ready to Run: Online Composition?
Responda
  • Overview page to see all composition
  • Create, Edit, Delete, Open and Share Composition
  • Global Filters for composition
  • Overview page to see all Global Filters
  • Create, Edit, Delete Composition

Questão 98

Questão
Which features are available in Ready to Run: Data Exploration & Visualization App?
Responda
  • Use RRI interface
  • Visualize several datasources and display them in one story
  • Visualize with only one data source and display them in one story
  • Share a PDF export of a story and URL link to the story
  • New Info Charts and Feeding Component
  • Custom Measures and Top N Filters

Questão 99

Questão
Define your Template Folders: [blank_start]Tools → Preferences → Application Design[blank_end] → Application Templates
Responda
  • Tools → Preferences → Application Design
  • Tools → Settings → Application Design
  • Tools → Preferences → Application
  • Tools → Preferences → Design

Questão 100

Questão
Export the Application you want to use as new Template: [blank_start]Application → Export as Template[blank_end]
Responda
  • Application → Export as Template
  • Design Application → Export as Template
  • Application → Export
  • Design Application → Template

Questão 101

Questão
Which CSS attributes are supported for both desktop browser and iPad/iPhone application?
Responda
  • font size
  • font color
  • weight (bold)
  • style (italic)
  • text decoration (underline)
  • background
  • text decoration (strikethrough)

Questão 102

Questão
The scripts are executed on the [blank_start]Analysis Application Design Service[blank_end] (unlike JavaScript that is executed in the Web browser)
Responda
  • Analysis Application Design Service
  • Analysis Application Designer Service
  • Analytic Application Design Service
  • Analytic Application Designer Service

Questão 103

Questão
Script Statement Types
Responda
  • call statements
  • conditional execution statements
  • assignment statements
  • calling statements
  • exception execution statements

Questão 104

Questão
Call statement Sytanx : [blank_start]<Component>.<Method>(<Arguments>);[blank_end]
Responda
  • <Component>.<Method>(<Arguments>);
  • IF xxx THEN xxx ELSE
  • VAR <VARIABLE> = <EXPRESSION>
  • <VARIABLE> = <EXPRESSION>

Questão 105

Questão
It offers content assistance.
Responda
  • CTRL + ENTER
  • CTRL + SPACE
  • CTRL + SHIFT + SPACE
  • CTRL + ?

Questão 106

Questão
BI Types: Design studio needs to know what type a parameter has. Which of the following is not included in BI Types?
Responda
  • Dimension
  • Member
  • Filter
  • MemberPresentation
  • ChartType
  • None of the above

Questão 107

Questão
Application methods to analyze the general behavior of your Design Studio application
Responda
  • log, alert, createErrorMessage, createWarningMessage, createInfoMessage
  • log, alert, createErrMessage, createWarningMessage, createInfoMessage
  • log, alert, createErrorMsg, createWarningMsg, createInfoMsg

Questão 108

Questão
Plug-ins that are included in SAP BusinessObjects Analysis, edition for Microsoft Office for both Excel and Powerpoint
Responda
  • Live Office
  • Analysis
  • EPM
  • Data Manager

Questão 109

Questão
BOAO is for multidimensional analysis of OLAP sources
Responda
  • True
  • False

Questão 110

Questão
The edition of SAP BusinessObjects Analysis for OLAP is accessed in [blank_start]BI Launch pad[blank_end]
Responda
  • BI Launch pad
  • Central Management Console
  • Central Configuration Manager

Questão 111

Questão
In what cases do we use Analysis, edition for MS Office?
Responda
  • Building MS Office Content in Excel & Ppt
  • Ad hoc Data Analysis in Excel
  • Consuming pre-defined BI Content in Excel and Ppt
  • Sophisticated workbook design that uses VBA APIs and so on
  • None of the Above
  • Exploring and Visualizing pre-defined BI Content

Questão 112

Questão
Three user profiles in SAP BOAO
Responda
  • Workbook Creator
  • Data Analyst
  • Administrator
  • Data Modeling Analyst
  • Architecture
  • SAP BW Consultant

Questão 113

Questão
What do you call on a new inserted sheet in Analysis?
Responda
  • Neutral
  • Analysis Sheet
  • Workbook sheet
  • Sheet

Questão 114

Questão
For Microsoft Powerpoint, you can add data sources with Analysis plug-in only
Responda
  • True
  • False

Questão 115

Questão
Info fields are available in BOAO both excel and ppt
Responda
  • True
  • False

Questão 116

Questão
We can access Analysis in MS Excel through
Responda
  • MS 2007, analysis options are available via File → Analysis
  • MS 2007, analysis options are available via MS Office button
  • MS 2010, Analysis options are available in the ribbon tab under File → Analysis

Questão 117

Questão
Which panel in BOAO is used to create views of your data, to find information on the used data sources and the components on your workbook?
Responda
  • Analysis Design Panel/Design Panel
  • Information Panel
  • Analysis Panel
  • Components Panel

Questão 118

Questão
What happens when working with the Design panel?
Responda
  • The crosstab is updated after each navigation step
  • The crosstab is updated before and after each navigation step
  • The crosstab cross checks the data on BEx query
  • The crosstab creates, updates, and deletes data after each navigation step

Questão 119

Questão
This is where we view the available fields for a single data source and the fields currently used in a crosstab
Responda
  • Analysis tab
  • Components tab
  • Analysis Design tab
  • Information tab

Questão 120

Questão
This is where we find the information about a data source or the entire workbook and used filters and variables.
Responda
  • Information tab
  • Analysis Design tab
  • Analysis tab
  • Info Fields

Questão 121

Questão
We cannot display information of a data source and entire workbook through drag and drop of information fields in the information tab
Responda
  • True
  • False

Questão 122

Questão
When using components tab for setting preferences, which is the highest node for the available components?
Responda
  • Workbook Settings
  • Data Source Settings
  • Crosstab Settings
  • Default Settings

Questão 123

Questão
Which of the following are the three tabs in the design panel?
Responda
  • Analysis
  • Components
  • Information
  • Worksheet

Questão 124

Questão
If HANA is implemented, what are the two additional data sources for Analysis?
Responda
  • local providers
  • composite providers
  • Remote Providers
  • Virtual Providers

Questão 125

Questão
If Analysis tab does not appear, the Analysis Add-in can be manually enabled.
Responda
  • True
  • False

Questão 126

Questão
Which of the following is true about break hierarchies?
Responda
  • Members are sorted independently of the hierarchy
  • The data is converted to a flat list
  • Result sets are reduced with focus on the most important data
  • Result set are color coded

Questão 127

Questão
If you open the Filter by Measure dialog box from a measure cell, the options such as definition is applied to a selected dimension, to all dimensions or to the most detailed dimension in your analysis are available
Responda
  • True
  • False

Questão 128

Questão
Dimensional Hierarchies that are created or imported in SAP BW are called Characteristic Hierarchies
Responda
  • True
  • False

Questão 129

Questão
Display hierarchies and dimensional hierarchies cannot be used in parallel
Responda
  • True
  • False

Questão 130

Questão
When using multiple queries in a workbook, you can open the prompt dialog by Data Source or by Query
Responda
  • True
  • False

Questão 131

Questão
Which of the following are performed for general settings in the Conditional Formatting dialog?
Responda
  • Choose the format option
  • Assign a name to the specific conditional formatting
  • Choose the measure for the conditional formatting
  • Format the filter components

Questão 132

Questão
It is not possible to restrict conditional formatting to specific area or member selection
Responda
  • True
  • False

Questão 133

Questão
You can delete all user-defined style sets and all that are installed with the Add-in.
Responda
  • True
  • False

Questão 134

Questão
Since styles are workbook-specific, you cannot import or export them
Responda
  • True
  • False

Questão 135

Questão
Which of the following can be used to supplement a crosstab?
Responda
  • Info Fields
  • Dynamic Charts
  • Filter Components
  • Dimensional Hierarchies

Questão 136

Questão
A waterfall chart can be used to show how an initial value is affected by a series of intermediate positive or negative values
Responda
  • True
  • False

Questão 137

Questão
Filter Functions can be used for which of the following?
Responda
  • Display Dynamic Filters
  • Display Static Filters
  • Display Effective Filters
  • Display User Filters

Questão 138

Questão
You can access User, Advanced, Platform, and Support settings via File → Analysis → Settings
Responda
  • True
  • False

Questão 139

Questão
The Design Studio enables application designers to create analysis applications and dashboards for browser and mobile devices on top of BW and SAP HANA data sources
Responda
  • True
  • False

Questão 140

Questão
You cannot use VBA to read values from cells in worksheets
Responda
  • True
  • False

Questão 141

Questão
When you have a data source with numerous rows you can use Fit Table feature to break the result into multiple slides
Responda
  • True
  • False

Questão 142

Questão
If a table is split across multiple slides and one or more of the details is manually deleted, the lost slides cannot be recovered
Responda
  • True
  • False

Questão 143

Questão
Columns and Rows in BOAO contain either measures or dimensions
Responda
  • True
  • False

Questão 144

Questão
BOAO must be installed on local machine. What are the available platforms and data sources?
Responda
  • SAP BW system
  • SAP BusinessObjects Business Intelligence Platform
  • SAP HANA
  • SYBASE

Questão 145

Questão
For the installation of Analysis, what components should be installed first?
Responda
  • MS Office (Excel and Powerpoint)
  • JDBC
  • MS .NET Framework 4.5 Redistributable Package for BIBO 4.1 Platform
  • MS .NET Framework 4.5 Redistributable Package for BIBO 4.3 Platform

Questão 146

Questão
Which applications can be used for accessing Analysis views?
Responda
  • Crystal Reports for Enterprise
  • WEBi
  • BOAO
  • BOAO for OLAP
  • Design Studio
  • Crystal Reports 2016

Questão 147

Questão
How can you access the Analysis client for Excel?
Responda
  • Start → All Programs → SAP Business Intelligence → SAP BusinessObjects Analysis → Analysis for MS Excel
  • Start → All Programs → SAP Business Warehouse → SAP BusinessObjects Analysis → Analysis for MS Excel
  • RDMX
  • RRMX
  • Excel icon → Analysis Ribbon in Excel

Questão 148

Questão
How do you manually enable and disable Analysis Client?
Responda
  • File → Options → Add-ins → Next to Manage, Select Com Add-ins → Choose Go → Select Analysis → OK
  • File → Settings → Add-ins → Next to Manage, Select Com Add-ins → Choose Go → Select Analysis → OK
  • Cannot be done
  • File → Options → Analysis Add-ins → Next to Manager, Select Com Add-ins → Choose Go → Select Analysis → OK

Questão 149

Questão
What are the main data sources for Analysis?
Responda
  • BW Queries
  • InfoProviders
  • HANA views
  • Query views
  • Universe
  • Relational connection

Questão 150

Questão
These are pre-analyzed data that implement business logic
Responda
  • HANA views
  • Query views
  • Analysis views

Questão 151

Questão
An area in which new models can be created based on a central data provider (e.g. Multiprovider) from BW and local data
Responda
  • BW Workplace
  • BW Workspace
  • BW Modeler
  • BW Workbench

Questão 152

Questão
These are tables in HANA that can be created from a flat file which can be added to a workbook as a data source
Responda
  • Local Provider
  • Composite Provider
  • Virtual Provider
  • Hybrid Provider

Questão 153

Questão
Combination of all the data that you want to view in your query
Responda
  • Local Providers
  • Local Composite Provider
  • Virtual Provider
  • Hybrid Provider

Questão 154

Questão
This can be used to view data in Analytic and other views for complex scenarios
Responda
  • A calculation view
  • A formula view
  • A conditional view

Questão 155

Questão
a data tables made up of row and column axis (report axis)
Responda
  • Analysis crosstab
  • Table
  • Data Table
  • Query Table

Questão 156

Questão
In Default view in Crosstab, the Default view of all BW sources should be
Responda
  • as in BEx
  • as defined by Query View
  • measures in the columns, aggregated over all dimensions
  • BEx Query Designer

Questão 157

Questão
Refreshing the data source will update your analysis with the changes
Responda
  • True
  • False

Questão 158

Questão
You can build an entire report by using Analysis tab
Responda
  • True
  • False

Questão 159

Questão
Areas in Analysis Tab
Responda
  • Explorer area
  • Field Explorer area
  • Rows/Columns area
  • Background filter
  • Filter member area

Questão 160

Questão
Configure Display for Members in BOAO
Responda
  • Select a dimension header → choose Members display menu → select the desired option (text, key, text and key, key and text)
  • Select a dimension header → choose Measures display menu → select the desired option
  • Select a column header → choose Measures display menu → select the desired option (Number format, Show SF, Currency Translation, General Format)

Questão 161

Questão
Comments in BOAO will be deleted when we changed the view on your data
Responda
  • True
  • False

Questão 162

Questão
In jumping to all targets using RRI, what would you use?
Responda
  • Goto
  • GotoAll
  • Gotoin

Questão 163

Questão
With sorting in BOAO, if you sort values of one measure, the other cells in your crosstab are also affected
Responda
  • True
  • False

Questão 164

Questão
Filtering members is a dynamic action because the members you have removed from your analysis remain excluded unless change the filter criteria and include them again
Responda
  • True
  • False

Questão 165

Questão
Ways on how to Filter by Member
Responda
  • Sort icon
  • Filter icon
  • Via context menu
  • Dragging elements to background filter

Questão 166

Questão
What are the filter options in the Filter icon?
Responda
  • Filter by Members
  • Filter by Measure
  • Select All Members
  • Supress Zeros on Rows and on Columns
  • Filter other members

Questão 167

Questão
Filter by Member is the only method in Analysis for Powerpoint
Responda
  • True
  • False

Questão 168

Questão
You can filter on hierarchy nodes. In filtering hierarchy nodes, You cannot display leaves only but you can display the entire Hierarchy
Responda
  • True
  • False

Questão 169

Questão
Which of the following are the Access Mode in Filter by member?
Responda
  • Read mode
  • Posted Values in the InfoProvider
  • Posted data in the current navigational state
  • Filter on Values in Master Data
  • Update mode
  • Write mode

Questão 170

Questão
Types of selection in filtering
Responda
  • Measure
  • Member
  • Individual
  • Range

Questão 171

Questão
With filtering by measures, you can define one or multiple rules (parameters) to filter the data of your analysis and not affecting the total or subtotals in your analysis
Responda
  • True
  • False

Questão 172

Questão
With filter by Measure, we can restrict all dimensions to top N independently
Responda
  • True
  • False

Questão 173

Questão
How would you exclude members that are not displayed in your analysis in totaling?
Responda
  • Totals → Calculate Total As → Only displayed values
  • Totals → Only displayed values
  • Totals → Calculate Total As → Sum
  • Totals → Calculate Total As → Sum of Displayed values

Questão 174

Questão
Which of the following are true about working with BEx conditions in Analysis?
Responda
  • BEx conditions correspond to a filter by measure
  • BEx conditions can be defined for a query created in BEx Query Designer
  • BEx conditions can be defined for a query view created in BEx tools such as BEx Web Analyzer
  • BEx conditions can be defined for a workbook created in BEx Analyzer
  • Inserting a query view with conditions in Analysis recognize activated and deactivated conditions as BEx conditions and displayed as filter by measure
  • BEx conditions from a workbook created in BEx Analyzer can be activated and deactivated before workbook conversion

Questão 175

Questão
How would you activate and deactivate conditions as BEx Conditions in Analysis?
Responda
  • Filter icon → BEx Conditions
  • Filter icon → Filter by measure
  • Filter icon → Filter by member

Questão 176

Questão
Your customer wants to create new measures in your analysis without changing the query definition
Responda
  • Create new measure based on Simple Calculation
  • Create new measure based on Math Calculation
  • Create new measure based on Dynamic Calculation
  • Create new measure based on Free-Form Calculation
  • Create Restricted Measure for HANA Data sources

Questão 177

Questão
With Dynamic Calculation, we use two or more available measures
Responda
  • True
  • False

Questão 178

Questão
Where can you specify whether all time-dependent hierarchies for a dimension should be available or only the hierarchy for a selected date?
Responda
  • In settings, select Advanced Settings
  • In Analysis ribbon, select Hierarchy
  • In Design panel, select Hierarchy

Questão 179

Questão
How to expand node to Level
Responda
  • Select a member cell of the dimension → Via context menu → expand node to level
  • Select a member cell of the dimension → Hierarchy drop down option in the menu → expand node to level
  • Select a member cell of the dimension → choose Hierarchy Show level → select the level → OK
  • Select a member cell of the dimension → Hierarchy menu → Show levels

Questão 180

Questão
Hierarchy totals can be displayed at the top or the bottom of the crosstab. When you choose Expand Upwards (Rows), the totals will be displayed at the bottom
Responda
  • True
  • False

Questão 181

Questão
In sorting with hierarchy, the members of the hierarchy are sorted within their groups by default unless you use Break Hierarchies
Responda
  • True
  • False

Questão 182

Questão
What do you call this option in which you can display multiple dimensions hierarchically without using dimensional hierarchy?
Responda
  • Filter
  • Sorting
  • Compact display in rows or columns
  • Runtime/Display Hierarchy

Questão 183

Questão
What should be set in order for a variable to be editable in the prompting dialog?
Responda
  • It must be input-ready
  • set to Manual Input in the Query Designer
  • it must not be input-ready
  • set to automatic Input in the Query Designer

Questão 184

Questão
Saved variable values in a workbook
Responda
  • Variant
  • Parameter
  • Variable values
  • Prompt values

Questão 185

Questão
The use of the operators in prompts, such as =, >=, [], *, ![], must be enabled in the registry by your IT administrator
Responda
  • True
  • False

Questão 186

Questão
When you have multiple queries in a workbook, what options are available to open the prompt dialog?
Responda
  • Open prompt dialog by workbook to see all variables
  • Open prompt dialog by data source to see variables for a specific query
  • Open prompt dialog by all query to see all variables
  • Open prompt dialog by sheet to see variables for a specific query

Questão 187

Questão
We can define variant for a query or for a document (workbook or presentation) and for a user-specific or global variant.
Responda
  • True
  • False

Questão 188

Questão
We can create multiple variants and multiple active variants.
Responda
  • True
  • False

Questão 189

Questão
Working with document variant is document mode. What is working with query variant?
Responda
  • data source mode
  • query mode
  • query source mode
  • query view

Questão 190

Questão
On what tab in Design panel would you see the Merge Variables?
Responda
  • Design tab
  • Analysis tab
  • Information tab
  • Components tab

Questão 191

Questão
What authorization object must be maintained in the Netweaver server so that the user can create variant?
Responda
  • S_RS_PARAM
  • R_SR_PARAM
  • S_SR_PARAM
  • S_RS_COMP

Questão 192

Questão
In data source mode, the context menu for prompts is only available if workbook property Merge Variables is selected unlike in document mode
Responda
  • True
  • False

Questão 193

Questão
In data source mode, Workbook property Merge Variables is selected when a new query is inserted so you don't have to select Merge Variables again
Responda
  • True
  • False

Questão 194

Questão
You can select various workbook properties on the Components tab in the Design panel that does not affect the behavior of the prompting dialog and existing prompt values.
Responda
  • True
  • False

Questão 195

Questão
To configure workbook properties, be sure to select the crosstab or the name of the data source on the Components tab
Responda
  • True
  • False

Questão 196

Questão
Which of the following options can be selected for workbook properties on the Components tab?
Responda
  • Remove Data before Saving
  • Force Prompt for Initial Refresh
  • Refresh workbook on Opening
  • Store prompts with Workbook
  • Merge variables
  • Update Data on Opening
  • Remove Data Cells before Saving

Questão 197

Questão
You can use the logic AND and OR in conditional formatting
Responda
  • True
  • False

Questão 198

Questão
In Conditional Formatting, how can you shift the visualization to a different measure than the one the rules have been defined on?
Responda
  • In New Conditional Formatting screen, choose display → check Applied to under Apply Visualization to Another measure → then choose a member
  • In New Conditional Formatting screen, choose selection → check Applied to under Apply Visualization to Another measure → then choose a member
  • In New Conditional Formatting screen, choose definition → check Applied to under Apply Visualization to Another measure → then choose a member

Questão 199

Questão
How do you apply conditional Formatting?
Responda
  • Conditional Formatting → New → Enter name → select measure → select style → define one or more rules on the definition tab by selecting a priority, operator, and threshold value → add
  • Conditional Formatting → New → Enter name → select member → select style → define one or more rules on the definition tab by selecting a priority, operator, and threshold value → add
  • Conditional Formatting → New → Enter name → select measure → select style → define one or more rules on the selection tab by defining for each dimension if the conditional formatting should be applied to All Members and Totals or only to Members or Totals → add
  • Conditional Formatting → New → Enter name → select measure → select style → define one or more rules on the display tab by defining which parts of the crosstab are affected by conditional formatting: Data cells, Row headers, Column headers and apply visualization for another measure → add

Questão 200

Questão
New rows/columns cannot be inserted next to a data cell
Responda
  • True
  • False

Semelhante

Paulo Freire Pedagogia da Autonomia
lb.roberto
Como Transformar Mapas Mentais em Suporte
Alessandra S.
Direito Internacional Público
victorbrando
Estrutura e Formação das Palavras
Alessandra S.
Guia de Redação do Vestibular
Alessandra S.
Combate a incêndio - Capítulo dois
willian reis
Calendário de Estudos ENEM 2014
Alessandra S.
Phrasal Verbs
GoConqr suporte .
Bioquímica
Luíza Cristina
SIMULADO 1 - CTFL - AT
Jorge Ricardo
Desafio dos sinais: do sinal ao significado - Aula 02
Emannuelle Araújo