1Z0-1041-22 Online Practice Questions and Answers

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 two statements are true regarding configuring filters to control visual content?

A. Expression filters cannot be applied in the filter steps of Oracle Analytics Cloud Data Visualization data flows.

B. Variables may be employed in all Data Visualization filter types (that is, Range, List, Date, Expression).

C. Application role filters for fact and dimension tables are defined in the Oracle Analytics Cloud Data Modeler.

D. When the Oracle Business Intelligence Enterprise Edition repository is used as a data source, filters defined in the initialization blocks with the client administration tool are automatically inherited in Data Visualization.

You have created a visualization of revenue data by date (at day level) for the last three years. What functionality should you use to create a prediction of ongoing revenue throughout the next three months?

A. Create a custom calculation based on the revenue metric.

B. Add a forecast with a forward period of approximately 90.

C. Add a forecast with a forward period of 3.

D. Add a trend line with exponential option.

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

Which two statements pertaining to Action Links are false?

A. Navigation from one Analysis to another Analysis is not possible if they reside In different folders.

B. The Navigation option on a column can be enabled conditionally.

C. Navigation from one Analysis to another Analysis only works when both analyses are created from single subject area.

D. Presentation variables can be used while navigating from one Analysis to another Analysis.

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 operating system does the administration tool require?

A. Microsoft Windows x86-64-bit

B. Linux x86-64-bit

C. Oracle Solaris on SPARC 64-bit

D. Oracle Solaris on x86 64-bit

What is a typical relationship between levels in a dimension hierarchy going from top to bottom?

A. Many to ManyRelationship

B. One to Many Relationship

C. Zero Cardinality

D. Multiple Relationship

What is not a pre-requisite for deploying the Oracle Business Intelligence Cloud Service Remote Data Connector?

A. Configure the load balancer or HTTP server for Secured Socket Layer communication.

B. Download the Oracle Business Intelligence Cloud Service Remote Data Connector WAR file from the Oracle Technology Network website.

C. Download and Install Weblogic Server and Node Manager from the Oracle Technology Network website or, alternatively, download and install Apache Tomcat.

D. Obtain the OAuth 2.0 token from the IETF OAuth Working Group website and save it to the Oracle Analytics Cloud bi_home directory.

Which step is required to create a new curated Data Set comprised of columns from several existing Data Sets?

A. Merge Columns

B. Add Data

C. Aggregate

D. Filter