WAP - Practice Exam Questions - AJB

1.    How do values display within the actuals time periods in a plan version when the account "Type" is set to "Link" with Actuals Overlay set to "Show actuals if the linked account has them"?

a)    Link account values display in black text for actuals periods within a plan version

b)    Link account values display in blue text for actuals periods within a plan version

c)    Link account values display in green text for actuals periods within a plan version

d)    Link account values display in red text for actuals periods within a plan version

c)    Link account values display in green text for actuals periods within a plan version

1.    What is the default number of dimensions that can be secured by access rules?

a)    4

b)    3

c)    2

d)    1

b)    3

1.    What are characteristics of rollup versions? (Select two correct answers.)

a)    Rollup versions do not allow for data entry or data imports

b)    Exchange rates can differ by each actuals sub-version.

c)    Rollup versions allow for data entry.

d)    Rollup versions are read-only.

a)    Rollup versions do not allow for data entry or data imports

d)    Rollup versions are read-only.

1.    What information does the User Activity Log track? (Select three correct answers.)

a)    Data entry audit log

b)    Date & Time

c)    Name

d)    Action of Login & Logout

e)    Tasks completed

b)    Date & Time

c)    Name

d)    Action of Login & Logout

1.    How many access rules can you assign to one user?

a)    Unlimited

b)    10

c)    2

d)    1

d)    1 – can only assign full view, limited view, or edit per access rule created?

1.    What actions can a user perform from the permission "Import To All Levels"? (Select three correct answers.)

a)    Export data

b)    View Import History page

c)    View and edit Level, Account & Dimension value mappings

d)    Import data to all levels regardless of your assigned access rules

e) Import data only to your owned levels

b)    View Import History page

c)    View and edit Level, Account & Dimension value mappings
d)    Import data to all levels regardless of your assigned access rules

1.    What model information is required when you submit support tickets?

a)    Access Rules Export

b)    Disk Usage

c)    Model Code

d)    Model Name

c)    Model Code

1.    What description accurately depicts the most permissive access type to the least permissive access type?

a)    Full View > Limited View > Edit

b)    Limited View > Full View > Edit

c)    Edit > Full View > Limited View

d)    Full View > Edit > Limited View

c)    Edit > Full View > Limited View

1.    What type of accounts allow for data splits from the import template?

a)    Metric accounts or modeled accounts

b)    General ledger or metric accounts

c)    General ledger or cube accounts

d)    General ledger or custom accounts

d)    General ledger or custom accounts

1.    What is the requirement in order for levels and dimensions to automap upon a data import?

a)    Levels and dimensions can only automap through data integration loaders

b)    Level names and dimension names on the import file must match the level names and dimension names within the model

c)    Level and dimension mappings are required in advance of a data import

d)    Levels and dimensions cannot automap

b)    Level names and dimension names on the import file must match the level names and dimension names within the model

1.    What actuals version option determines the actuals overlay end date within plan version(s)?

a)    Completed values through

b)    Left scroll limit

c)    End of version

d)    Lock leading day through

a)    Completed values through

1.    What happens to existing data when the option "Data Entry Sheet Type" for a GL account is changed from "Standard" to "Cube"?

a)    Data will be erased from the account for all versions and levels

b)    Data will be erased from the account for the specified version

c)    An account with existing data will not allow a change to the "Data Entry Sheet Type"

d)    Data will automatically display on the cube sheet where account is displayed

a)    Data will be erased from the account for all versions and levels

1.    Where do you navigate to view the User Activity Log once enabled?

a)    Administration

b)    Process Tracker

c)    Sheets > Overview

d)    Model Management

a)    Administration

1.    Which of the following is true if the general setup option "Allow Adaptive Insights support personnel to login" is NOT enabled?

a)    Support personnel can login without authorization for any reason.

b)    Support personnel can login without authorization only to review issues.

c)    Support personnel cannot login.

d)    Additional authorization is required by support to login by email.

c)    Support personnel cannot login.

(IDK IF THIS IS CORRECT)

1.    What type of imports are saved within Import History? (Select two correct answers.

a)    Virtual version imports

b)    Plan imports

c)    Transaction imports

d)    Actuals imports

c)    Transaction imports

d)    Actuals imports

1.    A user has an access rule assigned with one level and access type Full View. The same user is assigned to a user-assigned sheet that has all levels enabled. What level of access do you have on the user-assigned sheet?

a)    You can view and edit data for all levels in the user-assigned sheet.

b)    You cannot view any user-assigned sheets.

c)    You can only edit the granted level from the access rule in the user-assigned sheet.

d)    You can only view the granted level from the access rule in the user-assigned sheet.

a)    You can view and edit data for all levels in the user-assigned sheet.

1.    What is the impact on the account balance when the custom account "Type" has the setting: "Custom (cumulative)" and "Planned by (delta)?"

a)    The account balance automatically copies forward, and any amount entered in a future period is added to the account balance

b)    The account balance does not copy forward

c)    The account balance automatically copies forward, and any balance entered in a future period becomes the new account balance

d)    The account balance is set to read-only for all future balances

a)    The account balance automatically copies forward, and any amount entered in a future period is added to the account balance

1.    The sheet property Access Salary Detail is applicable to which sheet(s)?

a)    All sheets

b)    Modeled sheets

c)    Cube sheets

d)    Standard sheets

b)    Modeled sheets

1.    What images can be added to a model from Visual Preferences within Administration? (Select two correct answers.)

a)    Add images to display on dashboards

b)    Add a company logo to display in the middle on the top menu bar

c)    Add an avatar for your user profile

d)    Add logos to display on each sheet

b)    Add a company logo to display in the middle on the top menu bar

c)    Add an avatar for your user profile

1.    What actions can global user groups be used for? (Select three correct answers.)

a)    Create shared formulas

b)    Assigning access to user-assigned sheets.

c)    Sharing perspectives.

d)    Assigning tasks.

e)    Assigning access rules.

c)    Sharing perspectives.

d)    Assigning tasks.

e)    Assigning access rules.

1.    What model changes does the audit trail version option track? (Select two correct answers.)

a)    Audit trail tracked changes include data entered or imported on standard sheets, modeled sheets, cube sheets, and user-assigned sheets.

b)    Audit trail tracked changes include model management changes to levels

c)    Audit trail tracked changes include cell notes

d)    Audit trail tracked changes include administration changes to users

a)    Audit trail tracked changes include data entered or imported on standard sheets, modeled sheets, cube sheets, and user-assigned sheets.

c)    Audit trail tracked changes include cell notes

1.    What is a requirement in every model regarding versions?

a)    Must have at least one virtual version

b)    Must have at least one default plan version

c)    Must have at least one sub-actuals version

d)    Must have at least one locked plan version

b)    Must have at least one default plan version

1.    What type of data can be imported using download templates? (Select three correct answers.)

a)    Roles

b)    Modeled sheet data

c)    Cube sheet data

d)    Users

e) Standard sheet data

b)    Modeled sheet data

c)    Cube sheet data

e) Standard sheet data

1.    The Working Budget version start of plan is February 2016 and the Actuals version completed values through is March 2016. What is true regarding the actuals overlay values within the working budget version?

a)    The actuals overlay data stops at start of plan date, February 2016, not the Completed Values Through date, March 2016

b)    Actuals overlay values cannot display in a plan version

c)    The actuals overlay data stops at Completed Values Through date, March 2016

d)    The actuals overlay data stops at the actuals version end date within the plan version

a)    The actuals overlay data stops at start of plan date, February 2016, not the Completed Values Through date, March 2016

1.    What are the required import selections when importing modeled rows or cube sheet data?

a)    Select Import Into Sheet and select a specific modeled or cube sheet

b)    Select Import Into Sheet "Cube or Modeled Sheet"

c)    Select Import Into Sheet "Standard"

d)    Select Import Type "Transactions"

a)    Select Import Into Sheet and select a specific modeled or cube sheet

1.    What area of the model is locked and cannot be revised in any locked plan version?

a)    Roles and Permissions

b)    Access Rules

c)    Shared Formulas

d)    Levels

c)    Shared Formulas

1.    Assigning permission sets to users is conditional upon having which of the following permissions in addition to Users?

a)    Manage Global User Groups

b)    Permission Sets

c)    Time

d)    Organization Structure

b)    Permission Sets

1.    What are the required virtual version options when creating a virtual version? (Select two correct answers.)

a)    Select an Exchange rate version

b)    Select a Base version

c)    Select only a plan base version

d)    Select at least one actuals version (if sub-versions exist) for the base version

a)    Select an Exchange rate version – exchange rate to translate base version data

b)    Select a Base version – use for data

1.    Which access control category is unique to plan versions?

a)    Group

b)    Users

c)    Editable sheet access

d)    Administrators

c)    Editable sheet access

1.    When creating formulas in a plan version, an administrator can reference data from what versions

a)    Any virtual version

b)    Any actuals version

c)    Only the plan version you are working in

d)    Any plan version

c)    Only the plan version you are working in

1.    What mapping options are available to automap accounts? (Select two correct answers.)

a)    Match planning account on combination of name and code

b)    Match planning account name

c)    Accounts cannot be automapped

d)    Match planning account code

b)    Match planning account name

d)    Match planning account code

1.    What actions can you perform with the permission set permission Access OfficeConnect? (Select two correct answers.)

a)    Access web reports

b)    View and edit data for all levels regardless of access rules in OfficeConnect reports

c)    View and edit OfficeConnect reports

d)    Access OfficeConnect Excel, Word and Powerpoint

c)    View and edit OfficeConnect reports

d)    Access OfficeConnect Excel, Word and Powerpoint

1.    What two permissions are required to assign or edit user permission sets?

a)    Users and Permission Sets

b)    Users and Manage Global User Groups

c)    Organization Structure and Permission Sets

d)    Users and SAML

a)    Users and Permission Sets

1.    What are other settings in a model that work in combination with access rules to secure data? (Select three correct answers.)

a)    General Setup options

b)    Other sheet settings such as read-only and access salary detail.

c)    Version access

d)    Attributes

e)    Role permissions

b)    Other sheet settings such as read-only and access salary detail.

c)    Version access

e)    Role permissions

1.    A user with the permission set permission "Import Capabilities" has the level Accounting assigned as an owned level, but does not have an access rule assigning the level Accounting. What actions can the this user perform on the level Accounting?

a)    Approve this level within Workflow

b)    Enter data on sheets for this level

c)    View data on sheets for this level

d)    Import data to this level

d)    Import data to this level

1.    What actions cause changes in a plan version with the version option "Locked version" enabled? (Select three correct answers.)

a)    Data entry changes made on sheets within the locked version

b)    Adjusting global formulas such as metric, modeled or master formulas without using the formula override

c)    Enabling or changing the actuals overlay

d)    Shared Formula changes

e)    Calendar changes

b)    Adjusting global formulas such as metric, modeled or master formulas without using the formula override

c)    Enabling or changing the actuals overlay

e)    Calendar changes

1.    What prevents a dimension from being secured within access rules? (Select three correct answers.)

a)    Dimension has more than 10,000 dimension values

b)    Dimension setting "Use on levels is enabled"

c)    Dimension setting "Data import automatically creates dimension values" is enabled

d)    Dimensions can always be secured within access rules

e)    Dimension setting "Use mapping criteria to set dimension value on modeled sheets"

a)    Dimension has more than 10,000 dimension values

b)    Dimension setting "Use on levels is enabled"

c)    Dimension setting "Data import automatically creates dimension values" is enabled

1.    What version option must be enabled to enable the option "Calculate formula values"?

a)    Completed values through

b)    Locked version

c)    Enable workflow

d)    Default

b)    Locked version (I’m not sure) (I think this is locked version, but this is an old setting).

1.    What happens to an access rule based on users' owned levels if their owned levels are changed?

a)    The access rule automatically updates to reflect the changes made to the users' owned levels

b)    The access rule must be updated to reflect the changes made to the users' owned levels

c)    The access rule must be updated to reflect the changes made to the users' owned levels

d)    No changes occur to the access rule

a)    The access rule automatically updates to reflect the changes made to the users' owned levels

(I need to test this out)

1.    What type of data gets copied in a new plan version from the new version option "Copy all data"?

a)    All values and formulas in cube accounts

b)    All values and formulas in standard accounts

c)    Exchange rates

d)    All of the above

d)    All of the above

1.    In the actuals version, the Lock leading time period through version option will lock the version as of which start date?

a)    End of version

b)    Start of version

c)    Starting scroll location

d)    Start of plan

b)    Start of version

1.    What happens to existing standard data when you import new standard data?

a)    Import history is maintained for all versions.

b)    Data import files are maintained for all versions Intersections not included where data currently exists will be replaced.

c)    Existing data is only replaced where the import file has data at the level, account, time period, dimension and version intersections

d)    All data is automatically erased and replaced for all time periods for the selected version

c)    Existing data is only replaced where the import file has data at the level, account, time period, dimension and version intersections

1.    What permission set permission is required to be categorized within the version Access Control category Administrators?

a)    Versions

b)    Editable sheet access

c)    Privileged actuals access

d)    Users

a)    Versions

1.    What symbol is required in the Levels (Grant) column to create an access rule for all users based on their owned levels?

a)    (*)

b)    (#)

c)    (!)

d)    (~)

d)    (~)

1.    What type of data cannot be included on a standard import template?

a)    Levels

b)    Formulas

c)    Dimensions

d)    Values

b)    Formulas

1.    Which of the following tasks can a user always perform to their owned levels with the applicable permission set permissions, regardless of access rules assigned? (Select three correct answers.)

a)    Approve owned levels in workflow with Approve Levels permission

b)    Edit data on owned levels on any sheet with Editable sheet access permission

c)    View and create journal entries on owned levels with permission Access Consolidation

d)    Receive shared-by-level reports in your Shared Reports folder with Access Reports permission

e)    View data on dashboards for owned levels

a)    Approve owned levels in workflow with Approve Levels permission

c)    View and create journal entries on owned levels with permission Access Consolidation

d)    Receive shared-by-level reports in your Shared Reports folder with Access Reports permission

1.    What actions can you perform with the permission set permission "General Setup"? (Select two correct answers.)

a)    Revise access rules

b)    Update the Visual Preferences

c)    Update General Setup options of the instance

d)    Import to all levels

b)    Update the Visual Preferences

c)    Update General Setup options of the instance

1.    What does an association create a connection with?

a)    Dimension values and global user groups

b)    Attribute values and individual users

c)    Dimension values and individual users

d)    Accounts and individual users

c)    Dimension values and individual users

1.    What action is required before you can create an access rule based on all users' owned levels? (Select two correct answers.)

a)    User profiles must be created with assigned owned levels

b)    You must be assigned the permission anomaly detection

c)    A user group must be created with all users assigned to the group

d)    You must be assigned the privileged actuals access

a)    User profiles must be created with assigned owned levels

c)    A user group must be created with all users assigned to the group

1.    What happens when access rules are turned on after a model has been implemented? (Select two correct answers.)

a)    After access rules are enabled, access rules are automatically created that mimic level ownership access for all users

b)    Accounts can no longer be secured

c)    Once access rules are turned on in a model they cannot be turned off

d)    Dimensions can no longer be secured

I DO NOT HAVE ANSWERS FOR THIS

a)    After access rules are enabled, access rules are automatically created that mimic level ownership access for all users

c)    Once access rules are turned on in a model they cannot be turned off

1.    What types of non-dimension modeled sheet columns can be hidden based on securing modeled accounts? (Select two correct answers.)

a)    Text columns

b)    Initial Balance columns

c)    Display columns

d)    Attribute columns

b)    Initial Balance columns

c)    Display columns

1.    What are the impacts of setting a General Ledger account "Data Entry Sheet Type" as "Cube"? (Select three correct answers.)

a)    Account is set as read-only on standard sheets

b)    Data entry and imports to the account can only be completed on a cube sheet displaying the general ledger cube account

c)    Dimensional data in account carries from the cube sheet to the standard sheet

d)    Data entry and imports to the account can be completed on standard and/or cube sheets displaying the general ledger cube account

e)    Changing the account data entry sheet type from standard to cube will not impact existing data

a)    Account is set as read-only on standard sheets

b)    Data entry and imports to the account can only be completed on a cube sheet displaying the general ledger cube account

c)    Dimensional data in account carries from the cube sheet to the standard sheet

1.    Which of the following permission set permissions can circumvent levels, accounts and dimensions secured within access rules? (Select three correct answers.)

a)    Manage Global User Groups

b)    Manage Tasks

c)    Integration Operator > Data Designer > Integration Developer

d)    Model Management Access > Model Permissions

e)    Import Capabilities > Import to All Locations

c)    Integration Operator > Data Designer > Integration Developer

d)    Model Management Access > Model Permissions

e)    Import Capabilities > Import to All Locations

1.    What type of data are you prevented from viewing if assigned an access rule with the access type Limited View? (Select two correct answers.)

a)    View data

b)    Edit cell notes

c)    View standard account splits

d)    Rows on modeled sheets

c)    View standard account splits

d)    Rows on modeled sheets (IDK IF I BELIEVE THIS ONE)

1.    What fields are required when you import standard data? (Select three correct answers.)

a)    Dimension

b)    Split Label

c)    Date

d)    Account

e)    Level

c)    Date

d)    Account

e)    Level

1.    When a user is deleted, what items are removed from Adaptive Planning along with the user profile?

a)    User's audit trail

b)    User's cell and sheet notes

c)    User's personal reports

d)    User's shared reports

c)    User's personal reports

1.    The Permission Set permission allows you to perform which of the following actions? (Select two correct answers.)

a)    Adjust the calendar

b)    Create access rules

c)    Edit role permissions

d)    Create and delete permission sets

c)    Edit role permissions

d)    Create and delete permission sets

1.    What child level properties are inherited from the parent level and cannot be changed?

a)    Sheets

b)    Level Attributes

c)    Level Dimensions

d)    Currency

b)    Level Attributes

1.    Where can you import data when assigned a role with permission "Import Capabilities"?

a)    Import data only to assigned owned levels and assigned assumption sheets

b)    Import data only to assigned access rule levels and assigned assumption sheets

c)    Import data only to assigned owned levels

d)    Import data only to assigned access rule levels

b)    Import data only to assigned access rule levels and assigned assumption sheets

1.    What types of non-dimension modeled sheet columns can be hidden based on securing modeled accounts? (Select two correct answers.)

a)    Text columns

b)    Initial Balance columns

c)    Display columns

d)    Attribute columns

b)    Initial Balance columns

c)    Display columns

1.    What is the impact of changing the account details setting "Type" from "Expense (periodic)" to "Link"? (Select three correct answers.)

a)    Account is set to read-only in actuals version

b)    Account retains all existing data in locked plan versions

c)    Account data is deleted and overwritten with the linked account values in all plan versions

d)    Account requires a Links to selection for a cube or modeled sheet and an account

e)    Account is set to read-only in all plan versions

c)    Account data is deleted and overwritten with the linked account values in all plan versions

d)    Account requires a Links to selection for a cube or modeled sheet and an account

e)    Account is set to read-only in all plan versions

1.    What versions can you manually erase from the erase data page? (Select two correct answers.)

a)    Any plan version

b)    Actuals versions

c)    Unlocked plan versions

d)    Virtual versions

e)    Locked plan versions

c)    Unlocked plan versions

d)    Virtual versions

1.    What permission is required to create and revise access rules?

a)    Users

b)    Roles

c)    Organization Structure

d)    General Setup

a)    Users

1.    What areas of the model are hidden for a version if the Access Control option selected is "Hidden"? (Select two correct answers.)

a)    Dashboards for that version

b)    Access rules for that version

c)    Sheets for that version

d)    Version settings from version page

a)    Dashboards for that version

c)    Sheets for that version

1.    The Import Mode pull-down menu from the Integration page is applicable to what type of data?

a)    Modeled sheet data

b)    Transactions

c)    Cube sheet data

d)    Standard data

a)    Modeled sheet data