EMT Practice Test

1. Question Content...

---

Question1: Which method can you use to change the object qualification of an object within Web Intelligence Rich Client? Please choose the correct answer.
Response:

Question2: How can you see general report information such as the document author and the document creation date? Please choose the correct answer.
Response:

Question3: You have a measure with different names coming from two queries. How you determine which query each measure comes from?

Question4: What chart elements can use a formula? (2 answers)

Question5: Where are contexts created?
Please choose the correct answer.
Response:

Question6: You are creating a "Target Revenue Based on Required % Growth" variable that is represented by 5% revenue growth for California and 18% for Massachusetts. Which If() function statement is valid? Please choose the correct answer.
Response:

Question7: Identify from the given options the correct sequence of 'Web Intelligence Core Functions'? Please choose the correct answer.
Response:

Question8: 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)

Question9: Which three rules apply when you manually synchronize queries?
There are 3 correct answers to this question.
Response:

Question10: Select the correct sequence To Format a Bar Chart?
Please choose the correct answer.
Response:

Question11: What is the procedure to Display the data in the table as an image that maintains the original formatting? Please choose the correct answer.
Response:

Question12: What are the two relational operators that can be used with wildcard Characters, in a query filter? There are 2 correct answers to this question Response:

Question13: 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?

Question14: How do you share a Web Intelligence document with another user in the BI launch pad? (2 answers)

Question15: Which table type looks most similar to a Microsoft Excel pivot table?

Question16: Mention the five types of column charts for presenting DATA?
There are 3 correct answers to this question
Response:

Question17: Name the types of query filters that you can use in Web Intelligence?
There are 3 correct answers to this question
Response:

Question18: Which two statements are true about using the Where operator with an output context? There are 2 correct answers to this question.
Response:

Question19: Design mode provides access to the following toolboxes and their associated functions.
What are they?
There are 3 correct answers to this question
Response:

Question20: Where is a variable saved?

Question21: Which method can you use to hide data using an alerter?
Please choose the correct answer.
Response:

Question22: What data source can you select when creating a document using the Web Intelligence Rich Client? (2 answers)

Question23: In the Annual Revenue column, what formula calculates the total annual revenue in each row (shown in the attached graphic)?

Question24: What object type is represented by the icon shown below?

Question25: Where in a Web Intelligence report do you view merged objects in BusinessObjects Web Intelligence XI 4.x? Please choose the correct answer.
Response:

Question26: How much impact does data tracking have on the data size of a Web Intelligence document (WID) Compared to the same document without data tracking? Please choose the correct answer.
Response:

Question27: What can you do with a scope of analysis? (2 answers)

Question28: Which two operators can you use with output context in the Web Intelligence Rich Client? There are 2 correct answers to this question.
Response:

Question29: For what purposes can you use the Page Layout of a report?
There are 2 correct answers to this question.
Response:

Question30: Which of the following make up a semantic layer for a rational data source? (3 answers)

Question31: What does the ranking calculation mode Cumulative Percentage keep in the block?

Question32: Which three options appear in the Scope of Analysis pane in the Query panel? There are 3 correct answers to this question.
Response:

Question33: How will you define and make the required changes with the appropriate tab for the format options? There are 3 correct answers to this question Response:

Question34: What happens when you create a section in a report? (2 answers)

Question35: Which two are benefits of using breaks?
There are 2 correct answers to this question.
Response:

Question36: Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel? Please choose the correct answer.
Response:

Question37: To where can you copy a formula used in a document?
Please choose the correct answer.
Response:

Question38: How do you determine if a formula or a variable is used in a block? (2 answers)

Question39: Which three options are default page number cells?
There are 3 correct answers to this question.
Response:

Question40: Which three are prerequisites for combining data from multiple data providers? There are 3 correct answers to this question.
Response:

Question41: Which operators can be used in an Input calculation context?
There are 2 correct answers to this question.
Response:

Question42: Which statement is true of the Where operator when used within a variable? Please choose the correct answer.
Response:

Question43: What is the default behavior when creating a report from two queries from the same universe? Please choose the correct answer.
Response:

Question44: Discuss the components of a Web Intelligence Document?
There are 3 correct answers to this question
Response:

Question45: Which four Report Elements can you select from the Templates tab of Web Intelligence? There are 4 correct answers to this question.
Response:

Question46: Which three methods can you use to combine queries using the Web Intelligence Rich Client? There are 3 correct answers to this question.
Response:

Question47: Discuss all the advantages link to organizing a report in the section
There are 2 correct answers to this question
Response:

Question48: To what can you apply conditional formatting rules (2 answers)

Question49: Which two statements are true of the Web Intelligence default behavior when performing a UNION combined query method? There are 2 correct answers to this question.
Response:

Question50: Which two statements about the If() function are correct?
There are 2 correct answers to this question.
Response:

Question51: The universe is made up of classes and objects; there are three different types of objects.
What are they?
There are 3 correct answers to this question
Response:

Question52: What can you use to create hyperlinks between Web Intelligence documents?

Question53: 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?

Question54: Where is a Web Intelligence variable stored?
Please choose the correct answer.
Response:

Question55: Which two personal folders are available by default to Web Intelligence users? There are 2 correct answers to this question.
Response:

Question56: How does WHERE operator affect a formula?

Question57: Which of the following options involved to Create Variable from the Formula? There are 2 correct answers to this question Response:

Question58: Which three statements about the If() function are correct?
There are 3 correct answers to this question.
Response:

Question59: What actions can you perform in the Web Intelligence query panel? (3 answers)

Question60: Which of the following can you use to filter results dynamically? (2 answers)

Question61: What does the Change Source Wizard use to remap existing objects to a new data source? (2 answers)

Question62: Which Web Intelligence component should you use to list the existing variables in a report? Please choose the correct answer.
Response:

Question63: In the Query Panel, you can view and modify the default query properties. The query properties allow you to perform following actions, identify the correct answers from the following options? There are 2 correct answers to this question Response:

Question64: Which three objects represent qualifications from a local data provider? There are 3 correct answers to this question.
Response:

Question65: Which two statements describe reasons for using the FormatDate() function? There are 2 correct answers to this question.
Response:

Question66: What is the correct formula for the RunningSum column (shown in the attached graphic)?

Question67: Which tasks can you accomplish using breaks?
There are 2 correct answers to this question.
Response:

Question68: Where can you use a free-standing cell?

Question69: You insert the function CurrentDate() into a cell. To clarify the date you add a string so that the formula is now:
= "Sales Report from "+CurrentDate()
Which formatting capability is disabled for the cell?
Please choose the correct answer.
Response:

Question70: Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"? Please choose the correct answer.
Response:

Question71: Which sort option should you use to add Temporary Values?
Please choose the correct answer.
Response:

Question72: How does SAP recommend you print a Web Intelligence document to ensure the document layout is preserved?

Question73: Which three output context expressions are valid extended syntax expressions? There are 3 correct answers to this question.
Response:

Question74: You have two columns: order date and ship date. How do you calculate the processing time from the order date to the ship date?

Question75: How do you duplicate a query?
Please choose the correct answer.
Response:

Question76: Which statement is a benefit of using a Web Intelligence formula?
Please choose the correct answer.
Response:

Question77: Which operator allows you to select exactly one value as the operand for a query filter?

Question78: What can you use breaks for?
Please choose the correct answer.
Response: