IBM Cognos TM1 10.1 Developer sample practice questions
QUESTION NO: 1
The logging parameter within \}CubeProperties is designated
by a "Yes" or "No" for each cube.
What does this define?
A. Data changes to the TM1 cubes logged into the tm1s.log
file
B. cubepropertiesdataloggedintothetm1server.log
C. dimensionupdatesloggedintothetm1audit.log
D. userpermissionsloggedtothetm1server.log
Answer: A
QUESTION NO: 2
Which three are typically stored within a TM1 control
object? (Choose three.)
A. A list of TM1 users
B. TM1 system errors
C. Data required by the TM1 server to perform a driver-based
calculation
D. TM1 object-level security permissions
E. Statistical performance data about the TM1 server
Answer: A,D,E
Explanation:
QUESTION NO: 3
Click the Exhibit button.
Referring to the entries in the tm1server.log shown in the
exhibit, which statement is correct?
A. The product dimension has been updated.
B. The process Update_Product_Dimension has not created an
error log.
C. The process Update_Product_Dimension has no parameters.
D. The chore Scheduledjmport has completed.
Answer: B
Explanation:
QUESTION NO: 4
What are the elements of a rule?
A. Area Definition, Qualifier, Formula, Terminator, and
Sequence Indicator
B. Area Definition, Qualifier, Formula, and Priority Flag
C. Area Definition, Qualifier, Formula, and Terminator
D. Area Definition, Formula, Terminator, and Priority Flag
Answer: C
Explanation:
QUESTION NO: 5
You want to improve one TM1 cube by adding Skipcheck and
Feeder statements to a Rules file.
Which statement is correct?
A. The addition of rule-calculated cells to a cube will
cause reduced consumption of RAM.
B. The data integrity of consolidated cells will improve.
C. The performance of views containing rule-calculated cells
will improve.
D. Cross cube rule statements will be no longer be ignored.
Answer: C
Explanation:
QUESTION NO: 6
Cross-Cube Feeder statements will result in a Cube
Dependency relationship between the Dependent Cube (containing the feeder) and the Base Cube
(the target cube of the Feeder from the Dependent Cube) if the Feeding cells contain data at Server
startup or if initially null at server startup, the feeding cells are subsequently updated during
the server session.
Which statement describes the relationship between the cubes
having the Cube Dependency
relationship?
A. Cell value updates to the Dependent Cube will invalidate
the cache of the Base Cube.
B. Cell value updates to the Base Cube will invalidate the
cache of the Dependent Cube.
C. Cell value updates to the Dependent Cube will invalidate
the Cube Dependency.
D. Cell value updates to the Base Cube will invalidate the
Cube Dependency.
Answer: A
Explanation:
QUESTION NO: 7
Which three parameters create a view extract of a cube
either manually or when using
Turbolntegrator? (Choose three.)
A. Skip consolidated values.
B. Skip an ancestor of a specified element.
C. Skip zero/blank values.
D. Skip values greater than a specified numeric value.
E. Skip the eighth element in a dimension.
Answer: A,C,D
Explanation:
QUESTION NO: 8
The customer is experiencing performance issues with threads
blocking as shown in the TM1
Operations Console.
Which setting within the tmls.cfg file improves writer
response time by removing lock contention
resulting from concurrent cube data access?
A. AllowSeparateNandCRules=T
B. Parallellnteraction=T
C. UseStargateForRules=T
D. PersistentFeeders=T
Answer: B
Explanation:
QUESTION NO: 9
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
Explanation:
QUESTION NO: 10
In a Turbolntegrator process, you need to create a cube
structure before loading data into it. In which tab would you create the cube?
A. Epilog
B. Metadata
C. Data
D. Parameters
Answer: B
Explanation:
QUESTION NO: 11
Which two attributes are aliases on a large product
dimension? (Choose two.)
A. Product size
B. Product standard color
C. Product name in German
D. Unique long product name
Answer: C,D
Explanation:
QUESTION NO: 12
When creating TM1 applications using Performance Modeler,
what are the three legal values for Application Type? (Choose three.)
A. Central
B. Workflow
C. Responsibility
D. Approval
E. Distributed
Answer: A,C,D
Explanation:
QUESTION NO: 13
A customer is using TM1 subsets.Which two statements are true? (Choose two.)
A. There are three types of subsets: conventional, static,
and dynamic.
B. There are only two access-types for subsets: private and
public.
C. In TM1, there is a notion of a default subset that will
appear in the system default view
D. Subsets can only contain leaf-level elements.
Answer: B,C
Explanation:
QUESTION NO: 14
A Skip check 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 ZeroSuppression
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
Explanation:
QUESTION NO: 15
You setup a chore to run nightly at 9:00 p.m. The T1 process
requires specific parameters to be set. Where do you specify the parameters so that they are
applied by the chore?
A. In the default inputs in the T1 process
B. In the Parameter Values in the chore
C. In the T1 process using the ChoreParameterSet( . . )
function
D. In the \}Parameters control cube
Answer: B
Explanation:
QUESTION NO: 16
A TM1 Action Button can directly perform which two tasks?
(Choose two.)
A. Sort worksheet data in ascending or descending order.
B. Run a Turbolntegrator process.
C. Navigate to another worksheet.
D. Open a TM1 cube view.
Answer: B,C
Explanation:
QUESTION NO: 17
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
Explanation:
QUESTION NO: 18
Which component would you use to define and publish a
package in IBM Cognos Bl to report from TM1 data?
A. Framework Manager
B. Transformer
C. Report Studio
D. TM1 URL API
Answer: A
Explanation:
QUESTION NO: 19
You have a cube which contains four regions, North, South,
East, and West. You want to clear all data from the West region.
Which method accomplishes this goal?
A. Create a rule that sets values equal to zero.
B. Unload the cube.
C. Clear the cube data using CubeClearData.
D. Zero out the view using ViewZeroOut.
Answer: D
Explanation:
QUESTION NO: 20
Active Forms support which three features? (Choose three.)
A. Zero suppression columns
B. Zero suppression rows
C. Drill-through
D. Expandable/collapsible consolidations rows
E. Expandable/collapsible consolidations columns
Answer: B,C,D
Explanation:
QUESTION NO: 21
You have developed a sequence of T1 processes connected
together by the ExecuteProcess(..) command. To improve the performance of the application, you
decide to break up the subprocesses so that they run in their own thread to use cores more efficiently.
Which TM1 object accomplishes this goal?
A. TM1 RunTl.exe
B. ExecuteProcessNewThread(..)
C. ExecuteProcess(...)
D. BatchProcess.exe
Answer: A
Explanation:
QUESTION NO: 22
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
Explanation:
QUESTION NO: 23
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
Explanation:
QUESTION NO: 24
Referring to the exhibit, a rule is written where the
sales_amt is equal to units multiplied by avg selling price What does the cube view tell you about the rule calculation?
A. The rule is missing a Skipcheck statement.
B. The rule is overfed.
C. The rule is underfed
D. The ruled calculation is missing a feeder.
Answer: C
Explanation:
QUESTION NO: 25
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
Explanation:
QUESTION NO: 26
In Turbolntegrator, as part of the monthly data load, you
need to add new products and their sales values but the products do not exist within the Product
dimension in the cube. Which function would you use to first add the new products
to the Product dimension?
A. DimensionCreate()
B. DimensionElementlnsert()
C. DimensionElementPrincipalName()
D. CellPutN()
Answer: B
Explanation:
QUESTION NO: 27
You are importing data into TM1 using Turbolntegrator. Which
three actions are available?
(Choose three.)
A. Create or update a dimension from an external source.
B. Create or update a cube from an external source.
C. Re-create a cube to change both data and meta data.
D. Re-order the dimensions of an existing cube.
E. Remove a dimension to an existing cube.
Answer: A,B,C
Explanation:
QUESTION NO: 28
You develop a new Active Form and would like to format it so
that all simple (N-level) cells have a gray background with standard row IDs.
Where do you apply the gray formatting?
A. To the first data row in the Active Form if Column A = N
B. To the first data row in the Active Form if Column A = 0
C. To Format Range 0 in the Format Area
D. To Format Range N in the Format Area
Answer: D
Explanation:
QUESTION NO: 29
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
Explanation:
QUESTION NO: 30
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
QUESTION NO: 31
All items are in the same dimension and performance is of
the highest priority.
How do you calculate the difference between item A and item
B, and then store the result in item C?
A. Define C as sibling of A and B, and a rule ['C']=N:['A']-['B'];.
B. Define C as consolidation of A and B, B with a weight
of-1.
C. Define C as consolidation of A and B2, and a rule
['B2']=N:-['B'];.
D. Define C as consolidation of A and B, and a rule ['C'] =
C: ['A']-['B']:.
Answer: B
Explanation:
QUESTION NO: 32
You want to load data to Cube A that will result in faster
load times while ensuring TM1 can recover the content of the data load in the event of a
subsequent server failure.
Which technique would you use?
A. On the T1 Maps/Cube tab, select Enable Cube Logging, and
add a CubeSaveData(CubeA) function to the Advanced/Epilog tab.
B. On the T1 Maps/Cube tab. do not select Enable Cube
Logging, and add a
CubeSaveData(CubeA) to the Advanced/Epilog tab.
C. On the T1 Maps/Cube tab, select Enable Cube Logging, and
add a SaveDataAII function to the Advanced/Epilog tab.
D. On the T1 Maps/Cube tab, do not select Enable Cube
Logging, and add a SaveDataAII function to the Advanced/Epilog tab.
Answer: B
Explanation:
QUESTION NO: 33
Regarding the persistence of Local, Global, and User
variables, which statement is correct?
A. Local variables are destroyed when a process exits.
B. Global variables are destroyed when a process exits.
C. User variables are destroyed when a chore exits.
D. Local variables persist as long as the user executing the
chore is logged into the TM1 server.
Answer: A
Explanation:
QUESTION NO: 34
If there is more than one rule in the rules file for a given
cell, which rule does IBM CognosTM1 calculate?
A. The rule with the highest priority flag is calculated.
B. Depending on which rule was calculated immediately
before, the next one is used.
C. It calculates the last applicable rule.
D. It calculates the first applicable rule and then stops.
Answer: D
Explanation:
QUESTION NO: 35
You have three elements (A, B, and C) of a dimension in a
public subset called THE_SUB. You want to address them in an Area Definition in a rule.
Which syntax should you use?
A. [{'A', 'B' , 'CV}]
B. [{THE_SUB'\}]
C. ['THE_SUB']
D. [A'.'B'.'C]
Answer: A
Explanation:
QUESTION NO: 36
You are asked to use Performance Modeler to Transfer a cube.
The target cube already exists in the target system but the source cube contains an additional
dimension.
What happens to the target cube and its data?
A. The additional dimension is added and the existing data
is deleted.
B. The additional dimension is added and the existing data
is placed in the first leaf of the new dimension.
C. The additional dimension is added and the existing data
is propagated across all leaves of the new dimension.
D. The additional dimension is not added and the existing
data remains in place.
Answer: B
Explanation:
QUESTION NO: 37
Which two statements are true about spreading in TM1?
(Choose two.)
A. Spreading is often performed on a single dimension
without involving a cube.
B. The extend option under spreading allows spreading in
more than one direction (e.g., right and up) as one operation.
C. With spreading, there is only one update action allowed:
replace.
D. Spreading can be used to populate a cube with test data.
Answer: B,D
Explanation:
QUESTION NO: 38
What are three legal selection criteria for TM1 subsets?
(Choose three.)
A. SQL expression
B. Hierarchical level (e.g., Leaf level)
C. Attribute value
D. Java expression
E. Spelling pattern (e.g., by Wildcard filter)
Answer: B,C,E
QUESTION NO: 39
Which two statements are true about predefined administrator
groups? (Choose two.)
A. Members in the DataAdmin group can create processes.
B. Members in the SecurityAdmin group can view all cube data
in read-only mode.
C. Members in the DataAdmin group can view all security
settings in read-only mode
D. Members in the SecurityAdmin can create rules to manage
security.
Answer: A,C
Explanation:
QUESTION NO: 40
What does element-level security control?
A. Access to cubes that contain the secured elements
B. The ability to add, remove, and reorder the secured
elements in a dimension
C. Access to the cells identified by the secured elements
D. Access to applications that contain the secured elements
Answer: C
Explanation:
QUESTION NO: 41
The Rule Tracer can be used with which TM1 interface?
A. TM1 Slice Worksheets
B. TM1 Cube Viewer
C. TM1 Web View
D. TM1 In-Spreadsheet Browser
Answer: B
QUESTION NO: 42
You are concerned about overfeeding in a TM1 model.
What are two symptoms of this? (Choose two.)
A. Sub-optimal view performance
B. Unnecessary RAM consumption
C. Increases the log file size
D. Data integrity risks occur
Answer: A,B
Explanation:
QUESTION NO: 43
Your customer requires that all users be forced to collect
their data and commit only a whole set of data. They are not allowed to create different versions.
Which setting is required to fulfill this requirement?
A. Set the capability Personal Workspace Mode to Off and the
capability Sandbox to On.
B. Set the capability Personal Workspace Mode to Off and the
capability Sandbox to Off.
C. Set the capability Personal Workspace Mode to On and the
capability Sandbox to On.
D. Set the capability Personal Workspace Mode to On and the
capability Sandbox to Off.
Answer: D
Explanation:
QUESTION NO: 44
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
Explanation:
QUESTION NO: 45
You are developing a TM1 model for a city aquarium and must
add these new elements to the Animal dimension: Amphibians. Frog, and Salamander. Assume
that Amphibians is the parent of Frog and Salamander and that you want the children to automatically
roll up to the parent.
Which weighting and element type will you assign to each
element?
A. Amphibians Element Type = C. Weight=1
Frog Element Type = N, Weight=0
Salamander Element Type = N, Weight=0
B. Amphibians Element Type = C, Weight=1
Frog Element Type = N, Weight=1
Salamander Element Type = N, Weight=1
C. Amphibians Element Type = N, Weights
Frog Element Type = N, Weight=0
Salamander Element Type = N, Weight=0
D. Amphibians Element Type = P,Weight=1
Frog Element Type = N, Weight=1
Salamander Element Type = N, Weight=1
Answer: B
Explanation:
QUESTION NO: 46
In Cognos Insight, you have a cube containing the following
dimensions with the following members.
Products - Pencils, Pens
Regions – North,
South, East, West
Months - Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sept, Oct,
Nov, Dec
Versions - Actuals, Budget
You need to determine which region did not sell any Pencils
in January (Jan).
Where do you need to set explore points?
A. All regions, all months except Jan, Pencils, Actuals
B. Jan. Budget. Pens
C. Jan. Actuals, Pencils
D. All regions, all months except Jan, Pens, Budget
Answer: C
Explanation:
QUESTION NO: 47
In which TM1 cube would a developer define dimension
hierarchy levels for use in IBM Cognos B1
reporting?
A. \}HierarchyLevels
B. \}HierarchyProperties
C. \}DimensionProperties
D. \}Dimensionl_evels
Answer: B
Explanation:
QUESTION NO: 48
A TM1 Operations Console shows a thread which is waiting to
obtain a read lock on a cube.
Which thread is blocking it?
A. A thread which holds a read lock on the cube
B. A thread which holds a write lock on the cube
C. A thread which holds an intent to write lock on the cube
D. A thread which is waiting to write to the cube
Answer: B
Explanation:
0
QUESTION NO: 49
You have the dimension shown in Performance Modeler as shown
in the exhibit.
Which three actions create a subset containing the countries
starting with "A" in alphabetical order? (Choose three)
A. Hide consolidated members.
B. Hide leaf members.
C. Sort ascending.
D. Sort descending.
E. Filter by wildcard A*.
Answer: A,C,E
Explanation:
QUESTION NO: 50
Which action must you take before the TM1 cubes can be used
in IBM Cognos B1?
A. Define levels for all dimensions in TM1.
B. Define Measure dimensions for all cubes in TM1.
C. Define security for all elements in TM1.
D. Create an administrator account for IBM Cognos B1 to use.
Answer: B
Explanation:
QUESTION NO: 51
You execute a number of Turbolntegrator processes as part of
a chore using the ExecuteProcess function but errors result. Upon reviewing the log files,
inadequate information about the errors exist.
What is the debugging strategy?
A. Send comments to a log file with ASCIIOUTPUT function.
B. Turn on cube logging.
C. Use the SetChoreVerboseMessages function.
D. Send comments to a log file with TEXTOUTPUT function.
Answer: C
Explanation:
QUESTION NO: 52
What does IBM Cognos TM1 do with calculated values based on
rules?
A. It keeps them in a user cache for further usage.
B. It keeps them in a cube cache for further usage.
C. It keeps them in a disk-based cache for further usage.
D. It does not keep them in order to minimize memory usage.
Answer: B
Explanation:
QUESTION NO: 53
What are three examples of privileges that can be assigned
to TM1 objects? (Choose three.)
A. Hold
B. Lock
C. Admin
D. Reserve
E. Delete
Answer: B,C,D
Explanation:
QUESTION NO: 54
Following TM1 best practices for budget applications, which
dimension omits consolidated elements?
A. Time
B. Measures
C. Organization Chart
D. Chart of Accounts
Answer: B
Explanation:
QUESTION NO: 55
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
Explanation:
QUESTION NO: 56
User security assignments are stored in which control cube?
A. \}ClientSettings
B. \}ClientGroups
C. \}ClientProperties
D. \}ClientSecurity
Answer: B
Explanation:
QUESTION NO: 57
Which statement is true about cube properties?
A. The cube properties cube includes a list of all
dimensions in the cube.
B. Cube properties are held in the system cube named
\}CubeProperties using the dimension \}CubeProperties.
C. The cube properties cube is visible and accessible to all
users.
D. The cube properties cube includes a list of all the views
associated with the cube.
Answer: B
Explanation:
QUESTION NO: 58
Which statement is true when using Cognos Access Manager
(CAM) User Authentication with TM1?
A. IBM Cognos Authentication automatically manages users on
the TM1 Server.
B. IBM Cognos Authentication automatically manages TM1
Object Security.
C. IBM Cognos Authentication requires that all users must be
pre-loaded into TM1.
D. IBM Cognos Authentication requires that all users belong
to the TM1 group.
Answer: A
Explanation:
QUESTION NO: 59
You need to import new monthly sales data into an existing
cube.
Using the Turbolntegrator wizard, which action will load the
data while maintaining the cube structure?
A. Create a cube and populate it with data from the source.
B. Re-create a cube while preserving the existing data.
C. Update the cube.
D. Create a dimension from data imported from a source.
Answer: C
Explanation:
QUESTION NO: 60
A user has requested that you create a cube view displaying
individual fruit costs by month formatted as currency with two decimal places.Based on the dimensional information shown in the exhibit,
how would you arrange the cube to meet the user's formatting requirement?
A. Assign Version on row, Months on columns, Products and
Measures in title.
B. Assign the formatting to the cube view.
C. Assign Measures in row, Months in columns, Version in
title, and Product in title.
D. Assign Months in row, Measures in column, Version in
title, Product in title.
Answer: D
QUESTION NO: 61
You are developing a TM1 model for a city aquarium and need
to add a new sub-category of animals to the Animal
dimension. The new elements are: Amphibians, Frog, and Salamander.Assume that Amphibians is the parent of Frog and Salamander
and you want the children to automatically roll up
to the parent. Which weighting and element type will you assign to each element?
B. Amphibians Element
Type = Numeric (N), Weight 1
C. Amphibians Element
Type = String (S), Weight 1
D. Amphibians Element
Type = Aggregate (A), Weight 1
Answer: A
QUESTION NO: 62
You need the current
month as a number. Which function delivers the desired result?
A. TIMEST(NOW, '\m')
B. MONTH (NOW)
C. TIMVL(NOW, 'M')
D. TIME(NOW, 'M')
Answer: C
QUESTION NO: 63
You need to export
data from a TM1 cube including the column headers. Where do you put the ASCIIOutput
command for the column headers?
A. In the PROLOG section without condition
B. In the METADATA
section with condition to execute it only for the first record
C. In the DATA
section with condition to execute it only for the first record
D. In the EPILOG
section without condition
Answer: C
QUESTION NO: 64
You are planning a
customer installation with several TM1 servers, all with Integrated Security Mode 4 and a
common Cognos BI service. Security groups are common between all TM1 servers.
Where do you maintain groups and users to minimize administrative tasks?
A. In TM1 \}Group
dimension
B. In Cognos
Connection
C. In Cognos
Configuration
D. In Cognos TM1
Operations Console
Answer: B
QUESTION NO: 65
You have a cube that is showing slower than expected query
response times. Which strategy would you
pursue to improve query performance?
A. Apply cell
security to the cube.
B. Reorder the cube
dimensions using the Cube Optimizer.
C. Create a named
view on the cube.
D. Run the query
through TurboIntegrator.
Answer: B
QUESTION NO: 66
Your customer requires that all users be forced to write
their data directly into the server so that the data is visible to all other users. Which
setting fulfills this requirement?
A. Set the capability Personal Workspace Mode to On and the
capability Sandbox to On.
B. Set the capability Personal Workspace Mode to On and the
capability Sandbox to Off.
C. Set the capability Personal Workspace Mode to Off and the
capability Sandbox to On.
D. Set the capability Personal Workspace Mode to Off and the
capability Sandbox to Off.
Answer: D
QUESTION NO: 67
On which level of granularity can the capabilities for
Personal Workspace Mode and Sandboxes be set? They can be set:
A. per cube and group
B. per cube for all groups
C. per group for all cubes
D. once for all cubes and groups
Answer: C
QUESTION NO: 68
Which settings in the tm1s-log.properties file would
maximize the information producedusing TI processes while keeping other log information to a
minimum?
A. log4j.logger.TM1=WARN, S1
log4j.logger.TM1.Cube=INFO
B. log4j.logger.TM1=INFO, S1
log4j.logger.TM1.Process=ERROR
C. log4j.logger.TM1=ERROR, S1
log4j.logger.TM1.Process=INFO
D. log4j.logger.TM1=INFO, S1
log4j.logger.TM1.Process=WARN
Answer: C
QUESTION NO: 69
You develop a worksheet with drop down menus displaying
subset information. You want to ensure that after the worksheet is opened, all of the
subsets are automatically refreshed and up-to-date with the latest server changes. Which
workbook level named variable would you use?
A. TM1RefreshSheet = 1
B. TM1RebuildOption = 1
C. TM1SubsetRefresh = 1
D. TM1ActiveFormRefresh = 1
Answer: B
