Oracle 1Z0-936 問題集

質問 1：
The extensive palette of visualization options delivered with Oracle Analytics Cloud can be extended with custom plugins.
What option is false about implementing custom visualization plugins?
A. To be implemented, custom plugins must be deployed in the Bi_HOME\Analytics\src\customVi2 directory and BI Services need to be restarted.
B. The bicreateplugin script, provided with Oracle Analytics Cloud, can be used to create a skeleton visualization to facilitate custom development.
C. Plugins for rendering sophisticated visuals can be downloaded from the Oracle Data Visualization Library.
D. Oracle Analytics Cloud provides a Software Development Kit (SDK) to enable builds of custom plugins.
正解：A

質問 2：
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. 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.
B. In Cube Designer:
1. Export the cube to the application workbook.
C. 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.
D. A new dimension cannot be added to an existing cube using Cube Designer.
E. Previous changes applied manually in cloud service cannot be retained while using Cube Designer.
正解：C

質問 3：
How can Oracle Analytics Cloud be used to visualize group relationships between data points on a particular canvas?
A. Use a combination of a tree diagram and a trellis visualization.
B. Create a cluster with a suitable number of groups for the specific analysis.
C. Use a variety of colors for each data point.
D. Visualize the data by using a network chart.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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 from multiple business models as long as they contain common, conformed dimensions.
D. Analyses can be created with measures from multiple physical tables defined as sources in a single logical fact table.
正解：B,D

質問 5：
Which two elements does a well modeled Fact Table consist of?
A. Dimension Keys
B. Nulls
C. Measures
D. REST APIs
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Your company is using an Essbase cube, which is enabled for Scenario Management. Planners model data in individual scenarios and submit them for approval.
While modeling data in the "SB1" sandbox, you changed a few values based on some assumption. Later, you realized that your assumptions were incorrect. You want to start again with the original values, the same as base.
Which step should you perform?
A. Type #Revert in the changed scenario cells and Submit Data.
B. Type #Discard in the changed scenario cells and Submit Data.
C. Type #Original in the changed scenario cells and Submit Data.
D. Type #Base in the changed scenario cells and Submit Data.
E. Type #Missing In the changed scenario cells and Submit Data.
正解：A

質問 7：
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 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.
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 Split option from the hyphenated column's action menu.
正解：C