You want to create a filter that restricts access to the Fact table so that Revenue Is only visible to users assigned to a particular role. In which tab should you set this up?

A. Permissions

B. Row Level Data

C. Table filter

D. Data Filters

Which feature does the Data Lake Edition uniquely offer?

A. Use the Day by Day mobile app

B. Execute data flows on Apache Spark

C. Migrate content from your existing on-premises environment

D. Live optimized connectivity to your on-premises database

A client is using Weblogic Embeded LDAP server for identity managment. When creating the Oracle Analytics Cloud service, credentials must be provided for the Oracle Analytics Cloud administrator. Which of the following is a valid password?

A. ll-password_my

B. my-(passwordll$)

C. my-(passwordll#)

D. my_password$ 11

You want the Oracle BI Baseline Validation Tool to use specific dashboard prompts when executing a specific dashboard page. In which default file should you specify the values?

A. DashboardPrompts.txt

B. DashboardPrompts.xml

C. Prompts.txt

D. Prompts.xml

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 about the Data Sync functionality?

A. Data Sync can create and manage surrogate keys in target tables.

B. Data Sync is the only mechanism available in Oracle Analytics Cloud Standard Edition for loading data Into DBaaS tables.

C. To manage extractions and loads from cloud-based sources, Data Sync can invoke the REST APIs of the Oracle Database Cloud Service as well as the Oracle Business Intelligence Cloud Service.

D. Data Sync cannot load incremental source insertions and updates; only full refresh loads are supported.

Which subscription do you need to begin using Oracle Analytics Cloud?

A. Oracle Big Data Cloud Service

B. Oracle Cloud Infrastructure Compute Classic

C. Oracle Business Intelligence Foundation Service

D. Oracle Analytics Software as a Service

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.

You've been given a spreadsheet of employee attrition data and have been asked to determine which are the most important factors that contribute to whether an employee is likely to leave their position. What is the quickest way to start this analysis after uploading the data to Oracle Analytics Cloud?

A. Calculate a forecast of the probability of attrition.

B. Use Outlier identification.

C. Use the Explain option on the attrition attribute.

D. Perform a cluster analysis of employees.

What are two incorrect steps when creating pixel perfect reports with Bl Publisher?

A. Generate and save to a folder in the Presentation Catalog a sample set of data that can be used for configuring and testing the report.

B. Define a data model to set the business view of the data, join data sets, and create custom measures.

C. Create connections to sources, some of which include Oracle l0g/llg, Oracle BI Server, JDBC, and MS SQL Server 2005/2008.

D. Test connections between BI Publisher and configured sources using Oracle Fusion Middleware Control.