1Z0-1041-22 Online Practice Questions and Answers

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

You have added new columns to the source table. What should you do to include the new columns in your data model?

A. Update Data Model

B. Add Columns from Database

C. Synchronize with Database

D. Connect to Tables

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.

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

How can Oracle Analytics Cloud be used to visualize group relationships between data points on a particular canvas?

A. Use a variety of colors for each data point.

B. Create a cluster with a suitable number of groups for the specific analysis.

C. Use a combination of a tree diagram and a trellis visualization.

D. Visualize the data by using a network chart.

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

What are the two commonly used dimensional modeling schemas?

A. Star

B. Sun

C. Moon

D. Snowflake