Free Oracle Cloud Platform Enterprise Analytics 2020 Specialist Exam 1Z0-1041-20 Exam Practice Test

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?

• 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.
• Edit the Data Set and select the Split option from the hyphenated column's action menu.
• 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.
• Edit the Data Set and select the Group option from the hyphenated column's action menu to create two new groups for each element.

What does a confusion matrix illustrate?

• a table that reports the occurrences of higher positives, false negatives, lower positives, and true negatives for a machine learning model
• a table that reports the occurrences of negative positives, false negatives, true positives, and positive negatives for a machine learning model
• a table that reports the occurrences of false positives, false negatives, true positives, and true negatives for a machine learning model
• a table that reports the occurrences of upper positives, lower negatives, mid positives, and true negatives for a machine learning model

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

• 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
• Go to Oracle Cloud Infrastructure overview - Select the compartment where you have the ADW Click to DB Connection. - Click Download - Confirm Download
• Go to Oracle Cloud Baremetal overview - Select the compartment where you have the ADW - Click to DB wallet download - Confirm Download
• 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
• 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

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?

• Permissions
• Row Level Data
• Table filter
• Data Filters You can define data filters for fact tables, dimension tables, and columns that provide row-level security for data model objects. For example, you can create a filter that restricts access to the Products table so that only certain brands are visible to users assigned to a particular role. https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/securing-access-data.html

Your customer has a hybrid aggregate Essbase cube. They want to be able to model what-if scenarios with hypothetical data and are considering using the Sandbox dimension.Which two statements represent correct functionality of the Sandbox dimension?

• Using the sandbox dimension has storage overhead that would be required to replicate data from the base environment.
• The sandbox dimension has one base member and multiple sandbox members.
• Initially, the state of each sandbox member is #missing.
• When you submit changes to a base member, changes are seen and stored in each sandbox member.
• After working in the sandbox environment, you can commit changes to the base environment or even to another sandbox target.

Which is the correct URL for smartview?

• /smartview
• /Essbase
• / Essbase / sv
• /Essbase/smartview

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

• 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.
• Define a data model to set the business view of the data, join data sets, and create custom measures.
• Create connections to sources, some of which include Oracle l0g/llg, Oracle BI Server, JDBC, and MS SQL Server 2005/2008.
• Test connections between BI Publisher and configured sources using Oracle Fusion Middleware Control.

Your customer has an Essbase cube with current year P&L 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?

• Use the Update Cube option from the Build Option menu in Cube Designer.
• Use the Transform Data option in Cube Designer.
• Cube Designer cannot be used to load data in the cube.
• Cube Designer cannot be used to load data incrementally in the cube.
• Use the Load Data option in Cube Designer.

Your customer has an Essbase cube with current year P&L 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?

• Use the Update Cube option from the Build Option menu in Cube Designer.
• Use the Transform Data option in Cube Designer.
• Cube Designer cannot be used to load data in the cube.
• Cube Designer cannot be used to load data incrementally in the cube.
• Use the Load Data option in Cube Designer.

Which statement is false regarding arrangement of visuals on a canvas?

• Visuals can be stacked one on top of another.
• Visuals can be arranged vertically, one visual beside another.
• Visuals cannot be arranged automatically.
• Visuals can be arranged horizontally, one visual above another.