Download IBM Cognos TM1 10.1 Analyst.C2020-701.Pass4Sure.2015-04-05.60q.vcex

Vendor: IBM
Exam Code: C2020-701
Exam Name: IBM Cognos TM1 10.1 Analyst
Date: Apr 05, 2015
File Size: 854 KB

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Demo Questions

Question 1
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?
  1. Highlighted in blue
  2. Zeros
  3. Hidden
  4. Bold text
Correct answer: C
Explanation:
answer is verified.
answer is verified.
Question 2
Which three statements are true regarding TM1 Excel functions? (Choose three.)
  1. The VIEW function creates an optimized view of the cube specified by the cube argument.
  2. The DBR function stands for Database Read.
  3. The value returned by the DBRA function cannot be edited.
  4. ELCOMP returns the name of a child of a consolidated element in a specified dimension
  5. SUBNM returns the element of a dimension subset and allows a double-click to bring up the subset editor.
Correct answer: ADE
Question 3
What are three reasons why you would choose an Active Form over other report styles? (Choose three.)
  1. When the user needs to drill down and drill up on rows
  2. When the user needs to drill down and drill up on columns
  3. When the user needs to suppress zeros
  4. When there is a need to dynamically format cells
  5. When the user needs to move dimensions around the report
Correct answer: ACD
Question 4
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?
  1. Use the Filter by Attribute function.
  2. Use the Filter by Level function.
  3. Use the Filter by Wildcard function.
  4. Use the Filter by Element function.
Correct answer: B
Question 5
Which three selections are available when filtering a TM1 cube view? (Choose three.)
  1. TopCount
  2. Max
  3. BottomPercent
  4. BottomSum
  5. GreaterThan
Correct answer: ACD
Question 6
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?
  1. The user does not first select the Hierarchy Sort function.
  2. The user does not first select the All function.
  3. The user did not first select the Reload Subset function.
  4. The user should be using Filter by Level function.
Correct answer: B
Question 7
What is the difference between a TM1 Sandbox and a Personal Workspace?
  1. A Personal Workspace allows you to work in a private area where a Sandbox is shared.
  2. A Personal Workspace is a special default unnamed Sandbox where you begin your work.
  3. A Personal Workspace is shared.
  4. A Personal Workspace does not require you to commit your data as a Sandbox does.
Correct answer: B
Question 8
When exporting a cube view from TM1 Web, which prerequisite is required to ensure charts are included?
  1. DoJo 1.6
  2. Java Runtime Engine (JRE)
  3. Microsoft Excel
  4. Adobe Acrobat
Correct answer: C
Explanation:
answer is corrected.
answer is corrected.
Question 9
A user wants to update TM1 data within a Microsoft Excel worksheet. What are the three ways to do this? (Choose three.)
  1. Create an Active Form from within TM1 Cube Viewer.
  2. Create a Snapshot from within TM1 Cube Viewer.
  3. Create a Sandboxfrom within TM1 Cube Viewer.
  4. Select In-Spreadsheet Browser from within TM1 Perspectives.
  5. Create an Excel Slice from within TM1 Cube Viewer.
Correct answer: ADE
Question 10
Which three statements are correct about aliases? (Choose three.)
  1. Aliases must be unique within the dimension.
  2. Subset (user defined consolidation) cannot be the same name as an alias.
  3. Aliases can be used for alternative languages.
  4. There can only be one alias per dimension.
  5. Aliases must only contain non-numeric string characters.
Correct answer: ABC
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!