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 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.
• B. Edit the Data Set and select the Split option from the hyphenated column's action menu.
• 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.

What is true about setting up Usage tracking?

• A. You need to restart after modifying the connection pool.
• B. You need to set up a connection pool in Oracle Analytics Developer Client Tool.
• C. It is only available in Enterprise Edition.
• D. It is available in both Essbase and Enterprise Edition.
• E. You need to set up a connection pool in Data Modeler.

You want to create an Essbase cube using a MaxL script. This is the content of the Max! script:

You saved the script file locally as cubeBuild.mx1, uploaded it to the cloud service, and executed a "MaxL script" job type. The job failed. What is the problem?

• A. It is an invalid MaxL statement. "Create or replace database" Is not supported.
• B. It is an invalid job type.
• C. Only one MaxL statement per script is allowed.
• D. It is an invalid script file. A script file must be saved with a .msh extension.
• E. MaxL scripts are not supported.

A customer built an Essbase cube (Block Storage) with six dimensions. At a later stage, a few cube settings were updated and new members were added manually. Based on new requirements from users, the customer wants to add a new dimension to the existing cube.
The administrator will be using the Cube Designer extension in SmartVlew to make the updates. How can the customer update the cube incrementally while retaining any previous changes that were applied manually?

• A. In Cube Designer:
  1. Export the cube to the application workbook.
  2. Select "From Sheet" to populate the wizard with contents of the application workbook.
  3. Add a new dimension.
  4. Select "To Sheet" to propagate the changes to the application workbook.
  5. Add members in the dimension worksheet.
  6. Finally, select Update Cube from the build options.
• B. Select "From Sheet" to populate the wizard with contents of the application workbook.
  3. Add a new dimension.
  4. Select "To Sheet to propagate the changes to the application workbook.
  5 Add embers in the dimension worksheet.
  Finally, select the Load Data option.
• C. A new dimension cannot be added to an existing cube using Cube Designer.
• D. Previous changes applied manually in cloud service cannot be retained while using Cube Designer.
• E. In Cube Designer:
  1. Export the cube to the application workbook.

Which step is required to create a new curated Data Set comprised of columns from several existing Data Sets?

• A. Aggregate
• B. Merge Columns
• C. Filter
• D. Add Data