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 can be created from multiple business models as long as they contain common, conformed dimensions.

C. Analyses cannot be created from multiple subject areas even though 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.

Which statement is false with respect to Dashboard Prompts?

A. Prompt values can be limited based on requirements.

B. Repository variables and session variables can be used in prompt default values.

C. Prompts can be developed using multiple columns from different subject areas.

D. Images can be used in the prompts.

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.

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

You've created a visualization of revenue data over time. The revenue data over time exhibits some

curvature in the line visualization.

What trending algorithm should you use to refine the trendline?

A. Set the confidence interval to 95%.

B. Use the linear option.

C. Use the polynomial option.

D. Use the exponential option.

If something goes wrong with your data model, you can easily restore your content to a previous working state from a_____.

A. db_restore command

B. Model Restore

C. analytics_restore command D. snapshot

Which three options are correct about application workbooks?

A. Worksheets can be modified by using the Cube Designer wizard.

B. Worksheets cannot be modified directly in Excel.

C. Application workbooks support the generation reference dimension build method.

D. Multiple dimensions can be placed on a single worksheet.

E. Application workbooks can have data load worksheets and calculation worksheets.

What should you use to make sure that the model you created is correct?

A. Data Checker icon

B. Validate Icon

C. DB Sync Icon

D. Correct icon

Your customer has an Essbase cube with current year PandL data.

Once a month, the cube needs to be updated with the last closed month data.

How can the monthly data be loaded incrementally using Cube Designer?

A. Use the Update Cube option from the Build Option menu in Cube Designer.

B. Use the Transform Data option in Cube Designer.

C. Cube Designer cannot be used to load data in the cube.

D. Cube Designer cannot be used to load data incrementally in the cube.

E. Use the Load Data option in Cube Designer.

Which are the correct steps to download the Autonomous DW wallet?

A. - Go to Oracle Cloud Storage overview

-Select the bucket where you have the ADW

-

Click to DB Connection.

-

Click Download

-Enter appropriate Password.

-Confirm Download

B. - Go to Oracle Cloud Infrastructure overview

-Select the compartment where you have the ADW

Click to DB Connection.

-Click Download

-Confirm Download

C. - Go to Oracle Cloud Baremetal overview

-Select the compartment where you have the ADW

-Click to DB wallet download

-Confirm Download

D. - Go to Oracle Cloud Infrastructure overview

-Select the compartment where you have the ADW

-

Click to DB Connection.

-

Click Download

-Enter appropriate Password.

-Confirm Download

E. - Go to Oracle Cloud Infrastructure overview

-Select the compartment where you have the ATP

-

Click to DB Connection.

-

Click Download

-Enter appropriate Password.

-Confirm Download