Oracle Cloud Platform Enterprise Analytics 2021 Specialist Sample Questions:

1. 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 appliedmanually?

A) A new dimension cannot be added to an existing cube using Cube Designer.
B) In Cube Designer:
1. Export the cube to the application workbook.
C) Previous changes applied manually in cloud service cannot be retained while using Cube Designer.
D) Select "From Sheet" to populate the wizard with contents of the application workbook.
3. Add a new dimension.
4. Select "To Sheet to propagatethe changes to the application workbook.
5 Add embers in the dimension worksheet.
Finally, select the Load Data option.
E) 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, selectUpdate Cube from the build options.

2. What should you do to visualize the relationshipbetween two numeric values?

A) Use a box plot with trellising.
B) Create multiple pie charts.
C) Create a line chart with multiple reference lines.
D) Create a scatter plot of the two numeric values and choose a value of interest as the category (points).

3. Which two statements are true about a segment as defined in the Oracle Analytics Cloud machine learning functionality?

A) It Is a component of a data flow sequence.
B) It is a statistically determined group of data points that may contribute to predicting the value of an attribute of interest.
C) It Is a component of the output from the Explain functionality.
D) It is the resulting data set after applying a filter in a data flow.

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

5. Which two statements are true regarding the source of Oracle BI Enterprise Edition Analyses?

A) Analyses can be created from multiple subject areas as long as at least one metric Is Included from each, and the Dimensionality Flag is enabled.
B) Analyses cannot be created from multiple subject areas even though they contain common, conformed dimensions.
C) Analyses can be created with measures from multiple physical tables defined as sources in a single logical fact table.
D) Analyses can be created from multiple business models as long as they contain common, conformed dimensions.

Solutions: