SAP BO Xcelsius Quiz

Posted on: | By: – Comments Off

SAP BO Xcelsius Quiz

 



SAP BO Xcelsius Quiz contain set of 60 MCQ questions for SAP BO Xcelsius MCQ which will help you to clear beginner level quiz.



 
1) Can we view Crystal Xcelsius Design Files (XLF) in Infoview

  1. No
  2. Yes
  3. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
2) What is the use of AFD? Where it can be stored?

  1. used to create dashboards. It can be stored in repository, corporate or personal.
  2. used to create Reports and It can be stored in repository, corporate or personal.
  3. used to create universe and It can be stored in repository, corporate or personal.
  4. Opt B & C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
3) Why do we need metrics and sets?

  1. Metrics are used for analysis and Sets are used for grouping.
  2. Metrics are used to hold numeric values and Sets used for aggregation
  3. Metrics are used in Aggregate awareness and Sets are used for grouping
  4. Opt A & B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
4) BO Xcelsius is a tool for

  1. Query and Analysis
  2. Data Visualization
  3. Data Mining
  4. A & C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
5) Which one them cannot be scheduled

  1. Crystal Report
  2. Desktop Intelligence Reports
  3. Web Intelligence report
  4. Xcelsius

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
6) XCelsius is a ___________________ tool

  1. BI
  2. Analytical
  3. Visualization
  4. NONE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
7) Which of the following chart types can be used to emphasize a trend line?
1) Area Chart 2) Line Chart 3) Bullet Chart 4) Column Chart
 

  1. Both 1 & 2
  2. Area Chart
  3. Bullet Chart
  4. Line Chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
8) How many axis a Bubble Chart has?

  1. Two
  2. Three
  3. One
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
9) Which chart is best suited if one has to display a range of values and a trend line for these values?

  1. Line Chart
  2. Scatter Plot
  3. Combination Chart
  4. Area Chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
10) Consider the following scenario:
Volume of sales is available across region and historical Profit data is available over a period of 5 years.
Which chart can best display this combination of data together?
 

  1. Area Chart
  2. XY Chart
  3. Line Chart
  4. Combination Chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
11) OHLC is otherwise known as ____________

  1. Bubble Chart
  2. Candlestick Chart
  3. Radar Chart
  4. Sparkline

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
12) Sparkline chart is good at displaying ____________ data

  1. One dimesional
  2. Two dimensional
  3. Multi dimensional
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
13) Which chart is best suited to compare two sets of data along with hierarchical data?

  1. Bubble Chart
  2. Treemap
  3. XY Chart
  4. Waterfall Chart

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
14) If there is a sequential series of positive and negative values and to represent these values affects the intital baseline data. Which chart would you suggest?

  1. Sparkline
  2. Waterfall
  3. XY Chart
  4. Radar

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
15) Is it possible to add backgrounds or borders to a Canvas Container?

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
16) Which of the following is not a Container Component?

  1. Tab Set
  2. Canvas
  3. Image
  4. Canvas

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
17) Which of the following components are Selector Components?

  1. Accordion Menu 2. Toggle Button 3. Fisheye picture menu 4. Ticker

 

  1. 1& 2
  2. 2 & 4
  3. All of the above
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
18) Can Icon be used as a selector or display component?

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
19) Which selector is best suited to animate data for the users?

  1. Play Selector
  2. Fisheye Picture Menu
  3. Sliding Picture Menu
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
20) Which of the following statement is correct regarding Single value components?

  1. A) useful for displaying or inserting data to an individual cell.
  2. B) useful for displaying or inserting an invidual row or column.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
21) Visual alerts can be displayed using:

  1. Fisheye picture Menu
  2. Scorecard
  3. Hierarchical Table
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
22) Which component scrolls the text within the model?

  1. Sliding Picture Menu
  2. Ticker
  3. Fisheye Picture menu
  4. Play Selector

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
23) Minimum and Maximum limit cannot be set for input components.

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
24) Spinner is an _____________ component.

  1. Input
  2. Output
  3. Selector
  4. Canvas

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
25) Which of the following is not a Text Component?

  1. Input Text
  2. Input Text Area
  3. Label
  4. Text Box

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
26) For which component we can’t set up alerts from the following:

  1. Spinner
  2. Dial
  3. Gauge
  4. Value

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
27) How does Trend Analyzer work?

  1. A) inserts data point for the trendline in the spreadsheet which can be then be added to the model.
  2. B) automatically inserts the trend line to the model.
  3. C) creates a trend line and forecast values automatically when applied.
  4. D) None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
28) Image component is an ____________

  1. Input Component
  2. OutputComponent
  3. Art & Background Component
  4. CanvasComponent

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
29) Alert Thresholds can be set for

  1. Specify Value
  2. Listof Values
  3. Range of Values
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
30) Performance of the model is affected in case of

  1. Embedded Files
  2. Reference Files

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
31) In case of embedded files, the external file is loaded even if it is hidden through dynamic visibility.

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
32) When image is imported in to the normal Image components: Which of the below statement is valid?

  1. A) Xcelsius stores its own local copy of the image file internally
  2. B) Xcelsius references the actual image file whenever needed.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
33) If a model is connected with external sources then which of these option should be enabled or done inorder to run the model in a web server?

  1. Host application file must be made trusted
  2. Cross-domain policy file must be set up.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
34) Which statement is correct regarding deleting a componentfrom a group?

  1. A) To delete a component from a group, the components should be ungrouped first.
  2. B) Ungrouping is not necessary to delete a component

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
35) Alerts are not available for ___________

  1. Bubble Chart
  2. Area Chart
  3. Bar Chart
  4. Maps

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
36) Alert Thresholds can be set for

  1. Specific Value
  2. Listof Values
  3. Range of Values
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
37) The basic process of creating a model :

  1. Import data or Create query from external datasource.
  2. Add components and link them to spreadsheet.
  3. Modify the appearance, style and layout of components.
  4. Preview and publish the model.

 

  1. 1,2,&4
  2. 1,3&4
  3. All of the above
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
38) Color schemes are not transferred with XLF files.

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
39) Consider the scenario:
A custom color scheme is applied in the model and the model is opened in design mode on another computer. Which statements are correct?

  1. Custom color schemes continues to be used by existing components
  2. New components can’t mak
  3. 1&2
  4. 3
  5. 4
  6. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
40) Embedded spreadsheet can support macros & conditional formatting.

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
41) Inserting data in the embedded spreadsheet can be done by:

  1. Importing data from Excel.
  2. Copy & paste date from another spreadsheet.
  3. Manually enter data.
  4. Link a query’s result objects to cells.
  5. 1,2&3
  6. 3&4
  7. All of the above
  8. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
42) SUMIF, VLOOKUP & HLOOKUP affects the dashboard models performance.

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
43) How many number of rows are supported in a range selection in the embedded spreadsheet?

  1. 512
  2. 256
  3. Unlimited
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
44) Web Service connection allows to connect to external data sources using ________ protocol.

  1. UDDI
  2. HTTP
  3. WSDL
  4. SOAP

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
45) An XML data connection allows to connect to external data sources using __________ protocol.

  1. XML-RPC
  2. UDDI
  3. HTTP
  4. WSDL

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
46) Flash variable connections can be used to pass

  1. session tokens
  2. User IDs
  3. Web Service URLS
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
47) LCDS stands for

  1. Liveoffice Connetions Data Service
  2. LiveCycle Data Services
  3. Life Cycle Data Services
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
48) Dashboards is a ___________________ tool

  1. BI
  2. Analytical
  3. Visualization
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
49) RunQueryAsASServiceEX is set in the Query As a Web Service connection for?

  1. Index unaware prompts
  2. Date Prompts
  3. Index aware prompts
  4. Optional Prompts

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
50) ___________ is considered as a SAP datasource.

  1. Portal Data
  2. Flash Variables
  3. Live Office Connection
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
51) Logon credentials are not passed from parent Xcelsius model file when calling a secondary SWF file.

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
52) Xcelsius is a ___________________ tool

  1. BI
  2. Analytical
  3. Visualization
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
53) Which type of connection can’t be added again to a model after it’s added once?

  1. QAAWS
  2. XML Data
  3. Portal Data
  4. LCDS

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
54) Optimize Spreadsheet option when enabled:

  1. Xcelsius calculates the formulas in the model while exporting to SWF.
  2. Xcelsius calculates the formulas in the model at runtime of the model.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
55) Grid Component allows
1) Static data 2) Edit data 3) Drag the values

  1. 1&3
  2. 2 only
  3. 2&3
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
 
 


Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz