Online Access Free 1Z1-936 Practice Test

Which action cannot be employed to split one Data Set column containing data with hyphenated strings (in the format of xxx-xxx) into two columns?

• A.Edit the Data Set and select the Split option from the hyphenated column's action menu.
• B.Edit the Data Set and select the Edit option from the hyphenated column's action menu to invoke the Expression Editor. Use the String functions to parse and extract the string preceding the hyphen. Repeat for the text following the hyphen.
• C.Edit the Data Set and select the Group option from the hyphenated column's action menu to create two new groups for each element.
• D.Edit the Data Set and select the Create option from the hyphenated column's action menu to invoke the Expression Editor. Use the String functions to parse and extract the string preceding the hyphen. Repeat for the text following the hyphen.

Your customer has a hybrid aggregate Essbase cube. They want to be able to model what-if scenarios with hypothetical data and are considering using the Sandbox dimension.
Which two statements represent correct functionality of the Sandbox dimension?

• A.When you submit changes to a base member, changes are seen and stored in each sandbox member.
• B.Using the sandbox dimension has storage overhead that would be required to replicate data from the base environment.
• C.The sandbox dimension has one base member and multiple sandbox members.
• D.After working in the sandbox environment, you can commit changes to the base environment or even to another sandbox target.
• E.Initially, the state of each sandbox member is #missing.

Which tab should you use to restrict access to a specific item in a model?

• A.Permissions
• B.App Responsibilities
• C.Security
• D.App Roles

Which two statements pertaining to Action Links are false?

• A.The Navigation option on a column can be enabled conditionally.
• B.Navigation from one Analysis to another Analysis is not possible if they reside In different folders.
• C.Navigation from one Analysis to another Analysis only works when both analyses are created from single subject area.
• D.Presentation variables can be used while navigating from one Analysis to another Analysis.

Which operating system does the administration tool require?

• A.Oracle Solaris on x86 64-bit
• B.Microsoft Windows x86-64-bit
• C.Oracle Solaris on SPARC 64-bit
• D.Linux x86-64-bit