[Free] 2017(Sep) Latesttests Passguide IBM C2020-701 V13 Dumps with VCE and PDF 11-20

Latesttests 2017 Sep IBM Official New Released C2020-701 V13
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/C2020-701 V13.html

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% Free Download!
Download Free Demo:C2020-701 V13 Demo PDF
100% Pass Guaranteed!
Download 2017 Latesttests C2020-701 V13 Full Exam PDF and VCE

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

2017 Latesttests IT Certification PDF and VCE