Free Oracle Cloud Platform Enterprise Analytics 2022 Professional Exam 1Z0-1041-22 Exam Practice Test

Which are the steps to create a new Map Layer in OAC?

• From the map visualization select map properties, new layer and drag JSON file.
• From the OAC console, go to maps and drag and drop a JSON file.
• From the OAC console, go to maps and drag and drop a geoJSON file.
• From the map visualization select map properties, new layer and drag geoJSON file.

Monitoring information is updated automatically. You can also run a health check to update the display of monitoring information at any time. What are the correct steps to explicitly run a health check?

• Select anAnalytics Cloud service on the OAC dashboard; click the Display monitoring information icon on the Overview pane; click the Export Healthcheck Details icon.
• Select an Analytics Cloud service on the OAC dashboard; click the View Healthcheck Details IconIn the Resources section; click the Export Healthcheck Details icon.
• Select an Analytics Cloud service on the OAC dashboard; click the Display monitoring information Icon on the Overview pane; click the View Healthcheck Details icon in the Resources section.
• On the Overview pane, click the Display monitoring information icon and select an Analytics Cloud service; In the Resources section, click the View Healthcheck Details icon.

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

The data loads for your Essbase cube are taking many hours, due to which the cube is unavailable to theuser for extended periods every day. You are assigned the task of optimizing the data load process. Which are four optimization steps?

• making the data source as small as possible by eliminating redundancy
• grouping the data source by sparse-dimensionmember combination
• positioning data in reverse order as the outline
• switching from multiple data fields to a single data field
• loading from the Essbase server
• using Parallel load

Before you create an Oracle Analytics Cloud Standard Edition service, you must check to make sure you are subscribed to the required services. Which combination of services is required?

• Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Big Data Cloud
• Oracle Cloud Infrastructure Compute Classic; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required)
• Oracle Cloud Infrastructure ComputeClassic; Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required); Oracle Big Data Cloud
• Oracle Cloud Infrastructure Compute Classic; Oracle Database Cloud Service; Oracle Cloud Infrastructure Object Storage Classic; Oracle Identity Cloud Service (Oracle Universal Credits required)

What should you do to visualize the relationshipbetween two numeric values?

• Use a box plot with trellising.
• Create a line chart with multiple reference lines.
• Create a scatter plot of the two numeric values and choose a value of interest as the category (points).
• Create multiple pie charts.

Which two statements are true about the Data Sync functionality?

• Data Sync can create and manage surrogate keys in target tables.
• Data Sync is the only mechanism available in Oracle Analytics Cloud Standard Edition for loading data Into DBaaS tables.
• To manage extractions and loads from cloud-based sources, DataSync can invoke the REST APIs of the Oracle Database Cloud Service as well as the Oracle Business Intelligence Cloud Service.
• Data Sync cannot load incremental source insertions and updates; only full refresh loads are supported.

Which tab should you use to restrict access to a specific item in a model?

• Permissions
• Security
• App Responsibilities
• App Roles

Which option is false with respect to the Presentation Catalog?

• Catalog Manager is a client administration tool that can be used to view and manage the Presentation Catalog.
• Object permissions for Analyses and Prompts can be archived along with the object in the catalog.
• Multiple objects can be archived into a single file.
• To prevent corruption of the catalog, storage of objects of different types must be segregated into their own folders.

You want to create a filter that restricts access to the Fact table so thatRevenue 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