EMT Practice Test

1. Question Content...

---

Question1: Where is a variable saved?

Question2: What is required to use the Comments feature? Note: There are 2 correct Answers to this question.

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

Question4: Which report elements can you drill on? Note: There are 3 correct Answers to this question.

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

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

Question7: How do you change the dimension on which a section is based?

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

Question9: Which of the following filter components are used to restrict data? Note: There are 3 correct Answers to this question.

Question10: How do you remove a custom sort that has been applied to an object?

Question11: How do you make changes to a document that has been published in the BI launch pad? Note: There are
2 correct Answers to this question.

Question12: What does the RefValue() function return if there is no reference data?

Question13: What do you use to conditionally hide a report element?

Question14: You add a new object to a query and run the query. How do you display the new object in the document?

Question15: Which analysis function adds a column to a vertical table?

Question16: How does the ForEach operator affect the default calculation context?

Question17: In which of the following can you use the If( ) function in Web Intelligence?

Question18: What does the Change Source Wizard use to remap existing objects to a new data source? Note: There are 2 correct Answers to this question.

Question19: What is the input context of a calculation?

Question20: What actions can you perform in the Web Intelligence query panel? Note: There are 3 correct Answers to this question.

Question21: What data sources can you select when creating a document using the Web Intelligence Rich Client?
Note: There are 2 correct Answers to this question.

Question22: Which of the following make up a semantic layer for a relational data source? Note: There are 3 correct Answers to this question.

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

Question24: What happens when you create a section in a report? Note: There are 2 correct Answers to this question.

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

Question26: What do you use to search for content in multiple documents?

Question27: How do you duplicate an existing query? Note: There are 2 correct Answers to this question.