EMT Practice Test

1. Question Content...

---

Question1: Click the Exhibit button.

In the cube shown in the exhibit, you need to show only the five most expensive products. The list should change dynamically with the selection of the budget version. How would you achieve this?

Question2: A Private TM1 Cube View can be shared with which group?

Question3: A user wants to interactively stack and unstack dimensions to view. What are two ways to accomplish this? (Choose two.)

Question4: A user wants to update TM1 data within a Microsoft Excel worksheet. What are the three ways to do this?
(Choose three.)

Question5: A user wants to update a TM1 cube with string data from an Excel spreadsheet Which TM1 Excel function will allow you to do this?

Question6: An international company has an existing TM1 server application they use for planning, forecasting, and reporting. The corporate strategy department wants to share parts of this application with external consultants and partners. They decide to create Cognos Insight workspaces which includes data from this server application combined with additional analysis and content. They intend to distribute a single workspace ".cdd" file to the recipients. How should they integrate the TM1 server data with additional content resulting in distributable Cognos Insight workspace files?

Question7: Which two options allow the end user to expand and collapse dimensional elements listed on the row dimension of a given data view in TM1 Web "on-the-fly"? (Choose two)

Question8: What data spreading options are available to users in the Perspectives or Architect Cube Viewer? (Choose two.)

Question9: What is the difference between a TM1 Sandbox and a Personal Workspace?

Question10: Which three statements are correct about aliases? (Choose three.)

Question11: When exporting a cube view from TM1 Web, which prerequisite is required to ensure charts are included?

Question12: Using TM1 Application Web, which application is required to create a bottom-up, submission-based workflow with the ability to lock data after submission?

Question13: A customer wants to be able to select elements from a subset for a fixed number of columns. Which statement is correct?

Question14: When using the suppress zero option in a cube view, data that is in an aggregated or calculated value but still zero will display as what?

Question15: A user wants to create a TM1 Excel report using the DBRW function. What are two ways to reference the elements in the dimensions? (Choose two.)

Question16: When should you use the DBR formula over the DBRW formula?

Question17: How do you configure aTM1 Administration Server to run as a Windows service?

Question18: Which three statements are true in regards to the applications folder? (Choose three.)

Question19: The human resources department requires a TM1 Web Labor Detail report which shows Total Salary, Benefits, and Taxes for each employee within a selected department. The user should be able to select a department and have the rows of the report display just the employees in that department with the costs across the columns. Employees should be sorted in descending order based on Total Salary.
Unfortunately Salary, Benefits, and Taxes are all stored in different cubes and the cubes only share the Employee and Department dimensions. How should you build the Labor Detail report?

Question20: Which three statements are true regarding TM1 Excel functions? (Choose three.)

Question21: What are three reasons why you would choose an Active Form over other report styles? (Choose three.)

Question22: In TM1 Cube Viewer, you are viewing an Income Statement cube containing dimensions for Department, Months, Budget Version, and Account. Currently, the Account dimension is listed in the rows and the Months dimension is listed in the columns. You want to see a comparison of each element in the Budget Version dimension next to each account. Which feature in TM1 Cube Viewer will accommodate this requirement?

Question23: An end user wants to interactively create a temporary consolidation that does not exist within the dimension using the TM1 Cube Viewer. Which action will accomplish this?

Question24: A user wants to create a view looking at a particular product called "101 - Chips". They use the "Filter by Wild Card' function to locate the product, but no elements are returned. Which statement describes what is happening?

Question25: The manufacturing department interacts with IBM CognosTM1 data using TM1 Perspectives. They want to view data by product and location. Products are on the rows of the analysis and plants are on the columns.
Products are consolidated into categories and locations are consolidated into regions. Which two interfaces allow them to expand and collapse on both the rows and columns of the analysis? (Choose two.)

Question26: In which tier of the IBM Cognos TM1 client-server architecture does the TM1 Administration Server reside?

Question27: You need to calculate the possible outcome if prices are raised. However, the data in the IBM TM1 server should not be overwritten. The IBM TM1 model contains many business rules and calculations but no scenario dimension, which is what you want. How do you proceed?

Question28: Which two functions have been optimized for the wide area network (WAN)? (Choose two.)

Question29: A financial controller wants to create a financial statement report however, the chart of accounts dimension has more aggregations than is required for the report. The controller wants to create a subset that has only the sub account and account elements. How should this be accomplished?

Question30: Which three selections are available when filtering a TM1 cube view? (Choose three.)

Question31: A user has created a Sandbox based on a cube view. The user wants to have the Sandbox data saved as the base information. What should the user do?

Question32: Which three selections would you find in the Properties window of the subset editor? (Choose three.)