[Free] 2018(Jan) EnsurePass Testking IBM C2020-701 Dumps with VCE and PDF Download 11-20

Ensurepass.com : Ensure you pass the IT Exams 2018 Jan IBM Official New Released C2020-701
100% Free Download! 100% Pass Guaranteed!

IBM Cognos TM1 10.1 Analyst

Question No: 11

Which three statements are true regardingTM1 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.

Answer: A,D,E

Question No: 12

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

  1. Public

  2. Only to the creator

  3. Administrators

  4. Only to directory managers

Answer: B

Question No: 13

A userentering numerical data into TM1 Application Web places a hold consolidate on North America with three children: Canada, USA, and Mexico. At the time the hold is placed, the value of North America is $30.00, with each child value set at $10.00. A user subsequently adds $10.00 to the value of Canada.

Which statement is correct?

  1. quot;North Americaquot; increases $10.00, quot;USAquot; and quot;Mexicoquot; remain unchanged.

  2. quot;North Americaquot; remains unchanged. quot;USAquot; and quot;Mexicoquot; are reduced by $5.00 each.

  3. quot;North Americaquot; remains unchanged, quot;USAquot; is reduced by $10.00, quot;Mexicoquot; remains unchanged.

  4. All values are on hold, so the add function is ignored.

Answer: B

Question No: 14

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

  1. Alias

  2. Weight

  3. Type

  4. Parent Element

  5. Attribute

Answer: B,C,E

Question No: 15

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

  1. Tier 2: Web Application Server

  2. Tier 1: Web Client

  3. Tier 4:Relational Store

  4. Tier 3: Data

Answer: D

Question No: 16

A company usesExcel workbooks to access IBM Cognos TM1 data over a wide area network. The company needs to improve the performance of their Excel workbooks which contain multiple slices from multiple TM1 cubes.

Which two changes will improve performance? (Choose two.)

  1. Convert all DBR() functions to DBRW() functions.

  2. Make all DBRW() functions reference a single VIEW function.

  3. Convert all DBRA() functions to DBRW() functions.

  4. Convert all DBRW() functions to DBR() functions.

Answer: A,C

Question No: 17

Which two options allowthe end user to expand and collapse dimensional elements listed on the row dimension of a given data view in TM1 Web quot;on-the-flyquot;? (Choose two)

  1. Active Form

  2. TM1 Web Cube View

  3. Websheet

  4. TM1 Dynamic View

Answer: A,B

Question No: 18

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

  1. Repeat

  2. Straight Line

  3. Increase

  4. Decrease

Answer: A,B

Question No: 19

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?

  1. DBRW

  2. DBSW

  3. DBSS

  4. DBS

Answer: C

Question No: 20

Whenever you open the Salescube you see a hierarchical list of all products. The default view consists of default subsets for all dimensions. You would like to see a list of 10 products you are responsible for by default.

Which three actions would achieve this? (Choose three.)

  1. Create a private default subset for the product dimension and leave the default view unchanged.

  2. Create a private default subset for the product dimension and leave the default view unchanged,

  3. Create a private named subset for the product dimension and create a private named view using it.

  4. Create a private named subset for the product dimension and create a private default view using it.

  5. Create a private default subset for the product dimension and create a private default view using it.

Answer: A,D,E

100% Ensurepass Free Download!
Download Free Demo:C2020-701 Demo PDF
100% Ensurepass Free Guaranteed!
C2020-701 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.