1Z0-1041-20 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

You've created an instance with 1 OCPU and 15 GB of RAM. What is this combination of OCPU and RAM called?

A. Compute shape

B. Analytics shape

C. Classic compute

D. Architecture shape

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.

What should you use to make sure that the model you created is correct?

A. Data Checker icon

B. Validate Icon

C. DB Sync Icon

D. Correct icon

Which statement is false with respect to the ability to adjust visualization properties when placing multiple visuals on a canvas?

A. Change the visual's location on a canvas by selecting and dragging it to the desired location.

B. Duplicate a visual that is on the canvas, changing the visual type in the duplicated visual.

C. Resize the canvas by changing the Canvas Layout option from Auto Fit to Freeform.

D. Hide a visual by right-clicking the canvas and selecting Hide from the drop-down menu.

You are migrating 11.1.2.4.nnn On-Premises Essbase cubes to the cloud service. Which four steps should you perform?

A. Convert all applications and associated artifacts to non-Unicode mode before export.

B. Correct any partition settings in the Life Cycle Management exported .zip file.

C. Install and execute the Life Cycle Management utility to export the required Essbase source application.

D. Import a .zip file using the Command Line Interface tool.

E. Convert all application-level substitution variables to server-level variables before export.

F. Convert all application-level files and artifacts to database-level files and artifacts before export.

You have a data set that you wish to use to train a machine learning model in Oracle Analytics Cloud. The attribute you are interested in predicting has one of two text values (e.g. Yes/No or True/False). How should you perform this operation?

A. Create a data flow that includes a step to train a fuzzy prediction model and save the model for later use.

B. Create a data flow that includes a step to analyze sentiment and save the model for later use.

C. Create a data flow that includes a step to train a clustering model and save the model for later use.

D. Create a data flow that includes a step to train a binary classifier model and save the model for later use.

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

A. From the map visualization select map properties, new layer and drag JSON file.

B. From the OAC console, go to maps and drag and drop a JSON file.

C. From the OAC console, go to maps and drag and drop a geoJSON file.

D. From the map visualization select map properties, new layer and drag geoJSON file.

Which is the maximum row count for unformatted files?

A. 500k

B. 1.2 million

C. 2.2 million

D. 800k

E. 3.2 million

If we select the Oracle Analytics Cloud Enterprise Edition, which are the options available to select while creating the service?

A. Business Intelligence - Enterprise Reports Pixel Perfect Reports

Data Visualization

B. Business Intelligence - Enteprise Reports Data Visualization Essbase

C. Business Intelligence - Enterprise Reports Pixel Perfect Reports Essbase

D. Essbase Pixel Perfect Reports Data Visualization