EMT Practice Test

1. Question Content...

---

Question1: Which two options are valid options when you save a Web Intelligence document (WID) in the Web Intelligence Rich Client?
There are 2 correct answers to this question.
Response:

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

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

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

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

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

Question7: In which two situations should you use sub-queries?
There are 2 correct answers to this question.
Response:

Question8: Which method can you use to build a custom sort?
Please choose the correct answer.
Response:

Question9: You need to create a report that compares data to a reference data set. You create the report and activate the track data option. The report correctly indicates the changes in the data; however when you make another change to the report, the display no longer indicates any data tracking.
What actions could have caused this behavior?
There are 2 correct answers to this question.
Response:

Question10: What is the maximum number of sub-alerts that an alerter can contain?
Please choose the correct answer.
Response:

Question11: Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView?
Please choose the correct answer.
Response:

Question12: How can you make the pie chart (shown in the attached graphic) display correctly?

Question13: Why is the subtotal missing from the bottom of each break in the attached diagram?

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

Question15: You set the drill option "Prompt when drill requires additional data". Now you drill outside the scope of analysis on your report.
How does Web Intelligence respond?
Please choose the correct answer.
Response:

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

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

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

Question19: Which three data sources can you synchronize in a Web Intelligence 4.0 document (WID)?
There are 3 correct answers to this question.
Response:

Question20: Which two properties can you set in the hyperlink dialog box when you create a hyperlink to a document?
There are 2 correct answers to this question.
Response:

Question21: What is the required argument of the UserResponse( ) function?

Question22: You try to select a number of data objects from the Data tab to drag into a report, but some of them are grayed out and in italics. Which statement explains this behavior?
Please choose the correct answer.
Response:

Question23: 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:

Question24: For which tasks do you use an If() function?
There are 2 correct answers to this question.
Response:

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

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

Question27: Which two statements are true about Page Layout of a report?
There are 2 correct answers to this question.
Response:

Question28: Which two options should you take before you finish creating a variable in Web Intelligence?
There are 2 correct answers to this question.
Response:

Question29: How does WHERE operator affect a formula?

Question30: Which BusinessObjects Enterprise tool supports Offline Mode logins?
Please choose the correct answer.
Response:

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

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

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

Question34: You use the Last Refresh Date cell from the Templates in the Report Manager on your report page. You then reformat the cell as Tuesday, January 22, 2014. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?
Please choose the correct answer.
Response:

Question35: What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected?
Please choose the correct answer.
Response:

Question36: How do you access the Format Table option?

Question37: Why should you always log off the BI lunch pad rather than just closing your browser session?

Question38: How can you share Web Intelligence documents in your organization?
There are 2 correct answers to this question
Response:

Question39: Which tool do you use to edit merged objects in BusinessObjects Web Intelligence 4.0?
Please choose the correct answer.
Response:

Question40: Which function would you use to extract the word "pants" from the product name "casual pants" of the Product Name field?
Please choose the correct answer.
Response:

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

Question42: To which destinations can you send a Web Intelligence document (WID) through InfoView of BusinessObjects Web Intelligence XI 4.0?
There are 3 correct answers to this question.
Response:

Question43: Which two are limitations of a detail object?
There are 2 correct answers to this question.
Response:

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

Question45: 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:

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

Question47: How many blocks can you create in a Web Intelligence document (WID)?
Please choose the correct answer.
Response:

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

Question49: 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:

Question50: Which three elements are parts of a query filter?
There are 3 correct answers to this question.
Response:

Question51: In what application mode can you freeze column headers?
Please choose the correct answer.
Response:

Question52: Which two functions can you use to concatenate the strings "England" and "New" to create the string "New England"?
There are 2 correct answers to this question.
Response:

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

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

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

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

Question57: Which three layout options can you use when creating sections in a report?
There are 3 correct answers to this question.
Response:

Question58: Why do you use the "Turn into" functionality?

Question59: What happens if an operational prompt is blank when you execute a query?

Question60: Which of the following are extended syntax keywords? (2 answers)

Question61: Which tab should you use to change the page orientation of a report?
Please choose the correct answer.
Response:

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

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

Question64: Which property do you enable to keep rows in a break together on the same page?
Please choose the correct answer.
Response:

Question65: You are working with a set of store revenues. All stores have positive revenue values. Which formula should you use to display the variance value of the Revenue measure in your document when data tracking is active?
Please choose the correct answer.
Response:

Question66: Which three features can you use in Interactive View mode of BusinessObjects Web Intelligence 4.0?
There are 3 correct answers to this question.
Response:

Question67: Where in Web Intelligence Rich Client interface can you see the data source for a document built on a local data source?
Please choose the correct answer.
Response:

Question68: Which two are benefits of creating queries from existing queries?
There are 2 correct answers to this question.
Response:

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

Question70: Which three are drill options?
There are 3 correct answers to this question.
Response:

Question71: Which two search criteria are valid when using Delegated List of Values?
There are 2 correct answers to this question.
Response:

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

Question73: To produce a report that focuses more precisely on certain data, you may need to apply more than one filter, and these filter must use Logical Operators.
What are these Logical operators?
There are 2 correct answers to this question
Response:

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

Question75: Which two are running aggregate functions in Web Intelligence?
There are 2 correct answers to this question.
Response:

Question76: Which keyword is defined as flexible for input contexts?
Please choose the correct answer.
Response:

Question77: Which three calculations can you use in a measure object in Web Intelligence?
There are 3 correct answers to this question.
Response:

Question78: Which three calculations can you use in a measure object in Web Intelligence?
There are 3 correct answers to this question.
Response:

Question79: Which of the following is not a step of demonstration, to display an aggregate within a sectioned report.
Please choose the correct answer.
Response:

Question80: Which two methods can you use to apply report filters to a BusinessObjects Web Intelligence 4.0 document (WID)?
There are 2 correct answers to this question.
Response:

Question81: Which Report Manager tab should you use to change report formatting?
Please choose the correct answer.
Response: