# IBM Planning Analytics V2.0.x Administration

24 point

**1.What happens during a SaveDataAll?**
Select one: B
A. All cube files are recreated with the current cube data in memory
B. All cube files are updated with the current cube data in memory
C. Only cube files for cubes where data has been updated are updated
D. Only cube files for cubes where data has been updated are recreated

**2. In Planning Analytics Workspace Administration, which of the following objects are contained in a Lifecycle Management snapshot?**
Select one: D
A. Planning Analytics Workspace books, Planning Analytics Workspace views, and Websheets
B. TM1 database objects including cubes, dimensions, and elements, but not TM1 database cube data
C. Planning Analytics Workspace books, and Planning Analytics Workspace views with security based on groups
D. Planning Analytics Workspace books, and Planning Analytics Workspace views without security

**3.What tool is used to query the TM1 database audit log?**
Select one: C
A. TM1 Audit Query tool
B. Planning Analytics Workspace
C. TM1 Architect
D. Performance Modeler

**4.A user is able to see a cell but unable to see the value in the cell. What security mechanism is blocking the user's ability to see the value?**
Select one: C
A. Data Reservation
B. Cube Security
C. Cell Security
D. Element Security

**5. A user is running a TI process that is adding elements to a dimension using the DimensionElementInsert TI function. The dimension is named "accounts". When is the accounts.dim file updated?**
Select one: C
A. It is updated when the TM1 database is stopped or restarted
B. It is updated on the next SaveDataAll
C. It is updated as soon as the TI process is complete
D. It is updated at the time the DimensionElementInsert TI function is run

**6.What information is contained in the transaction log files?**
Select one: D
A. A description of changes to leaf level cells including rule derived cells
B. A description of changes to leaf and consolidated cells not including rule derived cells
C. A description of changes to leaf and consolidated cells including rule derived cells
D. A description of changes to leaf level cells not including rule derived cells

**7.Planning Analytics Administration displays a color-coded threshold (green, yellow, and red) based on what configurable criteria?**
Select one: A
A. CPU and Memory usage
B. Current number of blocked threads
C. Database health
D. Response latency

**8.Planning Analytics Workspace points to two different TM1 Admin Servers in the paw.env file. Each TM1 Admin Server has a different TM1 Database with the exact same name. When a Planning Analytics Workspace user examines the list of TM1 Databases in a book, what do they see?**
Select one: C
A. Only one TM1 database is displayed, the first TM1 Database based on the order of TM1 Admin Servers in the paw.env file
B. Only one TM1 database is displayed, the last TM1 Database based on the order of TM1 Admin Servers in the paw.env file
C. Both TM1 Databases are displayed
D. Neither TM1 Database is displayed

**9.What additional component is required to open a published Microsoft Excel workbook in IBM Planning Analytics Workspace?**
Select one: D
A. PMPSVC
B. PMHub
C. None
D. TM1 Web

**10.What is the difference between dynamic and static parameters in the tm1s.cfg file?**
Select one: D
A. Dynamic parameters can be modified. Static parameters cannot be modified.
B. Dynamic parameters are applied in the current user session. Static parameters are applied for each user only after the user logs into the TM1 database.
C. Dynamic parameters are applied to specific users. Static parameters are applied to all users.
D. Dynamic parameters are applied without a TM1 database restart. Static parameters take effect only after a TM1 database is restarted.

**11.What happens when there is a tm1s.log file present in the logging directory when the TM1 database is started?**
Select one: C
A. The TM1 database will throw a warning and start normally
B. The TM1 database will generate an error and fail to start
C. The TM1 database will attempt to reload transactions from the tm1s.log file as part of the startup process
D. The tm1s.log file is ignored and the TM1 database will start normally

**12.What happens to the transaction log (tm1s.log file) when the TM1 database is successfully stopped? The TM1 database is not started in this scenario.**
Select one: B
A. The transaction log file is moved to an archive directory
B. The transaction log is renamed to include a timestamp, and the logging directory will not contain a file named tm1s.log
C. The transaction log is renamed to include a timestamp, and a new tm1s.log file is created
D. The transaction log file is deleted

**13. An administrator is alerted by a user that a TM1 database is no longer accessible. A quick investigation confirms the TM1 database is not running and the log directory contains a file named tm1s.log. What does the administrator know based on this scenario?**
Select one: A
A. The TM1 database stopped abnormally, some transactions were not written to cube files on disk
B. The TM1 database stopped normally, some transactions were not written to cube files on disk
C. The TM1 database stopped abnormally, all transaction were written to cube files on disk
D. The TM1 database stopped normally, all transaction were written to cube files on disk

**14.IBM Planning Analytics for Microsoft Excel can connect to a TM1 database using two different components. Which two components are they?**
Select one or more: B,D
A. TM1 Admin Server
B. PMHub
C. TM1 Web
D. Planning Analytics Workspace
E. TM1 Applications

**15.What security feature can a TM1 database administrator use to prevent themselves and other administrators from accidentally writing to a cube?**
Select one: C
A. An administrator cannot prevent themselves from writing to a cube
B. Cube security
C. Lock
D. Data Reservation

**16.How are TM1 database transaction log files managed?**
Select one: A
A. The TM1 administrator must manually delete or archive transaction log files
B. Older transaction log files are deleted based on settings in the tm1s.cfg file
C. Older transaction log files are compressed based on settings in the tm1s.cfg file
D. Older transaction log files are archived based on settings in the tm1s.cfg file

**17.Which of the following files can be configured to enable debug logging on the TM1 database, and where must this file be configured?**
Select one: A
A. The tm1s-log.properties, in the TM1 database configuration directory
B. The tm1s.log file, in the TM1 database logging directory
C. The tm1s.cfg file, in the TM1 database configuration directory
D. The tm1s-log.propeties file, in the TM1 database logging directory

**18.Which of the following are roles in the TM1 database (Planning Analytics 2.0.5 and higher)?**
Select one: D
A. Admin, Data Admin, Security Admin, Ops Admin
B. Admin, Security Admin, Data Admin, CAM Admin
C. Admin, Security Admin, Data Admin
D. Admin, Modeler, Analyst, Consumer

**19.What action(s) should be performed before backing up files in the TM1 database data directory?**
Select one: B
A. Run a Save Data All
B. Run a Save Data All, and then stop the TM1 database
C. Stop the TM1 database
D. Run a TI process with the CubeSaveData TI function

**20. An IBM Planning Analytics for Microsoft Excel user is running a large report that is causing the TM1 database to use all available memory. What can the administrator do to limit the amount of memory used?**
Select one: C
A. Enforce the "Data display row limit" setting for the Planning Analytics for Microsoft Excel user
B. Reduce the VMM value in the }CubeProperties cube
C. Set the MaximumViewSize parameter in the tm1s.cfg file
D. Increase the MTQ parameter value in the tm1s.cfg file

**21.Which of the following can be used to update the TM1 database configuration parameters?**
Select one or more: A,B
A. Planning Analytics Administration (REST API)
B. The tm1s.cfg file
C. The tm1s-log.properites file
D. TM1 Architect
E. Control cubes

**22.Planning Analytics Workspace uses which API and port to communicate with the TM1 database?**
Select one: D
A. NGAPI (connects using PMHub), HTTPPortNumber as set in the tm1s.cfg file
B. C/C++ API, PortNumber parameter as set in the tm1s.cfg file
C. Java API, PortNumber parameter as set in the tm1s.cfg file
D. REST API, HTTPPortNumber parameter as set in the tm1s.cfg file

**23.Which log files can be downloaded using Planning Analytics Administration?**
Select one: B
A. The tm1server.log file, the transaction log files, and the audit log file
B. Any file in the TM1 database logging directory with the .log file extension except the file named tm1s.log
C. The tm1server.log file and all transaction logs
D. Any file in the TM1 database logging directory with the .log file extension

**24.What information is contained in a TM1 Database audit log?**
Select one or more: B,E
A. Changes to cell values in cubes
B. TI process execution history
C. Changes to configuration parameters
D. Changes to security
E. Metadata changes

**25.What file contains the passwords for all native (IntegratedSecurityMode=1) user accounts in the TM1 database including the account named Admin?**
Select one: B
A. }ElementAttributes_}Clients.cub
B. }ClientProperties.cub
C. }ClientSettings.cub
D. }ClientSecurity.cub

**26.A user in a TM1 database belongs to two groups. One group has WRITE access to a cube and the other group has READ access to the same cube. What access does the user have to the cube?**
Select one: B
A. The security level of the last group based on index in the }Groups dimension
B. WRITE
C. READ
D. The security level of the first group based on index in the }Groups dimension

**27.When examining the thread activity for a TM1 database in Planning Analytics Administration, both Session ID and Thread ID are displayed. What is the difference between Session ID and Thread ID?**
Select one: B
A. A user login is represented by a Thread ID and may have multiple Session IDs.
B. A user login is represented by a Session ID and may have multiple Thread IDs.
C. Planning Analytics Workspace and Planning Analytics for Microsoft Excel use only Session IDs. All other clients use Thread ID.
D. Planning Analytics Workspace and Planning Analytics for Microsoft Excel use only Thread ID. All other clients use Thread ID.

**28. To which of the following objects in a TM1 model can security be applied?**
Select one: D
A. Cube, View, Dimension, Subset, Element
B. Cube, View, Dimension, Hierarchy, Subset, Element, Cell
C. Cube, Dimension, Hierarchy, Element, Cell
D. Cube, Dimension, Element, Cell

**29.Which of the following security mechanisms are NOT based on groups in the TM1 database?**
Select one or more: C,D
A. Application Security
B. Capability assignment (}Capabilities cube)
C. GlobalSecurityOverlay
D. Data Reservation
E. Cell Security

**30. An administrator wants to migrate a dimension named "accounts", the dimension's hierarchies, and all element attributes with attribute values. Besides the accounts.dim file, what other files must the administrator migrate?**
Select one or more: B,C,D
A. The }ElementAttribute_accounts}hiers directory and all files in that directory
B. The }HierarchyProperties.dim and }HierarchyProperties.cub files
C. All }ElementAttribute_accounts.dim and }ElementAttributes_accounts.cub files
D. The }Hierarchies.dim file
E. The account}hiers directory and all files in that directory