Downloadable of C2021-702 answers materials and bootcamp for IBM certification for IT examinee, Real Success Guaranteed with Updated C2021-702 pdf dumps vce Materials. 100% PASS IBM Cognos TM1 10.1 Developer exam Today!
2021 May C2021-702 Study Guide Questions:
Q21. Click the Exhibit button.
Using Performance Modeler, items are set either from an amount which is brought in from another cube by a link or from a calculation (quantity times price). During testing, all the items are quantity times price. The relevant part of the rules file is shown in the exhibit.
How do you change the rules so that the items are set to the amount where required?
A. Disable Region "#Region Link rule: my link- Numeric" and manually add the corrected rule below the disabled region.
B. Move Region "#Region Link rule: my link- Numeric" above Region "N-Calculation rules: MY Calc".
C. Manually overwrite Area Definition in Region "N-Calculation rules: MY Calc".
D. Change the definition in the Dimension for Region "N-Calculation rules: MY Calc" to include If and Continue.
Answer: B
Q22. Regarding Sandboxes, why do numbers sometimes appear in blue or green?
A. Green is for values not sent to the server and blue is for uncommitted values.
B. Green is for uncommitted values and blue is for values not sent to the server.
C. Green and blue are for uncommitted values depending on client interface used.
D. Green and blue are for values not sent to the server depending on the client interface used.
Answer: A
Q23. If vOriginalDate = July 27, and you require vNewDate = Jul2012, which syntax is appropriate to complete this task?
A. vNewDate=SUBST(vOriginalDate,3,3) | '2012'
B. vNewDate=SUBST(vOriginalDate,3,3) & '2012'
C. vOriginalDate=SUBST(vNewDate,3,3) & '2012'
D. vNewDate=SUBST(vOriginalDate,3,3) + '2012'
Answer: A
Most up-to-date C2021-702 exam guide:
Q24. Within the TM1 cube viewer, which two filter methods are available? (Choose two.)
A. Filter by a text pattern match.
B. Filter by the largest or smallest values for a column element.
C. Filter by the largest or smallest values whose cumulative total equals a specified percentage of a dimension total
D. Filter by the MDX expression.
Answer: B,C
Q25. A new member is added to a dimension called Products which is used in a cube called Sales.
What information is recorded in the audit log?
A. A change to the total number of members in the Products dimension
B. A change to the size of the Sales cube
C. A change to the last updated time of the Products dimension
D. The name of the new member
Answer: C
Q26. An international enterprise has planners in European, Asian, and North American regions. The enterprise wants to have planners in each region enter cube data into the local regional TM1 server but report globally on a daily basis from a single enterprise-reporting server located in Canada. The enterprise wants to integrate the cube data from the different regions into a single reporting server in Canada.
Which method accomplishes this goal?
A. Use the TM1 rules to push data from each regional server into the Canadian reporting server.
B. Use the TM1 rules to pull data from each regional server into the Canadian reporting server.
C. UsetheTM1 replication/synchronization in the Canadian server to pull data from the regional servers.
D. Use the TM1 replication/synchronization in the regional servers to push data to the Canadian server.
Answer: C
Verified C2021-702 forum:
Q27. A Skipcheck statement appears in the Rules file, however the calculated cells are not fed. What are two results? (Choose two.)
A. Leaf level calculated cell values will not be calculated.
B. Non-null/non-zero Leaf level calculated cell values will be suppressed by a view's Zero-Suppression property.
C. Non-null/non-zero Leaf level calculated cell values will be ignored when imbedded in another leaf level cell rule calculation.
D. Non-null/non-zero Leaf level calculated cell values will not be included in the parent consolidation(s).
Answer: B,D
Q28. A customer is using dynamic subsets.
Which statement is true about TM1 Perspectives?
A. Expression-based dynamic subsets are created using MDX.
B. Expression-based dynamic subsets are created using SQL.
C. Expression-based dynamic subsets are created using Java.
D. Expression-based dynamic subsets can include "filter-by-SQL" operators.
Answer: A
Q29. You want to export only user-entered non-zero numeric values from a cube.
Which three view manipulation functions are required? (Choose three.)
A. ViewExtractSkipZeroesSet (exclude zero/null values in export)
B. ViewExtractSkipRuleValuesSet (exclude rule calculated values in export)
C. ViewExtractSkipStringSet (exclude string values in export)
D. ViewExtractSkipCalcsSet (exclude consolidated values in export)
E. ViewExtractSkipLevelZero (exclude leaf level values in export)
Answer: A,B,D
Q30. Which statement is true for TM1 dimensions?
A. TM1 can have dimension hierarchies with only one roll-up/consolidation structure per dimension.
B. All dimension attributes must be unique across dimension elements.
C. Dimension aliases must be unique across dimension elements.
D. Dimension attributes can be either type numeric, type subset, or type string/text.
Answer: C