1Z0-1041-22 Online Practice Questions and Answers

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 Split option from the hyphenated column's action menu.

C. 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.

D. Edit the Data Set and select the Group option from the hyphenated column's action menu to create two new groups for each element.

A customer wants to build a Block Storage (BSO) cube which has 8 standard dimensions and 2 attribute dimensions. How many dimension worksheets will the application workbook have?

A. 10 dimension worksheets

B. 12 dimension worksheets

C. 8 dimension worksheets

D. 9 dimension worksheets

E. 1 dimension worksheet

The data loads for your Essbase cube are taking many hours, due to which the cube is unavailable to the user for extended periods every day. You are assigned the task of optimizing the data load process. Which are four optimization steps?

A. making the data source as small as possible by eliminating redundancy

B. grouping the data source by sparse-dimension member combination

C. positioning data in reverse order as the outline

D. switching from multiple data fields to a single data field

E. loading from the Essbase server

F. using Parallel load

If your service uses the embedded LDAP server, you can add users and roles one-by-one through the Console. What is the correct process to add a role?

A. Click Roles; Click Add; Enter a name for the role; Import Users from a .csv file; Assign one or more users to this role by selecting Manage Members; Select Users from the Type list and then click Search to list all the users you imported from your .csv file.

B. Click Roles; Click Add; Enter a name for the role; Enter a more detailed display name and description (required); Assign one or more users to this role by selecting Manage Members, select Users from the Type list and then click Search to list all the users; Move all the users you want for this role to the Selected Users pane; click OK.

C. Click Roles; Click Add; Enter a name for the role; Enter a more detailed display name and description (optional); Assign one or more users to this role by selecting Manage Members; Import Users from a .csv file; Move all the users you want for this role to the Selected Users pane; click OK.

D. Click Roles; Click Add; Enter a name for the role; Enter a more detailed display name and description (optional); Assign one or more users to this role by selecting Manage Members, select Users from the Type list and then click Search to list all the users; Move all the users you want for this role to the Selected Users pane; click OK.

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. The bicreateplugin script, provided with Oracle Analytics Cloud, can be used to create a skeleton visualization to facilitate custom development.

B. Oracle Analytics Cloud provides a Software Development Kit (SDK) to enable builds of custom plugins.

C. To be implemented, custom plugins must be deployed in the Bi_HOME\Analytics\src\customVi2 directory and BI Services need to be restarted.

D. Plugins for rendering sophisticated visuals can be downloaded from the Oracle Data Visualization Library.

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. Previous changes applied manually in cloud service cannot be retained while using Cube Designer.

B. A new dimension cannot be added to an existing cube using Cube Designer.

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. In Cube Designer:

1. Export the cube to the application workbook.

E. 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.

Which two statements are true regarding the ways in which Oracle Analytics Cloud provides self- service data preparation capabilities?

A. The Oracle Data Integrator tool used for extraction, load, and transformation of data is a foundational component of the Oracle Analytics Cloud and is essential for data preparation.

B. Join rules for mashing up data from relational sources and delimited flat files can only be defined within the Oracle Analytics Cloud Data Modeler.

C. Data flows within the data preparation feature of Data Visualization can be used to extract, wrangle, and format data content from all supported data sources to create data sets upon which visuals may be constructed.

D. Data sources can include application tables, data warehouses, data lake reservoirs, delimited flat files, and Microsoft Excel spreadsheets in the .xlsx format.

Which option is false with respect to the Presentation Catalog?

A. Catalog Manager is a client administration tool that can be used to view and manage the Presentation Catalog.

B. Object permissions for Analyses and Prompts can be archived along with the object in the catalog.

C. Multiple objects can be archived into a single file.

D. To prevent corruption of the catalog, storage of objects of different types must be segregated into their own folders.

What is the Oracle resource recommendation for applying a patch?

A. Oracle recommends 230 GB, that is, 130 GB latency, and 100 GB data.

B. Oracle recommends 300 GB, that is, 150 GB latency, and 150 GB data.

C. Oracle recommends 200 GB, that is, 100 GB latency, and 100 GB data.

D. Oracle recommends 330 GB, that is, 180 GB latency, and 150 GB data.

What statement is false regarding how Data Flow Sequences can be configured?

A. Sequences can be configured to fork multiple Data Flows to be run in parallel so as to complete data preparation more quickly than running flows serially.

B. Data Set prepare execution can be encapsulated by embedding Sequences inside of other Sequences.

C. To remove an item from a Sequence, click the Action menu icon at the far right of the line upon which the item is found and then select Remove from the drop-down menu,

D. To change the order of an item in the Sequence, the item can be selected by clicking it and dragging it up or down. It will be placed immediately below the highlighted item.